private void bntProcess_Click(object sender, EventArgs e) { // Disable button, to avoid repeat pressing. this.btnCloseBooks.Enabled = false; this.bntProcess.Enabled = false; Vectra.DataSet2TableAdapters.configurationTableAdapter da = new Vectra.DataSet2TableAdapters.configurationTableAdapter(); da.UpdateStatementDate(getFridaysDate().ToString("dd-MMM-yyyy")); da.Update(this.dataSet2); //-- Backup before updating logProgress("Daily backup"); BackupSimple.doBackup(1); // The 1 for daily try { logProgress("Processing Transactions"); doWeeklyUpdate(); } catch (Exception ex) { MessageBox.Show(ex.StackTrace, ex.Message); } logProgress("Prepare Statements"); using (Form f = new StatementReportForm()) { f.WindowState = FormWindowState.Minimized; f.Show(); } logProgress("Prepare Aged-Trial-Balance"); using (Form f = new ATBReportForm()) { f.WindowState = FormWindowState.Minimized; f.Show(); } logProgress("Prepare Product Sales Details"); using (Form f = new SalesProdReportForm()) { f.WindowState = FormWindowState.Minimized; f.Show(); } logProgress("Prepare Sales Summary"); using (Form f = new SalesSummaryReportForm()) { f.WindowState = FormWindowState.Minimized; f.Show(); } logProgress("Prepare Receipts And Adjustments"); using (Form f = new ReceiptAndAdjReportForm()) { f.WindowState = FormWindowState.Minimized; f.Show(); } logProgress("Prepare Customer Transaction"); using (Form f = new CustomerTransactionReportForm()) { f.WindowState = FormWindowState.Minimized; f.Show(); } if (btnCloseBooks.Checked) // This closing the books. { logProgress("Reset Accounting Period"); resetAccountingPeriod(); sqLiteConnection1.Open(); SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = sqLiteConnection1; cmd.CommandText = "update invoice_header set invoice_locked = 1 where invoice_locked = 0"; cmd.ExecuteNonQuery(); cmd.CommandText = "update invoice_items set current_flag = '0' where current_flag = 1"; cmd.ExecuteNonQuery(); sqLiteConnection1.Close(); } logProgress("Weekly backup"); BackupSimple.doBackup(2); // The 2 for Weekly logProgress("Finished."); }
private void iNVOICE_HEADERBindingNavigatorSaveItem_Click(object sender, EventArgs e) { DataView dvn = new DataView(dataSet2.invoice_items); foreach (DataRowView r in dvn) { if (r.Row["prod_id"].ToString().Length < 2) { r.Row.Delete(); } } doTotal(); this.invoice_unpaidTextBox.Text = this.totalTextBox.Text; this.Validate(); ((DataRowView)iNVOICE_HEADERBindingSource.Current).Row["invoice_date"] = Convert.ToDateTime(((DataRowView)iNVOICE_HEADERBindingSource.Current).Row["invoice_date"]).ToString("dd/MM/yyyy"); ((DataRowView)iNVOICE_HEADERBindingSource.Current).Row["sort_date"] = Convert.ToDateTime(((DataRowView)iNVOICE_HEADERBindingSource.Current).Row["invoice_date"]).ToString("yyyyMMdd"); this.Validate(); this.iNVOICE_HEADERBindingSource.EndEdit(); this.invoice_itemsBindingSource.EndEdit(); this.tableAdapterManager.UpdateAll(this.dataSet2); Vectra.DataSet2TableAdapters.configurationTableAdapter da = new Vectra.DataSet2TableAdapters.configurationTableAdapter(); string acnt_period = da.getCurrentAcntPeriod().ToString(); DataRowView dv = (DataRowView)this.iNVOICE_HEADERBindingSource.Current; string cmd = @"update customer_trans set t_amount = {0}, t_unpaid = {0}, t_week_id = '{4}', t_src_dckt_id = '{5}', t_date = '{6}' where t_type = '{1}' and t_cust_id = {2} and t_src_id = {3}"; this.sqLiteConnection1.ConnectionString = myConfig.connstr; this.sqLiteConnection1.Open(); this.sqLiteCommand1.CommandText = String.Format(cmd, dv.Row["invoice_amount"].ToString(), "Invoice", dv.Row["cust_id"], dv.Row["invoice_number"], acnt_period.ToString(), dv.Row["docket_number"].ToString(), dv.Row["invoice_date"].ToString()); this.sqLiteCommand1.ExecuteNonQuery(); this.sqLiteConnection1.Close(); foreach (DataRowView r in dvn) { if (r.Row["prod_id"].ToString().Length < 2) { r.Row.Delete(); } } Close(); //close the form }
private string getAcntPeriod() { Vectra.DataSet2TableAdapters.configurationTableAdapter da = new Vectra.DataSet2TableAdapters.configurationTableAdapter(); return da.getCurrentAcntPeriod().ToString(); }