// GET: Inventory
public ActionResult Index(string sortColumn, string sortOrder, string currentFilter, string searchString, int?page, int?companyId)
{
if (companyId.HasValue)
{
Sessions.CompanyId = companyId;
}
ViewBag.CompanyName = companyRepo.GetById(Sessions.CompanyId.Value).Name;
ViewBag.CurrentSort = sortColumn;
ViewBag.SortOrder = sortOrder == "asc" ? "desc" : "asc";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
IQueryable <Vehicle> lstVehicle = vehicleAssignmentRepo.List()
.Where(p => p.CompanyId == Sessions.CompanyId.Value)
.Select(q => q.Vehicle);
if (!String.IsNullOrEmpty(searchString))
{
lstVehicle = lstVehicle.Where(s => s.LicenseNo.Contains(searchString) ||
s.EngineNo.Contains(searchString) ||
s.ChasisNo.Contains(searchString) ||
s.Make.Contains(searchString) ||
s.Year.ToString().Contains(searchString));
}
if (String.IsNullOrEmpty(sortColumn))
{
lstVehicle = lstVehicle.OrderBy(p => p.LicenseNo);
}
else
{
lstVehicle = lstVehicle.OrderBy(sortColumn + " " + sortOrder);
}
int pageSize = 10;
int pageNumber = (page ?? 1);
return(View(lstVehicle.ToPagedList(pageNumber, pageSize)));
}
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));
}