private void btnGenerateAndEmail_Click(object sender, EventArgs e)
        {
            ItemsRegisterSummaryRpt rpt = BuildReport();
            string filename             = string.Format("{0}\\Emails\\ItemsRegisterSummary[{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());

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