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