private void cboxBankAccount_SelectedIndexChanged(object sender, EventArgs e)
{
int bankAccountId = 0;
int.TryParse(cboxBankAccount.SelectedValue.ToString(), out bankAccountId);
if (bankAccountId == 0)
{
return;
}
decimal closingBalance = 0;
DateTime date = DateTime.Now;
date.AddDays(1);
JSManagementDataSet.BankAccountDetailDataTable bankAccountDetailData = bankAccountDetailTableAdapter.GetBankAccountOpeningBalanceByDateAndBankAccountId(date, bankAccountId);
if (bankAccountDetailData.Rows.Count > 0)
{
closingBalance = bankAccountDetailData[0].RuningTotal;
}
lbAvaiableClosingBalance.Text = closingBalance.ToString("#,###");
btFind_Click(new object(), new EventArgs());
}
private void btFind_Click(object sender, EventArgs e)
{
if (cboxBankAccount.SelectedValue.ToString() == "0")
{
grvBankAccountTransactionDetail.DataSource = null;
return;
}
int bankAccountId = int.Parse(cboxBankAccount.SelectedValue.ToString());
JSManagementDataSet.BankAccountDetailDataTable bankAccountDetailData = bankAccountDetailTableAdapter.GetBankAccountDetail(dateTimePickerFrom.Value, dateTimePickerTo.Value, bankAccountId);
grvBankAccountTransactionDetail.DataSource = bankAccountDetailData;
JSManagementDataSet.BankAccountDetailDataTable bankAccountOpeningData = bankAccountDetailTableAdapter.GetBankAccountOpeningBalanceByDateAndBankAccountId(dateTimePickerFrom.Value, bankAccountId);
lbOpeningBalanceFind.Text = bankAccountOpeningData.Rows.Count > 0 ? bankAccountOpeningData[0].RuningTotal.ToString("#,###", cul) : "0";
lbClosingBalanceFind.Text = bankAccountDetailData.Rows.Count > 0 ? bankAccountDetailData[bankAccountDetailData.Rows.Count - 1].RuningTotal.ToString("#,###") : lbOpeningBalanceFind.Text;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.INCOME_ID].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.INCOME_DATE].HeaderText = Constant.BankAccountDetail.ColumnHeaderText.INCOME_DATE;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.INCOME_NUMBER].HeaderText = Constant.BankAccountDetail.ColumnHeaderText.INCOME_NUMBER;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.PAYER_NAME].HeaderText = Constant.BankAccountDetail.ColumnHeaderText.PAYER_NAME;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.REASON].HeaderText = Constant.BankAccountDetail.ColumnHeaderText.REASON;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.AMOUNT].HeaderText = Constant.BankAccountDetail.ColumnHeaderText.AMOUNT;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.AMOUNT1].HeaderText = Constant.BankAccountDetail.ColumnHeaderText.AMOUNT1;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.RUNING_TOTAL].HeaderText = Constant.BankAccountDetail.ColumnHeaderText.RUNING_TOTAL;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.CREATED_BY].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.CREATED_DATE].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.LAST_EDITED_BY].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.LAST_EDITED_DATE].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.ORDER_ID].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.COST_ID].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.PURCHASE_RECEIPT_ORDER_ID].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.TO_BANK_ACCOUNT_ID].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.FROM_BANK_ACCOUNT_ID].Visible = false;
grvBankAccountTransactionDetail.Columns[Constant.BankAccountDetail.ColumnName.PURCHASE_ORDER_BANK_ACCOUNT_ID].Visible = false;
}
