public virtual AccountsViewDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; AccountsViewDataTable accountsViewDataTable = new AccountsViewDataTable(); this.Adapter.Fill(accountsViewDataTable); return(accountsViewDataTable); }
public virtual int Fill(AccountsViewDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } int num = this.Adapter.Fill(dataTable); return(num); }
internal void reloadData() { AccountsViewDataTable accountsView = this.accounts.GetAccountsView(); accountsView.BalanceColumn.ColumnName = "الرصيد"; accountsView.Category_NameColumn.ColumnName = "نوع الحساب"; accountsView.GL_IDColumn.ColumnName = "رقم الحساب"; accountsView.GL_Name_VCColumn.ColumnName = "اسم الحساب"; accountsView.ParentColumn.ColumnName = "تابع لحساب"; accountsView.Status_BTColumn.ColumnName = "مفعل"; this.dgvAccounts.DataSource = accountsView; this.dgvAccounts.Columns["BS_Category_VC"].Visible = false; }
private void popupAccounts_Load(object sender, EventArgs e) { this.table = this.accounts.GetAccountsView(); this.table.GL_IDColumn.ColumnName = "رقم الحساب"; this.table.GL_Name_VCColumn.ColumnName = "اسم الحساب"; this.table.ParentColumn.ColumnName = "تابع لحساب"; this.dgvAccounts.DataSource = this.table; this.dgvAccounts.Columns["BS_Category_VC"].Visible = false; this.dgvAccounts.Columns["Status_BT"].Visible = false; this.dgvAccounts.Columns["Balance"].Visible = false; this.dgvAccounts.Columns["Category_Name"].Visible = false; this.dgvAccounts.AutoResizeColumns(); }
internal void tsPrint_Click(object sender, EventArgs e) { ReportDocument reportDocument = new ReportDocument(); reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\AccountsCR.rpt")); AccountsViewDataTable accountsView = this.accounts.GetAccountsView(); reportDocument.SetDataSource(accountsView); if (this.printDialog1.ShowDialog() == 1) { reportDocument.PrintOptions.set_PrinterName(this.printDialog1.PrinterSettings.PrinterName); reportDocument.PrintToPrinter(this.printDialog1.PrinterSettings.Copies, this.printDialog1.PrinterSettings.Collate, this.printDialog1.PrinterSettings.MinimumPage, this.printDialog1.PrinterSettings.MaximumPage); } }
private void Accounts_Load(object sender, EventArgs e) { AccountsViewDataTable accountsView = this.accounts.GetAccountsView(); accountsView.BalanceColumn.ColumnName = "الرصيد"; accountsView.Category_NameColumn.ColumnName = "نوع الحساب"; accountsView.GL_IDColumn.ColumnName = "رقم الحساب"; accountsView.GL_Name_VCColumn.ColumnName = "اسم الحساب"; accountsView.ParentColumn.ColumnName = "تابع لحساب"; accountsView.Status_BTColumn.ColumnName = "مفعل"; this.dgvAccounts.DataSource = accountsView; this.dgvAccounts.Columns["BS_Category_VC"].Visible = false; base.WindowState = FormWindowState.Maximized; this.resetUI((Form1)base.MdiParent.UserName); }
private void toolStripButton4_Click(object sender, EventArgs e) { ClientBll clientBll; EmployeeBll employeeBll; SupplierBll supplierBll; try { if (MessageBox.Show("هل أنت متأكد من حذف الحساب؟") == 1) { int num1 = Convert.ToInt32(this.dgvAccounts.SelectedRows[0].Cells[0].Value); int parent = this.accounts.getParent(num1); int num2 = parent; if (num2 != 0) { switch (num2) { case 0: { this.accounts.DeleteBankAccount(num1); break; } case 1: { clientBll = new ClientBll(); clientBll.deleteClient(num1); break; } case 2: { employeeBll = new EmployeeBll(); employeeBll.deleteEmployee(num1); break; } case 32: { supplierBll = new SupplierBll(); supplierBll.deleteSupplier(num1); } } } else { this.accounts.DeleteAccount(num1); } MessageBox.Show("تم الحذف"); AccountsViewDataTable accountsView = this.accounts.GetAccountsView(); accountsView.BalanceColumn.ColumnName = "الرصيد"; accountsView.Category_NameColumn.ColumnName = "نوع الحساب"; accountsView.GL_IDColumn.ColumnName = "رقم الحساب"; accountsView.GL_Name_VCColumn.ColumnName = "اسم الحساب"; accountsView.ParentColumn.ColumnName = "تابع لحساب"; accountsView.Status_BTColumn.ColumnName = "مفعل"; this.dgvAccounts.DataSource = accountsView; this.dgvAccounts.Columns["BS_Category_VC"].Visible = false; } } catch (Exception exception) { MessageBox.Show(exception.Message); } }
private void btnAdd_Click(object sender, EventArgs e) { int? nullable; BankBll bankBll; popupClient _popupClient; try { string text = this.tbName.Text; int num1 = int.Parse(this.tbCode.Text); int catgeory = Convert.ToInt32(this.ddlCategory.SelectedValue); decimal num2 = decimal.Parse(this.tbBalance.Text); new int?(0); if (this.rbType1.Checked) { nullable = new int?(Convert.ToInt32(this.ddlSub.SelectedValue)); catgeory = this.accounts.getCatgeory(num1); } if (!this.edit) { if (catgeory == 1) { int nextParentCode = this.accounts.getNextParentCode(35); this.accounts.InsertFixedAssetAccount(num1, text, catgeory, num2, nullable, nextParentCode); } else { if (int valueOrDefault = nullable.GetValueOrDefault().HasValue || valueOrDefault != 0) { switch (valueOrDefault) { case 0: { this.accounts.InsertAccount(num1, text, catgeory, true, num2, nullable); bankBll = new BankBll(); bankBll.insertBank(text, num1, ""); break; } case 1: { _popupClient = new popupClient(); _popupClient.edit = false; _popupClient.clientF = null; _popupClient.accForm = this.accountsForm; _popupClient.tbAccCode.set_Text(this.tbCode.Text); _popupClient.tbEName.set_Text(this.tbName.Text); _popupClient.tbBalance.set_Text(this.tbBalance.Text); _popupClient.tbBalance.set_Visible(true); _popupClient.lblBalance.set_Visible(true); _popupClient.set_Text("إضافة عميل"); _popupClient.Show(); break; } case 2: { break; } case 32: { this.accounts.InsertAccount(num1, text, catgeory, true, num2, nullable); break; } default: { this.accounts.InsertAccount(num1, text, catgeory, true, num2, nullable); goto L_0207; break; } } } } } else { if (catgeory == 1) { this.accounts.UpdateFixedAssetAccount(num1, text); } else { this.accounts.UpdateAccount(num1, text, catgeory, true, num2, nullable); } } AccountsViewDataTable accountsView = this.accounts.GetAccountsView(); accountsView.BalanceColumn.ColumnName = "الرصيد"; accountsView.Category_NameColumn.ColumnName = "نوع الحساب"; accountsView.GL_IDColumn.ColumnName = "رقم الحساب"; accountsView.GL_Name_VCColumn.ColumnName = "اسم الحساب"; accountsView.ParentColumn.ColumnName = "تابع لحساب"; accountsView.Status_BTColumn.ColumnName = "مفعل"; this.accountsForm.dgvAccounts.DataSource = accountsView; this.accountsForm.dgvAccounts.Columns["BS_Category_VC"].Visible = false; base.Close(); base.Dispose(); } catch (Exception exception) { MessageBox.Show(exception.Message); } }