/// <summary>
/// Ledger posting edit function
/// </summary>
/// <param name="decpdcMasterId"></param>
public void LedgerPostingEdit(decimal decpdcMasterId)
{
PDCPayableMasterSP SpPDCPayable = new PDCPayableMasterSP();
DataTable dtblLedgerPostingId = new DataTable();
LedgerPostingSP SpLedgerPosting = new LedgerPostingSP();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
ExchangeRateSP SpExchangRate = new ExchangeRateSP();
decimal decOldExchange = 0;
decimal decNewExchangeRate = 0;
decimal decNewExchangeRateId = 0;
decimal decSelectedCurrencyRate = 0;
decimal decAmount = 0;
decimal decConvertRate = 0;
string strReferenceType = string.Empty;
decimal decOldExchangeId = 0;
try
{
dtblLedgerPostingId = SpPDCPayable.LedgerPostingIdByPDCpayableId(decpdcMasterId);
decimal decledgerpostingId1 = Convert.ToDecimal(dtblLedgerPostingId.Rows[0]["ledgerPostingId"].ToString());
decimal decLedgerPostingId2 = Convert.ToDecimal(dtblLedgerPostingId.Rows[1]["ledgerPostingId"].ToString());
if (!btnAgainstRef.Enabled)
{
infoLedgerPosting.LedgerPostingId = decledgerpostingId1;
infoLedgerPosting.VoucherTypeId = decPDCpayableVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtvoucherNo.Text.Trim();
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Debit = Convert.ToDecimal(txtAmount.Text.ToString());
infoLedgerPosting.Credit = 0;
infoLedgerPosting.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
infoLedgerPosting.ChequeNo = txtcheckNo.Text.Trim();
infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
SpLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
else
{
infoLedgerPosting.LedgerPostingId = decledgerpostingId1;
infoLedgerPosting.VoucherTypeId = decPDCpayableVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtvoucherNo.Text.Trim();
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Credit = 0;
foreach (DataRow dr in dtblPartyBalance.Rows)
{
if (infoLedgerPosting.LedgerId == Convert.ToDecimal(dr["LedgerId"].ToString()))
{
decOldExchange = Convert.ToDecimal(dr["OldExchangeRate"].ToString());
decNewExchangeRateId = Convert.ToDecimal(dr["CurrencyId"].ToString());
decSelectedCurrencyRate = SpExchangRate.GetExchangeRateByExchangeRateId(decOldExchange);
decAmount = Convert.ToDecimal(dr["Amount"].ToString());
decConvertRate = decConvertRate + (decAmount * decSelectedCurrencyRate);
}
}
infoLedgerPosting.Debit = decConvertRate;
infoLedgerPosting.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
infoLedgerPosting.ChequeNo = txtcheckNo.Text.Trim();
infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
SpLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
infoLedgerPosting.LedgerId = 12;
foreach (DataRow dr in dtblPartyBalance.Rows)
{
if (Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString()) == Convert.ToDecimal(dr["LedgerId"].ToString()))
{
if (dr["ReferenceType"].ToString() == "Against")
{
decNewExchangeRateId = Convert.ToDecimal(dr["CurrencyId"].ToString());
decNewExchangeRate = SpExchangRate.GetExchangeRateByExchangeRateId(decNewExchangeRateId);
decOldExchangeId = Convert.ToDecimal(dr["OldExchangeRate"].ToString());
decOldExchange = SpExchangRate.GetExchangeRateByExchangeRateId(decOldExchangeId);
decAmount = Convert.ToDecimal(dr["Amount"].ToString());
decimal decForexAmount = (decAmount * decNewExchangeRate) - (decAmount * decOldExchange);
if (decForexAmount >= 0)
{
infoLedgerPosting.Debit = decForexAmount;
infoLedgerPosting.Credit = 0;
}
else
{
infoLedgerPosting.Credit = -1 * decForexAmount;
infoLedgerPosting.Debit = 0;
}
SpLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
}
}
infoLedgerPosting.LedgerPostingId = decLedgerPostingId2;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtvoucherNo.Text.Trim();
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.LedgerId = 6;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = Convert.ToDecimal(txtAmount.Text.ToString());
infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate;
infoLedgerPosting.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
infoLedgerPosting.ChequeNo = txtcheckNo.Text.Trim();
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
SpLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
catch (Exception ex)
{
MessageBox.Show("PP15:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
