/// <summary>
/// Function to update values in ledgerposting table
/// </summary>
public void ledgerUpdate()
{
try
{
string strfinancialId;
FinancialYearSP spFinancialYear = new FinancialYearSP();
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
infoFinancialYear = spFinancialYear.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;
}
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
DataTable dtbl = spLedgerPosting.GetLedgerPostingIds(decLedgerIdForEdit.ToString(), 1);
foreach (DataRow dr in dtbl.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.Rows.Count > 0)
{
if (decOpeningBlnc > 0)
{
spLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
else
{
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
spAccountLedger.LedgerPostingDeleteByVoucherTypeAndVoucherNo(decLedgerIdForEdit.ToString(), 1);
}
}
else
{
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
catch (Exception ex)
{
MessageBox.Show("Cus16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save Function
/// </summary>
public void SaveFunction()
{
try
{
DateValidation Objdatevalidation = new DateValidation();
OtherDateValidationFunction ObjotherdateValidation = new OtherDateValidationFunction();
Objdatevalidation.DateValidationFunction(txtVoucherDate);
AccountLedgerSP SpAccountLedger = new AccountLedgerSP();
SettingsSP spSettings = new SettingsSP();
txtVoucherDate.Text = txtVoucherDate.Text.Trim();
cmbvouchertype.Text = cmbvouchertype.Text.Trim();
txtAmount.Text = txtAmount.Text.Trim();
txtBank.Text = txtBank.Text.Trim();
txtcheckdate.Text = txtcheckdate.Text.Trim();
txtcheckNo.Text = txtcheckNo.Text.Trim();
txtNarration.Text = txtNarration.Text.Trim();
DataTable dtblMaster = new DataTable();
PDCClearanceMasterSP sppdcClearance = new PDCClearanceMasterSP();
PDCClearanceMasterInfo infoPdcclearance = new PDCClearanceMasterInfo();
infoPdcclearance.SuffixPrefixId = decSufixprefixPdcpayableID;
infoPdcclearance.FinancialYearId = Convert.ToDecimal(PublicVariables._decCurrentFinancialYearId.ToString());
infoPdcclearance.VoucherNo = strVoucherNo;
infoPdcclearance.InvoiceNo = txtvoucherNo.Text;
if (txtVoucherDate.Text != string.Empty)
infoPdcclearance.Date = Convert.ToDateTime(txtVoucherDate.Text);
else
infoPdcclearance.Date = DateTime.Now;
infoPdcclearance.LedgerId = decimal.Parse(strledgerId.ToString());
infoPdcclearance.AgainstId = decmasterId;
infoPdcclearance.UserId = PublicVariables._decCurrentUserId;
infoPdcclearance.VoucherTypeId = decPDCclearanceVoucherTypeId;
infoPdcclearance.Status = cmbStatus.Text.ToString();
infoPdcclearance.Type = cmbvouchertype.Text.ToString();
infoPdcclearance.ExtraDate = DateTime.Now;
infoPdcclearance.Narration = txtNarration.Text;
infoPdcclearance.Extra1 = string.Empty;
infoPdcclearance.Extra2 = string.Empty;
if (!isInEditMode)
{
decimal decIdentity = sppdcClearance.PDCClearanceMasterAdd(infoPdcclearance);
LedgerPostingAdd();
if (cmbStatus.Text.ToString() == "Bounced")
{
if (SpAccountLedger.AccountGroupIdCheck(txtAccountLedger.Text.ToString()))
{
PartyBalanceAddOrEdit();
}
}
Messages.SavedMessage();
if (cbxPrint.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decIdentity);
}
else
{
Print(decIdentity);
}
}
ClearFunction();
}
else
{
decimal decIdentity = decPDCClearanceEditId;
infoPdcclearance.PDCClearanceMasterId = decPDCClearanceEditId;
sppdcClearance.PDCClearanceMasterEdit(infoPdcclearance);
SpAccountLedger.LedgerPostingDeleteByVoucherTypeAndVoucherNo(strVoucherNo, decPDCclearanceVoucherTypeId);
LedgerPostingAdd();
SpAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(strVoucherNo, decPDCclearanceVoucherTypeId);
if (cmbStatus.Text.ToString() == "Bounced")
{
if (SpAccountLedger.AccountGroupIdCheck(txtAccountLedger.Text.ToString()))
{
PartyBalanceAddOrEdit();
}
}
Messages.UpdatedMessage();
if (cbxPrint.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decIdentity);
}
else
{
Print(decIdentity);
}
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("PC11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to delete
/// </summary>
public void DeleteFunction()
{
try
{
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
if (spAccountLedger.AccountLedgerCheckReferences(decLedgerIdForEdit) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
spAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(decLedgerIdForEdit.ToString(), 1);
spAccountLedger.LedgerPostingDeleteByVoucherTypeAndVoucherNo(decLedgerIdForEdit.ToString(), 1);
Messages.DeletedMessage();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("Cus9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// delete function
/// </summary>
public void DeleteFunction()
{
try
{
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
if (spAccountLedger.SupplierCheckreferenceAndDelete(Convert.ToDecimal(strLedgerId.ToString())) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
spAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(decLedger.ToString(), 1);
spAccountLedger.LedgerPostingDeleteByVoucherTypeAndVoucherNo(decLedger.ToString(), 1);
spAccountLedger.AccountLedgerDelete(decLedger);
Messages.DeletedMessage();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("SUP11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}