/// <summary>
/// Function to edit the service voucher
/// </summary>
/// <param name="decServiceMasterId"></param>
public void EditFunction(decimal decServiceMasterId)
{
try
{
ServiceMasterInfo infoServiceMaster = new ServiceMasterInfo();
ServiceDetailsInfo infoServiceDetails = new ServiceDetailsInfo();
ServicesBll BllService = new ServicesBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
int inRowCount = dgvServiceVoucher.RowCount;
int inValue = 0;
decimal decLedgerPostingId1 = 0;
decimal decLedgerPostingId2 = 0;
List<DataTable> listObjLedgerPostingId = new List<DataTable>();
listObjLedgerPostingId = BllService.LedgerPostingIdByServiceMaasterId(decServiceMasterId);
decLedgerPostingId1 = Convert.ToDecimal(listObjLedgerPostingId[0].Rows[0]["ledgerPostingId"].ToString());
decLedgerPostingId2 = Convert.ToDecimal(listObjLedgerPostingId[0].Rows[1]["ledgerPostingId"].ToString());
for (int ini = 0; ini < inRowCount - 1; ini++)
{
if (dgvServiceVoucher.Rows[ini].Cells["dgvcmbParticulars"].Value != null && dgvServiceVoucher.Rows[ini].Cells["dgvcmbParticulars"].Value.ToString() != string.Empty)
{
inValue++;
}
}
if (inValue > 0)
{
infoServiceMaster.ServiceMasterId = decServiceMasterId;
infoServiceMaster.SuffixPrefixId = decServiceSuffixPrefixId;
infoServiceMaster.Date = Convert.ToDateTime(txtVoucherDate.Text);
infoServiceMaster.LedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString());
infoServiceMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
infoServiceMaster.Narration = txtNarration.Text.Trim();
infoServiceMaster.UserId = PublicVariables._decCurrentUserId;
infoServiceMaster.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text);
infoServiceMaster.ServiceAccount = Convert.ToDecimal(cmbServiceAC.SelectedValue.ToString());
decimal decExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());//spExchangeRate.GetExchangeRateByCurrencyId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoServiceMaster.ExchangeRateId = decExchangeRateId;
infoServiceMaster.EmployeeId = Convert.ToDecimal(cmbSalesman.SelectedValue.ToString());
infoServiceMaster.Customer = txtCustomer.Text.Trim();
infoServiceMaster.Discount = Convert.ToDecimal(txtDiscount.Text);
infoServiceMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text);
infoServiceMaster.VoucherTypeId = DecServicetVoucherTypeId;
infoServiceMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoServiceMaster.ExtraDate = PublicVariables._dtCurrentDate;
infoServiceMaster.Extra1 = string.Empty;
infoServiceMaster.Extra2 = string.Empty;
//------------------deleting removed rows----------------------------------------//
BankReconciliationBll BllBankReconciliation = new BankReconciliationBll();
foreach (object obj in strArrOfRemove)
{
string str = Convert.ToString(obj);
BllService.ServiceDetailsDelete(Convert.ToDecimal(str));
}
BllService.ServiceMasterEdit(infoServiceMaster);
infoServiceDetails.ServiceMasterId = decServiceMasterId;
infoServiceDetails.Extra1 = string.Empty;
infoServiceDetails.Extra2 = string.Empty;
infoServiceDetails.ExtraDate = PublicVariables._dtCurrentDate;
for (int i = 0; i < inRowCount - 1; i++)
{
if (dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value.ToString() != string.Empty)
{
infoServiceDetails.ServiceId = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value.ToString());
}
if (dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value.ToString() != string.Empty)
{
infoServiceDetails.Measure = dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value.ToString();
}
if (dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != string.Empty)
{
infoServiceDetails.Amount = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString());
if (dgvServiceVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value.ToString() != string.Empty)
{
infoServiceDetails.ServiceDetailsId = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value.ToString());
infoServiceDetails.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
BllService.ServiceDetailsEdit(infoServiceDetails);
}
else
{
infoServiceDetails.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
decServiceDetailsId = BllService.ServiceDetailsAddReturnWithIdentity(infoServiceDetails);
}
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decAmount = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value);
decConvertRate += decAmount * decSelectedCurrencyRate;
}
}
decCredit = 0;
decDebit = decConvertRate;
decLedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString());
LedgerPostingEdit(decLedgerPostingId1, decLedgerId, decCredit, decDebit);
decCredit = decConvertRate;
decDebit = 0;
decLedgerId = Convert.ToDecimal(cmbServiceAC.SelectedValue.ToString());
LedgerPostingEdit(decLedgerPostingId2, decLedgerId, decCredit, decDebit);
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
decimal decI = Convert.ToDecimal(bllAccountLedger.AccountGroupIdCheck(cmbCashParty.Text));
if (decI > 0)
{
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
infoPartyBalance.PartyBalanceId = decPartyBalanceId;
infoPartyBalance.Date = Convert.ToDateTime(txtVoucherDate.Text);
infoPartyBalance.LedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString());
infoPartyBalance.VoucherTypeId = DecServicetVoucherTypeId;
infoPartyBalance.VoucherNo = strVoucherNo;
infoPartyBalance.AgainstVoucherTypeId = 0;
infoPartyBalance.AgainstVoucherNo = "0";
infoPartyBalance.InvoiceNo = strInvoiceNo;
infoPartyBalance.AgainstInvoiceNo = "0";
infoPartyBalance.ReferenceType = "New";
infoPartyBalance.Debit = decAmount;
infoPartyBalance.Credit = 0;
infoPartyBalance.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text);
infoPartyBalance.ExchangeRateId = decExchangeRateId;
infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPartyBalance.Extra1 = string.Empty;
infoPartyBalance.Extra2 = string.Empty;
BllPartyBalance.PartyBalanceEdit(infoPartyBalance);
}
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decServiceMasterId);
}
else
{
Print(decServiceMasterId, infoServiceMaster.ExchangeRateId);
}
}
this.Close();
if (frmServiceVoucherRegisterObj != null)
{
frmServiceVoucherRegisterObj.Show();
frmServiceVoucherRegisterObj.GridFill();
}
else if (frmServiceReportObj != null)
{
frmServiceReportObj.Show();
frmServiceReportObj.GridFill();
}
}
else
{
Messages.InformationMessage("Can't save Service Voucher without atleast one ledger with complete details");
}
}
catch (Exception ex)
{
MessageBox.Show("SV 24 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// BankReconciliation Grid Fill function
/// </summary>
public void BankReconciliationFill()
{
try
{
BankReconciliationInfo infoBankReconciliation = new BankReconciliationInfo();
BankReconciliationBll BllBankReconciliation = new BankReconciliationBll();
dgvBankReconciliation.Rows.Clear();
List<DataTable> listObj = new List<DataTable>();
if (cmbBankAccount.SelectedIndex > -1)
{
if (cmbStatus.Text == "Reconciled")
{
listObj = BllBankReconciliation.BankReconciliationFillReconcile(Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()), Convert.ToDateTime(txtStatementFrom.Text), Convert.ToDateTime(txtStatementTo.Text));
if (listObj[0].Rows.Count > 0)
{
for (int i = 0; i < listObj[0].Rows.Count; i++)
{
dgvBankReconciliation.Rows.Add();
dgvBankReconciliation.Rows[i].Cells["dgvtxtSlNo"].Value = listObj[0].Rows[i]["Sl No"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtDate"].Value = listObj[0].Rows[i]["date"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtParticular"].Value = listObj[0].Rows[i]["ledgerName"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherType"].Value = listObj[0].Rows[i]["voucherTypeName"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherNo"].Value = listObj[0].Rows[i]["voucherNo"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeNo"].Value = listObj[0].Rows[i]["chequeNo"].ToString();
dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeDate"].Value = listObj[0].Rows[i]["chequeDate"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtDeposit"].Value = listObj[0].Rows[i]["debit"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtWithdraw"].Value = listObj[0].Rows[i]["credit"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtStatementDate"].Value = listObj[0].Rows[i]["statementDate"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = listObj[0].Rows[i]["ledgerPostingId"];
}
}
}
else
{
listObj = BllBankReconciliation.BankReconciliationUnrecocile(Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()), Convert.ToDateTime(txtStatementFrom.Text), Convert.ToDateTime(txtStatementTo.Text));
if (listObj[0].Rows.Count > 0)
{
for (int i = 0; i < listObj[0].Rows.Count; i++)
{
dgvBankReconciliation.Rows.Add();
dgvBankReconciliation.Rows[i].Cells["dgvtxtSlNo"].Value = listObj[0].Rows[i]["Sl No"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtDate"].Value = listObj[0].Rows[i]["date"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtParticular"].Value = listObj[0].Rows[i]["ledgerName"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherType"].Value = listObj[0].Rows[i]["voucherTypeName"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherNo"].Value = listObj[0].Rows[i]["voucherNo"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeNo"].Value = listObj[0].Rows[i]["chequeNo"].ToString();
dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeDate"].Value = listObj[0].Rows[i]["chequeDate"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtDeposit"].Value = listObj[0].Rows[i]["debit"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtWithdraw"].Value = listObj[0].Rows[i]["credit"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtStatementDate"].Value = string.Empty;
dgvBankReconciliation.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = listObj[0].Rows[i]["ledgerPostingId"];
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("BR:3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Edit Function
/// </summary>
/// <param name="decMasterId"></param>
public void Edit(decimal decMasterId)
{
try
{
int inRowCount = dgvPaymentVoucher.RowCount;
int inTableRowCount = dtblPartyBalance.Rows.Count;
int inB = 0;
PaymentMasterInfo InfoPaymentMaster = new PaymentMasterInfo();
//PaymentMasterSP SpPaymentMaster = new PaymentMasterSP();
PaymentDetailsInfo InfoPaymentDetails = new PaymentDetailsInfo();
//PaymentDetailsSP SpPaymentDetails = new PaymentDetailsSP();
PaymentVoucherBll BllPaymentVoucher = new PaymentVoucherBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo InfoLegerPosting = new LedgerPostingInfo();
PartyBalanceInfo InfopartyBalance = new PartyBalanceInfo();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
BankReconciliationBll BllBankReconcilation = new BankReconciliationBll();
InfoPaymentMaster.Date = dtpDate.Value;
InfoPaymentMaster.PaymentMasterId = decMasterId;
InfoPaymentMaster.Extra1 = string.Empty;
InfoPaymentMaster.Extra2 = string.Empty;
InfoPaymentMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoPaymentMaster.InvoiceNo = txtVoucherNo.Text.Trim();
InfoPaymentMaster.LedgerId = Convert.ToDecimal(cmbBankorCash.SelectedValue.ToString());
InfoPaymentMaster.Narration = txtNarration.Text.Trim();
InfoPaymentMaster.SuffixPrefixId = decDailySuffixPrefixId;
decimal decTotalAmount = TotalAmountCalculation();
InfoPaymentMaster.TotalAmount = decTotalAmount;
InfoPaymentMaster.UserId = PublicVariables._decCurrentUserId;
InfoPaymentMaster.VoucherNo = strVoucherNo;
InfoPaymentMaster.VoucherTypeId = decPaymentVoucherTypeId;
decimal decPaymentMasterId = BllPaymentVoucher.PaymentMasterEdit(InfoPaymentMaster);
if (decPaymentmasterId != 0)
{
MasterLedgerPostingEdit();
}
foreach (object obj in arrlstOfRemove)
{
string str = Convert.ToString(obj);
BllPaymentVoucher.PaymentDetailsDelete(Convert.ToDecimal(str));
BllLedgerPosting.LedgerPostDeleteByDetailsId(Convert.ToDecimal(str), strVoucherNo, decPaymentVoucherTypeId);
}
BllLedgerPosting.LedgerPostingDeleteByVoucherNoVoucherTypeIdAndLedgerId(strVoucherNo, decPaymentVoucherTypeId, 12);
decimal decPaymentDetailsId1 = 0;
for (int inI = 0; inI < inRowCount - 1; inI++)
{
InfoPaymentDetails.Amount = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
InfoPaymentDetails.ExchangeRateId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString());
InfoPaymentDetails.Extra1 = string.Empty;
InfoPaymentDetails.Extra2 = string.Empty;
if (dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
InfoPaymentDetails.LedgerId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
}
if (dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
InfoPaymentDetails.ChequeNo = dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
if (dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
InfoPaymentDetails.ChequeDate = Convert.ToDateTime(dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value);
}
else
{
InfoPaymentDetails.ChequeDate = DateTime.Now;
}
}
else
{
InfoPaymentDetails.ChequeNo = string.Empty;
InfoPaymentDetails.ChequeDate = DateTime.Now;
}
InfoPaymentDetails.PaymentMasterId = decPaymentMasterId;
if (dgvPaymentVoucher.Rows[inI].Cells["dgvtxtpaymentDetailsId"].FormattedValue.ToString() == "0")//if new rows are added
{
if (dgvPaymentVoucher.Rows[inI].HeaderCell.Value.ToString() != "X")//add new rows added which are completed
{
decimal decPaymentDetailsId = BllPaymentVoucher.PaymentDetailsAdd(InfoPaymentDetails);//to add new rows in payment details
if (decPaymentDetailsId != 0)
{
for (int inJ = 0; inJ < inTableRowCount; inJ++)
{
if (dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() == dtblPartyBalance.Rows[inJ]["LedgerId"].ToString())
{
PartyBalanceAddOrEdit(inJ);
}
}
inB++;
DetailsLedgerPosting(inI, decPaymentDetailsId);//to add new ledger posting
}
}
}
else
{
if (dgvPaymentVoucher.Rows[inI].HeaderCell.Value != null && dgvPaymentVoucher.Rows[inI].HeaderCell.Value.ToString() != "X")//add new rows updated which are completed
{
InfoPaymentDetails.PaymentDetailsId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvtxtpaymentDetailsId"].Value.ToString());
decimal decPaymentDetailsId = BllPaymentVoucher.PaymentDetailsEdit(InfoPaymentDetails);//to edit rows
if (decPaymentDetailsId != 0)
{
for (int inJ = 0; inJ < inTableRowCount; inJ++)
{
if (dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() == dtblPartyBalance.Rows[inJ]["LedgerId"].ToString())
{
PartyBalanceAddOrEdit(inJ);
}
}
inB++;
decPaymentDetailsId1 = InfoPaymentDetails.PaymentDetailsId;
decimal decLedgerPostId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value.ToString());
DetailsLedgerPostingEdit(inI, decLedgerPostId, decPaymentDetailsId1);
}
}
else
{
decimal decDetailsId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inI].Cells["dgvtxtpaymentDetailsId"].Value.ToString());
BllPaymentVoucher.PaymentDetailsDelete(decDetailsId);
BllLedgerPosting.LedgerPostDeleteByDetailsId(decDetailsId, strVoucherNo, decPaymentVoucherTypeId);
for (int inJ = 0; inJ < dtblPartyBalance.Rows.Count; inJ++)
{
if (dtblPartyBalance.Rows.Count == inJ)
{
break;
}
if (dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
if (dtblPartyBalance.Rows[inJ]["LedgerId"].ToString() == dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString())
{
if (dtblPartyBalance.Rows[inJ]["PartyBalanceId"].ToString() != "0")
{
arrlstOfDeletedPartyBalanceRow.Add(dtblPartyBalance.Rows[inJ]["PartyBalanceId"]);
}
}
}
}
}
}
}
DeletePartyBalanceOfRemovedRow();
isUpdated = true;
Messages.UpdatedMessage();
if (cbxPrintafterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPaymentmasterId);
}
else
{
Print(decPaymentMasterId);
}
}
if (frmPaymentRegisterObj != null)
{
this.Close();
frmPaymentRegisterObj.CallFromPaymentVoucher(this);
}
if (frmPaymentReportObj != null)
{
this.Close();
frmPaymentReportObj.CallFromPaymentVoucher(this);
}
if (frmDayBookObj != null)
{
this.Close();
}
if (frmBillallocationObj != null)
{
this.Close();
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("PV18:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Checking invalid entries for Save or Update and Save and Update function
/// </summary>
public void saveOrEdit()
{
try
{
BankReconciliationInfo infoBankReconciliation = new BankReconciliationInfo();
BankReconciliationBll BllBankReconciliation = new BankReconciliationBll();
foreach (DataGridViewRow dgv in dgvBankReconciliation.Rows)
{
if (dgv.Cells["dgvtxtStatementDate"].Value != null && Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()) != 0 && dgv.Cells["dgvtxtStatementDate"].Value.ToString() != string.Empty)
{
infoBankReconciliation.LedgerPostingId = decimal.Parse(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString());
infoBankReconciliation.StatementDate = Convert.ToDateTime((dgv.Cells["dgvtxtStatementDate"].Value.ToString()));
infoBankReconciliation.Extra1 = string.Empty;
infoBankReconciliation.Extra2 = string.Empty;
infoBankReconciliation.ExtraDate = PublicVariables._dtCurrentDate;
decimal decReconcileId = BllBankReconciliation.BankReconciliationLedgerPostingId(Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()));
if (decReconcileId != 0)
{
infoBankReconciliation.ReconcileId = decReconcileId;
BllBankReconciliation.BankReconciliationEdit(infoBankReconciliation);
}
else
BllBankReconciliation.BankReconciliationAdd(infoBankReconciliation);
}
else
{
if (Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()) != 0)
{
decimal decReconcileId = BllBankReconciliation.BankReconciliationLedgerPostingId(Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()));
if (decReconcileId != 0)
{
BllBankReconciliation.BankReconciliationDelete(decReconcileId);
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("BR:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit the debitnote voucher
/// </summary>
/// <param name="decDebitNoteMasterId"></param>
public void Edit(decimal decDebitNoteMasterId)
{
try
{
//DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP();
//DebitNoteDetailsSP spDebitNoteDetails = new DebitNoteDetailsSP();
DebitNoteBll bllDebitNote = new DebitNoteBll();
DebitNoteMasterInfo infoDebitNoteMaster = new DebitNoteMasterInfo();
DebitNoteDetailsInfo infoDebitNoteDetails = new DebitNoteDetailsInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
/*****************Update in DebitNoteMaster table *************/
decimal decTotalDebit = 0;
decimal decTotalCredit = 0;
infoDebitNoteMaster.DebitNoteMasterId = decDebitNoteMasterId;
infoDebitNoteMaster.VoucherNo = strVoucherNo;
infoDebitNoteMaster.InvoiceNo = txtVoucherNo.Text.Trim();
infoDebitNoteMaster.SuffixPrefixId = decDebitNoteSuffixPrefixId;
infoDebitNoteMaster.Date = Convert.ToDateTime(txtDate.Text);
infoDebitNoteMaster.Narration = txtNarration.Text;
infoDebitNoteMaster.UserId = PublicVariables._decCurrentUserId;
infoDebitNoteMaster.VoucherTypeId = decDebitNoteVoucherTypeId;
infoDebitNoteMaster.FinancialYearId = Convert.ToDecimal(PublicVariables._decCurrentFinancialYearId.ToString());
infoDebitNoteMaster.ExtraDate = DateTime.Now;
infoDebitNoteMaster.Extra1 = string.Empty;
infoDebitNoteMaster.Extra2 = string.Empty;
decTotalDebit = Convert.ToDecimal(txtDebitTotal.Text.Trim());
decTotalCredit = Convert.ToDecimal(txtCreditTotal.Text.Trim());
infoDebitNoteMaster.TotalAmount = decTotalDebit;
decimal decEffectRow = bllDebitNote.DebitNoteMasterEdit(infoDebitNoteMaster);
/**********************DebitNoteDetails Edit********************/
if (decEffectRow > 0)
{
infoDebitNoteDetails.DebitNoteMasterId = decDebitNoteMasterId;
infoDebitNoteDetails.ExtraDate = DateTime.Now;
infoDebitNoteDetails.Extra1 = string.Empty;
infoDebitNoteDetails.Extra2 = string.Empty;
//-----------to delete details, LedgerPosting and bankReconciliation of removed rows--------------//
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
BankReconciliationBll BllBankReconciliation = new BankReconciliationBll();
foreach (object obj in arrlstOfRemove)
{
string str = Convert.ToString(obj);
bllDebitNote.DebitNoteDetailsDelete(Convert.ToDecimal(str));
BllLedgerPosting.LedgerPostDeleteByDetailsId(Convert.ToDecimal(str), strVoucherNo, decDebitNoteVoucherTypeId);
}
BllLedgerPosting.LedgerPostingDeleteByVoucherNoVoucherTypeIdAndLedgerId(strVoucherNo, decDebitNoteVoucherTypeId, 12);
//=============================================================================================//
decimal decLedgerId = 0;
decimal decDebit = 0;
decimal decCredit = 0;
decimal decDebitNoteDetailsId = 0;
int inRowCount = dgvDebitNote.RowCount;
for (int inI = 0; inI < inRowCount; inI++)
{
if (dgvDebitNote.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvDebitNote.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
infoDebitNoteDetails.LedgerId = Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
decLedgerId = infoDebitNoteDetails.LedgerId;
}
if (dgvDebitNote.Rows[inI].Cells["dgvcmbDrOrCr"].Value != null && dgvDebitNote.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() != string.Empty)
{
//------------------Currency conversion------------------//
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvcmbCurrency"].Value));
decAmount = Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
//======================================================//
if (dgvDebitNote.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() == "Dr")
{
infoDebitNoteDetails.Debit = Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoDebitNoteDetails.Credit = 0;
decDebit = decConvertRate;
decCredit = infoDebitNoteDetails.Credit;
}
else
{
infoDebitNoteDetails.Credit = Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoDebitNoteDetails.Debit = 0;
decDebit = infoDebitNoteDetails.Debit;
decCredit = decConvertRate;
}
infoDebitNoteDetails.ExchangeRateId = Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString());
if (dgvDebitNote.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvDebitNote.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
infoDebitNoteDetails.ChequeNo = dgvDebitNote.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoDebitNoteDetails.ChequeNo = string.Empty;
}
if (dgvDebitNote.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvDebitNote.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
infoDebitNoteDetails.ChequeDate = Convert.ToDateTime(dgvDebitNote.Rows[inI].Cells["dgvtxtChequeDate"].Value);
}
else
{
infoDebitNoteDetails.ChequeDate = DateTime.Now;
}
if (dgvDebitNote.Rows[inI].Cells["dgvtxtDetailsId"].Value != null && dgvDebitNote.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString() != string.Empty)
{
infoDebitNoteDetails.DebitNoteDetailsId = Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString());
bllDebitNote.DebitNoteDetailsEdit(infoDebitNoteDetails);
PartyBalanceAddOrEdit(inI);
decDebitNoteDetailsId = infoDebitNoteDetails.DebitNoteDetailsId;
decimal decLedgerPostId = Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value.ToString());
LedgerPostingEdit(decLedgerPostId, decLedgerId, decCredit, decDebit, decDebitNoteDetailsId, inI);
}
else
{
decDebitNoteDetailsId = bllDebitNote.DebitNoteDetailsAdd(infoDebitNoteDetails);
PartyBalanceAddOrEdit(inI);
LedgerPosting(decLedgerId, decCredit, decDebit, decDebitNoteDetailsId, inI);
}
}
}
Messages.UpdatedMessage();
}
//----------------If print after save is enable-----------------------//
SettingsBll BllSettings = new SettingsBll();
if (cbxPrintAfterSave.Checked == true)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(infoDebitNoteMaster.DebitNoteMasterId);
}
else
{
Print(infoDebitNoteMaster.DebitNoteMasterId);
}
}
//===================================================================//
if (frmDebitNoteRegisterObj != null)
{
this.Close();
frmDebitNoteRegisterObj.Enabled = true;
}
else if (frmDebitNoteReportObj != null)
{
this.Close();
frmDebitNoteReportObj.Enabled = true;
}
else
{
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("DRNT34:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}