public ActionResult Export(LowStockReportSearchModel searchModel)
{
var result = _lowStockReportAdminService.ExportLowStockReport(searchModel);
if (result.Success)
{
return(result.FileResult);
}
TempData.ErrorMessages().Add(result.Message);
return(RedirectToAction("Index"));
}
public IQueryable <ProductVariant> Get(LowStockReportSearchModel searchModel)
{
IQueryable <ProductVariant> queryOver =
_session.Query <ProductVariant>().Where(variant => variant.TrackingPolicy == TrackingPolicy.Track);
if (_ecommerceSettings.WarehouseStockEnabled)
{
queryOver =
queryOver.Where(
variant => variant.WarehouseStock.Sum(stock => stock.StockLevel) <= searchModel.Threshold);
}
else
{
queryOver = queryOver.Where(variant => variant.StockRemaining <= searchModel.Threshold);
}
return(queryOver.Cacheable());
}
public ExportStockReportResult ExportLowStockReport(LowStockReportSearchModel searchModel)
{
try
{
List <ProductVariant> items = _getLowStockQuery.Get(searchModel).ToList();
return(new ExportStockReportResult
{
FileResult = GetLowStockFileResult(_getStockReportFile.GetFile(items)),
Success = true
});
}
catch (Exception exception)
{
CurrentRequestData.ErrorSignal.Raise(exception);
return(new ExportStockReportResult
{
Message =
_stringResourceProvider.GetValue("Export Low Stock Report Failed",
"Low Stock Report exporting has failed. Please try again and contact system administration if error continues to appear.")
});
}
}
public IPagedList <ProductVariant> Search(LowStockReportSearchModel searchModel)
{
IQueryable <ProductVariant> queryOver = _getLowStockQuery.Get(searchModel);
return(queryOver.Paged(searchModel.Page));
}
public ViewResult Index(LowStockReportSearchModel lowStockReportSearchModel)
{
ViewData["results"] = _lowStockReportAdminService.Search(lowStockReportSearchModel);
ViewData["updated"] = TempData["updated"];
return(View(lowStockReportSearchModel));
}
