public ActionResult AllSales(Models.ReportDatesModel model)
{
try
{
var startDate = new SqlParameter("@SDate", model.StartDate);
var endDate = new SqlParameter("@EDate", model.EndDate);
if (model.OnlyHeaders)
{
var res = _dbContent.SqlQuery <Models.ResultItem>("exec GetOrdersHeader @SDate,@EDate", startDate, endDate);
byte[] bytes = ExportAllOrdersToXlsx(res.ToList());
return(File(bytes, MimeTypes.TextXlsx, "orders.xlsx"));
}
else
{
var res = _dbContent.SqlQuery <Models.ResultItem>("exec GetOrdersDetailed @SDate,@EDate", startDate, endDate);
byte[] bytes = ExportAllOrdersToXlsx(res.ToList());
return(File(bytes, MimeTypes.TextXlsx, "orders.xlsx"));
}
}
catch (Exception exc)
{
ErrorNotification(exc);
return(View("~/Plugins/Widgets.SalesReporting/Views/AllSales.cshtml", model));
}
}
public ActionResult AllSales()
{
var model = new Models.ReportDatesModel();
model.StartDate = DateTime.Now.AddDays(-1).Date;
model.EndDate = DateTime.Now.Date;
return(View("~/Plugins/Widgets.SalesReporting/Views/AllSales.cshtml", model));
}
