/// <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); }