//DeliveryManProfile Method/Linq created by Julhas
public List <object> DeliveryManProfile(int id)
{
return(new List <object>((from u in _deliveryGroupRepository.GetAll().ToList()
join m in _securityUserRepository.GetAll().ToList() on u.DeliveryBoyId equals m.Id
join ms in _subZoneRepository.GetAll().ToList() on u.SubZoneId equals ms.Id
where u.DeliveryBoyId == id
select new { u.DeliveryBoyId, m.FirstName, m.LastName, zone = ms.Name }).ToList()));
}
public IList <SecurityUserVM> GetSecurityUserList()
{
try
{
var securityUsers = securityUserRepository.GetAll().ToList();
IList <SecurityUserVM> securityUserVMList = new List <SecurityUserVM>();
foreach (var securityUser in securityUsers)
{
var vm = ConvertToSecurityUserVM(securityUser);
securityUserVMList.Add(vm);
}
return(securityUserVMList);
}
catch (Exception ex)
{
ExceptionManager.HandleServiceException(ex);
// The exception will be thrown out, not null
return(null);
}
}