ublic class DmlStatementstools
{
public static void BangloreRecords()
{
List<Lead> lstleads=[select id ,ownerid,Name,company,title,status, city__c from lead
where city__c='Mumbai'] ;
if(!lstleads.isEmpty())
{
QueueSobject salesQueue=[select QueueId,Queue.name,SobjectType from QueueSobject
where Queue.Name='Mumbai_Sales_Group' and SobjectType='Lead'];
if(salesQueue!=Null)
{
for(Lead ldsrecords : lstleads){
ldsrecords.ownerid = salesQueue.QueueId;
}
update lstleads;
system.debug('no of dml statements used ....'+ system.Limits.getDMLstatements());
system.debug('no of dml records ....'+ system.Limits.getDMLRows());
}
}
}
dWJsaWMgY2xhc3MgRG1sU3RhdGVtZW50c3Rvb2xzIAp7CiAgICBwdWJsaWMgc3RhdGljIHZvaWQgQmFuZ2xvcmVSZWNvcmRzKCkKICAgIHsKICAgICAgCiAgICAgICBMaXN0PExlYWQ+IGxzdGxlYWRzPVtzZWxlY3QgaWQgLG93bmVyaWQsTmFtZSxjb21wYW55LHRpdGxlLHN0YXR1cywgY2l0eV9fYyBmcm9tIGxlYWQKICAgICAgICAgICAgICAgICAgICAgICAgICAgd2hlcmUgIGNpdHlfX2M9J011bWJhaSddIDsKICAgICAgICBpZighbHN0bGVhZHMuaXNFbXB0eSgpKQogICAgICAgIHsKICAgICAgICAgICAgCiAgICAgICAgUXVldWVTb2JqZWN0IHNhbGVzUXVldWU9W3NlbGVjdCBRdWV1ZUlkLFF1ZXVlLm5hbWUsU29iamVjdFR5cGUgZnJvbSBRdWV1ZVNvYmplY3QKICAgICAgICAgICAgICAgICAgICAgICB3aGVyZSBRdWV1ZS5OYW1lPSdNdW1iYWlfU2FsZXNfR3JvdXAnIGFuZCBTb2JqZWN0VHlwZT0nTGVhZCddOwogICAgICAgICAgICAKICBpZihzYWxlc1F1ZXVlIT1OdWxsKQogIHsKICAgICAgCiAgCiAgICAgIGZvcihMZWFkIGxkc3JlY29yZHMgOiBsc3RsZWFkcyl7CiAgICAgICAgICAKICAgICAgCiAgICAgICAgICAgIGxkc3JlY29yZHMub3duZXJpZCA9IHNhbGVzUXVldWUuUXVldWVJZDsKICAgIH0KICAgIHVwZGF0ZSBsc3RsZWFkczsKICAgICAgc3lzdGVtLmRlYnVnKCdubyBvZiBkbWwgc3RhdGVtZW50cyB1c2VkIC4uLi4nKyBzeXN0ZW0uTGltaXRzLmdldERNTHN0YXRlbWVudHMoKSk7CiAgICAgICAgICBzeXN0ZW0uZGVidWcoJ25vIG9mIGRtbCByZWNvcmRzIC4uLi4nKyBzeXN0ZW0uTGltaXRzLmdldERNTFJvd3MoKSk7CiAgICAgIAp9CiAgICB9CiAgICAgICAgCiAgICB9ICAKICAgIA==