SOQL & DML in Salesforce

24 Comments

1. Completed Day 4 assignment

2. Done with assignment 4

3. Episode 4 – Querying & Manipulating Salesforce Data Assignment Completed!

4. Completed assignment for Day 4 (I have created one class “ApexHourAssignmentDay4” and 4 methods)

5. Day 4 Assignment is completed!

6. Day 4 Assignment is completed

7. Day 4 – Assignment is completed.

8. Completed Day 4 Assignment

9. Day 4: Assignment done

10. Completed Day 4 assignment

11. Assignment 4 completed

12. Assignment 4 completed

13. Assignment 4 completed

14. Can you please add the additional link provided by the speaker.

    • We will upload all link and required detail soon

15. Assignment 4 completed

16. Assignment 4 Completed

17. Completed Day 4 Assignment

18. Completed AssignmentDay 4.

19. Solution : All 4 steps in one method – >

    public class MyAccountActions {

    public MyAccountActions ( ) { } // Constructor

    public static void createAccount ( ) {

    Account acc = new Account ( Name = ‘ApexTestAccount ‘);
    insert acc;

    List listContact = new List();

    for ( integer i =1; i

    List result = [ SELECT Id, Name FROM Contact WHERE CreatedDate = TODAY ];
    System.debug(‘Result of query1:’+ result);
    for(Contact conlist : result){

    System.debug(conlist.Name);
    }

    // Query 2 –>

    List conList2 = [ SELECT Name,Account.Name FROM Contact];
    System.debug(‘Result of query2:’+ conList2);

    // Query 3 –>

    List accList = [ SELECT Name, ( SELECT ID, Name FROM Contacts ) from Account ];
    System.debug(‘Result of query3:’+ accList);
    }

    }

    • Please ignore above Solution, some lines got deleted by mistake. I am sorry about it.

      Solution: All 4 steps in one class

      public class MyAccountActions {

      public MyAccountActions () { } // Constructor

      public static void createAccount ( ) {

      Account acc = new Account(Name = ‘ApexTestAccount’);
      insert acc;

      List listContact = new List();

      for ( integer i =1; i<=5; i++ ) {

      Contact con = new Contact(FirstName = 'Apex', LastName = 'Contact' + i, AccountId = acc.Id);

      listContact.add(con);

      }

      insert listContact;

      system.debug('New account =' + acc);

      List result = [ SELECT Id, Name FROM Contact WHERE CreatedDate = TODAY ];
      System.debug(‘Result of query1:’+ result);

      for(Contact conlist : result){

      System.debug(conlist.Name);

      }

      List conList2 = [ SELECT Name,Account.Name FROM Contact];
      System.debug(‘Result of query2:’+ conList2);

      List accList = [ SELECT Name, ( SELECT ID, Name FROM Contacts ) from Account ];
      System.debug(‘Result of query3:’+ accList);
      }

      }

20. Code for Assignment Day 4
    ——————————–
    public class ApexHourAssignmentDay4 {
    public void insertAccountAndContacts() {
    Account acc = new Account();
    acc.Name=’Apex Hour Day 4 Account’;
    insert acc;
    System.debug(‘Account Record has ben created:’ + acc.Name);
    List listContacts = new List();
    for(Integer i=1;i<=5;i++) {
    Contact contact = new Contact();
    contact.FirstName = 'Apex';
    contact.LastName = ' Contact' + i;
    contact.AccountId = acc.Id;
    listContacts.add(contact);
    }
    insert listContacts;
    System.debug('Contacts Records has been created:' + listContacts);
    }

    public void getRecentlyCreatedContacts(){
    List listContacts = new List();
    listContacts = [select Id,Name from Contact where createdDate = today];
    for(Contact contact : listContacts) {
    system.debug(‘Contact Name:’ + contact.name);
    }
    }

    public void getContactswithAccount(){
    List listContacts = new List();
    listContacts = [select Id,Name,Account.Name from Contact];
    for(Contact contact : listContacts) {
    system.debug(‘Account Name:’ + contact.Account.Name);
    system.debug(‘Contact Name:’ + contact.name);

    }
    }

    public void getAccountwithContacts(){
    List listAccounts = new List();
    listAccounts = [select Id,Name, (select Id,Name from Contacts) from Account];
    for(Account account : listAccounts){
    system.debug(‘Account Name:’ + account.Name);
    for(Contact contact : account.Contacts) {
    system.debug(‘Contact Name:’ + contact.Name);
    }
    }
    }
    }

    In Developer Console –> Open Execute Anonymous Window
    ————————————————————————
    ApexHourAssignmentDay4 day4 = new ApexHourAssignmentDay4();
    day4.insertAccountAndContacts();
    day4.getRecentlyCreatedContacts();
    day4.getContactswithAccount();
    day4.getAccountwithContacts();

21. Great lecture thank you. Where can I get the Powerpoint?

22. brother it’s showing this error

    Line: 2, Column: 6
    method does not exist or incorrect signature: void insertAccountAndContacts() from the type ApexHourAssignmentDay4

    I am not getting what’s going wrong here ?