Sign Up ›
  • himanshu huske 7
  • NEWBIE
  • 105 Points
  • Member since 2019
  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 59
    Questions
  • 22
    Replies
2 replies

count value should get incremented across each batch

Account_Asset_Role__c field is unique, we have integer count, while bulk updation if duplicate value is found on Account_Asset_Role__c field, feild will be updated as (duplicate + count) duplicate 1, duplicate 2..... when the new batch starts count again comes to 1
integer count should always maintain its value eg: if count is 2 in first batch than in second batch it should start with 3
please give a solution on this 
global class BatchAccountAssetRoleConsolidation implements Database.Batchable<sObject>, Database.Stateful {
    private Map<String, Integer> accountAssetRoleCountMap = new Map<String, Integer>();
    private Integer successCount = 0;
    private Integer errorCount = 0;
    Integer count = 0;
    
    global Database.QueryLocator start(Database.BatchableContext BC) {
        String query = 'Select id, Account__c, Contact__r.AccountId, Asset__c, Role__c, Account_Asset_Role__c from Account_Asset_Relationship__c';
        return Database.getQueryLocator(query);
    }
    
    global void execute(Database.BatchableContext BC, List<Account_Asset_Relationship__c> aarLst) {
        Set<String> uniqueValues = new Set<String>();
        
        for(Account_Asset_Relationship__c aar : aarLst) {
            String key;
       
            if (aar.Account__c != null && aar.Role__c != null) {
                key = ((String) aar.Account__c + (String) aar.Asset__c + aar.Role__c);
            } 
            else if (aar.Account__c == null && aar.Role__c != null && aar.Contact__c != null) {
                key = ((String) aar.Contact__r.AccountId + (String) aar.Asset__c + aar.Role__c);
                aar.Account__c = aar.Contact__r.AccountId;
            }
            else if (aar.Account__c == null && aar.Role__c == null && aar.Contact__c != null) {
                key = ((String) aar.Contact__r.AccountId + (String) aar.Asset__c);
                aar.Account__c = aar.Contact__r.AccountId;
            }
            else if (aar.Account__c != null && aar.Role__c != null && aar.Contact__c != null) {
                key = ((String) aar.Account__c + (String) aar.Asset__c + aar.Role__c);
            }
            else if (aar.Account__c != null && aar.Contact__c != null && aar.Role__c == null) {
                key = ((String) aar.Contact__r.AccountId + (String) aar.Asset__c);             
            }
            else {
                continue;
            }
            
            if (accountAssetRoleCountMap.containsKey(key)) {
                count = accountAssetRoleCountMap.get(key);
                while(uniqueValues.contains('duplicate ' + count)){
                    count++;
                }
                aar.Account_Asset_Role__c = 'duplicate ' + count;
                accountAssetRoleCountMap.put(key, count + 1);
                uniqueValues.add('duplicate ' + count);
            }
            else {
                accountAssetRoleCountMap.put(key, 1);
                aar.Account_Asset_Role__c = key;
            }
        }
        
        try { 
            List<Database.SaveResult> saveResults = Database.update(aarLst, false);
            for(Database.SaveResult sr : saveResults) {
                if (sr.isSuccess()) {
                    successCount++;
                } else {
                    errorCount++;
                }
            }
        } catch(Exception e) {
            System.debug(e);
            errorCount += aarLst.size();
        }
    }
 
    global void finish(Database.BatchableContext BC) {
        // execute any post-processing operations like sending email
        System.debug('Batch finished with ' + successCount + ' successful records and ' + errorCount + ' error');
                     }
                     }

 
1 replies

Need Test Class for controller 

public class CSI_DeligationController {

    public static CSI_Response deligateUSer(String deligateeJson){
        if(String.isNotBlank(deligateeJson)){
            CSI_DataWrapper.DeligateeContact contactWrapper =(CSI_DataWrapper.DeligateeContact) JSON.deserialize(deligateeJson, CSI_DataWrapper.DeligateeContact.Class);
             
            if(contactWrapper != null){
                Contact contactRecord = new Contact();
                contactRecord.FirstName = contactWrapper.firstName;
                contactRecord.LastName = contactWrapper.lastName;
                contactRecord.Email = contactWrapper.email;
                contactRecord.AccountId = contactWrapper.accountId;
                
                RecordType recType = [SELECT Id, Name, DeveloperName 
                                      FROM RecordType 
                                      WHERE SObjectType = 'Contact' AND 
                                      		Name =: contactWrapper.recordType ];

                contactRecord.RecordTypeId = recType.id;
                
                try{
                    insert contactRecord;
                    //return CSI_Utils.createPortalUser(contactRecord);
                }catch(Exception ex){
                    System.debug('Exception '+ ex.getMessage());
                    return new CSI_Response(false, ex.getMessage(), '');
                }
            }
        }
        return new CSI_Response(false, '' , '');
    }
}

 
0 replies

Please Provide Test class 

public class CSI_BankReferenceController {

/**
  * ───────────────────────────────────────────────────────────────────────────────────────────────┐
  * getApplicationRecord method is written to get ApplicationId of current Application.
  * CSIApplicationController.getApplicationRecord returns CSI_Response.
  * ────────────────────────────────────────────────────────────────────────────────────────────────
  * @return   CSI_Response     returns instance of CSI_Responce class.
  * ───────────────────────────────────────────────────────────────────────────────────────────────┘
  */    
@AuraEnabled
    public static CSI_Response getApplicationRecord(){
    	return CSI_ApplicationController.getApplicationRecord();
    }

/**
  * ───────────────────────────────────────────────────────────────────────────────────────────────┐
  * getBankReferences method is written to get Bank deteials of current Application.
  * ────────────────────────────────────────────────────────────────────────────────────────────────
  * @return   CSI_Response     returns instance of CSI_Responce class.
  * ───────────────────────────────────────────────────────────────────────────────────────────────┘
  */      
   @AuraEnabled
    public static CSI_Response getBankReferences(String applicationId){
        
        if(String.isNotEmpty(applicationId)){ 
                System.debug('applicationId '+ applicationId);
            Application_Member__c applicationMember;
            //Query to get List of Application Members of current Application where RecordType='Bank Reference'
            List<Application_Member__c> lstApplicationMember = [SELECT Id, Name,Phone__c, Mobile__c,Name__c,Phone_Type__c
                                                 FROM Application_Member__c 
                                                 WHERE Application__c =: applicationId AND RecordType.Name = 'Bank Reference' 
                                                 LIMIT 1];
				System.debug('lstApplicationMember '+ lstApplicationMember);
			if(!lstApplicationMember.isEmpty()){
            applicationMember=lstApplicationMember.get(0);
            }
            
            //Query to get List of Application Contract of current Application 
            List<Application_Contract__c> lstApplicationContract = [SELECT Bank_Institution__c, Account_Funding_Type__c,Reference_Bank_US_Ind__c
                                                                        FROM Application_Contract__c
                                                                        WHERE  Application__c =: applicationId LIMIT 1];
				Application_Contract__c applicationContract;
				if(!lstApplicationContract.isEmpty()){
					applicationContract = lstApplicationContract.get(0);
				
				return new CSI_Response(true, '', new CompanyInformationWrapper(applicationId,applicationContract,applicationMember));
			}
		}
		
		return new CSI_Response(false, 'Application not found', '');
    }
    
    /**
  * ───────────────────────────────────────────────────────────────────────────────────────────────┐
  * saveCompanyInformation method is written to save data entered on form/scrren of bankReference. 
  * ────────────────────────────────────────────────────────────────────────────────────────────────
  * @param  applicationId Type:String  Id of current Application.
  * @param  jsonData      Type:String  Data entered on screen convertd into json type string.
  * @return   CSI_Response     returns instance of CSI_Responce class.
  * ───────────────────────────────────────────────────────────────────────────────────────────────┘
  */ 
      @AuraEnabled
    public static CSI_Response saveCompanyInformation(String applicationId, String jsonData){
       System.debug('Save Method');
        System.debug('jsonData '+ jsonData);
            
        if(String.isNotBlank(applicationId) && String.isNotBlank(jsonData)){
            CompanyInformationWrapper companyInfo = (CompanyInformationWrapper) JSON.deserialize(jsonData, CompanyInformationWrapper.class);
            
            try{
                if(companyInfo.applicationMember != null){
                    upsert companyInfo.applicationMember;
                }
                
                if(companyInfo.applicationContract != null){
                    upsert companyInfo.applicationContract;
                }
                
                
                CSI_Response csiResp = getBankReferences(applicationId);
                CSI_ApplicationProgressHandler.updateApplicationProgress('Bank Reference', applicationId);
                csiResp.message = 'Saved Successfully!';
                return csiResp;
            }catch(Exception ex){
                System.debug('Exception : '+ ex.getMessage());
                return new CSI_Response(false, ex.getMessage(), '');
            }
        }
        
        return new CSI_Response(false, 'Something went wrong.' , '');
    }
  
    //Methode to create new Instance of Application_Member__c where Record Type is 'Bank Reference' & Application=applicationId
     public static Application_Member__c createNewApplicationMemberInstanceCmp(String applicationId){
         
        Id recordTypeId=Schema.SObjectType.Application_Member__c.getRecordTypeInfosByName().get('Bank Reference').getRecordTypeId();
        
        system.debug('recordTypeId ' + recordTypeId);
        
        Application_Member__c newAppMemberInstance = new Application_Member__c();
        newAppMemberInstance.Salutation__c = '';               
        newAppMemberInstance.Application__c = applicationId;
        newAppMemberInstance.Email__c = '';
        newAppMemberInstance.Mobile__c = '';
        newAppMemberInstance.Name__c = '';
        newAppMemberInstance.Phone__c = '';
        newAppMemberInstance.Phone_Type__c='';
        newAppMemberInstance.FirstName__c = 'te';
        newAppMemberInstance.LastName__c = '';
        newAppMemberInstance.Title__c = '';
        newAppMemberInstance.RecordTypeId = recordTypeId;
        newAppMemberInstance.Address_Line_1__c = '';
        //newAppMemberInstance.Address_Line_2__c = '';
        newAppMemberInstance.City__c = '';
        newAppMemberInstance.State__c = '';
        newAppMemberInstance.Zip_Code__c = '';
        newAppMemberInstance.Country__c = '';
        
       
        
        return newAppMemberInstance;
    }
    }

 
1 replies

Validation Rule Scenerio

I have Account(parent) and Application(child) obj.
i want validation on account such that
if Application__c.status__c = 'inprogress'.
parent account record gets locked.
if we try to make changes in parent account record it will show error popup message
5 replies

Trigger Task On Account

I have Account, Opportunity and Application Object.
Application is child to account, Application has picklist field status__c
if, Application Statas__c ='inProgress' , Account and Opportunity records should get locked, 
if status=='InProgress' records should get unlock.
1 replies

To HighLight Empty Fields in Aura

I have 2 tabs in application.
first is application, second is summary.
application has some field in which we input data and save,
and summary shows all data entered in application,
Summary also has edit button, which redirect to application tab.
I want functionality such that, after redirecting to application tab.
whatever fields are empty in application should be highlited with some message below it
3 replies

Change status field value on condition

Hi Guys,
Please help me in code.
I have some fields like fName, lNmae,Email, DrivingLiscience etc and a status__c field(values: not opened, in progress, compleated ) .
if all fields are populated then status__c = 'compleated' 
else status__c ='inprogress';
6 replies

State Abbreviation Logic

Please provide any salesforce standard logic for state abbreviation.
eg: California - CA , Alaska - AL
for User state picklist
 
2 replies

jhyui

Hi,
I Have Fields First name, last name, and file upload.
file only get upload when firstname last name are populated.
so I want to show a message "enter first name and last name" when we try to upload file without first name and last name
in aura component
SOLVED
1 replies

Please help me with trigger code

Only One contact should be primary under Account.If user makes other contact as primary then previous one should be made non- primary.Need to store the new and old primary contact value on 2 fields oldContact and newContact on Account.
 
4 replies

Please provide trigger code

update 1 parent 'contact info' text field with names of all the child contact related records names.
1 replies

Please Provide Lightning Code

I want to create certain input field for account, if we populate those field and click on 'save' button, Account should get created of that values... 
Please Provide Me code for this scenerio..
3 replies

Please correct my trigger code.

acount record has child contact record, if status__c(picklist) field of contact record is 'open' update account description field of account record. 
trigger x4 on Account (before update) {
    list<account> accList = new list<account>();
    set<id> idSet = new set<id>();
    for(account acc : trigger.new){
        idSet.add(acc.id);
    }
    list<contact> conList = [Select id, accountid, Status__c from contact where accountId in: idSet];
    map<id,contact> conMap = new map<id,contact>();
    for(contact con : conList){
        conMap.put(con.accountId, con);
    }
    for(account a : trigger.new){
        if(conmap.containsKey(a.id) || conmap.get(a.id).Status__c=='open'){
            a.description = 'account is updated from contact';
            accList.add(a);
        }
    }
    update acclist;
}


 
3 replies

Apex Devlopement Scenerio

Consider there is 1 Lac Account record in the system. Each account record has 2 child Contact records. You have requirement as to update child records address same as parent address and if there is no address populate 'Not available' string in address.
5 replies

Apex Class does not return list of record

Working as SystemAdmin,
No triggers are active, 
public class S_4_ContactListController {
   @AuraEnabled
   public static List<Contact> getContactList(){
      list<Contact> contactList = new List<Contact>([Select Id, FirstName,LastName, Email, Phone From contact Where Email != null]);  
      // contactList = [Select Id, FirstName,LastName, Email, Phone From contact Where Email != null];
     return contactList;  
    }
}

 
1 replies

Batch Apex Scenerio

i have objects Patient__c, Doctor__c, Appointment__c, Medications__c.
Appointment__c has field patient__c(lookup), doctor__c(lookup), AppointMentDate__c(Date)
Medications__c has field patient__c(lookup), doctor__c(lookup), description__c, NextVisit__c(date).
Patient__c has an Email__c field.
if medication record is created with NextVisit != Null, 
it should send email before 2 days To get Appointment.
if appointment is made before NextVisit__c date, email should not get sent.
1 replies

Please provide testclass for my StandardsetController 

public class Claim_Property_from_Sales_Region {

    public contact con {get;set;}
  
    public PageReference Cancel() {
    PageReference prf = new PageReference('https://ap8.salesforce.com/a0H/o');
        return prf;
    }


    public PageReference claimAndCountinue() {
    updateSearchItemsMap();
    SetStatusWorking();
        return null;
    }

    public void SetStatusWorking(){
     List<Property__c> pt = new List<Property__c>();
      set<id> idSet = mapHoldingSelectedRecords.keySet();
     List<Property__c> prplist = [Select id,Status__c from Property__c where id in : idSet];
        for(Property__c prp : prplist){
        Property__c property = new Property__c();
        property.id =  prp.id;
     //   property.Agent__c = UserInfo.getUserId();
        property.Status__c  = 'Working';
        pt.add(property);
        update pt;
        }
}
     
    
    public PageReference claimProp() {
    updateSearchItemsMap();
    SetStatusWorking();
    PageReference pf = new PageReference('https://ap8.salesforce.com/a0H/o');
        return pf;
    }


    public Claim_Property_from_Sales_Region() {
     mapHoldingSelectedRecords = new Map<Id, WrapperClass>();
     init();
    }

   
   Public Integer size{get;set;}
 Public Integer noOfRecords{get; set;}
 public List <WrapperClass> wrapperRecordList{get;set;}
 Map<Id, WrapperClass> mapHoldingSelectedRecords{get;set;}
 
 
 public void init() {
 wrapperRecordList = new List<WrapperClass>();
 for (Property__c p : (List<Property__c>)setCon.getRecords()) {
 if(mapHoldingSelectedRecords != null && mapHoldingSelectedRecords.containsKey(p.id)){
 wrapperRecordList.add(mapHoldingSelectedRecords.get(p.id));
 
 }
 else{
   wrapperRecordList.add(new WrapperClass(p, false));
 }
 }
 } 
 
   public ApexPages.StandardSetController setCon {
 get {
 if(setCon == null) {
   setCon = new ApexPages.StandardSetController(Database.getQueryLocator([SELECT id, Property_Name__c,Property_City__c, Listing_Price__c, Status__c,createdDate FROM Property__c where Status__c = 'open']));
   setCon.setPageSize(5);
 }
   return setCon;
 }
 set;
 }
 public Boolean hasNext {
 get {
   return setCon.getHasNext();
 }
 set;
 }
 
 public Boolean hasPrevious {
 get {
   return setCon.getHasPrevious();
 }
 set;
 }
 
 public Integer pageNumber {
 get {
   return setCon.getPageNumber();
 }
 set;
 }
   Public Integer getTotalPages(){
     Decimal totalSize = setCon.getResultSize();
     Decimal pageSize = setCon.getPageSize();
     Decimal pages = totalSize/pageSize;
     return (Integer)pages.round(System.RoundingMode.CEILING);
 }
 
 public void first() {
   updateSearchItemsMap();
   setCon.first();
   init();
 }
 
 public void last() {
   updateSearchItemsMap();
   setCon.last();
   init();
 }
 public void previous() {
   updateSearchItemsMap();
   setCon.previous();
   init();
 }
 
 public void next() {
   updateSearchItemsMap();
   setCon.next();
   init();
 }

 private void updateSearchItemsMap() {
 for(WrapperClass wrp : wrapperRecordList){
  if(wrp.isSelected){
     mapHoldingSelectedRecords.put(wrp.prop.id, wrp);
  }
  if(wrp.isSelected == false && mapHoldingSelectedRecords.containsKey(wrp.prop.id)){
     mapHoldingSelectedRecords.remove(wrp.prop.id);
  }
 }
 }
 public class WrapperClass {
 public Boolean isSelected {get;set;}
 public Property__c prop {get;set;}
 public WrapperClass(Property__c prop, Boolean isSelected) {
    this.prop = prop;
    this.isSelected = isSelected;
 }
 }
}

 
0 replies

Please provide Test class for this scenerio

Objects: Contact and Property_c  
Property__c has Agent__c(lookUp to Contact)
1)   Contact has Default_commission_split__c field and Property has Agent_Commission_Per__c field
Whenever Default_commission_split__c get updated, Agent_Commission_Per__c should also get updated.
2)  Contact has Year_To_date_Total_Sales__c field and Property has Sales_price__c field
Year_To_date_Total_Sales__c should b sum of all Property record Sales_price__c field(Same as rollUp Summary 
//trigger
trigger Pupulate_Agent_And_AgentCommission on Property__c (before update,after update) {

    if(trigger.isbefore){
        Populate_Agent_Commision pA = new Populate_Agent_Commision();
        pA.Agent_Commission(trigger.new, trigger.new);
    }
  
    if(trigger.isafter){
        Calculate_YearToSaleDate_From_SalesPrice cY = new Calculate_YearToSaleDate_From_SalesPrice();
        cY.YearToSaleDate_Updation(trigger.new);
    }
}


public class Populate_Agent_Commision {
    public  void Agent_Commission(List<Property__c> prop1,List<Property__c> prop2) {
          list<contact> contactlist = new list<contact>();
   set<id> pset = new set<id>();
       for (Property__c p1 : prop1){
           pset.add(p1.Agent__c);
        }
        map<id,contact> conmap = new map<id,contact>();
   list<contact> conlist = [select id,name,Default_commission_split__c,Year_To_date_Total_Sales__c from contact where id in: pset];
    for(contact c : conlist){
           conmap.put(c.id, c);
    }
    for(property__c p2: prop2){
        if(p2.status__C =='Closed Pending Approval'|| p2.Status__c =='Closed Approved'){
          p2.Agent_Commission_Per__c = conmap.get(p2.Agent__c).Default_commission_split__c;
    
    }
}
}
}

public class Calculate_YearToSaleDate_From_SalesPrice {
    public void YearToSaleDate_Updation(list<Property__c> propList){
        Set<id> AgentId = new Set<id>();
    for(Property__c p1 : propList){
       AgentId.add(p1.Agent__c);
    }
   list<Property__c> pList =  [Select id, Agent__c, Property_Name__c, Sales_price__c From Property__c Where Agent__c IN: AgentId];
    map<Id,list<Property__c>> conMap = new map<Id,list<Property__c>>();
    for(Property__c pr_1 : pList){
       conMap.put(pr_1.Agent__c, new list<Property__c>()); 
       conMap.get(pr_1.Agent__c).add(pr_1);
    }
   list<Contact> conList = [Select id, Name, Year_To_date_Total_Sales__c from Contact Where id IN: conMap.keySet()];
    decimal amount = 0;
    for(Contact c1 : conList){
        for(Property__c pr_2: conMap.get(c1.Id)){
         amount += pr_2.Sales_price__c;  
        }
       c1.Year_To_date_Total_Sales__c = amount;
    }    
   update conList;
    }
}

)



 
0 replies

please provide this code using handler class 

trigger Trg_Property_Contact on Property__c (before update,after update) {
   String UserID = UserInfo.getUserId();
   list<contact> contactlist = new list<contact>();
   set<id> pset = new set<id>();
   map<id,contact> conmap = new map<id,Contact>();
       for (Property__c p : trigger.new){
           pset.add(p.Agent__c);
        }
   list<contact> conlist = [select id,name,Default_commission_split__c,Year_To_date_Total_Sales__c from contact where id in: pset];
    for(contact c : conlist){
           conmap.put(c.id, c);
    }
if(trigger.isbefore){
    for(property__c p1: trigger.new){
        if(p1.status__C =='Closed Pending Approval'|| p1.Status__c =='Closed Approved'){
          p1.Agent_Commission_Per__c = conmap.get(p1.Agent__c).Default_commission_split__c;
    }
}
   
}
if(trigger.isafter){
      set<id> myset = new set<id>();
      map<id,contact> cmap = new map<id,Contact>();
      list<contact> contactlist = new list<contact>();
          for (Property__c p : trigger.old){
               myset.add(p.Agent__c);
          }
   list<contact> conlist = [select id,name,Default_commission_split__c,Year_To_date_Total_Sales__c from contact where id in: myset];
       for(contact ct : conlist){
           cmap.put(ct.id, ct);
          }
       for(property__c p3: trigger.old){
        if(p3.status__C =='Closed Pending Approval'){
            if(cmap.containskey(p3.Agent__c)){
               contact c1 = cmap.get(p3.Agent__c); 
               c1.Year_To_date_Total_Sales__c = c1.Year_To_date_Total_Sales__c + p3.Sales_price__c;
            }
    }
  }
    update contactlist;
}
}

 
3 replies

Trigger to populate lookUp Field

There are two Objects:
1.Property__c(obj) with fields Status__c(Picklist) and Ajent__c(lookUp to Contact)
2.Contact (obj)
Scenerio:
Contact obj has some records 
if user change status__c of property form 'open' to 'working' the, If that user have a contact record, Agent__c field should get populated with that Contact Name field.  
2 replies

count value should get incremented across each batch

Account_Asset_Role__c field is unique, we have integer count, while bulk updation if duplicate value is found on Account_Asset_Role__c field, feild will be updated as (duplicate + count) duplicate 1, duplicate 2..... when the new batch starts count again comes to 1
integer count should always maintain its value eg: if count is 2 in first batch than in second batch it should start with 3
please give a solution on this 
global class BatchAccountAssetRoleConsolidation implements Database.Batchable<sObject>, Database.Stateful {
    private Map<String, Integer> accountAssetRoleCountMap = new Map<String, Integer>();
    private Integer successCount = 0;
    private Integer errorCount = 0;
    Integer count = 0;
    
    global Database.QueryLocator start(Database.BatchableContext BC) {
        String query = 'Select id, Account__c, Contact__r.AccountId, Asset__c, Role__c, Account_Asset_Role__c from Account_Asset_Relationship__c';
        return Database.getQueryLocator(query);
    }
    
    global void execute(Database.BatchableContext BC, List<Account_Asset_Relationship__c> aarLst) {
        Set<String> uniqueValues = new Set<String>();
        
        for(Account_Asset_Relationship__c aar : aarLst) {
            String key;
       
            if (aar.Account__c != null && aar.Role__c != null) {
                key = ((String) aar.Account__c + (String) aar.Asset__c + aar.Role__c);
            } 
            else if (aar.Account__c == null && aar.Role__c != null && aar.Contact__c != null) {
                key = ((String) aar.Contact__r.AccountId + (String) aar.Asset__c + aar.Role__c);
                aar.Account__c = aar.Contact__r.AccountId;
            }
            else if (aar.Account__c == null && aar.Role__c == null && aar.Contact__c != null) {
                key = ((String) aar.Contact__r.AccountId + (String) aar.Asset__c);
                aar.Account__c = aar.Contact__r.AccountId;
            }
            else if (aar.Account__c != null && aar.Role__c != null && aar.Contact__c != null) {
                key = ((String) aar.Account__c + (String) aar.Asset__c + aar.Role__c);
            }
            else if (aar.Account__c != null && aar.Contact__c != null && aar.Role__c == null) {
                key = ((String) aar.Contact__r.AccountId + (String) aar.Asset__c);             
            }
            else {
                continue;
            }
            
            if (accountAssetRoleCountMap.containsKey(key)) {
                count = accountAssetRoleCountMap.get(key);
                while(uniqueValues.contains('duplicate ' + count)){
                    count++;
                }
                aar.Account_Asset_Role__c = 'duplicate ' + count;
                accountAssetRoleCountMap.put(key, count + 1);
                uniqueValues.add('duplicate ' + count);
            }
            else {
                accountAssetRoleCountMap.put(key, 1);
                aar.Account_Asset_Role__c = key;
            }
        }
        
        try { 
            List<Database.SaveResult> saveResults = Database.update(aarLst, false);
            for(Database.SaveResult sr : saveResults) {
                if (sr.isSuccess()) {
                    successCount++;
                } else {
                    errorCount++;
                }
            }
        } catch(Exception e) {
            System.debug(e);
            errorCount += aarLst.size();
        }
    }
 
    global void finish(Database.BatchableContext BC) {
        // execute any post-processing operations like sending email
        System.debug('Batch finished with ' + successCount + ' successful records and ' + errorCount + ' error');
                     }
                     }

 
5 replies

Trigger Task On Account

I have Account, Opportunity and Application Object.
Application is child to account, Application has picklist field status__c
if, Application Statas__c ='inProgress' , Account and Opportunity records should get locked, 
if status=='InProgress' records should get unlock.
3 replies

Change status field value on condition

Hi Guys,
Please help me in code.
I have some fields like fName, lNmae,Email, DrivingLiscience etc and a status__c field(values: not opened, in progress, compleated ) .
if all fields are populated then status__c = 'compleated' 
else status__c ='inprogress';
6 replies

State Abbreviation Logic

Please provide any salesforce standard logic for state abbreviation.
eg: California - CA , Alaska - AL
for User state picklist
 
4 replies

Please provide trigger code

update 1 parent 'contact info' text field with names of all the child contact related records names.
3 replies

Apex Devlopement Scenerio

Consider there is 1 Lac Account record in the system. Each account record has 2 child Contact records. You have requirement as to update child records address same as parent address and if there is no address populate 'Not available' string in address.
5 replies

Apex Class does not return list of record

Working as SystemAdmin,
No triggers are active, 
public class S_4_ContactListController {
   @AuraEnabled
   public static List<Contact> getContactList(){
      list<Contact> contactList = new List<Contact>([Select Id, FirstName,LastName, Email, Phone From contact Where Email != null]);  
      // contactList = [Select Id, FirstName,LastName, Email, Phone From contact Where Email != null];
     return contactList;  
    }
}

 
3 replies

Trigger to populate lookUp Field

There are two Objects:
1.Property__c(obj) with fields Status__c(Picklist) and Ajent__c(lookUp to Contact)
2.Contact (obj)
Scenerio:
Contact obj has some records 
if user change status__c of property form 'open' to 'working' the, If that user have a contact record, Agent__c field should get populated with that Contact Name field.  
4 replies

Callout is Not Working, Please correct

Hi mighty developers,
I m a beginner, please correct my code.
i have Country__c Object with all Text fields  Name__c,Capital_City__c,Region__c,Sub_Region__c,Regional_Block__c,Country_ISO_Code_2__c,Country_ISO_Code_3__c from Country__c.
this is the Url for integration:  https://restcountries.eu/
I want to create records for each country and populate all fiels in records for JSON
also provide testing code if possible 
public class CountryNameWrapper{
	public string name{get;set;}
	public string alpha2Code{get;set;}
	public string alpha3Code{get;set;}
	public string capital{get;set;}
	public string region{get;set;}
	public string subregion{get;set;}
	public List<CountryNameWrapper.RegionalBlocsWrapper> regionalBlocs{get;set;}
	
	public class RegionalBlocsWrapper{
		public String acronym{get;set;}
		public String name{get;set;}
		public List<String> otherAcronyms{get;set;}
		public List<String> otherNames{get;set;}
	}
}


global class Load_Countries_RestApi implements Database.Batchable<sObject>,Database.AllowsCallouts {
 global String query ;
    
 global Database.QueryLocator start(Database.BatchableContext BC) {
     query = 'Select Name__c,Capital_City__c,Region__c,Sub_Region__c,Country_ISO_Code_2__c,Country_ISO_Code_3__c from Country__c';     
        //Query all countries from Country object
        return DataBase.getQueryLocator(query);                                    
    }
    
 global void execute(Database.BatchableContext BC , List <Country__c> contlist) {
     Boolean hasChanged = false;
     Http http = new Http();
     HttpRequest request = new HttpRequest();
     request.setEndpoint('https://restcountries.eu/rest/v2/all');
     request.setMethod('GET');
     HttpResponse response = http.send(request);
     if (response.getStatusCode() == 299) {
     System.debug('response--->'+(List<CountryNameWrapper>)JSON.deserialize(response.getBody(),List<CountryNameWrapper>.class));
     List<CountryNameWrapper> abc = (List<CountryNameWrapper>)JSON.deserialize(response.getBody(),List<CountryNameWrapper>.class);
     List<Country__c> cntList = new List<Country__c>();
     for(CountryNameWrapper cw : abc){
     Country__c cnt = new Country__c();
     cnt.Name__c = cw.name;
     cnt.Capital_City__c = cw.name;
     cnt.Region__c = cw.region;
     cnt.Sub_Region__c = cw.subregion;
  //   cnt.Regional_Block__c = cw.regionalBlocs;
     cnt.Country_ISO_Code_2__c = cw.alpha2Code;
     cnt.Country_ISO_Code_3__c = cw.alpha3Code;
     cntList.add(cnt);
}
insert cntList;
     //Give call to https://restcountries.eu/rest/v2/name/AF
     //AF is country name. It will return you the iterate over the list //(List<CountryNameWrapper>) and see if the information in country is same //as that of object returned from API. If it is not same then set boolean
     //hasChanged to true.
     
     //If has changed is true, then update country object
     }    
 }
 global void finish(Database.BatchableContext BC){
 }   
}

 
2 replies

Update Account Discription with Checkbox

In Account object there is a checkbox IsPrimary__c, and in Contact there is PickList Status__c(values: 'IsPrimary', 'IsSecondery').
for an account record if two contact record are created with one as Status__c = IsPrimary and another Status__c = IsSecondery.
1. If in Account IsPrimary__c checkbox is checked then.
Account Discription = Discription in contact having Status__c = IsPrimary. 
2. If in Account IsPrimary__c checkbox is Unchecked then.
Account Discription = Discription in contact having Status__c = IsSecondery.
Please Provide Trigger Using Map
2 replies

trigger_task

I Have customer obj with field IsPrimary(checkbox) and addrText(textarea)
I also have an obj Addresses with field Addr_type(picklist with valuse 'Primery' and 'Secondery') and Addr_Line_1
if IspPrimary is checked, addrText should get populated with Addresses record Addr_Line_1 having  having picklist value as primary 
else adresses record with secondery value of addressLine_1
SOLVED
2 replies

VisualForce_Task_4

I want to create Visualforce Page in which their is a timer for Hour,Minute,Seconds which should start when we click on 'START' button and stop When 'STOP' button is clicked
2 replies

Trigger Scenario - All Child Contact "Status" based on it...

Account and Contact One Custom fiedl - "Status"
one Account having multiple contact - if all contact Status fiedl is Active then only update "Active" in Account page. Even if 1 contact inactive then Account also inactive - 
I have written trigger. but it working fine only with 1 record. I mean when user insert new contatc at that whatever status I have given based on that it update on contact. but how to check for All contact ? 
3 replies

VF Page Parameters

I have customer__c object with FirstName_c, LastName_c, DOB_c fields.
First VF page has  FirstName_c, LastName_c, DOB_c  InputFields and a "save" button which save record in Object
And "List" Button show that record fields with that values of input field in Second VF page.
 
4 replies

System.SObjectException in rollUp summary for sum


Hi developers,
Please fix th issue for thisUser-added imagetrigger TotalAmt_Child_paraent on Child__c (after insert,after update, after delete,after undelete) {
    set<id> idSet = new  set<id>();
    List<Child__c> cList = new List<Child__c>();
    List<Parent__c> pList = new List<Parent__c>();
    if(trigger.isinsert ||trigger.isupdate ||trigger.isundelete){
        for(Child__c c : trigger.new){
            if(c.ParentMD__c != null)
                idSet.add(c.ParentMD__c);
        }
    }
    if(trigger.isdelete){
        for(Child__c c : trigger.old){
            if(c.ParentMD__c != null)
                idSet.add(c.ParentMD__c);
        }
    }    
    if(idSet.size()>0){
    decimal amt = 0;
    cList = [Select id, ParentMD__c from Child__c where ParentMD__c in: idSet];
    Map<id,List<Child__c>> prMap = new Map<id,List<Child__c>>();
    for(Child__c c : cList){
        prMap.put(c.ParentMD__c, new List<Child__c>());
        prMap.get(c.ParentMD__c).add(c);
    }
    pList = [Select id,TotalAmt__c from Parent__c where id in: prMap.keySet()];
        for(Parent__c p : pList){
            for(Child__c ch : prMap.get(p.id)){
                if(ch.MyAmt__c != null)
                    amt +=  ch.MyAmt__c; 
            }
            p.TotalAmt__c = amt;
        }
        update pList;
    }
    }
1 replies

auto sum amount trigger

Write a trigger to auto calculate sum of amount when ever record is inserted update deleted in opportunity object using rollup summary fields
SOLVED
2 replies

master detail trigger

1.customer__c(master obj) and address__c(detail obj).
address__c has has 2 checkbox field Nagpur__c and Pune__c and customer__c has TextField Hometown__c 
if Nagpur__c is checked, Hometown__c = 'nagpur';
if Pune__c is checked, Hometown__c = 'pune';
2. is it true, that master-detail relation trigger like above wont require query ?
 
3 replies

VisualForce_Task_1

Please Help Me With Code.
I want to create a page in which,
we use <apex:inputField> or <apex:inputText> for FirstName, LastName, DateOfBirth,Gender(PickList).
There will be a button on page, after insert value in each field and clicking on button, next page will get display, wich will show list of output. which we have entered in inputField or input text.
please give me a code using following methods,
PageReference Px = page.PageName;
    Px.getParameters().put();
ApexPages.currentPage().getParameters().get();