protected void showInExcelToolStripMenuItem_Click(object sender, EventArgs e)
{
var exportWrapper = new Dictionary <string, TableExporter.ITable> {
{ Name, this }
};
TableExporter.ShowInExcel(exportWrapper, false);
}
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";
}
}));
}
protected void ExportTable(object sender, EventArgs e)
{
exportSelectedCellsOnly = sender == copyToClipboardSelectedToolStripMenuItem ||
sender == exportSelectedCellsToFileToolStripMenuItem ||
sender == showInExcelSelectToolStripMenuItem;
/*var progressWindow = new Form
* {
* Size = new Size(300, 60),
* Text = "Exporting...",
* StartPosition = FormStartPosition.CenterScreen,
* ControlBox = false
* };
* var progressBar = new ProgressBar
* {
* Dock = DockStyle.Fill,
* Style = ProgressBarStyle.Marquee
* };
* progressWindow.Controls.Add(progressBar);
* progressWindow.Show();*/
if (sender == clipboardToolStripMenuItem ||
sender == copyToClipboardSelectedToolStripMenuItem)
{
TableExporter.CopyToClipboard(this);
}
else if (sender == fileToolStripMenuItem ||
sender == exportSelectedCellsToFileToolStripMenuItem)
{
TableExporter.ExportToFile(this);
}
else if (sender == showInExcelToolStripMenuItem ||
sender == showInExcelSelectToolStripMenuItem)
{
var exportWrapper = new Dictionary <string, TableExporter.ITable> {
{ Name, this }
};
TableExporter.ShowInExcel(exportWrapper, false);
}
}
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
},
}));
}
protected void fileToolStripMenuItem_Click(object sender, EventArgs e)
{
TableExporter.ExportToFile(this);
}
protected void clipboardToolStripMenuItem_Click(object sender, EventArgs e)
{
TableExporter.CopyToClipboard(this);
}
