private void btnExportPDF_Click(object sender, EventArgs e)
        {
            exp_Factory.fileName = txtReportName.Text;

            if (exp_Factory.fileName.Equals(""))
            {
                exp_Factory.fileName = Regex.Replace(SelectSpName, "exp_", "", RegexOptions.IgnoreCase);
            }
            string fileName = exp_Factory.ExportToPDF(dt);

            MessageBox.Show("PDF: Exported Succsefully to :\n" + fileName);
        }
示例#2
0
        private static void Main(string[] args)
        {
            // MessageBox.Show(args[0]);
            if (args.Length == 0)
            {
                Application.EnableVisualStyles();
                Application.SetCompatibleTextRenderingDefault(false);
                Application.Run(new FormReportExporter());
            }
            else if (args[0].ToLower().Equals("day"))
            {
                //MessageBox.Show("This was Day");
                //This takes the current day and send it as an argunment to the SQL stored procedure
                ExporterFactory exp_Factory = new ExporterFactory(false);
                exp_Factory.setDate(DateTime.Now.AddDays(-1).Date, DateTime.Now.AddDays(-1).Date);
                DataTable dt = exp_Factory.GetData();
                exp_Factory.periodeName = "Day";
                string fileName = exp_Factory.ExportToPDF(dt);
                exp_Factory.SendEmail(fileName);
            }
            else if (args[0].ToLower().Equals("week"))
            {
                //This takes the current day and send it as an argunment to the SQL stored procedure
                ExporterFactory exp_Factory = new ExporterFactory(false);
                exp_Factory.setDate(DateTime.Now.AddDays(-8).Date, DateTime.Now.AddDays(-1).Date);

                DataTable dt = exp_Factory.GetData();
                exp_Factory.periodeName = "Week";
                string fileName = exp_Factory.ExportToPDF(dt);
                exp_Factory.SendEmail(fileName);
            }
            else if ((args[0].ToLower().Equals("month")))
            {
                ExporterFactory exp_Factory = new ExporterFactory(false);
                exp_Factory.setDate(DateTime.Now.AddMonths(-1).Date, DateTime.Now.AddDays(-1).Date);

                DataTable dt = exp_Factory.GetData();
                exp_Factory.periodeName = "Month";
                string fileName = exp_Factory.ExportToPDF(dt);
                exp_Factory.SendEmail(fileName);
            }
        }