private void FormReportExporter_Load(object sender, EventArgs e) { //PasswordForm frm = new PasswordForm(); //if (frm.ShowDialog() != DialogResult.OK) //{ // // The user canceled. // this.Close(); //} btnExportPDF.Enabled = false; btnexportEXCEL.Enabled = false; btnexportEXCEL.Click += btnexportEXCEL_Click; btnExportPDF.Click += btnExportPDF_Click; exp_Factory = new ExporterFactory(true); if (exp_Factory.BisLocked) { this.Text = exp_Factory.ProgTittle; txtReportName.Text = exp_Factory.ReportName; comboBoxDBs.Items.Add(exp_Factory.GetCatalog()); foreach (var item in exp_Factory.GetSpName()) { comboBoxSPs.Items.Add(item); } comboBoxDBs.SelectedIndex = 0; comboBoxSPs.SelectedIndex = 0; comboBoxDBs.Enabled = false; comboBoxSPs.Enabled = true; comboBoxDBs.Visible = false; comboBoxSPs.Visible = true; labelSPs.Visible = true; labelDBNames.Visible = false; } else { comboBoxDBs.DataSource = GetDBNames(); } //exp_Factory.setDate(DateTime.Now.AddDays(-1), DateTime.Now); //DataTable dt = exp_Factory.GetData(); //dataGridView.DataSource = dt; //string fileName = exp_Factory.ExportToPDF(dt); //exp_Factory.SendEmail(fileName); // Display the password form. }
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); } }