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