public JsonResult DateRangeDepartmentReport(string depId, DateTime start, DateTime end)
{
var model = PublicationReportBuilder.CreateDeparmentReport(depId, start, end);
return(new JsonResult()
{
Data = model, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult PrintDepartmentPublicationsReport(string depId, DateTime start, DateTime end)
{
var model = PublicationReportBuilder.CreateDeparmentReport(depId, start, end);
if (model.Count > 0)
{
SLDocument doc = PublicationReportBuilder.PrintDepartmentReport(model);
var ms = new MemoryStream();
doc.SaveAs(ms);
ms.Position = 0;
var name = $"Публикации - {model[0].DepartmentName}";
if (model[0].Start != null && model[0].End != null)
{
name += $" за {model[0].Start.Value.ToShortDateString().Replace('/', '.')} - {model[0].End.Value.ToShortDateString().Replace('/', '.')}.xlsx";
}
return(File(ms, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", name));
}
return(RedirectToAction("DepartmentPublications"));
}