private void displayResult() { try { dgvChartOfAccounts.DataSource = null; if (txtSearch.Text != "") { dgvChartOfAccounts.DataSource = loChartOfAccount.getAllData("", txtSearch.Text, ""); } else { dgvChartOfAccounts.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); } } catch (Exception ex) { throw ex; } }
private string getSubsidiary(string pAccountId) { try { string _Subsidiary = ""; foreach (DataRow _dr in loChartOfAccount.getAllData("", pAccountId, "").Rows) { _Subsidiary = _dr["Subsidiary"].ToString(); } return(_Subsidiary); } catch (Exception ex) { throw ex; } }
private void btnProcess_Click(object sender, EventArgs e) { try { dgvDetail.Rows.Clear(); dgvDetailPaymentReceipt.Rows.Clear(); string _customerId = ""; try { _customerId = cboCustomer.SelectedValue.ToString(); } catch { MessageBoxUI _mb = new MessageBoxUI("You must select a Customer!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } //insert debit account string[] lRecordDebitData = new string[11]; lRecordDebitData[0] = ""; //detail id lRecordDebitData[1] = GlobalVariables.CRDebitAccount; //coa id lRecordDebitData[2] = ""; lRecordDebitData[3] = ""; foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.CRDebitAccount, "").Rows) { lRecordDebitData[2] = _dr["Code"].ToString(); //coa code lRecordDebitData[3] = _dr["Account Title"].ToString(); //coa title } lRecordDebitData[4] = string.Format("{0:n}", decimal.Parse(txtPaymentReceipt.Text)); //debit lRecordDebitData[5] = "0.00"; //credit lRecordDebitData[6] = "Bank"; //subsidiary lRecordDebitData[7] = ""; //subsidiary id/code lRecordDebitData[8] = ""; //subsidiary description lRecordDebitData[9] = ""; //remarks lRecordDebitData[10] = "Add"; addData(lRecordDebitData); //insert credit account string[] lRecordCreditData = new string[11]; lRecordCreditData[0] = ""; //detail id lRecordCreditData[1] = GlobalVariables.CRCreditAccount; //coa id lRecordCreditData[2] = ""; lRecordCreditData[3] = ""; foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.CRCreditAccount, "").Rows) { lRecordCreditData[2] = _dr["Code"].ToString(); //coa code lRecordCreditData[3] = _dr["Account Title"].ToString(); //coa title } lRecordCreditData[4] = "0.00"; //debit lRecordCreditData[5] = string.Format("{0:n}", decimal.Parse(txtPaymentReceipt.Text)); //credit lRecordCreditData[6] = "Customer"; //subsidiary lRecordCreditData[7] = _customerId; //subsidiary id/code lRecordCreditData[8] = cboCustomer.Text; //subsidiary description lRecordCreditData[9] = ""; //remarks lRecordCreditData[10] = "Add"; addData(lRecordCreditData); //insert payment receive decimal _paymentbalance = decimal.Parse(txtPaymentReceipt.Text); foreach (DataRow _dr in loSalesOrder.getCashReceiptSOByCustomer(_customerId, "").Rows) { if (_paymentbalance != 0) { if (decimal.Parse(_dr["Running Balance"].ToString()) == _paymentbalance) { string[] lRecordPaymentData = new string[7]; lRecordPaymentData[0] = ""; //detail lRecordPaymentData[1] = _dr["Id"].ToString(); // sales order id lRecordPaymentData[2] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // amount due lRecordPaymentData[3] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // payment amount lRecordPaymentData[4] = "0.00"; // balance lRecordPaymentData[5] = ""; // remarks lRecordPaymentData[6] = "Add"; addDataReceipt(lRecordPaymentData, true); _paymentbalance = decimal.Parse(_dr["Running Balance"].ToString()) - _paymentbalance; } else if (decimal.Parse(_dr["Running Balance"].ToString()) > _paymentbalance) { string[] lRecordPaymentData = new string[7]; lRecordPaymentData[0] = ""; //detail lRecordPaymentData[1] = _dr["Id"].ToString(); // sales order id lRecordPaymentData[2] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // amount due lRecordPaymentData[3] = string.Format("{0:n}", _paymentbalance); // payment amount lRecordPaymentData[4] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString()) - _paymentbalance); // balance lRecordPaymentData[5] = ""; // remarks lRecordPaymentData[6] = "Add"; addDataReceipt(lRecordPaymentData, true); _paymentbalance = 0; } else if (decimal.Parse(_dr["Running Balance"].ToString()) < _paymentbalance) { string[] lRecordPaymentData = new string[7]; lRecordPaymentData[0] = ""; //detail lRecordPaymentData[1] = _dr["Id"].ToString(); // sales order id lRecordPaymentData[2] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // amount due lRecordPaymentData[3] = string.Format("{0:n}", decimal.Parse(_dr["Running Balance"].ToString())); // payment amount lRecordPaymentData[4] = string.Format("{0:n}", 0); // balance lRecordPaymentData[5] = ""; // remarks lRecordPaymentData[6] = "Add"; addDataReceipt(lRecordPaymentData, true); _paymentbalance = _paymentbalance - decimal.Parse(_dr["Running Balance"].ToString()); } } } if (_paymentbalance > 0) { MessageBoxUI _mb = new MessageBoxUI("OVER PAYMENT! " + string.Format("{0:n}", _paymentbalance), GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); return; } } catch (Exception ex) { ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnProcess_Click"); em.ShowDialog(); return; } }
private void SystemConfigurationUI_Load(object sender, EventArgs e) { try { cboCurrentLocation.DataSource = loLocation.getAllData("ViewAll", "", ""); cboCurrentLocation.DisplayMember = "Description"; cboCurrentLocation.ValueMember = "Id"; cboCurrentLocation.SelectedIndex = 0; cboCurrentBranch.DataSource = loBranch.getAllData("ViewAll", "", ""); cboCurrentBranch.DisplayMember = "Description"; cboCurrentBranch.ValueMember = "Id"; cboCurrentBranch.SelectedIndex = 0; cboSODebitAccount.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboSODebitAccount.DisplayMember = "Account Title"; cboSODebitAccount.ValueMember = "Id"; cboSODebitAccount.SelectedIndex = -1; cboSOCreditAccount.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboSOCreditAccount.DisplayMember = "Account Title"; cboSOCreditAccount.ValueMember = "Id"; cboSOCreditAccount.SelectedIndex = -1; cboPODebitAccount.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboPODebitAccount.DisplayMember = "Account Title"; cboPODebitAccount.ValueMember = "Id"; cboPODebitAccount.SelectedIndex = -1; cboPOCreditAccount.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboPOCreditAccount.DisplayMember = "Account Title"; cboPOCreditAccount.ValueMember = "Id"; cboPOCreditAccount.SelectedIndex = -1; cboCRDebitAccount.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboCRDebitAccount.DisplayMember = "Account Title"; cboCRDebitAccount.ValueMember = "Id"; cboCRDebitAccount.SelectedIndex = -1; cboCRCreditAccount.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboCRCreditAccount.DisplayMember = "Account Title"; cboCRCreditAccount.ValueMember = "Id"; cboCRCreditAccount.SelectedIndex = -1; cboCDDebitAccount.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboCDDebitAccount.DisplayMember = "Account Title"; cboCDDebitAccount.ValueMember = "Id"; cboCDDebitAccount.SelectedIndex = -1; cboCDCreditAccount.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboCDCreditAccount.DisplayMember = "Account Title"; cboCDCreditAccount.ValueMember = "Id"; cboCDCreditAccount.SelectedIndex = -1; cboCashierPeriodDebit.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboCashierPeriodDebit.DisplayMember = "Account Title"; cboCashierPeriodDebit.ValueMember = "Id"; cboCashierPeriodDebit.SelectedIndex = -1; cboCashierPeriodCredit.DataSource = loChartOfAccount.getAllData("ViewAll", "", ""); cboCashierPeriodCredit.DisplayMember = "Account Title"; cboCashierPeriodCredit.ValueMember = "Id"; cboCashierPeriodCredit.SelectedIndex = -1; } catch { } try { refresh(); readSystemSettings(); } catch { } }
private void getSubsidiary() { try { foreach (DataRow _dr in loChartOfAccount.getAllData("", cboChartOfAccount.SelectedValue.ToString(), "").Rows) { if (_dr["Subsidiary"].ToString() != "") { lblSubsidiary.Text = _dr["Subsidiary"].ToString(); cboSubsidiary.Enabled = true; btnLookupSubsidiary.Enabled = true; if (lblSubsidiary.Text == "Bank") { cboSubsidiary.DataSource = null; cboSubsidiary.DataSource = loBank.getAllData("ViewAll", "", ""); cboSubsidiary.ValueMember = "Id"; cboSubsidiary.DisplayMember = "Description"; cboSubsidiary.SelectedIndex = -1; } else if (lblSubsidiary.Text == "Customer") { cboSubsidiary.DataSource = null; cboSubsidiary.DataSource = loCustomer.getAllData("ViewAll", "", ""); cboSubsidiary.ValueMember = "Id"; cboSubsidiary.DisplayMember = "Name"; cboSubsidiary.SelectedIndex = -1; } else if (lblSubsidiary.Text == "Supplier") { cboSubsidiary.DataSource = null; cboSubsidiary.DataSource = loSupplier.getAllData("ViewAll", "", ""); cboSubsidiary.ValueMember = "Id"; cboSubsidiary.DisplayMember = "Name"; cboSubsidiary.SelectedIndex = -1; } else if (lblSubsidiary.Text == "Sales Person") { cboSubsidiary.DataSource = null; cboSubsidiary.DataSource = loSalesPerson.getSalesPersonNames(); cboSubsidiary.ValueMember = "Id"; cboSubsidiary.DisplayMember = "Name"; cboSubsidiary.SelectedIndex = -1; } else if (lblSubsidiary.Text == "Equipment") { cboSubsidiary.DataSource = null; cboSubsidiary.DataSource = loEquipment.getAllData("ViewAll", "", ""); cboSubsidiary.ValueMember = "Id"; cboSubsidiary.DisplayMember = "Description"; cboSubsidiary.SelectedIndex = -1; } else if (lblSubsidiary.Text == "Building") { cboSubsidiary.DataSource = null; cboSubsidiary.DataSource = loBuilding.getAllData("ViewAll", "", ""); cboSubsidiary.ValueMember = "Id"; cboSubsidiary.DisplayMember = "Description"; cboSubsidiary.SelectedIndex = -1; } } else { lblSubsidiary.Text = ""; cboSubsidiary.Enabled = false; btnLookupSubsidiary.Enabled = false; cboSubsidiary.DataSource = null; } } } catch { } /* * catch * { * lblSubsidiary.Text = ""; * cboSubsidiary.Enabled = false; * btnLookupSubsidiary.Enabled = false; * cboSubsidiary.DataSource = null; * } */ }
private void load() { try { decimal _totalEarnings = 0; decimal _totalExpenses = 0; decimal _overAllTotalDebit = 0; decimal _overAllTotalCredit = 0; //income try { dgvIncomeEntry.Rows.Clear(); decimal _totaldebit = 0; decimal _totalcredit = 0; foreach (DataRow _drIncomeStatement in loJournalEntryDetail.getIncomeStatementForClosingEntry(int.Parse(txtFinancialYear.Text), GlobalVariables.IncomeClassificationCode).Rows) { decimal _total = decimal.Parse(_drIncomeStatement["Credit"].ToString()) - decimal.Parse(_drIncomeStatement["Debit"].ToString()); if (_total >= 0) { _totaldebit += _total; _totalcredit += 0; int i = dgvIncomeEntry.Rows.Add(); dgvIncomeEntry.Rows[i].Cells["IncomeAccountId"].Value = _drIncomeStatement["Account Id"].ToString(); dgvIncomeEntry.Rows[i].Cells["IncomeAccountCode"].Value = _drIncomeStatement["Account Code"].ToString(); dgvIncomeEntry.Rows[i].Cells["IncomeAccountTitle"].Value = _drIncomeStatement["Account Title"].ToString(); dgvIncomeEntry.Rows[i].Cells["IncomeDebit"].Value = string.Format("{0:n}", _total); dgvIncomeEntry.Rows[i].Cells["IncomeCredit"].Value = string.Format("{0:n}", 0); _overAllTotalDebit += _total; _overAllTotalCredit += 0; } else { _totaldebit += 0; _totalcredit += (_total * -1); int i = dgvIncomeEntry.Rows.Add(); dgvIncomeEntry.Rows[i].Cells["IncomeAccountId"].Value = _drIncomeStatement["Account Id"].ToString(); dgvIncomeEntry.Rows[i].Cells["IncomeAccountCode"].Value = _drIncomeStatement["Account Code"].ToString(); dgvIncomeEntry.Rows[i].Cells["IncomeAccountTitle"].Value = _drIncomeStatement["Account Title"].ToString(); dgvIncomeEntry.Rows[i].Cells["IncomeDebit"].Value = string.Format("{0:n}", 0); dgvIncomeEntry.Rows[i].Cells["IncomeCredit"].Value = string.Format("{0:n}", _total * -1); _overAllTotalDebit += 0; _overAllTotalCredit += (_total * -1); } } int j = dgvIncomeEntry.Rows.Add(); foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.IncomeAndExpenseSummaryCode, "").Rows) { dgvIncomeEntry.Rows[j].Cells["IncomeAccountId"].Value = _dr["Id"].ToString(); dgvIncomeEntry.Rows[j].Cells["IncomeAccountCode"].Value = _dr["Code"].ToString(); dgvIncomeEntry.Rows[j].Cells["IncomeAccountTitle"].Value = _dr["Account Title"].ToString(); dgvIncomeEntry.Rows[j].Cells["IncomeDebit"].Value = string.Format("{0:n}", _totalcredit); dgvIncomeEntry.Rows[j].Cells["IncomeCredit"].Value = string.Format("{0:n}", _totaldebit); _overAllTotalDebit += _totalcredit; _overAllTotalCredit += _totaldebit; _totalEarnings = _totaldebit - _totalcredit; } } catch (Exception ex) { throw ex; } //expenses try { dgvExpenseEntry.Rows.Clear(); decimal _totaldebit = 0; decimal _totalcredit = 0; foreach (DataRow _drIncomeStatement in loJournalEntryDetail.getIncomeStatementForClosingEntry(int.Parse(txtFinancialYear.Text), GlobalVariables.ExpensesClassificationCode).Rows) { decimal _total = decimal.Parse(_drIncomeStatement["Debit"].ToString()) - decimal.Parse(_drIncomeStatement["Credit"].ToString()); if (_total >= 0) { _totaldebit += 0; _totalcredit += _total; int i = dgvExpenseEntry.Rows.Add(); dgvExpenseEntry.Rows[i].Cells["ExpenseAccountId"].Value = _drIncomeStatement["Account Id"].ToString(); dgvExpenseEntry.Rows[i].Cells["ExpenseAccountCode"].Value = _drIncomeStatement["Account Code"].ToString(); dgvExpenseEntry.Rows[i].Cells["ExpenseAccountTitle"].Value = _drIncomeStatement["Account Title"].ToString(); dgvExpenseEntry.Rows[i].Cells["ExpenseDebit"].Value = string.Format("{0:n}", 0); dgvExpenseEntry.Rows[i].Cells["ExpenseCredit"].Value = string.Format("{0:n}", _total); _overAllTotalDebit += 0; _overAllTotalCredit += _total; } else { _totaldebit += (_total * -1); _totalcredit += 0; int i = dgvExpenseEntry.Rows.Add(); dgvExpenseEntry.Rows[i].Cells["ExpenseAccountId"].Value = _drIncomeStatement["Account Id"].ToString(); dgvExpenseEntry.Rows[i].Cells["ExpenseAccountCode"].Value = _drIncomeStatement["Account Code"].ToString(); dgvExpenseEntry.Rows[i].Cells["ExpenseAccountTitle"].Value = _drIncomeStatement["Account Title"].ToString(); dgvExpenseEntry.Rows[i].Cells["ExpenseDebit"].Value = string.Format("{0:n}", (_total * -1)); dgvExpenseEntry.Rows[i].Cells["ExpenseCredit"].Value = string.Format("{0:n}", 0); _overAllTotalDebit += (_total * -1); _overAllTotalCredit += 0; } } int j = dgvExpenseEntry.Rows.Add(); foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.IncomeAndExpenseSummaryCode, "").Rows) { dgvExpenseEntry.Rows[j].Cells["ExpenseAccountId"].Value = _dr["Id"].ToString(); dgvExpenseEntry.Rows[j].Cells["ExpenseAccountCode"].Value = _dr["Code"].ToString(); dgvExpenseEntry.Rows[j].Cells["ExpenseAccountTitle"].Value = _dr["Account Title"].ToString(); dgvExpenseEntry.Rows[j].Cells["ExpenseDebit"].Value = string.Format("{0:n}", _totalcredit); dgvExpenseEntry.Rows[j].Cells["ExpenseCredit"].Value = string.Format("{0:n}", _totaldebit); _overAllTotalDebit += _totalcredit; _overAllTotalCredit += _totaldebit; _totalExpenses = _totalcredit - _totaldebit; } } catch (Exception ex) { throw ex; } // retained earnings if (_totalEarnings >= _totalExpenses) { dgvRetainedEarningEntry.Rows.Clear(); int k = dgvRetainedEarningEntry.Rows.Add(); foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.RetainedEarningsCode, "").Rows) { dgvRetainedEarningEntry.Rows[k].Cells["REAccountId"].Value = _dr["Id"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REAccountCode"].Value = _dr["Code"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REAccountTitle"].Value = _dr["Account Title"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REDebit"].Value = string.Format("{0:n}", 0); dgvRetainedEarningEntry.Rows[k].Cells["RECredit"].Value = string.Format("{0:n}", _totalEarnings - _totalExpenses); _overAllTotalDebit += 0; _overAllTotalCredit += _totalEarnings - _totalExpenses; } int l = dgvRetainedEarningEntry.Rows.Add(); foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.IncomeAndExpenseSummaryCode, "").Rows) { dgvRetainedEarningEntry.Rows[k].Cells["REAccountId"].Value = _dr["Id"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REAccountCode"].Value = _dr["Code"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REAccountTitle"].Value = _dr["Account Title"].ToString(); dgvRetainedEarningEntry.Rows[l].Cells["REDebit"].Value = string.Format("{0:n}", _totalEarnings - _totalExpenses); dgvRetainedEarningEntry.Rows[l].Cells["RECredit"].Value = string.Format("{0:n}", 0); _overAllTotalDebit += _totalEarnings - _totalExpenses; _overAllTotalCredit += 0; } } else { dgvRetainedEarningEntry.Rows.Clear(); int k = dgvRetainedEarningEntry.Rows.Add(); foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.RetainedEarningsCode, "").Rows) { dgvRetainedEarningEntry.Rows[k].Cells["REAccountId"].Value = _dr["Id"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REAccountCode"].Value = _dr["Code"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REAccountTitle"].Value = _dr["Account Title"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REDebit"].Value = string.Format("{0:n}", (_totalEarnings - _totalExpenses) * -1); dgvRetainedEarningEntry.Rows[k].Cells["RECredit"].Value = string.Format("{0:n}", 0); _overAllTotalDebit += (_totalEarnings - _totalExpenses) * -1; _overAllTotalCredit += 0; } int l = dgvRetainedEarningEntry.Rows.Add(); foreach (DataRow _dr in loChartOfAccount.getAllData("", GlobalVariables.IncomeAndExpenseSummaryCode, "").Rows) { dgvRetainedEarningEntry.Rows[k].Cells["REAccountId"].Value = _dr["Id"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REAccountCode"].Value = _dr["Code"].ToString(); dgvRetainedEarningEntry.Rows[k].Cells["REAccountTitle"].Value = _dr["Account Title"].ToString(); dgvRetainedEarningEntry.Rows[l].Cells["REDebit"].Value = string.Format("{0:n}", 0); dgvRetainedEarningEntry.Rows[l].Cells["RECredit"].Value = string.Format("{0:n}", (_totalEarnings - _totalExpenses) * -1); _overAllTotalDebit += 0; _overAllTotalCredit += (_totalEarnings - _totalExpenses) * -1; } } txtTotalDebit.Text = string.Format("{0:n}", _overAllTotalDebit); txtTotalCredit.Text = string.Format("{0:n}", _overAllTotalCredit); } catch (Exception ex) { throw ex; } }