public byte[] GetAuthorizationUtilizationFile()
{
var exporter = new TableExporter(_context.Database.Connection.ConnectionString);
return(exporter.GetFile(new ExportDefinition
{
SelectStatement = "EXEC [webreports].[AuthorizationUtilization]",
FormatAsTable = true
}));
}
public byte[] GetProviderCaseloadsFile()
{
var exporter = new TableExporter(_context.Database.Connection.ConnectionString);
return(exporter.GetFile(new ExportDefinition
{
SelectStatement = "EXEC [webreports].[ProviderCaseloads]",
FormatAsTable = true
}));
}
public byte[] GetLatestNotesAndTasksFile()
{
var exporter = new TableExporter(_context.Database.Connection.ConnectionString);
return(exporter.GetFile(new ExportDefinition
{
SelectStatement = "EXEC [webreports].[LatestTasksAndNotesByPatient]",
FormatAsTable = true,
Format = (ws, table) =>
{
var r = ws.Cells[2, 4, table.Rows.Count + 1, 4];
r.Style.Numberformat.Format = "yyyy-mm-dd";
}
}));
}
public byte[] DumpTables()
{
Action <ExcelWorksheet, DataTable> format = (ws, table) =>
{
var r = ws.Cells[2, 2, table.Rows.Count + 1, 2];
r.Style.Numberformat.Format = "yyyy-mm-dd HH:mm:ss";
};
var exporter = new TableExporter(_context.Database.Connection.ConnectionString);
return(exporter.GetFile(new ExportDefinition[] {
new ExportDefinition
{
SelectStatement = "SELECT * FROM Patients",
WorksheetName = "Patients",
TableRangeName = "Patients",
FormatAsTable = true,
Format = format
},
new ExportDefinition
{
SelectStatement = "SELECT * FROM Referrals",
WorksheetName = "Referrals",
TableRangeName = "Referrals",
FormatAsTable = true,
Format = format
},
new ExportDefinition
{
SelectStatement = "SELECT * FROM ProvidersDump",
WorksheetName = "Providers",
TableRangeName = "Providers",
FormatAsTable = true,
Format = format
},
}));
}
