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