public ActionResult Stock()
{
SalePointProductStockList request = new SalePointProductStockList();
List <SalePoint> SalePointList = new List <SalePoint>();
SalePointList = AgroExpressDBAccess.GetallEnabledSalePoint();
request.salepointlist = SalePointList.Select(x => new SelectListItem
{
Value = x.PKSalePointID.ToString(),
Text = x.SalePointName
});
var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct();
request.product = ProductInf.Select(x => new SelectListItem
{
Value = x.PKProductId.ToString(),
Text = x.ProductName
});
List <SalePointProductStock> productStock = new List <SalePointProductStock>();
productStock = AgroExpressDBAccess.GetSalePointProductStock();
request.SearchResult = productStock.OrderBy(o => o.SalePointId).ToList();
return(View(request));
}
public ActionResult Stock(SalePointProductStockList request)
{
List <SalePoint> SalePointList = new List <SalePoint>();
SalePointList = AgroExpressDBAccess.GetallEnabledSalePoint();
request.salepointlist = SalePointList.Select(x => new SelectListItem
{
Value = x.PKSalePointID.ToString(),
Text = x.SalePointName
});
var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct();
request.product = ProductInf.Select(x => new SelectListItem
{
Value = x.PKProductId.ToString(),
Text = x.ProductName
});
List <SalePointProductStock> productStock = new List <SalePointProductStock>();
productStock = AgroExpressDBAccess.GetSalePointProductStock();
if (request.SalePointId != null)
{
productStock = productStock.Where(a => a.SalePointId == request.SalePointId).ToList();
}
if (request.ProductId != null)
{
productStock = productStock.Where(a => a.ProductId == request.ProductId).ToList();
}
if (request.StockAmountMin != null)
{
productStock = productStock.Where(a => a.ProductStock >= request.StockAmountMin).ToList();
}
if (request.StockAmountMAx != null)
{
productStock = productStock.Where(a => a.ProductStock <= request.StockAmountMAx).ToList();
}
request.SearchResult = productStock.OrderBy(o => o.SalePointId).ToList();
return(View(request));
}
