public JsonResult GetById(int CompanyID) { VehicleAssignmentRepository vehicleAssignmentRepo = new VehicleAssignmentRepository(); List <VehicleAssignmentVM> lstItemAssignmentVM = (from p in vehicleRepo.List().ToList() join q in vehicleAssignmentRepo.List().Where(p => p.CompanyId == CompanyID).ToList() on p.Id equals q.VehicleId into pq from r in pq.DefaultIfEmpty() where r == null ? false : true select new VehicleAssignmentVM { VehicleId = p.Id, VehiclePlateNo = p.LicenseNo }).ToList(); return(Json(lstItemAssignmentVM)); }
public ActionResult Assignment() { VehicleAssignmentRepository vehicleAssignmentRepo = new VehicleAssignmentRepository(); List <VehicleAssignmentVM> lstItemAssignmentVM = (from p in vehicleRepo.List().ToList() join q in vehicleAssignmentRepo.List().Where(p => p.CompanyId == Sessions.CompanyId.Value).ToList() on p.Id equals q.VehicleId into pq from r in pq.DefaultIfEmpty() select new VehicleAssignmentVM { VehicleId = p.Id, Vehicle = p, IsAssigned = r == null ? false : true }).ToList(); return(View(lstItemAssignmentVM)); }