public ActionResult FactoryList(FactoryProductionList request) { List <Production> ProductionInfo = AgroExpressDBAccess.ProductionInfoByDate(request.EntryDateMin, request.EntryDateMax); if (request.ProductID != null) { ProductionInfo = ProductionInfo.Where(a => a.ProductId == request.ProductID).ToList(); } if (request.AmountMax != null) { ProductionInfo = ProductionInfo.Where(a => a.Amount <= request.AmountMax).ToList(); } if (request.AmountMin != null) { ProductionInfo = ProductionInfo.Where(a => a.Amount >= request.AmountMin).ToList(); } var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); ProductInf = ProductInf.Where(a => a.ProductName.ToLower() != "milk").ToList(); request.ProductList = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); request.SearchResult = ProductionInfo; return(View(request)); }
public ActionResult FactoryList() { FactoryProductionList Production = new FactoryProductionList(); Production.EntryDateMax = System.DateTime.Now; Production.EntryDateMin = System.DateTime.Now.AddDays(-30); List <Production> ProductionInfo = AgroExpressDBAccess.ProductionInfoByDate(Production.EntryDateMin, Production.EntryDateMax); Production.SearchResult = ProductionInfo; var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); ProductInf = ProductInf.Where(a => a.ProductName.ToLower() != "milk").ToList(); Production.ProductList = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); return(View(Production)); }