public IQueryable<Stock> GetStocks(StockSearchVM searchModel)
{
var result = db.Stocks.AsQueryable();
if (searchModel != null)
{
if (!string.IsNullOrWhiteSpace(searchModel.batch))
result = result.Where(x => x.BatchNo == searchModel.batch);
if (!string.IsNullOrEmpty(searchModel.name))
result = result.Where(x => x.Item.Name.Contains(searchModel.name));
if (!string.IsNullOrEmpty(searchModel.option))
{
if (searchModel.option == "BelowMin")
{
result =result.Where(x=> x.Qty < x.Item.AlertQty);
}
else if(searchModel.option == "UnSold")
{
result = result.Where(x => x.Qty == x.InitialQty);
}
}
if ((searchModel.fromDate != null )|| (searchModel.toDate != null))
{
if (searchModel.fromDate != null && searchModel.toDate == null)
{
result = result.Where(x => x.ExpiryDate > searchModel.fromDate);
}
else if (searchModel.toDate != null && searchModel.fromDate == null)
{
result = result.Where(x => x.ExpiryDate < searchModel.toDate);
}
else
{
result = result.Where(x => (x.ExpiryDate > searchModel.fromDate && x.ExpiryDate < searchModel.toDate));
}
}
}
return result;
}
public ActionResult TestStocks(StockSearchVM vm)
{
var filter = new StocksFilterRepository();
var model = filter.FilterStocks(vm);
return PartialView("_StocksPartialView", model);
}
public ActionResult Stocks(StockSearchVM vm)
{
var filter = new StocksFilterRepository();
var model = filter.FilterStocks(vm);
return View(model);
}
public IQueryable<Stock> FilterStocks(StockSearchVM searchModel)
{
var result = db.Stocks.AsQueryable();
if (searchModel != null)
{
if (!string.IsNullOrWhiteSpace(searchModel.batch))
result = result.Where(x => x.BatchNo == searchModel.batch);
if (!string.IsNullOrEmpty(searchModel.name))
result = result.Where(x => x.Item.Name.Contains(searchModel.name));
if (!string.IsNullOrEmpty(searchModel.option))
{
if (searchModel.option == "BelowMin")
{
result = result.Where(x => x.Qty < x.Item.AlertQty);
}
else if (searchModel.option == "UnSold")
{
result = result.Where(x => x.Qty == x.InitialQty);
}
else if (searchModel.option == "Expired")
{
result = result.Where(x => DbFunctions.DiffDays( DateTime.Now, x.ExpiryDate) <= 0);
}
else if(searchModel.option == "90")
{
result = result.Where(x => DbFunctions.DiffDays(DateTime.Now, x.ExpiryDate) <= 90 && DbFunctions.DiffDays(DateTime.Now, x.ExpiryDate) > 0);
}
else if (searchModel.option == "60")
{
result = result.Where(x => DbFunctions.DiffDays(DateTime.Now, x.ExpiryDate) <= 60 && DbFunctions.DiffDays(DateTime.Now, x.ExpiryDate) > 0);
}
else if (searchModel.option == "30")
{
result = result.Where(x => DbFunctions.DiffDays(DateTime.Now, x.ExpiryDate) <= 30 && DbFunctions.DiffDays(DateTime.Now, x.ExpiryDate) > 0);
}
else if (searchModel.option == "15")
{
result = result.Where(x => DbFunctions.DiffDays(DateTime.Now, x.ExpiryDate) <= 15 && DbFunctions.DiffDays(DateTime.Now, x.ExpiryDate) > 0);
}
}
if ((searchModel.fromDate != null) || (searchModel.toDate != null))
{
if (searchModel.fromDate != null && searchModel.toDate == null)
{
result = result.Where(x => x.ExpiryDate > searchModel.fromDate);
}
if (searchModel.toDate != null && searchModel.fromDate == null)
{
result = result.Where(x => x.ExpiryDate < searchModel.toDate);
}
if (searchModel.toDate != null && searchModel.fromDate != null)
{
result = result.Where(x => (x.ExpiryDate > searchModel.fromDate && x.ExpiryDate < searchModel.toDate));
}
}
}
return result;
}
public ActionResult index(StockSearchVM vm)
{
var business = new FilterBusinessLogic();
var model = business.GetStocks(vm);
return View(model);
}