private void btnGenerateAndEmail_Click(object sender, EventArgs e) { ItemsListSummaryRpt rpt = BuildReport(); string filename = string.Format("{0}\\Emails\\ItemsListSummary[{1}].xls", Application.StartupPath, DateTime.Now.ToString("yyyyMMdd_HHmm")); rpt.WriteExcelReport(filename); mApplicationController.Email(null, null, filename); }
private void BtnSave_Click(object sender, EventArgs e) { dlgSave.Filter = "Excel Files (*.xls)|*.xls|HTML Files (*.htm)|*.htm|Text Files (*.txt)|*.txt|PDF Files (*.pdf)|*.pdf|Rich Text Files (*.rtf)|*.rtf"; if (dlgSave.ShowDialog() == DialogResult.OK) { string filename = dlgSave.FileName; string ext = System.IO.Path.GetExtension(filename.ToLower()); ItemsListSummaryRpt rpt = BuildReport(); if (ext.Equals(".xls")) { rpt.WriteExcelReport(filename); } else if (ext.Equals(".htm")) { rpt.WriteHtmlReport(filename); } else if (ext.Equals(".txt")) { rpt.WriteDelimitedTextReport(filename); } else if (ext.Equals(".pdf")) { bool landscape = false; if (MessageBox.Show("Do you want to save the PDF in Landscape view?", "PDF Landscape View", MessageBoxButtons.YesNo) == DialogResult.Yes) { landscape = true; } rpt.WritePdfReport(filename, landscape); } else if (ext.Equals(".rtf")) { rpt.WriteRtfReport(filename); } if (MessageBox.Show("Do you want to open the file", "File Saved", MessageBoxButtons.YesNo) == DialogResult.Yes) { System.Diagnostics.Process.Start(filename); } } }