public class DmlStatementstools
{
public static void BangloreRecords(string cityName,string saleQueueName)
{
if(cityName!=Null && cityName!='' && saleQueueName!=null && saleQueueName!='')
{
List<Lead> lstleads=[select id ,ownerid,Name,company,title,status, city__c from lead
where city__c=:cityName] ;
if(!lstleads.isEmpty())
{
QueueSobject salesQueue=[select QueueId,Queue.name,SobjectType from QueueSobject
where Queue.Name=:saleQueueName 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());
}
}
}
}
}
cHVibGljIGNsYXNzIERtbFN0YXRlbWVudHN0b29scyAKewogICAgcHVibGljIHN0YXRpYyB2b2lkIEJhbmdsb3JlUmVjb3JkcyhzdHJpbmcgY2l0eU5hbWUsc3RyaW5nIHNhbGVRdWV1ZU5hbWUpCiAgICB7CiAgICAgICAgaWYoY2l0eU5hbWUhPU51bGwgJiYgY2l0eU5hbWUhPScnICYmIHNhbGVRdWV1ZU5hbWUhPW51bGwgJiYgc2FsZVF1ZXVlTmFtZSE9JycpCiAgICAgICAgewogICAgICAgTGlzdDxMZWFkPiBsc3RsZWFkcz1bc2VsZWN0IGlkICxvd25lcmlkLE5hbWUsY29tcGFueSx0aXRsZSxzdGF0dXMsIGNpdHlfX2MgZnJvbSBsZWFkCiAgICAgICAgICAgICAgICAgICAgICAgICAgIHdoZXJlICBjaXR5X19jPTpjaXR5TmFtZV0gOwogICAgICAgIGlmKCFsc3RsZWFkcy5pc0VtcHR5KCkpCiAgICAgICAgewogICAgICAgICAgICAKICAgICAgICBRdWV1ZVNvYmplY3Qgc2FsZXNRdWV1ZT1bc2VsZWN0IFF1ZXVlSWQsUXVldWUubmFtZSxTb2JqZWN0VHlwZSBmcm9tIFF1ZXVlU29iamVjdAogICAgICAgICAgICAgICAgICAgICAgIHdoZXJlIFF1ZXVlLk5hbWU9OnNhbGVRdWV1ZU5hbWUgYW5kIFNvYmplY3RUeXBlPSdMZWFkJ107CiAgICAgICAgICAgIAogIGlmKHNhbGVzUXVldWUhPU51bGwpCiAgewogICAgICAKICAKICAgICAgZm9yKExlYWQgbGRzcmVjb3JkcyA6IGxzdGxlYWRzKXsKICAgICAgICAgIAogICAgICAKICAgICAgICAgICAgbGRzcmVjb3Jkcy5vd25lcmlkID0gc2FsZXNRdWV1ZS5RdWV1ZUlkOwogICAgfQogICAgdXBkYXRlIGxzdGxlYWRzOwogICAgICBzeXN0ZW0uZGVidWcoJ25vIG9mIGRtbCBzdGF0ZW1lbnRzIHVzZWQgLi4uLicrIHN5c3RlbS5MaW1pdHMuZ2V0RE1Mc3RhdGVtZW50cygpKTsKICAgICAgICAgIHN5c3RlbS5kZWJ1Zygnbm8gb2YgZG1sIHJlY29yZHMgLi4uLicrIHN5c3RlbS5MaW1pdHMuZ2V0RE1MUm93cygpKTsKICAgICAgCn0KICAgIH0KICAgICAgICB9CiAgICB9ICAKICAgIH0=