private void LoadVoucher(int VoucherMasterId)
{
try
{
DataSet dsVocuher = VM.GetVoucherStructure(VoucherMasterId);
dsVocuher.Tables[0].TableName = "VoucherMaster";
dsVocuher.Tables[1].TableName = "VoucherDetail";
dsVocuher.Tables[2].TableName = "FlagDC";
dsVocuher.Tables[3].TableName = "ChartOfAccount";
if (dsVocuher.Tables["VoucherMaster"].Rows.Count > 0)
{
dtpVoucher.Text = dsVocuher.Tables["VoucherMaster"].Rows[0]["Date"].ToString();
txtNaration.Text = dsVocuher.Tables["VoucherMaster"].Rows[0]["Narration"].ToString();
txtAmount.Text = dsVocuher.Tables["VoucherMaster"].Rows[0]["TotalDebit"].ToString();
DataRow drDebit = dsVocuher.Tables["VoucherDetail"].Select("FlagDC = 'D'")[0];
txtCustomerCode.Text = drDebit["CustomerCode"].ToString();
txtAccCode.Text = drDebit["AccountCode"].ToString();
DataRow drCredit = dsVocuher.Tables["VoucherDetail"].Select("FlagDC = 'C'")[0];
txtBankAcc.Text = drCredit["AccountCode"].ToString();
//txtBankAccountCode
//txtRemarks.Text = drCredit["Remarks"].ToString();
DataTable dtVoucherDetail = manageBank.GetBankVoucherDetailByVoucherMasterId(VoucherMasterId);
if (dtVoucherDetail.Rows.Count > 0)
{
try
{
BankVoucherDetailId = Convert.ToInt32(dtVoucherDetail.Rows[0]["BankVoucherDetailId"]);
BankACId = Convert.ToInt32(dtVoucherDetail.Rows[0]["BankAccountId"]);
txtBankAccountCode.Text = manageBank.GetBankAccount(BankACId).Rows[0]["Code"].ToString();
txtChequeNumber.Text = dtVoucherDetail.Rows[0]["ChequeNumber"].ToString();
cmbChequeBank.SelectedValue = dtVoucherDetail.Rows[0]["ChequeBankId"].ToString();
dtpCheque.Value = Convert.ToDateTime(dtVoucherDetail.Rows[0]["ChequeDate"]);
}
catch (Exception ex)
{
}
}
ButtonRights(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void LoadBankAccount(int BACId)
{
DataTable dtBankAC = manageBank.GetBankAccount(BACId);;
if (dtBankAC.Rows.Count > 0)
{
txtBranchCode.Text = dtBankAC.Rows[0]["BranchCode"].ToString();
txtACNumber.Text = dtBankAC.Rows[0]["AccountNo"].ToString();
txtACTitle.Text = dtBankAC.Rows[0]["AccountTitle"].ToString();
cmbBankName.SelectedValue = dtBankAC.Rows[0]["BankId"].ToString();
txtCOACode.Text = manageAccount.GetChartOfAccounts(Convert.ToInt32(dtBankAC.Rows[0]["COAId"])).Rows[0]["AccountCode"].ToString();
txtBranchCode.Focus();
ButtonRights(false);
}
}
private void LoadBankAccount(int BankACId)
{
BankManager manageBank = new BankManager();
DataTable dtBankAccount = manageBank.GetBankAccount(BankACId);
if (dtBankAccount.Rows.Count > 0)
{
txtBACTitle.Text = dtBankAccount.Rows[0]["AccountTitle"].ToString();
if (!string.IsNullOrEmpty(dtBankAccount.Rows[0]["COAId"].ToString()))
{
txtBankAcc.Text = manageAccount.GetChartOfAccounts(Convert.ToInt32(dtBankAccount.Rows[0]["COAId"])).Rows[0]["AccountCode"].ToString();
}
BankId = Convert.ToInt32(dtBankAccount.Rows[0]["BankId"]);
}
}