/// <summary> /// Combo fill function of CashorBank in Grid /// </summary> public void GridBankOrCashComboFill() { try { DataTable dtbl = new DataTable(); ContraDetailsSP spContraDetails = new ContraDetailsSP(); dtbl = spContraDetails.CashOrBankComboFill(); DataRow drow = dtbl.NewRow(); drow["ledgerName"] = string.Empty; drow["ledgerId"] = 0; dtbl.Rows.InsertAt(drow, 0); dgvcmbBankorCashAccount.DataSource = dtbl; dgvcmbBankorCashAccount.DisplayMember = "ledgerName"; dgvcmbBankorCashAccount.ValueMember = "ledgerId"; } catch (Exception ex) { MessageBox.Show("CV:02" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Edit function Call the ledger posting Edit function also /// </summary> /// <param name="decMasterId"></param> public void EditFunction(decimal decMasterId) { try { ContraMasterSP spContraMaster = new ContraMasterSP(); ContraMasterInfo infoContraMaster = new ContraMasterInfo(); ContraDetailsSP spContraDetails = new ContraDetailsSP(); ContraDetailsInfo infoCOntraDetails = new ContraDetailsInfo(); ExchangeRateSP spExchangeRate = new ExchangeRateSP(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); decimal decContraDetailsId = 0; decimal decLedgerPostId = 0; infoContraMaster.ContraMasterId = decMasterId; infoContraMaster.LedgerId = Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()); if (isAutomatic) { infoContraMaster.VoucherNo = strVoucherNo; } if (isAutomatic) { infoContraMaster.InvoiceNo = strInvoiceNo; } else { infoContraMaster.InvoiceNo = txtVoucherNo.Text; } infoContraMaster.Date = Convert.ToDateTime(dtpContraVoucherDate.Text.ToString()); infoContraMaster.Narration = txtNarration.Text.Trim(); infoContraMaster.TotalAmount = Convert.ToDecimal(txtTotal.Text); if (rbtnDeposit.Checked) infoContraMaster.Type = "Deposit"; else infoContraMaster.Type = "Withdraw"; infoContraMaster.SuffixPrefixId = decContraSuffixPrefixId; infoContraMaster.VoucherTypeId = DecContraVoucherTypeId; infoContraMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoContraMaster.UserId = PublicVariables._decCurrentUserId; infoContraMaster.Extra1 = string.Empty; infoContraMaster.Extra2 = string.Empty; infoContraMaster.Date = Convert.ToDateTime(txtContraVoucherDate.Text); int inCount = dgvContraVoucher.RowCount; int inValue = 0; for (int i = 0; i < inCount - 1; i++) { if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != null) { inValue++; } } if (inValue > 0) { if (Convert.ToDecimal(txtTotal.Text) != 0) { infoCOntraDetails.ContraMasterId = decMasterId; infoCOntraDetails.Extra1 = string.Empty; infoCOntraDetails.Extra2 = string.Empty; //------------------deleting removed rows----------------------------------------// foreach (var item in arrlstOfRemove) { decimal decId = Convert.ToDecimal(item); spContraDetails.ContraDetailsDelete(Convert.ToDecimal(decId)); spLedgerPosting.LedgerPostDeleteByDetailsId(Convert.ToDecimal(decId), strVoucherNo, DecContraVoucherTypeId); } //--------------------------End---------------------------------------------------// int inRowCount = dgvContraVoucher.RowCount; decimal decLedgerId = 0; decimal decLedger1Id = 0; decimal decDebit = 0; decimal decCredit = 0; decLedger1Id = Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()); for (int i = 0; i < inRowCount; i++) { if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != "") { decLedgerId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString()); infoCOntraDetails.LedgerId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString()); } if (dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value.ToString() != "") { infoCOntraDetails.ChequeNo = dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value.ToString(); } else { infoCOntraDetails.ChequeNo = string.Empty; } if (dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value.ToString() != "") { infoCOntraDetails.ChequeDate = Convert.ToDateTime(dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value.ToString()); } else { infoCOntraDetails.ChequeDate = Convert.ToDateTime("1/1/1753"); } if (dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != "") { infoCOntraDetails.Amount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString()); if (dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value.ToString() != "") { infoCOntraDetails.ContraDetailsId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value.ToString()); decContraDetailsId = infoCOntraDetails.ContraDetailsId; decSelectedCurrencyRate = spExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString())); decAmount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString()); decConvertRate = decAmount * decSelectedCurrencyRate; if (rbtnDeposit.Checked) { decCredit = decConvertRate; decDebit = 0; } else { decDebit = decConvertRate; decCredit = 0; } infoCOntraDetails.ContraMasterId = decMasterId; infoCOntraDetails.ExchangeRateId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString()); spContraDetails.ContraDetailsEdit(infoCOntraDetails); decLedgerPostId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtLedgerPostingId"].Value.ToString()); LedgerPostingEdit(decLedgerPostId, decLedgerId, decCredit, decDebit, decContraDetailsId, i); } else { infoCOntraDetails.ExchangeRateId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString()); decSelectedCurrencyRate = spExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString())); decAmount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString()); decConvertRate = decAmount * decSelectedCurrencyRate; if (rbtnDeposit.Checked) { decCredit = decConvertRate; decDebit = 0; } else { decDebit = decConvertRate; decCredit = 0; } decContraDetailsId = spContraDetails.ContraDetailsAddReturnWithhIdentity(infoCOntraDetails); LedgerPosting(decLedgerId, decCredit, decDebit, decContraDetailsId, i); } } } spContraMaster.ContraMasterEdit(infoContraMaster); decLedgerPostId = spLedgerPosting.LedgerPostingIdForTotalAmount(strVoucherNo, DecContraVoucherTypeId); decAmount = Convert.ToDecimal(txtTotal.Text); decContraDetailsId = 0; if (rbtnDeposit.Checked) { decDebit = decAmount; decCredit = 0; LedgerPostingEdit(decLedgerPostId, decLedger1Id, decCredit, decDebit, decContraDetailsId, -1); } else { decCredit = decAmount; decDebit = 0; LedgerPostingEdit(decLedgerPostId, decLedger1Id, decCredit, decDebit, decContraDetailsId, -1); } Messages.UpdatedMessage(); if (cbxPrintafterSave.Checked) { if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decMasterId); } else { Print(decMasterId); } } this.Close(); } else { Messages.InformationMessage("Cannot save total amount as 0"); dgvContraVoucher.Focus(); } } else { Messages.InformationMessage("Cant update contra voucher without atleast one ledger with complete details"); } } catch (Exception ex) { MessageBox.Show("CV:17" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Fill all the controlls while coming from other forms for update or delete /// </summary> public void FillFunction() { try { ContraDetailsSP spContraDetails = new ContraDetailsSP(); ContraMasterSP spContraMaster = new ContraMasterSP(); ContraMasterInfo infoContraMaster = new ContraMasterInfo(); LedgerPostingSP SpLedgerPosting = new LedgerPostingSP(); VoucherTypeSP spVoucherType = new VoucherTypeSP(); infoContraMaster = spContraMaster.ContraMasterView(decMasterId); txtVoucherNo.ReadOnly = false; strVoucherNo = infoContraMaster.VoucherNo; txtVoucherNo.Text = infoContraMaster.InvoiceNo; strInvoiceNo = infoContraMaster.InvoiceNo; strInvoiceNo = infoContraMaster.InvoiceNo; decContraSuffixPrefixId = Convert.ToDecimal(infoContraMaster.SuffixPrefixId.ToString()); DecContraVoucherTypeId = Convert.ToDecimal(infoContraMaster.VoucherTypeId.ToString()); int inDecimalPlace = PublicVariables._inNoOfDecimalPlaces; txtNarration.Text = infoContraMaster.Narration; txtContraVoucherDate.Text = Convert.ToString(infoContraMaster.date); cmbBankAccount.SelectedValue = infoContraMaster.LedgerId; strVoucherNo = infoContraMaster.VoucherNo; if (infoContraMaster.Type == "Deposit") { rbtnDeposit.Checked = true; } else { rbtnWithdrawal.Checked = true; } isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(DecContraVoucherTypeId); if (isAutomatic) { txtVoucherNo.Enabled = false; } else { txtVoucherNo.Enabled = true; } DataTable dtbl = new DataTable(); dtbl = spContraDetails.ContraDetailsViewWithMasterId(decMasterId); for (int i = 0; i < dtbl.Rows.Count; i++) { dgvContraVoucher.Rows.Add(); dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value = Convert.ToDecimal(dtbl.Rows[i]["ledgerId"].ToString()); dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(dtbl.Rows[i]["exchangeRateId"].ToString()); dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(dtbl.Rows[i]["amount"].ToString()); if (dtbl.Rows[i]["chequeNo"].ToString() != string.Empty) { dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value = dtbl.Rows[i]["chequeNo"].ToString(); if (dtbl.Rows[i]["chequeDate"].ToString() == "01 Jan 1753") { dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value = null; } else { dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value = dtbl.Rows[i]["chequeDate"].ToString(); } } dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value = dtbl.Rows[i]["contraDetailsId"].ToString(); decimal decDetailsId1 = Convert.ToDecimal(dtbl.Rows[i]["contraDetailsId"].ToString()); decimal decLedgerPostingId = SpLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, DecContraVoucherTypeId); dgvContraVoucher.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString(); } } catch (Exception ex) { MessageBox.Show("CV:31" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Save function Call the ledger posting function also /// </summary> public void SaveFuction() { try { decimal decContraDetailsId = 0; ContraMasterSP spContraMaster = new ContraMasterSP(); ContraMasterInfo infoContraMaster = new ContraMasterInfo(); ContraDetailsSP spContraDetails = new ContraDetailsSP(); ContraDetailsInfo infoCOntraDetails = new ContraDetailsInfo(); ExchangeRateSP spExchangeRate = new ExchangeRateSP(); decimal decIdentity = 0; decimal decLedgerId = 0; decimal decDebit = 0; decimal decCredit = 0; int inCount = dgvContraVoucher.RowCount; int inValue = 0; for (int i = 0; i < inCount - 1; i++) { if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != null) { inValue++; } } if (inValue > 0) { if (Convert.ToDecimal(txtTotal.Text) != 0) { infoContraMaster.LedgerId = Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()); if (isAutomatic) { infoContraMaster.VoucherNo = strVoucherNo; } else { decimal decVoucherNo = spContraMaster.ContraVoucherMasterGetMaxPlusOne(DecContraVoucherTypeId) + 1; infoContraMaster.VoucherNo = Convert.ToString(decVoucherNo); } infoContraMaster.Date = Convert.ToDateTime(dtpContraVoucherDate.Text.ToString()); infoContraMaster.Narration = txtNarration.Text.Trim(); infoContraMaster.TotalAmount = Convert.ToDecimal(txtTotal.Text); infoContraMaster.Extra1 = string.Empty; infoContraMaster.Extra2 = string.Empty; if (rbtnDeposit.Checked) { infoContraMaster.Type = "Deposit"; } else { infoContraMaster.Type = "Withdraw"; } infoContraMaster.SuffixPrefixId = decContraSuffixPrefixId; infoContraMaster.VoucherTypeId = DecContraVoucherTypeId; infoContraMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoContraMaster.UserId = PublicVariables._decCurrentUserId; if (isAutomatic) { infoContraMaster.InvoiceNo = strInvoiceNo; } else { infoContraMaster.InvoiceNo = txtVoucherNo.Text; } decIdentity = spContraMaster.ContraMasterAdd(infoContraMaster); infoCOntraDetails.ContraMasterId = decIdentity; infoCOntraDetails.Extra1 = string.Empty; infoCOntraDetails.Extra2 = string.Empty; int inRowCount = dgvContraVoucher.RowCount; //-------------------------------Saving grid details-------------------------------------------------------------------- for (int i = 0; i < inRowCount - 1; i++) { if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != string.Empty) { infoCOntraDetails.LedgerId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString()); } if (dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != string.Empty) { infoCOntraDetails.Amount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString()); } if (dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty) { infoCOntraDetails.ChequeNo = dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value.ToString(); } else { infoCOntraDetails.ChequeNo = string.Empty; } if (dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty) { infoCOntraDetails.ChequeDate = Convert.ToDateTime(dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value.ToString()); } else { infoCOntraDetails.ChequeDate = Convert.ToDateTime("1/1/1753"); } infoCOntraDetails.ExchangeRateId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString()); decContraDetailsId = spContraDetails.ContraDetailsAddReturnWithhIdentity(infoCOntraDetails); //---------------------------------------------------------Ledger Posting-----------------------------------------/---------------------------------------------------/ if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != string.Empty) { decLedgerId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString()); } if (dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != string.Empty) { decSelectedCurrencyRate = spExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value)); decAmount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString()); decConvertRate = decAmount * decSelectedCurrencyRate; if (rbtnDeposit.Checked) { decCredit = decConvertRate; decDebit = 0; LedgerPosting(decLedgerId, decCredit, decDebit, decContraDetailsId, i); } else { decDebit = decConvertRate; decCredit = 0; LedgerPosting(decLedgerId, decCredit, decDebit, decContraDetailsId, i); } } } decAmount = Convert.ToDecimal(txtTotal.Text); decContraDetailsId = 0; if (rbtnDeposit.Checked) { decDebit = decAmount; decCredit = 0; LedgerPosting(infoContraMaster.LedgerId, decCredit, decDebit, decContraDetailsId, -1); } else { decCredit = decAmount; decDebit = 0; LedgerPosting(infoContraMaster.LedgerId, decCredit, decDebit, decContraDetailsId, -1); } //------------------------------------------------------------------Ledger Posting---end---------------------------------------------------------------------// Messages.SavedMessage(); if (cbxPrintafterSave.Checked) { if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decIdentity); } else { Print(decIdentity); } } Clear(); } else { Messages.InformationMessage("Cannot save total debit and credit as 0"); dgvContraVoucher.Focus(); } } else { Messages.InformationMessage("Cant save contra voucher without atleast one ledger with complete details"); } } catch (Exception ex) { MessageBox.Show("CV:16" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Delete Function /// </summary> /// <param name="decContraMasterId"></param> public void DeleteFunction(decimal decContraMasterId) { try { ContraDetailsSP spContraDetails = new ContraDetailsSP(); spContraDetails.ContraVoucherDelete(decContraMasterId, DecContraVoucherTypeId, strVoucherNo); Messages.DeletedMessage(); this.Close(); if (frmsearch != null) { this.Close(); frmsearch.GridFill(); } } catch (Exception ex) { MessageBox.Show("CV:18" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }