/// <summary>
/// Create the export spreadsheet, then show a dialog to save it.
/// </summary>
/// <param name="exportView">SpreadsheetExport object. Can pass in objects of derived classes (export subtypes)</param>
private void executeExportSpreadsheetView(SpreadsheetExport exportView)
{
// create the spreadsheet
exportView.retrieveData();
exportView.prepareSpreadsheet();
try
{
// save the spreadsheet
exportView.saveSpreadsheet();
}
catch (Exception ex)
{
// it failed
// tell the user and the logger
System.Windows.Forms.MessageBox.Show("Error saving spreadsheet file", "Retail POS",
System.Windows.Forms.MessageBoxButtons.OK,
System.Windows.Forms.MessageBoxIcon.Error);
logger.Error(ex, "Error saving spreadsheet file: " + ex.Message);
logger.Error("Stack trace: ", ex.StackTrace);
// nothing more we can do
return;
}
/*
* // at this point, it succeeded
* // tell the user and the logger
* System.Windows.Forms.MessageBox.Show("Saved spreadsheet file", "Retail POS",
* System.Windows.Forms.MessageBoxButtons.OK,
* System.Windows.Forms.MessageBoxIcon.Information);
* logger.Info("Saved spreadsheet file");
*/
}
private void transactionsToolStripMenuItem_Click(object sender, EventArgs e)
{
// export transaction data from database
// create an instance of the view
SpreadsheetExport exportView = spreadsheetExportFactory.getSpreadsheetExportView("Transaction");
// execute it
executeExportSpreadsheetView(exportView);
}
private void productsToolStripMenuItem1_Click(object sender, EventArgs e)
{
// export product data from database
// create an instance of the view
SpreadsheetExport exportView = spreadsheetExportFactory.getSpreadsheetExportView("Product");
// execute it
executeExportSpreadsheetView(exportView);
}
