public ActionResult ExportTo(string name)
{
switch (name)
{
case "GridViewWorks":
MySession.Current.TabAction = name;
//MySession.Current.Units = dbWUnits.Units.ToList();
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, Resources.Resource.Works),
BLWorkers.Works.GetWorkerWorksModel().WorksList.ToList()));
case "GridViewPayments":
MySession.Current.TabAction = name;
MySession.Current.Works = BLWorkers.Works.GetWorkerWorksModel().WorksList.ToList();
MySession.Current.PaymentTypes = BLWorkers.WorkerPayment.GetPaymentTypeList();
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, Resources.Resource.Payments),
BLWorkers.WorkerPayment.GetWorkerPaymentModel(dbWorks, dbWorkerPayment).WorkerPayments.ToList()));
default:
var modelToShow = dbWorks.Works.ToList().Where(x => x.object_id == MySession.Current.ObjectId);
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, string.Empty), modelToShow.ToList()));
}
}
public ActionResult ExportTo(string name)
{
switch (name)
{
case "GridViewWorks":
MySession.Current.TabAction = name;
MySession.Current.Units = dbUnits.Units.ToList();
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, Resources.Resource.Works),
BLObject.ObjectWorks.GetObjectWorkModel().ObjectWorksList.ToList()));
case "GridViewMaterial":
MySession.Current.TabAction = name;
var materials = BLObject.ObjectMaterial.GetObjectMaterialModel().ObjectMaterialList;
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, Resources.Resource.Materials), materials));
case "GridViewExtra":
MySession.Current.TabAction = name;
var extras = BLObject.ObjectExtra.GetObjectExtraModel().ObjectExtraList;
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, Resources.Resource.Extras), extras));
case "GridViewPayment":
MySession.Current.TabAction = name;
var payment = dbObjectPayments.ObjectPayments.ToList().Where(x => x.object_id == MySession.Current.ObjectId);
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, Resources.Resource.Payments), payment.ToList()));
case "GridViewInstrument":
MySession.Current.TabAction = name;
var instruments = BLObject.ObjectInstrument.GetObjectInstrumentModel();
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, Resources.Resource.Instruments), instruments));
default:
var modelToShow = dbWorks.Works.ToList().Where(x => x.object_id == MySession.Current.ObjectId);
return(GridViewExtension.ExportToPdf(
ExportDataGridView.GetGridSettings(name, string.Empty), modelToShow.ToList()));
}
}
private async void btnExport_Click(object sender, EventArgs e)
{
if (dgvFiles.DataSource != null)
{
ResetStatus();
SaveFileDialog sfd = new SaveFileDialog
{
Title = "Save as Excel File",
InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop),
Filter = "Excel Workbook (*.xlsx)|*.xlsx",
FileName = "Compare Reports - Result.xlsx"
};
try
{
sslblMain.Text = $"[{ btnExport.Parent.Text }] Choosing save destination";
if (sfd.ShowDialog() == DialogResult.OK)
{
EnableControlsAndManageTaskbar(false);
pbMain.Maximum = 3;
Progress <byte> progress = new Progress <byte>(action =>
{
tbManager.SetProgressValue(action, pbMain.Maximum);
pbMain.Value = action;
if (action == 1)
{
sslblMain.Text = $"[{btnExport.Parent.Text}] Opening Excel instance";
}
else
{
sslblMain.Text = $"[{btnExport.Parent.Text}] Exporting data";
}
});
await Task.Run(() => ExportDataGridView.ToExcel(dgvFiles, sfd.FileName, progress));
sslblMain.Text = $"[{btnExport.Parent.Text}] Data export completed!";
}
else
{
sslblMain.Text = $"[{btnExport.Parent.Text}] Data export cancelled...";
}
}
catch (Exception ex)
{
ExceptionHandler(
btnExport.Parent.Text,
"An error occured during data export!",
ex.GetType().Name,
ex.Message,
ex.StackTrace);
}
finally
{
EnableControlsAndManageTaskbar(true);
}
}
else
{
MessageBox.Show("There is no data to export!", "Data Required", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
}
}
