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