/// <summary> /// Function to fill Datagridview /// </summary> public void DebitNoteRegisterGridFill() { try { List<DataTable> listObj = new List<DataTable>(); //DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); listObj = bllDebitNote.DebitNoteMasterViewAllWithSlNo(); dgvDebitNoteRegister.DataSource = listObj[0]; } catch (Exception ex) { MessageBox.Show("DNTREG1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// When doubleclicking on the grid /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvReport_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { decimal decVouchertypeId = 0; string strVoucherNo = string.Empty; try { if (dgvReport.CurrentRow.Index == e.RowIndex) { if ((dgvReport.CurrentRow.Cells["voucherTypeId"].Value != null && dgvReport.CurrentRow.Cells["voucherTypeId"].Value.ToString() != string.Empty)) { int inI = dgvReport.CurrentCell.RowIndex; foreach (DataGridViewRow dgv in dgvReport.Rows) { if (dgv.Cells["VoucherNo"].Value != null && dgv.Cells["VoucherNo"].Value.ToString() != string.Empty && dgv.Cells["voucherTypeId"].Value != null && dgv.Cells["voucherTypeId"].Value.ToString() != string.Empty) { strVoucherType = dgv.Cells["VoucherType"].Value.ToString(); decVouchertypeId = Convert.ToDecimal(dgv.Cells["voucherTypeId"].Value.ToString()); strVoucherNo = dgv.Cells["VoucherNo"].Value.ToString(); } else { if (dgv.Cells["ledgerId"].Value.ToString() != string.Empty) { decledgerId = decimal.Parse(dgv.Cells["ledgerId"].Value.ToString()); strVoucherType = dgv.Cells["Account Ledger"].Value.ToString(); frmLedgerDetails frmLedger = new frmLedgerDetails(); frmLedger = Application.OpenForms["frmLedgerDetails"] as frmLedgerDetails; if (frmLedger == null) { frmLedger = new frmLedgerDetails(); frmLedger.MdiParent = formMDI.MDIObj; frmLedger.callFromAgeing(this, decledgerId); this.Enabled = false; } } } if (dgv.Index == inI) { break; } } if (strVoucherType == "Payment Voucher") { PaymentVoucherBll BllPaymentVoucher = new PaymentVoucherBll(); decMasterId = BllPaymentVoucher.paymentMasterIdView(decVouchertypeId, strVoucherNo); frmPaymentVoucher frmPaymentVoucher = new frmPaymentVoucher(); frmPaymentVoucher = Application.OpenForms["frmPaymentVoucher"] as frmPaymentVoucher; if (frmPaymentVoucher == null) { frmPaymentVoucher = new frmPaymentVoucher(); frmPaymentVoucher.MdiParent = formMDI.MDIObj; frmPaymentVoucher.callFromAgeing(this, decMasterId); this.Enabled = false; } } else if (strVoucherType == "Receipt Voucher") { RecieptVoucherBll bllRecieptVoucher = new RecieptVoucherBll(); //ReceiptMasterSP spRecieptMaster = new ReceiptMasterSP(); decMasterId = bllRecieptVoucher.ReceiptMasterIdView(decVouchertypeId, strVoucherNo); frmReceiptVoucher frmReceiptVoucher = new frmReceiptVoucher(); frmReceiptVoucher = Application.OpenForms["frmReceiptVoucher"] as frmReceiptVoucher; if (frmReceiptVoucher == null) { frmReceiptVoucher = new frmReceiptVoucher(); frmReceiptVoucher.MdiParent = formMDI.MDIObj; frmReceiptVoucher.callFromAgeing(this, decMasterId); this.Enabled = false; } } else if (strVoucherType == "Journal Voucher") { JournalVoucherBll bllJournalMaster = new JournalVoucherBll(); decMasterId = bllJournalMaster.JournalMasterIdView(decVouchertypeId, strVoucherNo); frmJournalVoucher frmJournalVoucher = new frmJournalVoucher(); frmJournalVoucher = Application.OpenForms["frmJournalVoucher"] as frmJournalVoucher; if (frmJournalVoucher == null) { frmJournalVoucher = new frmJournalVoucher(); frmJournalVoucher.MdiParent = formMDI.MDIObj; frmJournalVoucher.callFromAgeing(this, decMasterId); this.Enabled = false; } } else if (strVoucherType == "PDC Receivable") { PDCRecivebleBll BllPDCReciveble = new PDCRecivebleBll(); decMasterId = BllPDCReciveble.PdcReceivableMasterIdView(decVouchertypeId, strVoucherNo); frmPdcReceivable frmPdcReceivable = new frmPdcReceivable(); frmPdcReceivable = Application.OpenForms["frmPdcReceivable"] as frmPdcReceivable; if (frmPdcReceivable == null) { frmPdcReceivable = new frmPdcReceivable(); frmPdcReceivable.MdiParent = formMDI.MDIObj; frmPdcReceivable.callFromAgeing(this, decMasterId); this.Enabled = false; } } else if (strVoucherType == "PDC Payable") { PDCPayableBll BllPDCPayable = new PDCPayableBll(); decMasterId = BllPDCPayable.PdcPayableMasterIdView(decVouchertypeId, strVoucherNo); frmPdcPayable frmPdcPayable = new frmPdcPayable(); frmPdcPayable = Application.OpenForms["frmPdcPayable"] as frmPdcPayable; if (frmPdcPayable == null) { frmPdcPayable = new frmPdcPayable(); frmPdcPayable.MdiParent = formMDI.MDIObj; frmPdcPayable.callFromAgeing(this, decMasterId); this.Enabled = false; } } else if (strVoucherType == "Sales Invoice") { //SalesMasterSP spMaster = new SalesMasterSP(); SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll(); decMasterId = BllSalesInvoice.SalesMasterIdViewByvoucherNoAndVoucherType(decVouchertypeId, strVoucherNo); //SalesMasterSP spSalesMaster = new SalesMasterSP(); bool blPOS = BllSalesInvoice.DayBookSalesInvoiceOrPOS(decMasterId, decVouchertypeId); frmSalesInvoice frmSalesInvoice = new frmSalesInvoice(); frmPOS frmPOS = new frmPOS(); if (blPOS == true) { frmPOS = Application.OpenForms["frmPOS"] as frmPOS; if (frmPOS == null) { frmPOS = new frmPOS(); frmPOS.MdiParent = formMDI.MDIObj; frmPOS.callFromAgeing(this, decMasterId); this.Enabled = false; } } else { frmSalesInvoice = Application.OpenForms["frmSalesInvoice"] as frmSalesInvoice; if (frmSalesInvoice == null) { frmSalesInvoice = new frmSalesInvoice(); frmSalesInvoice.MdiParent = formMDI.MDIObj; frmSalesInvoice.callFromAgeing(this, decMasterId); this.Enabled = false; } } } else if (strVoucherType == "Purchase Invoice") { PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll(); decMasterId = BllPurchaseInvoice.PurchaseMasterIdViewByvoucherNoAndVoucherType(decVouchertypeId, strVoucherNo); frmPurchaseInvoice objpurchase = new frmPurchaseInvoice(); objpurchase.WindowState = FormWindowState.Normal; objpurchase.MdiParent = formMDI.MDIObj; objpurchase.callFromAgeing(this, decMasterId); this.Enabled = false; } else if (strVoucherType == "Credit Note") { CreditNoteBll BllCreditNoteMaster = new CreditNoteBll(); decMasterId = BllCreditNoteMaster.CreditNoteMasterIdView(decVouchertypeId, strVoucherNo); frmCreditNote objpurchase = new frmCreditNote(); objpurchase.WindowState = FormWindowState.Normal; objpurchase.MdiParent = formMDI.MDIObj; objpurchase.callFromAgeing(this, decMasterId); this.Enabled = false; } else if (strVoucherType == "Debit Note") { //DebitNoteMasterSP spDebitNote = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); decMasterId = bllDebitNote.DebitNoteMasterIdView(decVouchertypeId, strVoucherNo); frmDebitNote objpurchase = new frmDebitNote(); objpurchase.WindowState = FormWindowState.Normal; objpurchase.MdiParent = formMDI.MDIObj; objpurchase.callFromAgeing(this, decMasterId); this.Enabled = false; } } } } catch (Exception ex) { MessageBox.Show("AR17:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// On double clicking the cell in grid, it loads the corresponding Voucher to update or delete the entries /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvBillAllocation_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex != -1) { decVoucherTypeId = Convert.ToDecimal(dgvBillAllocation.CurrentRow.Cells["voucherTypeId"].Value.ToString()); strTypeOfVoucher = dgvBillAllocation.CurrentRow.Cells["typeOfVoucher"].Value.ToString(); strVoucherNo = dgvBillAllocation.CurrentRow.Cells["voucherNo"].Value.ToString(); if (strTypeOfVoucher == "PDC Payable") { PDCPayableBll BllPDCPayable = new PDCPayableBll(); decimal decMasterId = BllPDCPayable.PdcPayableMasterIdView(decVoucherTypeId, strVoucherNo); frmPdcPayable frmpdcPayableObj = new frmPdcPayable(); frmpdcPayableObj = Application.OpenForms["frmPdcPayable"] as frmPdcPayable; if (frmpdcPayableObj == null) { frmpdcPayableObj = new frmPdcPayable(); frmpdcPayableObj.MdiParent = formMDI.MDIObj; frmpdcPayableObj.CallFromBillAllocation(this, decMasterId); } } if (strTypeOfVoucher == "PDC Receivable") { PDCRecivebleBll BllPDCReciveble = new PDCRecivebleBll(); decimal decMasterId = BllPDCReciveble.PdcReceivableMasterIdView(decVoucherTypeId, strVoucherNo); frmPdcReceivable frmPdcReceivableObj = new frmPdcReceivable(); frmPdcReceivableObj = Application.OpenForms["frmPdcReceivable"] as frmPdcReceivable; if (frmPdcReceivableObj == null) { frmPdcReceivableObj = new frmPdcReceivable(); frmPdcReceivableObj.MdiParent = formMDI.MDIObj; frmPdcReceivableObj.CallFromBillAllocation(this, decMasterId); } } if (strTypeOfVoucher == "Payment Voucher") { PaymentVoucherBll BllPaymentVoucher = new PaymentVoucherBll(); decimal decMasterId = BllPaymentVoucher.paymentMasterIdView(decVoucherTypeId, strVoucherNo); frmPaymentVoucher frmPaymentVoucherObj = new frmPaymentVoucher(); frmPaymentVoucherObj = Application.OpenForms["frmPaymentVoucher"] as frmPaymentVoucher; if (frmPaymentVoucherObj == null) { frmPaymentVoucherObj = new frmPaymentVoucher(); frmPaymentVoucherObj.MdiParent = formMDI.MDIObj; frmPaymentVoucherObj.CallFromBillAllocation(this, decMasterId); } } if (strTypeOfVoucher == "Receipt Voucher") { RecieptVoucherBll bllRecieptVoucherBll = new RecieptVoucherBll(); decimal decMasterId = bllRecieptVoucherBll.ReceiptMasterIdView(decVoucherTypeId, strVoucherNo); frmReceiptVoucher frmReceiptVoucherObj = new frmReceiptVoucher(); frmReceiptVoucherObj = Application.OpenForms["frmReceiptVoucher"] as frmReceiptVoucher; if (frmReceiptVoucherObj == null) { frmReceiptVoucherObj = new frmReceiptVoucher(); frmReceiptVoucherObj.MdiParent = formMDI.MDIObj; frmReceiptVoucherObj.CallFromBillAllocation(this, decMasterId); } } if (strTypeOfVoucher == "Journal Voucher") { JournalVoucherBll JournalVoucherbll = new JournalVoucherBll(); decimal decMasterId = JournalVoucherbll.JournalMasterIdView(decVoucherTypeId, strVoucherNo); frmJournalVoucher frmJournalVoucherObj = new frmJournalVoucher(); frmJournalVoucherObj = Application.OpenForms["frmJournalVoucher"] as frmJournalVoucher; if (frmJournalVoucherObj == null) { frmJournalVoucherObj = new frmJournalVoucher(); frmJournalVoucherObj.MdiParent = formMDI.MDIObj; frmJournalVoucherObj.CallFromBillAllocation(this, decMasterId); } } if (strTypeOfVoucher == "Credit Note") { CreditNoteBll BllCreditNoteMaster = new CreditNoteBll(); decimal decMasterId = BllCreditNoteMaster.CreditNoteMasterIdView(decVoucherTypeId, strVoucherNo); frmCreditNote frmCreditNoteObj = new frmCreditNote(); frmCreditNoteObj = Application.OpenForms["frmCreditNote"] as frmCreditNote; if (frmCreditNoteObj == null) { frmCreditNoteObj = new frmCreditNote(); frmCreditNoteObj.MdiParent = formMDI.MDIObj; frmCreditNoteObj.CallFromBillAllocation(this, decMasterId); } } if (strTypeOfVoucher == "Debit Note") { //DebitNoteMasterSP sp = new DebitNoteMasterSP(); DebitNoteBll bll = new DebitNoteBll(); decimal decMasterId = bll.DebitNoteMasterIdView(decVoucherTypeId, strVoucherNo); frmDebitNote frmDebitNoteObj = new frmDebitNote(); frmDebitNoteObj = Application.OpenForms["frmDebitNote"] as frmDebitNote; if (frmDebitNoteObj == null) { frmDebitNoteObj = new frmDebitNote(); frmDebitNoteObj.MdiParent = formMDI.MDIObj; frmDebitNoteObj.CallFromBillAllocation(this, decMasterId); } } } } catch (Exception ex) { MessageBox.Show("BA:15" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Datagridview /// </summary> public void SearchRegister() { try { string strVoucherNo = txtVoucherNo.Text.ToString(); string strToDate = string.Empty; if (txtToDate.Text == string.Empty) { strToDate = txtFromDate.Text.ToString(); } else { strToDate = txtToDate.Text.ToString(); } string strFromDate = txtFromDate.Text; List<DataTable> listObj = new List<DataTable>(); //DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); listObj = bllDebitNote.DebitNoteRegisterSearch(strVoucherNo, strFromDate, strToDate); dgvDebitNoteRegister.DataSource = listObj[0]; } catch (Exception ex) { MessageBox.Show("DNTREG2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to print the details /// </summary> public void Print() { try { if (dgvDebitNoteReport.Rows.Count > 0) { string strFromDate = txtFromDate.Text; string strToDate = txtToDate.Text; decimal decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()); decimal decLedgerId = Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString()); //DebitNoteMasterSP SpDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); DataSet dsDebitNoteReport = bllDebitNote.DebitNoteReportPrinting(strFromDate, strToDate, decVoucherTypeId, decLedgerId, 1); frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.DebitNoteReportPrinting(dsDebitNoteReport); } } catch (Exception ex) { MessageBox.Show("DRNTREP6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// TO serch the datas and fill the grid /// </summary> public void Search() { try { if (cmbVoucherType.Items.Count != 0 && cmbAccountLedger.Items.Count != 0) { if ((cmbAccountLedger.SelectedValue.ToString() != "System.Data.DataRowView") && (cmbVoucherType.SelectedValue.ToString() != "System.Data.DataRowView")) { if (txtFromDate.Text.Trim() != string.Empty && txtToDate.Text.Trim() != string.Empty) { string strFromDate = txtFromDate.Text; string strToDate = txtToDate.Text; decimal decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()); decimal decLedgerId = Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString()); List<DataTable> listObjDebitNoteReport = new List<DataTable>(); //DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); listObjDebitNoteReport = bllDebitNote.DebitNoteReportSearch(strFromDate, strToDate, decVoucherTypeId, decLedgerId); dgvDebitNoteReport.DataSource = listObjDebitNoteReport[0]; } } } } catch (Exception ex) { MessageBox.Show("DRNTREP5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// function to delete voucher /// </summary> /// <param name="decDebitNoteMasterId"></param> public void DeleteFunction(decimal decDebitNoteMasterId) { try { //DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); PartyBalanceBll BllPartyBalance = new PartyBalanceBll(); if (!BllPartyBalance.PartyBalanceCheckReference(decDebitNoteVoucherTypeId, strVoucherNo)) { bllDebitNote.DebitNoteVoucherDelete(decDebitNoteMasterId, decDebitNoteVoucherTypeId, strVoucherNo); Messages.DeletedMessage(); if (frmDebitNoteRegisterObj != null) { this.Close(); frmDebitNoteRegisterObj.Enabled = true; } else if (frmDebitNoteReportObj != null) { this.Close(); frmDebitNoteReportObj.Enabled = true; } else if (objVoucherSearch != null) { this.Close(); objVoucherSearch.GridFill(); } else if (frmLedgerDetailsObj != null) { this.Close(); } else { Clear(); } } else { Messages.InformationMessage("Reference exist. Cannot delete"); txtDate.Focus(); } } catch (Exception ex) { MessageBox.Show("DRNT25:" + 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); } }
/// <summary> /// Function to clear the fields /// </summary> public void Clear() { try { TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll(); //DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); //-----------------------------------VoucherNo automatic generation-------------------------------------------// if (strVoucherNo == string.Empty) { strVoucherNo = "0"; //strMax; } strVoucherNo = obj.VoucherNumberAutomaicGeneration(decDebitNoteVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName); if (Convert.ToDecimal(strVoucherNo) != bllDebitNote.DebitNoteMasterGetMaxPlusOne(decDebitNoteVoucherTypeId)) { strVoucherNo = bllDebitNote.DebitNoteMasterGetMax(decDebitNoteVoucherTypeId).ToString(); strVoucherNo = obj.VoucherNumberAutomaicGeneration(decDebitNoteVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName); if (bllDebitNote.DebitNoteMasterGetMax(decDebitNoteVoucherTypeId).ToString() == "0") { strVoucherNo = "0"; strVoucherNo = obj.VoucherNumberAutomaicGeneration(decDebitNoteVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName); } } //===================================================================================================================// if (isAutomatic) { SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll(); //SuffixPrefixSP spSuffisprefix = new SuffixPrefixSP(); SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo(); infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decDebitNoteVoucherTypeId, dtpVoucherDate.Value); strPrefix = infoSuffixPrefix.Prefix; strSuffix = infoSuffixPrefix.Suffix; strInvoiceNo = strPrefix + strVoucherNo + strSuffix; txtVoucherNo.Text = strInvoiceNo; txtVoucherNo.ReadOnly = true; } else { txtVoucherNo.ReadOnly = false; txtVoucherNo.Text = string.Empty; strInvoiceNo = txtVoucherNo.Text; } dgvDebitNote.Rows.Clear(); VoucherDate(); dtpVoucherDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy"); txtDebitTotal.Text = string.Empty; txtCreditTotal.Text = string.Empty; btnSave.Text = "Save"; btnDelete.Enabled = false; isEditMode = false; dtblPartyBalance.Clear();//To clear party balance entries to clear the dgvpartybalance PrintCheck(); if (!txtVoucherNo.ReadOnly) { txtVoucherNo.Focus(); } else { txtDate.Select(); } txtNarration.Text = string.Empty; } catch (Exception ex) { MessageBox.Show("DRNT3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to determine whether to call SaveFunction or EditFunction function /// </summary> public void SaveOrEditFunction() { try { //DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); if (!isEditMode) { if (txtVoucherNo.Text.Trim() != string.Empty) { if (!isAutomatic) { strInvoiceNo = txtVoucherNo.Text.Trim(); if (!bllDebitNote.DebitNoteVoucherCheckExistance(strInvoiceNo, decDebitNoteVoucherTypeId, 0)) { SaveFunction(); } else { Messages.InformationMessage("Voucher number already exist"); } } else { SaveFunction(); } } else { Messages.InformationMessage("Enter voucherNo"); txtVoucherNo.Focus(); } } else { if (txtVoucherNo.Text.Trim() != string.Empty) { if (!isAutomatic) { strInvoiceNo = txtVoucherNo.Text.Trim(); if (!bllDebitNote.DebitNoteVoucherCheckExistance(strInvoiceNo, decDebitNoteVoucherTypeId, decDebitNoteMasterIdForEdit)) { EditFunction(decDebitNoteMasterIdForEdit); } else { Messages.InformationMessage("Voucher number already exist"); } } else { EditFunction(decDebitNoteMasterIdForEdit); } } else { Messages.InformationMessage("Enter voucherNo"); } } } catch (Exception ex) { MessageBox.Show("DRNT21:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to save the debitnote voucher /// </summary> public void Save() { try { decimal decTotalDebit = 0; decimal decTotalCredit = 0; decTotalDebit = Convert.ToDecimal(txtDebitTotal.Text.Trim()); decTotalCredit = Convert.ToDecimal(txtCreditTotal.Text.Trim()); //DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP(); //DebitNoteDetailsSP spDebitNoteDetails = new DebitNoteDetailsSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); DebitNoteMasterInfo infoDebitNoteMaster = new DebitNoteMasterInfo(); DebitNoteDetailsInfo infoDebitNoteDetails = new DebitNoteDetailsInfo(); PartyBalanceBll BllPartyBalance = new PartyBalanceBll(); PartyBalanceInfo InfopartyBalance = new PartyBalanceInfo(); ExchangeRateBll BllExchangeRate = new ExchangeRateBll(); 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.Extra1 = string.Empty; infoDebitNoteMaster.Extra2 = string.Empty; infoDebitNoteMaster.TotalAmount = decTotalDebit; decimal decJDebitNoteMasterId = bllDebitNote.DebitNoteMasterAdd(infoDebitNoteMaster); /*******************DebitNoteDetailsAdd and LedgerPosting*************************/ infoDebitNoteDetails.DebitNoteMasterId = decJDebitNoteMasterId; infoDebitNoteDetails.ExtraDate = DateTime.Now; infoDebitNoteDetails.Extra1 = string.Empty; infoDebitNoteDetails.Extra2 = string.Empty; decimal decLedgerId = 0; decimal decDebit = 0; decimal decCredit = 0; int inRowCount = dgvDebitNote.RowCount; for (int inI = 0; inI < inRowCount - 1; 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) { if (dgvDebitNote.Rows[inI].Cells["dgvtxtAmount"].Value != null && dgvDebitNote.Rows[inI].Cells["dgvtxtAmount"].Value.ToString() != string.Empty) { //--------Currency conversion--------------// decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvDebitNote.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString())); 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; } decimal decDebitNoteDetailsId = bllDebitNote.DebitNoteDetailsAdd(infoDebitNoteDetails); if (decDebitNoteDetailsId != 0) { PartyBalanceAddOrEdit(inI); LedgerPosting(decLedgerId, decCredit, decDebit, decDebitNoteDetailsId, inI); } } } Messages.SavedMessage(); //----------------If print after save is enable-----------------------// SettingsBll BllSettings = new SettingsBll(); if (cbxPrintAfterSave.Checked == true) { if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decJDebitNoteMasterId); } else { Print(decJDebitNoteMasterId); } } //===================================================================// } catch (Exception ex) { MessageBox.Show("DRNT31:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to print the voucher /// </summary> /// <param name="decMasterId"></param> public void Print(decimal decMasterId) { try { //DebitNoteMasterSP SpDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); DataSet dsDebitNoteVoucher = bllDebitNote.DebitNotePrinting(decMasterId, 1); frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.DebitNotePrinting(dsDebitNoteVoucher); } catch (Exception ex) { MessageBox.Show("DRNT26:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill the fields for edit or delete /// </summary> public void FillFunction() { try { DebitNoteMasterInfo infoDebitNoteMaster = new DebitNoteMasterInfo(); //DebitNoteMasterSP spDebitNoteMaster = new DebitNoteMasterSP(); DebitNoteBll bllDebitNote = new DebitNoteBll(); infoDebitNoteMaster = bllDebitNote.DebitNoteMasterView(decDebitNoteMasterIdForEdit); txtVoucherNo.ReadOnly = false; strVoucherNo = infoDebitNoteMaster.VoucherNo; strInvoiceNo = infoDebitNoteMaster.InvoiceNo; txtVoucherNo.Text = strInvoiceNo; decDebitNoteSuffixPrefixId = infoDebitNoteMaster.SuffixPrefixId; decDebitNoteVoucherTypeId = infoDebitNoteMaster.VoucherTypeId; dtpVoucherDate.Value = infoDebitNoteMaster.Date; txtNarration.Text = infoDebitNoteMaster.Narration; VoucherTypeBll BllVoucherType = new VoucherTypeBll(); isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(decDebitNoteVoucherTypeId); if (isAutomatic) { txtVoucherNo.ReadOnly = true; } else { txtVoucherNo.ReadOnly = false; } //GridFill List<DataTable> listObj = new List<DataTable>(); //DebitNoteDetailsSP spDebitNoteDetailsSp = new DebitNoteDetailsSP(); //DebitNoteBll bllDebitNote = new DebitNoteBll(); listObj = bllDebitNote.DebitNoteDetailsViewByMasterId(decDebitNoteMasterIdForEdit); AccountLedgerBll bllAccountLedger = new AccountLedgerBll(); LedgerPostingBll BllLedgerPosting = new LedgerPostingBll(); for (int inI = 0; inI < listObj[0].Rows.Count; inI++) { dgvDebitNote.Rows.Add(); dgvDebitNote.Rows[inI].Cells["dgvcmbAccountLedger"].Value = Convert.ToDecimal(listObj[0].Rows[inI]["ledgerId"].ToString()); if (Convert.ToDecimal(listObj[0].Rows[inI]["debit"].ToString()) == 0) { dgvDebitNote.Rows[inI].Cells["dgvcmbDrOrCr"].Value = "Cr"; dgvDebitNote.Rows[inI].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(listObj[0].Rows[inI]["credit"].ToString()); } else { dgvDebitNote.Rows[inI].Cells["dgvcmbDrOrCr"].Value = "Dr"; dgvDebitNote.Rows[inI].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(listObj[0].Rows[inI]["debit"].ToString()); } dgvDebitNote.Rows[inI].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(listObj[0].Rows[inI]["exchangeRateId"].ToString()); if (listObj[0].Rows[inI]["chequeNo"].ToString() != string.Empty) { dgvDebitNote.Rows[inI].Cells["dgvtxtChequeNo"].Value = listObj[0].Rows[inI]["chequeNo"].ToString(); dgvDebitNote.Rows[inI].Cells["dgvtxtChequeDate"].Value = (Convert.ToDateTime(listObj[0].Rows[inI]["chequeDate"].ToString())).ToString(); } dgvDebitNote.Rows[inI].Cells["dgvtxtDetailsId"].Value = listObj[0].Rows[inI]["DebitNoteDetailsId"].ToString(); decimal decDetailsId1 = Convert.ToDecimal(listObj[0].Rows[inI]["DebitNoteDetailsId"].ToString()); decimal decLedgerPostingId = BllLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, decDebitNoteVoucherTypeId); dgvDebitNote.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString(); btnSave.Text = "Update"; } PartyBalanceBll BllPartyBalance = new PartyBalanceBll(); List<DataTable> listObj1 = new List<DataTable>(); listObj1 = BllPartyBalance.PartyBalanceViewByVoucherNoAndVoucherType(decDebitNoteVoucherTypeId, strVoucherNo, infoDebitNoteMaster.Date); dtblPartyBalance = listObj1[0]; dgvDebitNote.ClearSelection(); txtDate.Focus(); } catch (Exception ex) { MessageBox.Show("DRNT37:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }