//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); } }