public ActionResult SqlReport(OrgSearchModel m, string report, DateTime?dt1 = null, DateTime?dt2 = null)
{
try
{
var orgs = m.FetchOrgs();
var oids = string.Join(",", orgs.Select(oo => oo.OrganizationId));
ViewBag.ExcelUrl = $"/OrgSearch/SqlReportExcel/{report}";
ViewBag.DisplayName = report.SpaceCamelCase();
ViewBag.OrgIds = oids;
ViewBag.dt1 = dt1;
ViewBag.dt2 = dt2;
var content = CurrentDatabase.ContentOfTypeSql(report);
if (content.Contains("pagebreak", ignoreCase: true))
{
var p = m.GetSqlParameters(oids, dt1, dt2, content);
ViewBag.Results = PythonModel.PageBreakTables(CurrentDatabase, content, p);
return(View());
}
ViewBag.Results = m.SqlTable(report, oids, dt1, dt2);
return(View());
}
catch (Exception ex)
{
return(Message(ex));
}
}
public ActionResult SqlReport(OrgSearchModel m, string report)
{
try
{
var orgs = m.FetchOrgs();
var oids = string.Join(",", orgs.Select(oo => oo.OrganizationId));
ViewBag.ExcelUrl = $"/OrgSearch/SqlReportExcel/{report}";
ViewBag.DisplayName = report.SpaceCamelCase();
ViewBag.Results = m.SqlTable(report, oids);
ViewBag.OrgIds = oids;
return(View());
}
catch (Exception ex)
{
return(Message(ex));
}
}