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