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 JsonResult HalfYearDepartmentReport(string depId, int year, int half) { try { var model = PublicationReportBuilder.ScientificPublishing(depId, year, half); return(new JsonResult() { Data = model, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { return(null); } }
public ActionResult PrintHalfYearDepartmentReport(string depId, int year, int half) { try { var model = PublicationReportBuilder.ScientificPublishing(depId, year, half); SLDocument doc = PublicationReportBuilder.PrintHalfReport(model); var ms = new MemoryStream(); doc.SaveAs(ms); ms.Position = 0; var name = "Звiт за пiврiччя-" + DateTime.UtcNow.ToLongDateString() + ".xlsx"; return(File(ms, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", name)); } catch (Exception ex) { return(Redirect("/Department/HalfYearDepartmentPublications")); } }
public ActionResult PrintForm11() { var model = PublicationReportBuilder.CreateForm11(user); if (model.Count > 0) { SLDocument doc = PublicationReportBuilder.PrintReportForm11(model, user); var ms = new MemoryStream(); doc.SaveAs(ms); ms.Position = 0; var name = $"Публикации - {user.LastName} {user.FirstName.FirstOrDefault()}. {user.ThirdName.FirstOrDefault()}. .xlsx"; return(File(ms, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", name)); } return(RedirectToAction("Index")); // var filestream = PublicationReportBuilder.PrintReportForm11(user); //return File(filestream, "application/vnd.ms-excel", $"Публикации {user.LastName} {user.FirstName.Substring(0, 1)}. {user.ThirdName.Substring(0, 1)}. - {DateTime.Now.ToShortDateString()}.xls".Replace('/','-')); }
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")); }
// GET: Publication public ActionResult Index() { return(View(PublicationReportBuilder.CreateForm11(user))); }