public decimal JournalMasterEdit(JournalMasterInfo journalmasterinfo)
{
decimal decEffectRow = 0m;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("JournalMasterEdit", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam14 = new SqlParameter();
sprmparam14 = sccmd.Parameters.Add("@journalMasterId", SqlDbType.Decimal);
sprmparam14.Value = journalmasterinfo.JournalMasterId;
sprmparam14 = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar);
sprmparam14.Value = journalmasterinfo.VoucherNo;
sprmparam14 = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar);
sprmparam14.Value = journalmasterinfo.InvoiceNo;
sprmparam14 = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal);
sprmparam14.Value = journalmasterinfo.SuffixPrefixId;
sprmparam14 = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam14.Value = journalmasterinfo.Date;
sprmparam14 = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal);
sprmparam14.Value = journalmasterinfo.TotalAmount;
sprmparam14 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam14.Value = journalmasterinfo.Narration;
sprmparam14 = sccmd.Parameters.Add("@userId", SqlDbType.Decimal);
sprmparam14.Value = journalmasterinfo.UserId;
sprmparam14 = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal);
sprmparam14.Value = journalmasterinfo.VoucherTypeId;
sprmparam14 = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal);
sprmparam14.Value = journalmasterinfo.FinancialYearId;
sprmparam14 = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam14.Value = journalmasterinfo.ExtraDate;
sprmparam14 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam14.Value = journalmasterinfo.Extra1;
sprmparam14 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam14.Value = journalmasterinfo.Extra2;
decEffectRow = sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
return(decEffectRow);
}
public decimal JournalMasterAdd(JournalMasterInfo infoJournalmaster)
{
decimal decId = 0;
try
{
decId = spJournalMaster.JournalMasterAdd(infoJournalmaster);
}
catch (Exception ex)
{
MessageBox.Show("JVBLL7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decId);
}
public JournalMasterInfo JournalMasterView(decimal decJournalMasterId)
{
JournalMasterInfo infoJournalmaster = new JournalMasterInfo();
try
{
infoJournalmaster = spJournalMaster.JournalMasterView(decJournalMasterId);
}
catch (Exception ex)
{
MessageBox.Show("JVBLL11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(infoJournalmaster);
}
public decimal JournalMasterEdit(JournalMasterInfo infoJournalmaster)
{
decimal decEffectRow = 0;
try
{
decEffectRow = spJournalMaster.JournalMasterEdit(infoJournalmaster);
}
catch (Exception ex)
{
MessageBox.Show("JVBLL8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decEffectRow);
}
public JournalMasterInfo JournalMasterView(decimal journalMasterId)
{
JournalMasterInfo journalmasterinfo = new JournalMasterInfo();
SqlDataReader sdrreader = null;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("JournalMasterView", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam2 = new SqlParameter();
sprmparam2 = sccmd.Parameters.Add("@journalMasterId", SqlDbType.Decimal);
sprmparam2.Value = journalMasterId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
journalmasterinfo.JournalMasterId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString());
journalmasterinfo.VoucherNo = ((DbDataReader)sdrreader)[1].ToString();
journalmasterinfo.InvoiceNo = ((DbDataReader)sdrreader)[2].ToString();
journalmasterinfo.SuffixPrefixId = decimal.Parse(((DbDataReader)sdrreader)[3].ToString());
journalmasterinfo.Date = DateTime.Parse(((DbDataReader)sdrreader)[4].ToString());
journalmasterinfo.TotalAmount = decimal.Parse(((DbDataReader)sdrreader)[5].ToString());
journalmasterinfo.Narration = ((DbDataReader)sdrreader)[6].ToString();
journalmasterinfo.UserId = decimal.Parse(((DbDataReader)sdrreader)[7].ToString());
journalmasterinfo.VoucherTypeId = decimal.Parse(((DbDataReader)sdrreader)[8].ToString());
journalmasterinfo.FinancialYearId = decimal.Parse(((DbDataReader)sdrreader)[9].ToString());
journalmasterinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)[10].ToString());
journalmasterinfo.Extra1 = ((DbDataReader)sdrreader)[11].ToString();
journalmasterinfo.Extra2 = ((DbDataReader)sdrreader)[12].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
base.sqlcon.Close();
}
return(journalmasterinfo);
}
/// <summary>
/// Function to edit the debitnote voucher
/// </summary>
/// <param name="decJournalMasterId"></param>
public void Edit(decimal decJournalMasterId)
{
try
{
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
JournalMasterInfo infoJournalMaster = new JournalMasterInfo();
JournalVoucherBll bllJournalDetails = new JournalVoucherBll();
JournalDetailsInfo infoJournalDetails = new JournalDetailsInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
/*****************Update in JournalMaster table *************/
decimal decTotalDebit = 0;
decimal decTotalCredit = 0;
infoJournalMaster.JournalMasterId = decJournalMasterId;
infoJournalMaster.VoucherNo = strVoucherNo;
infoJournalMaster.InvoiceNo = txtVoucherNo.Text.Trim();
infoJournalMaster.SuffixPrefixId = decJournalSuffixPrefixId;
infoJournalMaster.Date = Convert.ToDateTime(txtDate.Text);
infoJournalMaster.Narration = txtNarration.Text.Trim();
infoJournalMaster.UserId = PublicVariables._decCurrentUserId;
infoJournalMaster.VoucherTypeId = decJournalVoucherTypeId;
infoJournalMaster.FinancialYearId = Convert.ToDecimal(PublicVariables._decCurrentFinancialYearId.ToString());
infoJournalMaster.ExtraDate = DateTime.Now;
infoJournalMaster.Extra1 = string.Empty;
infoJournalMaster.Extra2 = string.Empty;
decTotalDebit = Convert.ToDecimal(txtDebitTotal.Text.Trim());
decTotalCredit = Convert.ToDecimal(txtCreditTotal.Text.Trim());
infoJournalMaster.TotalAmount = decTotalDebit;
decimal decEffectRow = bllJournalMaster.JournalMasterEdit(infoJournalMaster);
/**********************JournalDetails Edit********************/
if (decEffectRow > 0)
{
infoJournalDetails.JournalMasterId = decJournalMasterId;
infoJournalDetails.ExtraDate = DateTime.Now;
infoJournalDetails.Extra1 = string.Empty;
infoJournalDetails.Extra2 = string.Empty;
//-----------to delete details, LedgerPosting and bankReconciliation of removed rows--------------//
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
foreach (object obj in arrlstOfRemove)
{
string str = Convert.ToString(obj);
bllJournalDetails.JournalDetailsDelete(Convert.ToDecimal(str));
BllLedgerPosting.LedgerPostDeleteByDetailsId(Convert.ToDecimal(str), strVoucherNo, decJournalVoucherTypeId);
}
BllLedgerPosting.LedgerPostingDeleteByVoucherNoVoucherTypeIdAndLedgerId(strVoucherNo, decJournalVoucherTypeId, 12);
//=============================================================================================//
decimal decLedgerId = 0;
decimal decDebit = 0;
decimal decCredit = 0;
decimal decJournalDetailsId = 0;
int inRowCount = dgvJournalVoucher.RowCount;
for (int inI = 0; inI < inRowCount; inI++)
{
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
infoJournalDetails.LedgerId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
decLedgerId = infoJournalDetails.LedgerId;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() != string.Empty)
{
//------------------Currency conversion------------------//
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value));
decAmount = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
//======================================================//
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() == "Dr")
{
infoJournalDetails.Debit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Credit = 0;
decDebit = decConvertRate;
decCredit = infoJournalDetails.Credit;
}
else
{
infoJournalDetails.Credit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Debit = 0;
decDebit = infoJournalDetails.Debit;
decCredit = decConvertRate;
}
infoJournalDetails.ExchangeRateId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString());
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeNo = dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoJournalDetails.ChequeNo = string.Empty;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeDate = Convert.ToDateTime(dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
infoJournalDetails.ChequeDate = DateTime.Now;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString() != string.Empty)
{
infoJournalDetails.JournalDetailsId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString());
bllJournalDetails.JournalDetailsEdit(infoJournalDetails);
PartyBalanceAddOrEdit(inI);
decJournalDetailsId = infoJournalDetails.JournalDetailsId;
decimal decLedgerPostId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value.ToString());
LedgerPostingEdit(decLedgerPostId, decLedgerId, decCredit, decDebit, decJournalDetailsId, inI);
}
else
{
decJournalDetailsId = bllJournalDetails.JournalDetailsAdd(infoJournalDetails);
PartyBalanceAddOrEdit(inI);
LedgerPosting(decLedgerId, decCredit, decDebit, decJournalDetailsId, inI);
}
}
}
DeletePartyBalanceOfRemovedRow();
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(infoJournalMaster.JournalMasterId);
}
else
{
Print(infoJournalMaster.JournalMasterId);
}
}
if (journalRegisterObj != null)
{
this.Close();
journalRegisterObj.Enabled = true;
}
else if (frmJournalReportObj != null)
{
this.Close();
frmJournalReportObj.Enabled = true;
}
else if (frmDayBookObj != null)
{
this.Close();
}
else if (frmBillallocationObj != null)
{
this.Close();
}
}
//----------------If print after save is enable-----------------------//
//===================================================================//
}
catch (Exception ex)
{
MessageBox.Show("JV16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Save the voucher
/// </summary>
public void Save()
{
try
{
decimal decTotalDebit = 0;
decimal decTotalCredit = 0;
decTotalDebit = Convert.ToDecimal(txtDebitTotal.Text.Trim());
decTotalCredit = Convert.ToDecimal(txtCreditTotal.Text.Trim());
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
JournalVoucherBll bllJournalVoucher = new JournalVoucherBll();
JournalMasterInfo infoJournalMaster = new JournalMasterInfo();
JournalDetailsInfo infoJournalDetails = new JournalDetailsInfo();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
PartyBalanceInfo InfopartyBalance = new PartyBalanceInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
infoJournalMaster.VoucherNo = strVoucherNo;
infoJournalMaster.InvoiceNo = txtVoucherNo.Text;
infoJournalMaster.SuffixPrefixId = decJournalSuffixPrefixId;
infoJournalMaster.Date = Convert.ToDateTime(txtDate.Text);
infoJournalMaster.Narration = txtNarration.Text.Trim();
infoJournalMaster.UserId = PublicVariables._decCurrentUserId;
infoJournalMaster.VoucherTypeId = decJournalVoucherTypeId;
infoJournalMaster.FinancialYearId = Convert.ToDecimal(PublicVariables._decCurrentFinancialYearId.ToString());
infoJournalMaster.Extra1 = string.Empty;
infoJournalMaster.Extra2 = string.Empty;
infoJournalMaster.ExtraDate = DateTime.Now;
infoJournalMaster.TotalAmount = decTotalDebit;
decimal decJournalMasterId = bllJournalMaster.JournalMasterAdd(infoJournalMaster);
/*******************JournalDetailsAdd and LedgerPosting*************************/
infoJournalDetails.JournalMasterId = decJournalMasterId;
infoJournalDetails.ExtraDate = DateTime.Now;
infoJournalDetails.Extra1 = string.Empty;
infoJournalDetails.Extra2 = string.Empty;
decimal decLedgerId = 0;
decimal decDebit = 0;
decimal decCredit = 0;
int inRowCount = dgvJournalVoucher.RowCount;
for (int inI = 0; inI < inRowCount - 1; inI++)
{
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
infoJournalDetails.LedgerId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
decLedgerId = infoJournalDetails.LedgerId;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() != string.Empty)
{
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString() != string.Empty)
{
//--------Currency conversion--------------//
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString()));
decAmount = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
//===========================================//
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() == "Dr")
{
infoJournalDetails.Debit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Credit = 0;
decDebit = decConvertRate;
decCredit = infoJournalDetails.Credit;
}
else
{
infoJournalDetails.Credit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Debit = 0;
decDebit = infoJournalDetails.Debit;
decCredit = decConvertRate;
}
}
infoJournalDetails.ExchangeRateId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString());
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeNo = dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoJournalDetails.ChequeNo = string.Empty;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeDate = Convert.ToDateTime(dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
infoJournalDetails.ChequeDate = DateTime.Now;
}
decimal decJournalDetailsId = bllJournalVoucher.JournalDetailsAdd(infoJournalDetails);
if (decJournalDetailsId != 0)
{
PartyBalanceAddOrEdit(inI);
LedgerPosting(decLedgerId, decCredit, decDebit, decJournalDetailsId, inI);
}
}
}
Messages.SavedMessage();
//----------------If print after save is enable-----------------------//
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decJournalMasterId);
}
else
{
Print(decJournalMasterId);
}
}
//===================================================================//
}
catch (Exception ex)
{
MessageBox.Show("JV14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the fields for edit or delete
/// </summary>
public void FillFunction()
{
try
{
JournalMasterInfo infoJournalMaster = new JournalMasterInfo();
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
infoJournalMaster = bllJournalMaster.JournalMasterView(decJournalMasterIdForEdit);
VoucherTypeInfo infoVoucherType = new VoucherTypeInfo();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
infoVoucherType = BllVoucherType.VoucherTypeView(infoJournalMaster.VoucherTypeId);
this.Text = infoVoucherType.VoucherTypeName;
txtVoucherNo.ReadOnly = false;
strVoucherNo = infoJournalMaster.VoucherNo;
strInvoiceNo = infoJournalMaster.InvoiceNo;
txtVoucherNo.Text = strInvoiceNo;
decJournalSuffixPrefixId = infoJournalMaster.SuffixPrefixId;
decJournalVoucherTypeId = infoJournalMaster.VoucherTypeId;
dtpVoucherDate.Value = infoJournalMaster.Date;
txtNarration.Text = infoJournalMaster.Narration;
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(decJournalVoucherTypeId);
if (isAutomatic)
{
txtVoucherNo.ReadOnly = true;
}
else
{
txtVoucherNo.ReadOnly = false;
}
//GridFill
List<DataTable> ListObj = new List<DataTable>();
JournalVoucherBll bllJournalDetailsSp = new JournalVoucherBll();
ListObj = bllJournalDetailsSp.JournalDetailsViewByMasterId(decJournalMasterIdForEdit);
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
for (int inI = 0; inI < ListObj[0].Rows.Count; inI++)
{
dgvJournalVoucher.Rows.Add();
dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value = Convert.ToDecimal(ListObj[0].Rows[inI]["ledgerId"].ToString());
if (Convert.ToDecimal(ListObj[0].Rows[inI]["debit"].ToString()) == 0)
{
dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value = "Cr";
dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[inI]["credit"].ToString());
}
else
{
dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value = "Dr";
dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[inI]["debit"].ToString());
}
dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(ListObj[0].Rows[inI]["exchangeRateId"].ToString());
if (ListObj[0].Rows[inI]["chequeNo"].ToString() != string.Empty)
{
dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value = ListObj[0].Rows[inI]["chequeNo"].ToString();
dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value = (Convert.ToDateTime(ListObj[0].Rows[inI]["chequeDate"].ToString())).ToString("dd-MMM-yyyy");
}
dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value = ListObj[0].Rows[inI]["journalDetailsId"].ToString();
decimal decDetailsId1 = Convert.ToDecimal(ListObj[0].Rows[inI]["journalDetailsId"].ToString());
decimal decLedgerPostingId = BllLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, decJournalVoucherTypeId);
dgvJournalVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString();
btnSave.Text = "Update";
}
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
List<DataTable> listObj = new List<DataTable>();
listObj = BllPartyBalance.PartyBalanceViewByVoucherNoAndVoucherType(decJournalVoucherTypeId, strVoucherNo, infoJournalMaster.Date);
dtblPartyBalance = listObj[0];
dgvJournalVoucher.ClearSelection();
txtDate.Focus();
}
catch (Exception ex)
{
MessageBox.Show("JV37:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}