Write a trigger on Account when account is insert then calcuate total account those are vendor or buyer

Write a trigger on Account when Account is insert then calculate the  MaxCount for Account Type:Create Two custom field on account one field is AccountType(PickList) and add two value "Vendor" and other is "Buyer" and create Second field MaxCount(Number). when Account is added and AccountType__c = Vendor or Buyer the calculate the No of Account those have AccountType__C = Vendor or Buyer and Add value in MaxCount__c field.


trigger onAccountUpdateAccoutType on Account (before insert) {
      AggregateResult aggResBuyer = [select max(maxcount__c) from account where AccoutType__c='buyer'];
       AggregateResult aggResVendor = [select max(maxcount__c) from account where AccoutType__c='vendor'];
       Integer buyer,vendor;
       if(aggResBuyer.get('expr0')==null)
       {
        buyer=0;
       }
       else
       {
         buyer = integer.valueof(aggResBuyer.get('expr0'));
       
       }
       if(aggResVendor.get('expr0')==null)
       {
        vendor=0;
       }
       else
       {
         vendor = integer.valueof(aggResVendor.get('expr0'));
       }
      
   buyer++;
      vendor++;
     
      
    for(account acc:trigger.new)
    {
        if(acc.AccoutType__c!='none')
        {
            if(acc.AccoutType__c=='buyer')
            {
                acc.maxcount__c=buyer;
                 buyer++;
            }
            else
            {
                acc.maxcount__c=vendor;
                 vendor++;
            }
        }
    }

}

Comments

Post a Comment

Popular Post

Show Hyper Link On Add Error in Salesforce Trigger

Requirement: Check Duplicate record in system and show the add error in form of hyperlink corresponding duplicate record ID Solution : Write a trigger and show add error objExistingRecord >>> OldRecord Id objNewRecord >> New Record  objNewRecord.addError('Same Combination of Record already Inserted in System: <a href=\'/'+ objExistingRecord.id +'\'>'+objExistingRecord.Name+'</a>', false);                                                                           Thanks                                                Sumit Shukla
Read more

Find Day of selected Date on VF Page

Image
Requirement: Find the day of selected date in date field Solution: public class DayOfDate {     Private Date startDate = date.newInstance(0001, 1, 1);        Public Date selectedDate{get;set;}     public String dayValue{get;set;}     public Account acc {get;set;}     public DayOfDate()     {           system.debug('startDate***'+startDate);         selectedDate = date.today();         system.debug('selectedDate*****'+selectedDate);         acc = new Account();     }     public void calculateDayOfDate()     {         List<String> listDay = new List<String>{'Saturday' , 'Sunday' , 'Monday' , 'Tuesday' , 'Wednesday' , 'Thursday' , 'Friday'};         selectedDate = acc.SLAExpirationDate__c;      ...
Read more

Write The Dynamic Query in Salesforce and bind in page block table with filter conditions

Class Code public class ClassName {     public product2 objProduct {get;set;}     public string StrCourseName {get;set;}     public string UserName {get;set;}     public id AccountId {get;set;}     public List<PricebookEntry> lstpbe ;     public List<WrapProductSelect> lstWrapProductSelect{get;set;}     public list<opportunity> lstOpportunityToInsert {get;set;}     public list<Offer_Item__c> lstofofferItem{get;set;}     public list<OpportunityLineItem> lstofOppLI;     public boolean isSelectedProduct;     public list<product2> lstProductSearched {get;set;}     public integer totalPageNumber{get;set;}     public integer intNumRecord{get;set;}     public Integer pageNumber{get;set;}     public Integer pageSize{get;set;}     public Integer intTotalCount{get;...
Read more