I am trying to bulkify my trigger and looking for help looking for help. It works fine as it is for a single record but need to ensure it works in bulk, so need to bulkify it but not sure how.
Also, I will appreciate if some one can help me with test class as well.
Thanks RP
trigger updateSerialList on Meter_Serial_Info__c(Before insert, Before update, Before delete){
if(Trigger.isDelete || Trigger.isUpdate)
{
for (Meter_Serial_Info__c msio: trigger.old)
{
if(msio.Serial__c<> Null)
{
List<Serial_List__c> scsi = [select Maker__c, id ,Array__c from Serial_List__c where Serial__c = : msio.Serial__c];
if(scsi.size()>0)
{
scsi[0].Array__c= Null;
update scsi;
}
}
}
}
if(Trigger.isInsert || Trigger.isUpdate)
{
for (Meter_Serial_Info__c msi: trigger.new)
{
if(msi.Serial__c<> Null)
{
List<Serial_List__c> scsi = [select Maker__c, Array__c, id from Serial_List__c where Serial__c = : msi.Serial__c];
if(scsi.size()>0)
{
scsi[0].Array__c= msi.Array__c;
update scsi;
msi.Maker__c = scsi[0].Maker__c;
}
else
{
msi.Maker__c = 'Not Available';
}
}
}
}
}