Day Three

SOQL

DISPLAY LIST OF ACCOUNTS
----------------------------------------------
LIST<ACCOUNT> LISTACC;
LISTACC=NEW LIST<ACCOUNT>();
LISTACC=[SELECT NAME,ID,TYPE,SITE FROM ACCOUNT ];
FOR(INTEGER I=0;I<LISTACC.SIZE();I++)
{ 
    SYSTEM.DEBUG(LISTACC[I]);
    
}


DISPLAY LIST OF ACCOUNTS(ALTERNATE METHOD)
----------------------------------------------------------------
LIST<ACCOUNT> LISTACC;
LISTACC=NEW LIST<ACCOUNT>();
LISTACC=[SELECT NAME,ID,TYPE,SITE FROM ACCOUNT ];
FOR(ACCOUNT ACC:LISTACC)
{ SYSTEM.DEBUG(ACC);
}
--------------------------------------
INSERTING A RECORD IN ACCOUNT

ACCOUNT ACC=NEW ACCOUNT();
ACC.NAME='Gyanvriksh';
INSERT ACC;

---------------------------------------------
INSERTING MULTIPLE RECORDS THROUGH A LIST IN ACCOUNTS

LIST<ACCOUNT> LISTACC;
LISTACC=NEW LIST<ACCOUNT>();
ACCOUNT ACC1=NEW ACCOUNT();
ACC1.NAME='Kelly';
LISTACC.ADD(ACC1);
ACCOUNT ACC2=NEW ACCOUNT();
ACC2.NAME='Gvipl';
LISTACC.ADD(ACC2);
INSERT LISTACC;

----------------------------------------------------------

UPDATE AN EXISTING ACCOUNT BASED ON A CONDITION
-----------------------------------------------------

LIST<ACCOUNT> LISTACC;
LISTACC=NEW LIST<ACCOUNT>();

LISTACC =[SELECT NAME,ID FROM ACCOUNT ];

FOR(ACCOUNT ACC:LISTACC)
{  
    IF(ACC.NAME=='Kelly')
    {
        ACC.SITE='WWW.GOOGLE.COM';
        ACC.TYPE='PROSPECT';
        UPDATE ACC;
    }
}   

---------------------------------------
UPDATE AN EXISTING RECORD WITHOUT USING A LIST
----------------------------------------------------
ACCOUNT ACC=NEW ACCOUNT();
ACC=[SELECT NAME,ID FROM ACCOUNT WHERE NAME='Kelly' LIMIT 1];


 
  IF(ACC.NAME=='Kelly')
    {
        ACC.SITE='WWW.YAHOO.CO.IN';
        ACC.TYPE='PROSPECT';
        UPDATE ACC;
    }
   
   ------------------------------------------------------------------
   CREATING A CLASS AND UPDATING RECORDS THRU METHODS OF CLASS aCCOUNTCLASS
   ------------------------------------------------------
   
   public class AccountClass
{
  public account updateAccount(string accName)
  {
  
     ACCOUNT ACC=NEW ACCOUNT();
     ACC=[SELECT NAME,ID FROM ACCOUNT WHERE NAME=:accName LIMIT 1];


 
      IF(ACC.NAME<>null)
       {
        ACC.SITE='WWW.YAHOO.CO.IN';
        ACC.TYPE='PROSPECT';
        UPDATE ACC;
        system.debug('account update'+ACC);
        }
        RETURN ACC;
  }
  
  public account updateAccountWithValues(string accName,string type,string site)
  {
  
     ACCOUNT ACC=NEW ACCOUNT();
     ACC=[SELECT NAME,ID FROM ACCOUNT WHERE NAME=:accName LIMIT 1];


 
      IF(ACC.NAME<>null)
       {
        ACC.SITE=site;
        ACC.TYPE=type;
        UPDATE ACC;
        system.debug('account update2'+ACC);
        }
        RETURN ACC;
  }
  }
  
  
  CALLING THE METHOD THROUGH CLASS OBJECT
  ----------------------------------------------------
  
  AccountCLASS obj=new AccountCLASS();
obj.UpdateAccount('Gyan');
obj.UpdateaccountWithValues('Acme,'other','www.google.com');


**************************************************************************
ADDING ANOTHER METHOD TO THE CLASS TO INSERT A NEW RECORD
*************************************************************************
public account InsertAccount(string name,string type, string site)
   {
   
     ACCOUNT ACC=NEW ACCOUNT();
     
     ACC.NAME=name;
     ACC.TYPE=type;
     ACC.SITE=site;
     INSERT ACC;
     system.debug('new inserted record' +ACC);
     RETURN ACC;
     
     }
  }