Skip to main content
Topics#ApexFrage von Jagriti Kukreti
Jagriti Kukreti (RBC) fragte in #Apex
11. Apr. 2019, 10:33

how to convert following class to handler:

trigger countmeetings on Event (after insert, after delete) {

List<id> levent = new List<id>();

Set<id> accid = new Set<id>();

List<Event> eventtoupdate = new List<Event>();

public integer inp=0;

if(trigger.isInsert){

for(Event ce:trigger.new){

accid.add(ce.WhatId);

}

}

if(trigger.IsDelete){

for(Event ce: trigger.old){

accid.add(ce.WhatId);

}

}

for(Event ev:[SELECT id FROM event WHERE whatid=:accid]){

    levent.add(ev.id);

}

for(Event event :[SELECT id,Distribution_Meetings__c FROM Event WHERE id=:levent]){

    event.Distribution_Meetings__c = levent.size();

    eventtoupdate.add(event);

    }

If(eventtoupdate.size()>0){

    update eventtoupdate;

}

    }
2 Antworten
  1. Biswojeet Ray (TeqFocus Consulting LLC)
    11. Apr. 2019, 11:42

    Hi JKK,

    Please try this.

    Trigger ->

    trigger countmeetings on Event (after insert, after delete) {

        if(trigger.IsInsert) {

            EventHelper.updateDistributionMeetings(trigger.new);

        }

        if(trigger.IsDelete) {

            EventHelper.updateDistributionMeetings(trigger.old);

        }

    }

    HELPER ->

    public class EventHelper {

        public Set<Id> accountIds {get; set;}

        public Void updateDistributionMeetings(List<Event> allEvents) {

            for (Event eventRec : allEvents) {

                accountIds.add(eventRec.WhatId);

            }

            Map<Id, Integer> accountWithCount = new Map<Id, Integer>();

            List<Event> events = [SELECT Id, Distribution_Meetings__c, WhatId FROM Event WHERE WhatId =: accountIds];

            for (Id accId : accountIds) {

                Integer totalAccount = 0;

                for (Event eventRec : events) {

                    if (eventRec.WhatId == accId) {

                        totalAccount++;

                    }

                }

                accountWithCount.put(accId, totalAccount);

            }

            List<Event> eventsForUpdate = new List<Event>();

            for (Event eventRec : events) {

                eventRec.Distribution_Meetings__c = accountWithCount.get(eventRec.WhatId);

                eventsForUpdate.add(eventRec);

            }

            Update eventsForUpdate;

        }

    }

    I hope it helps you.

    Kindly let me know if it helps you and please mark as Best Answer.

    Thanks and Regards,

    Biswojeet
Antwort schreiben...
0/9000