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