/// <summary>
/// Function to update values in ledgerposting table
/// </summary>
public void ledgerUpdate()
{
try
{
string strfinancialId;
FinancialYearBll BllFinancialYear = new FinancialYearBll();
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
infoFinancialYear = BllFinancialYear.FinancialYearViewForAccountLedger(1);
strfinancialId = infoFinancialYear.FromDate.ToString("dd-MMM-yyyy");
decimal decLedgerPostingId = 0;
if (txtOpeningBalance.Text.Trim() != string.Empty)
{
decOpeningBlnc = Convert.ToDecimal(txtOpeningBalance.Text.Trim());
}
else
{
decOpeningBlnc = 0;
}
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
List<DataTable> dtbl = BllLedgerPosting.GetLedgerPostingIds(decLedgerIdForEdit.ToString(), 1);
foreach (DataRow dr in dtbl[0].Rows)
{
decLedgerPostingId = Convert.ToDecimal(dr.ItemArray[0].ToString());
}
if (cmbDrorCr.Text == "Dr")
{
infoLedgerPosting.Debit = decOpeningBlnc;
}
else
{
infoLedgerPosting.Credit = decOpeningBlnc;
}
infoLedgerPosting.LedgerPostingId = decLedgerPostingId;
infoLedgerPosting.VoucherTypeId = 1;
infoLedgerPosting.VoucherNo = decLedgerIdForEdit.ToString();
infoLedgerPosting.Date = Convert.ToDateTime(strfinancialId.ToString());
infoLedgerPosting.LedgerId = decLedgerIdForEdit;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = decLedgerIdForEdit.ToString();
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
if (dtbl[0].Rows.Count > 0)
{
if (decOpeningBlnc > 0)
{
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
else
{
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
bllAccountLedger.LedgerPostingDeleteByVoucherTypeAndVoucherNo(decLedgerIdForEdit.ToString(), 1);
}
}
else
{
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
catch (Exception ex)
{
MessageBox.Show("Cus16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to update ledger posting table
/// </summary>
public void LedgerUpdate()
{
try
{
decimal decLedgerPostingId = 0;
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
List<DataTable> listObj = new List<DataTable>();
listObj = BllLedgerPosting.GetLedgerPostingIds(strVoucherNo, decMonthlyVoucherTypeId);
int ini = 0;
foreach (DataRow dr in listObj[0].Rows)
{
ini++;
if (ini == 2)
{
decLedgerPostingId = Convert.ToDecimal(dr.ItemArray[0].ToString());
infoLedgerPosting.LedgerPostingId = decLedgerPostingId;
infoLedgerPosting.Date = Convert.ToDateTime(dtpVoucherDate.Value.ToString());
if (isAutomatic)
{
infoLedgerPosting.VoucherNo = strVoucherNo;
}
else
{
infoLedgerPosting.VoucherNo = txtVoucherNo.Text;
}
infoLedgerPosting.Debit = Convert.ToDecimal(lblTotalAmount.Text.ToString());
infoLedgerPosting.Credit = 0;
infoLedgerPosting.VoucherTypeId = decMonthlyVoucherTypeId;
infoLedgerPosting.LedgerId = 4;
infoLedgerPosting.DetailsId = 0;
if (isAutomatic)
{
infoLedgerPosting.InvoiceNo = strInvoiceNo;
}
else
{
infoLedgerPosting.InvoiceNo = txtVoucherNo.Text;
}
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
if (ini == 1)
{
decLedgerPostingId = Convert.ToDecimal(dr.ItemArray[0].ToString());
infoLedgerPosting.LedgerPostingId = decLedgerPostingId;
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
if (isAutomatic)
{
infoLedgerPosting.VoucherNo = strVoucherNo;
}
else
{
infoLedgerPosting.VoucherNo = txtVoucherNo.Text;
}
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = Convert.ToDecimal(lblTotalAmount.Text.ToString());
infoLedgerPosting.VoucherTypeId = decMonthlyVoucherTypeId;
infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbCashOrBankAcc.SelectedValue.ToString());
infoLedgerPosting.DetailsId = 0;
if (isAutomatic)
{
infoLedgerPosting.InvoiceNo = strInvoiceNo;
}
else
{
infoLedgerPosting.InvoiceNo = txtVoucherNo.Text;
}
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
}
}
catch (Exception ex)
{
MessageBox.Show("MSV5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
///Function to edit ledgerposting incase of opening balance
/// </summary>
public void LedgerPostingEdit()
{
try
{
string strfinancialId;
decOpeningBalance = Convert.ToDecimal(((txtOpeningBalance.Text == "") ? "0" : txtOpeningBalance.Text.Trim()));
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
FinancialYearBll BllFinancialYear = new FinancialYearBll();
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
infoFinancialYear = BllFinancialYear.FinancialYearViewForAccountLedger(1);
strfinancialId = infoFinancialYear.FromDate.ToString("dd-MMM-yyyy");
infoLedgerPosting.VoucherTypeId = 1;
infoLedgerPosting.Date = Convert.ToDateTime(strfinancialId.ToString());
if (cmbOpeningBalanceCrOrDr.Text == "Dr")
{
infoLedgerPosting.Debit = decOpeningBalance;
}
else
{
infoLedgerPosting.Credit = decOpeningBalance;
}
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = decAccountLedgerId.ToString();
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.LedgerId = decAccountLedgerId;
infoLedgerPosting.VoucherNo = decAccountLedgerId.ToString();
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
List<DataTable> dtbl = BllLedgerPosting.GetLedgerPostingIds(decAccountLedgerId.ToString(), 1);
if (dtbl[0].Rows.Count > 0)
{
if (decOpeningBalance > 0)
{
//Edit
infoLedgerPosting.LedgerPostingId = Convert.ToDecimal(dtbl[0].Rows[0][0].ToString());
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
else
{
//Delete
bllAccountLedger.LedgerPostingDeleteByVoucherTypeAndVoucherNo(decAccountLedgerId.ToString(), 1);
}
}
else
{
//Add new row
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
catch (Exception ex)
{
MessageBox.Show("AL5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}