/// <summary>
/// Function for Save and Edit
/// </summary>
public void SaveOrEdit()
{
try
{
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseReturnBll BllPurchaseReturn = new PurchaseReturnBll();
PurchaseReturnDetailsInfo infoPurchaseReturnDetails = new PurchaseReturnDetailsInfo();
StockPostingInfo infoStockPosting = new StockPostingInfo();
//StockPostingSP spStockPosting = new StockPostingSP();
StockPostingBll BllStockPosting = new StockPostingBll();
UnitConvertionBll BllUnitConvertion = new UnitConvertionBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
PurchaseReturnBilltaxInfo infoPurchaseReturnBillTax = new PurchaseReturnBilltaxInfo();
SettingsBll BllSettings = new SettingsBll();
UnitBll bllUnit = new UnitBll();
List<DataTable> ListObj = new List<DataTable>();
string strAgainstVoucherNo = string.Empty;
string strAgainstInvoiceNo = string.Empty;
decimal decPurchaseReturnMasterIds = 0;
decimal decPurchaseMasterId = 0;
decimal decDiscount = 0;
decimal decExchangeRate = 0;
decimal decDis = 0;
if (isAutomatic)
{
if (strVoucherNo != string.Empty)
{
infoPurchaseReturnMaster.VoucherNo = strVoucherNo;
}
if (txtReturnNo.Text != string.Empty)
{
infoPurchaseReturnMaster.InvoiceNo = txtReturnNo.Text;
}
}
else
{
infoPurchaseReturnMaster.VoucherNo = strVoucherNo;
infoPurchaseReturnMaster.InvoiceNo = txtReturnNo.Text;
}
if (decPurchaseReturnVoucherTypeId != 0)
{
infoPurchaseReturnMaster.VoucherTypeId = decPurchaseReturnVoucherTypeId;
}
infoPurchaseReturnMaster.SuffixPrefixId = (decPurchaseReturnSuffixPrefixId != 0) ? decPurchaseReturnSuffixPrefixId : 0;
infoPurchaseReturnMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoPurchaseReturnMaster.PurchaseAccount = Convert.ToDecimal(cmbPurchaseAccount.SelectedValue.ToString());
if (cmbInvoiceNo.SelectedValue != null && cmbInvoiceNo.Visible == true)
{
infoPurchaseReturnMaster.PurchaseMasterId = Convert.ToDecimal((cmbInvoiceNo.SelectedValue.ToString()));
decPurchaseMasterId = Convert.ToDecimal((cmbInvoiceNo.SelectedValue.ToString()));
}
else
{
infoPurchaseReturnMaster.PurchaseMasterId = 0;
}
infoPurchaseReturnMaster.ExchangeRateId = (cmbCurrency.SelectedValue != null) ? Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()) : 0;
infoPurchaseReturnMaster.Narration = txtNarration.Text.Trim();
infoPurchaseReturnMaster.UserId = PublicVariables._decCurrentUserId;
infoPurchaseReturnMaster.LrNo = txtLrlNo.Text.Trim();
infoPurchaseReturnMaster.TransportationCompany = txtTransportationCompany.Text.Trim();
infoPurchaseReturnMaster.Date = Convert.ToDateTime(txtDate.Text);
infoPurchaseReturnMaster.TotalAmount = (txtTotalAmount.Text != string.Empty) ? Convert.ToDecimal(txtTotalAmount.Text) : 0;
infoPurchaseReturnMaster.TotalTax = (lblTaxAmount.Text != string.Empty) ? Convert.ToDecimal(lblTaxAmount.Text) : 0;
infoPurchaseReturnMaster.Discount = (txtBillDiscount.Text != string.Empty) ? Convert.ToDecimal(txtBillDiscount.Text) : 0;
infoPurchaseReturnMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPurchaseReturnMaster.Extra1 = string.Empty;
infoPurchaseReturnMaster.Extra2 = string.Empty;
infoPurchaseReturnMaster.ExtraDate = DateTime.Now;
infoPurchaseReturnMaster.GrandTotal = (txtGrandTotal.Text != string.Empty) ? Convert.ToDecimal(txtGrandTotal.Text) : 0;
if (btnSave.Text == "Save")
{
decPurchaseReturnMasterIds = BllPurchaseReturn.PurchaseReturnMasterAddWithReturnIdentity(infoPurchaseReturnMaster);
}
else
{
infoPurchaseReturnMaster.PurchaseReturnMasterId = decPurchaseReturnMasterId;
decExchangeRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(infoPurchaseReturnMaster.ExchangeRateId);
BllPurchaseReturn.PurchaseReturnMasterEdit(infoPurchaseReturnMaster);
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
BllLedgerPosting.LedgerPostDelete(strVoucherNo, decPurchaseReturnVoucherTypeId);
bllAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(strVoucherNo, decPurchaseReturnVoucherTypeId);
}
infoLedgerPosting.Date = infoPurchaseReturnMaster.Date;
infoLedgerPosting.VoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoLedgerPosting.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.LedgerId = infoPurchaseReturnMaster.PurchaseAccount;
infoLedgerPosting.Debit = 0;
if (btnSave.Text == "Save")
{
infoLedgerPosting.Credit = TotalNetAmountCalculation() * BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.ExtraDate = DateTime.Now;
}
else
{
infoLedgerPosting.Credit = TotalNetAmountCalculation();
}
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
infoLedgerPosting.LedgerId = infoPurchaseReturnMaster.LedgerId;
if (btnSave.Text == "Save")
{
infoLedgerPosting.Debit = Convert.ToDecimal(txtGrandTotal.Text) * BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.ExtraDate = DateTime.Now;
}
else
{
infoLedgerPosting.Debit = Convert.ToDecimal(txtGrandTotal.Text);
}
infoLedgerPosting.Credit = 0;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
foreach (DataGridViewRow dgvrow in dgvPurchaseReturnTax.Rows)
{
if (dgvrow.Cells["dgvtxtTaxId"].Value != null && dgvrow.Cells["dgvtxtTaxId"].Value.ToString() != string.Empty)
{
infoLedgerPosting.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvtxtledgerId"].Value.ToString());
infoLedgerPosting.Credit = (dgvrow.Cells["dgvtxtAmounts"].Value == null) ? 0 : Convert.ToDecimal(dgvrow.Cells["dgvtxtAmounts"].Value.ToString());
infoLedgerPosting.Debit = 0;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
if (txtBillDiscount.Text.Trim() != string.Empty)
{
decDis = Convert.ToDecimal(txtBillDiscount.Text);
}
if (decDis >= 0)
{
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = decDis;
infoLedgerPosting.LedgerId = 9;
infoLedgerPosting.ExtraDate = DateTime.Now;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
if (btnSave.Text == "Update")
{
infoPurchaseReturnMaster = BllPurchaseReturn.PurchaseReturnMasterView(decPurchaseReturnMasterId);
if (infoPurchaseReturnMaster.PurchaseMasterId == 0)
{
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(0, "NA", infoPurchaseReturnMaster.VoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
if (infoPurchaseReturnMaster.PurchaseMasterId != 0)
{
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(infoPurchaseMaster.VoucherTypeId, strInvoiceNo, strVoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
}
foreach (DataGridViewRow dgvrow in dgvPurchaseReturn.Rows)
{
if (dgvrow.Cells["dgvtxtProductId"].Value != null && dgvrow.Cells["dgvtxtProductId"].Value.ToString() != string.Empty)
{
infoPurchaseReturnDetails.ExtraDate = DateTime.Now;
infoPurchaseReturnDetails.Extra1 = string.Empty;
infoPurchaseReturnDetails.Extra2 = string.Empty;
infoPurchaseReturnDetails.PurchaseReturnMasterId = (btnSave.Text == "Save") ? decPurchaseReturnMasterIds : decPurchaseReturnMasterId;
infoPurchaseReturnDetails.ProductId = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtproductId"].Value));
infoPurchaseReturnDetails.Qty = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtqty"].Value));
infoPurchaseReturnDetails.Rate = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtrate"].Value));
if (btnSave.Text == "Save")
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
infoPurchaseReturnDetails.UnitConversionId = BllUnitConvertion.UnitconversionIdViewByUnitIdAndProductId(infoPurchaseReturnDetails.UnitId, infoPurchaseReturnDetails.ProductId);
}
else
{
if (Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value) == 0)
{
try
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
}
catch
{
infoPurchaseReturnDetails.UnitId = bllUnit.UnitIdByUnitName(Convert.ToString(dgvrow.Cells["dgvcmbUnit"].Value.ToString()));
}
infoPurchaseReturnDetails.UnitConversionId = BllUnitConvertion.UnitconversionIdViewByUnitIdAndProductId(infoPurchaseReturnDetails.UnitId, infoPurchaseReturnDetails.ProductId);
}
else
{
try
{
infoPurchaseReturnDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
}
catch
{
infoPurchaseReturnDetails.UnitId = bllUnit.UnitIdByUnitName(Convert.ToString(dgvrow.Cells["dgvcmbUnit"].Value.ToString()));
}
}
infoPurchaseReturnDetails.UnitConversionId = Convert.ToDecimal(dgvrow.Cells["dgvtxtUnitConversionId"].Value);
}
infoPurchaseReturnDetails.Discount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtdiscount"].Value));
if (dgvrow.Cells["dgvcmbTax"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbTax"].Value) != string.Empty && dgvrow.Cells["dgvcmbTax"].Value as string != "NA")
{
infoPurchaseReturnDetails.TaxId = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvcmbTax"].Value));
if (strTaxComboFill != string.Empty)
{
infoPurchaseReturnDetails.TaxAmount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtTaxAmount"].Value));
}
}
else
{
infoPurchaseReturnDetails.TaxId = 0;
}
if (dgvrow.Cells["dgvcmbBatch"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbBatch"].Value) != string.Empty)
{
infoPurchaseReturnDetails.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value);
}
else
{
infoPurchaseReturnDetails.GodownId = 0;
}
if (dgvrow.Cells["dgvcmbGodown"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbGodown"].Value) != string.Empty)
{
infoPurchaseReturnDetails.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value);
}
else
{
infoPurchaseReturnDetails.RackId = 0;
}
if (dgvrow.Cells["dgvcmbRack"].Value != null && Convert.ToString(dgvrow.Cells["dgvcmbRack"].Value) != string.Empty)
{
infoPurchaseReturnDetails.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value);
}
infoPurchaseReturnDetails.GrossAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtgrossValue"].Value.ToString());
infoPurchaseReturnDetails.NetAmount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtNetAmount"].Value));
infoPurchaseReturnDetails.Amount = Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtAmount"].Value));
infoPurchaseReturnDetails.SlNo = Convert.ToInt32(Convert.ToString(dgvrow.Cells["dgvtxtSlNo"].Value));
infoPurchaseReturnDetails.PurchaseDetailsId = (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value != null) ? Convert.ToDecimal(Convert.ToString(dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value)) : 0;
if (dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value != null)
{
if (dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString() == "0" || dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString() == string.Empty)
{
BllPurchaseReturn.PurchaseReturnDetailsAddWithReturnIdentity(infoPurchaseReturnDetails);
}
else
{
infoPurchaseReturnDetails.PurchaseReturnDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseReturnDetailsId"].Value.ToString());
BllPurchaseReturn.PurchaseReturnDetailsEdit(infoPurchaseReturnDetails);
}
}
else
{
BllPurchaseReturn.PurchaseReturnDetailsAddWithReturnIdentity(infoPurchaseReturnDetails);
}
if (btnSave.Text == "Save")
{
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
}
infoStockPosting.Date = infoPurchaseReturnMaster.Date;
infoStockPosting.ProductId = infoPurchaseReturnDetails.ProductId;
infoStockPosting.BatchId = infoPurchaseReturnDetails.BatchId;
infoStockPosting.UnitId = infoPurchaseReturnDetails.UnitId;
infoStockPosting.GodownId = infoPurchaseReturnDetails.GodownId;
infoStockPosting.RackId = infoPurchaseReturnDetails.RackId;
decimal decConversionId = BllUnitConvertion.UnitConversionRateByUnitConversionId(infoPurchaseReturnDetails.UnitConversionId);
//infoStockPosting.OutwardQty = infoPurchaseReturnDetails.Qty / (decConversionId == 0 ? 1 : decConversionId);
infoStockPosting.OutwardQty = infoPurchaseReturnDetails.Qty;
infoStockPosting.InwardQty = 0;
infoStockPosting.Rate = infoPurchaseReturnDetails.Rate;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
if (infoPurchaseReturnDetails.PurchaseDetailsId != 0)
{
infoStockPosting.AgainstVoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstVoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.AgainstInvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.InvoiceNo = txtReturnNo.Text.Trim();
infoStockPosting.VoucherTypeId = decPurchaseReturnVoucherTypeId;
decAgainstVoucherTypeId = infoStockPosting.VoucherTypeId;
}
else
{
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoStockPosting.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoStockPosting.VoucherTypeId = decPurchaseReturnVoucherTypeId;
decAgainstVoucherTypeId = 0;
}
BllStockPosting.StockPostingAdd(infoStockPosting);
}
}
if (btnSave.Text == "Update")
{
removePurchaseReturnDetails();
}
infoAccountLedger = bllAccountLedger.AccountLedgerView(infoPurchaseReturnMaster.LedgerId);
if (infoAccountLedger.BillByBill == true)
{
infoPartyBalance.Date = infoPurchaseReturnMaster.Date;
infoPartyBalance.LedgerId = infoPurchaseReturnMaster.LedgerId;
if (decAgainstVoucherTypeId != 0)
{
infoPartyBalance.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoPartyBalance.VoucherNo = infoPurchaseMaster.VoucherNo;
infoPartyBalance.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoPartyBalance.AgainstVoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoPartyBalance.AgainstInvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoPartyBalance.ReferenceType = "Against";
}
else
{
infoPartyBalance.VoucherTypeId = infoPurchaseReturnMaster.VoucherTypeId;
infoPartyBalance.VoucherNo = infoPurchaseReturnMaster.VoucherNo;
infoPartyBalance.InvoiceNo = infoPurchaseReturnMaster.InvoiceNo;
infoPartyBalance.AgainstVoucherTypeId = 0;
infoPartyBalance.AgainstVoucherNo = "NA";
infoPartyBalance.AgainstInvoiceNo = "NA";
infoPartyBalance.ReferenceType = "New";
}
infoPartyBalance.Debit = infoPurchaseReturnMaster.TotalAmount;
infoPartyBalance.Credit = 0;
infoPartyBalance.CreditPeriod = 0;
infoPartyBalance.ExchangeRateId = infoPurchaseReturnMaster.ExchangeRateId;
infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPartyBalance.Extra1 = string.Empty;
infoPartyBalance.Extra2 = string.Empty;
BllPartyBalance.PartyBalanceAdd(infoPartyBalance);
}
foreach (DataGridViewRow item in dgvPurchaseReturnTax.Rows)
{
if (item.Cells["dgvtxtTaxId"].Value != null)
{
if (Convert.ToDecimal(item.Cells["dgvtxtAmounts"].Value.ToString()) > 0)
{
infoPurchaseReturnBillTax.PurchaseReturnMasterId = (btnSave.Text == "Save") ? decPurchaseReturnMasterIds : decPurchaseReturnMasterIds;
infoPurchaseReturnBillTax.TaxId = Convert.ToDecimal(item.Cells["dgvtxtTaxId"].Value.ToString());
infoPurchaseReturnBillTax.TaxAmount = (item.Cells["dgvtxtAmounts"].Value == null) ? 0 : Convert.ToDecimal(item.Cells["dgvtxtAmounts"].Value.ToString());
infoPurchaseReturnBillTax.Extra1 = string.Empty;
infoPurchaseReturnBillTax.Extra2 = string.Empty;
BllPurchaseReturn.PurchaseReturnBilltaxAdd(infoPurchaseReturnBillTax);
}
}
}
if (btnSave.Text == "Save")
{
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseReturnMasterIds);
}
else
{
Print(decPurchaseReturnMasterIds);
}
}
Clear();
}
else
{
decDiscount = Convert.ToDecimal(txtBillDiscount.Text);
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseReturnMasterId);
}
else
{
Print(decPurchaseReturnMasterId);
}
}
if (frmPurchaseReturnRegisterObj != null)
{
frmPurchaseReturnRegisterObj.GridFill();
frmPurchaseReturnRegisterObj.Enabled = true;
}
if (ObjPurchaseReturnReport != null)
{
ObjPurchaseReturnReport.PurchaseReturnReportGridFill();
ObjPurchaseReturnReport.Enabled = true;
}
if (frmLedgerDetailsObj != null)
{
frmLedgerDetailsObj.LedgerDetailsView();
frmLedgerDetailsObj.Enabled = true;
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("PR:49" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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>
/// Function for ledgerposting
/// </summary>
/// <param name="decid"></param>
/// <param name="decCredit"></param>
/// <param name="decDebit"></param>
/// <param name="decDetailsId"></param>
/// <param name="strVoucherNos"></param>
public void LedgerPosting(decimal decid, decimal decCredit, decimal decDebit, decimal decDetailsId, string strVoucherNos)
{
try
{
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
infoLedgerPosting.VoucherTypeId = DecServicetVoucherTypeId;
if (isAutomatic)
{
infoLedgerPosting.VoucherNo = strVoucherNo;
}
else
{
infoLedgerPosting.VoucherNo = strVoucherNos;
}
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.LedgerId = decid;
infoLedgerPosting.DetailsId = decDetailsId;
infoLedgerPosting.Debit = Convert.ToDecimal(txtGrandTotal.Text.ToString());
infoLedgerPosting.Credit = 0;
if (isAutomatic)
{
infoLedgerPosting.InvoiceNo = strInvoiceNo;
}
else
{
infoLedgerPosting.InvoiceNo = txtInvoiceNumber.Text; //For Manual mode
}
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
infoLedgerPosting.Date = PublicVariables._dtCurrentDate; // get credit the net amount to tally both cr and dr
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.VoucherTypeId = DecServicetVoucherTypeId;
if (isAutomatic)
{
infoLedgerPosting.VoucherNo = strVoucherNo;
}
else
{
infoLedgerPosting.VoucherNo = strVoucherNos;
}
if (isAutomatic)
{
infoLedgerPosting.InvoiceNo = strInvoiceNo;
}
else
{
infoLedgerPosting.InvoiceNo = txtInvoiceNumber.Text; //For Manual mode
}
infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbServiceAC.SelectedValue.ToString());
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = Convert.ToDecimal(txtTotalAmount.Text.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = decDetailsId; ;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
decimal decBillDis = 0;
decBillDis = Convert.ToDecimal(txtDiscount.Text.Trim().ToString());
if (decBillDis > 0)
{
infoLedgerPosting.Debit = decBillDis; // here get debit the bill discount to tally both cr and dr
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.VoucherTypeId = DecServicetVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = strInvoiceNo;
infoLedgerPosting.LedgerId = 8; // here want to get discount ledgerId (now not available) so temp 'm using
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = decDetailsId;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
catch (Exception ex)
{
MessageBox.Show("SV 18 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// LedgerPosting Update Function
/// </summary>
/// <param name="decLedgerPostingId"></param>
/// <param name="decLedgerId"></param>
/// <param name="decCredit"></param>
/// <param name="decDebit"></param>
/// <param name="decDetailsId"></param>
/// <param name="inI"></param>
public void LedgerPostingEdit(decimal decLedgerPostingId, decimal decLedgerId, decimal decCredit, decimal decDebit, decimal decDetailsId, int inI)
{
try
{
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
infoLedgerPosting.LedgerPostingId = decLedgerPostingId;
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.VoucherTypeId = DecContraVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.DetailsId = decDetailsId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = txtVoucherNo.Text;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.LedgerId = decLedgerId;
infoLedgerPosting.Credit = decCredit;
infoLedgerPosting.Debit = decDebit;
if (inI > -1)
{
if (dgvContraVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvContraVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
infoLedgerPosting.ChequeNo = dgvContraVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoLedgerPosting.ChequeNo = string.Empty;
}
if (dgvContraVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvContraVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
infoLedgerPosting.ChequeDate = Convert.ToDateTime(dgvContraVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value);
}
else
{
infoLedgerPosting.ChequeDate = DateTime.Now;
}
}
else
{
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
}
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
catch (Exception ex)
{
MessageBox.Show("CV:20" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Ledger Posting edit function
/// </summary>
/// <param name="decpdcMasterId"></param>
public void LedgerPostingEdit(decimal decpdcMasterId)
{
PDCRecivebleBll BllPdcRecieveble = new PDCRecivebleBll();
List<DataTable> listObjLedgerPostingId = new List<DataTable>();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
decimal decOldExchange = 0;
decimal decNewExchangeRate = 0;
decimal decNewExchangeRateId = 0;
decimal decSelectedCurrencyRate = 0;
decimal decAmount = 0;
decimal decConvertRate = 0;
string strReferenceType = string.Empty;
decimal decOldExchangeId = 0;
try
{
listObjLedgerPostingId = BllPdcRecieveble.LedgerPostingIdByPDCReceivableId(decpdcMasterId);
decimal decledgerpostingId1 = Convert.ToDecimal(listObjLedgerPostingId[0].Rows[0]["ledgerPostingId"].ToString());
decimal decLedgerPostingId2 = Convert.ToDecimal(listObjLedgerPostingId[0].Rows[1]["ledgerPostingId"].ToString());
if (!btnAgainRef.Enabled)
{
infoLedgerPosting.LedgerPostingId = decledgerpostingId1;
infoLedgerPosting.VoucherTypeId = decPDCReceivableVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtVoucherNo.Text.Trim();
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = Convert.ToDecimal(txtAmount.Text);
infoLedgerPosting.ChequeDate = Convert.ToDateTime(txtCheckDate.Text);
infoLedgerPosting.ChequeNo = txtcheckNo.Text.Trim();
infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
else
{
infoLedgerPosting.LedgerPostingId = decledgerpostingId1;
infoLedgerPosting.VoucherTypeId = decPDCReceivableVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtVoucherNo.Text.Trim();
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Debit = 0;
foreach (DataRow dr in dtblPartyBalance.Rows)
{
if (infoLedgerPosting.LedgerId == Convert.ToDecimal(dr["LedgerId"].ToString()))
{
decOldExchange = Convert.ToDecimal(dr["OldExchangeRate"].ToString());
decNewExchangeRateId = Convert.ToDecimal(dr["CurrencyId"].ToString());
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(decOldExchange);
decAmount = Convert.ToDecimal(dr["Amount"].ToString());
decConvertRate = decConvertRate + (decAmount * decSelectedCurrencyRate);
}
}
infoLedgerPosting.Credit = decConvertRate;
infoLedgerPosting.ChequeDate = Convert.ToDateTime(txtCheckDate.Text);
infoLedgerPosting.ChequeNo = txtcheckNo.Text.Trim();
infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
infoLedgerPosting.LedgerId = 12;
foreach (DataRow dr in dtblPartyBalance.Rows)
{
if (Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString()) == Convert.ToDecimal(dr["LedgerId"].ToString()))
{
if (dr["ReferenceType"].ToString() == "Against")
{
decNewExchangeRateId = Convert.ToDecimal(dr["CurrencyId"].ToString());
decNewExchangeRate = BllExchangeRate.GetExchangeRateByExchangeRateId(decNewExchangeRateId);
decOldExchangeId = Convert.ToDecimal(dr["OldExchangeRate"].ToString());
decOldExchange = BllExchangeRate.GetExchangeRateByExchangeRateId(decOldExchangeId);
decAmount = Convert.ToDecimal(dr["Amount"].ToString());
decimal decForexAmount = (decAmount * decNewExchangeRate) - (decAmount * decOldExchange);
if (decForexAmount >= 0)
{
infoLedgerPosting.Credit = decForexAmount;
infoLedgerPosting.Debit = 0;
}
else
{
infoLedgerPosting.Debit = -1 * decForexAmount;
infoLedgerPosting.Credit = 0;
}
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
}
}
infoLedgerPosting.LedgerPostingId = decLedgerPostingId2;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtVoucherNo.Text.Trim();
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.LedgerId = 7;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.Debit = Convert.ToDecimal(txtAmount.Text);
infoLedgerPosting.Credit = 0;
infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate;
infoLedgerPosting.ChequeDate = Convert.ToDateTime(txtCheckDate.Text);
infoLedgerPosting.ChequeNo = txtcheckNo.Text.Trim();
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
catch (Exception ex)
{
MessageBox.Show("PR10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save ledgerposting table
/// </summary>
/// <param name="decid"></param>
public void LedgerPosting(decimal decid)
{
try
{
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = Convert.ToDecimal(lblTotalAmount.Text.ToString());
infoLedgerPosting.VoucherTypeId = decMonthlyVoucherTypeId;
if (isAutomatic)
{
infoLedgerPosting.VoucherNo = strVoucherNo;
}
else
{
infoLedgerPosting.VoucherNo = txtVoucherNo.Text;
}
infoLedgerPosting.Date = Convert.ToDateTime(dtpVoucherDate.Value.ToString());
infoLedgerPosting.LedgerId = decid;
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.LedgerPostingAdd(infoLedgerPosting);
infoLedgerPosting.Debit = Convert.ToDecimal(lblTotalAmount.Text.ToString());
infoLedgerPosting.Credit = 0;
infoLedgerPosting.VoucherTypeId = decMonthlyVoucherTypeId;
if (isAutomatic)
{
infoLedgerPosting.VoucherNo = strVoucherNo;
}
else
{
infoLedgerPosting.VoucherNo = txtVoucherNo.Text;
}
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.LedgerId = 4; //ledgerId of salarys
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;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
catch (Exception ex)
{
MessageBox.Show("MSV4:" + 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();
ContraVoucherDetailsBll bllContraVoucherDetails = new ContraVoucherDetailsBll();
ContraDetailsInfo infoCOntraDetails = new ContraDetailsInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
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);
bllContraVoucherDetails.ContraDetailsDelete(Convert.ToDecimal(decId));
BllLedgerPosting.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 = BllExchangeRate.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());
bllContraVoucherDetails.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 = BllExchangeRate.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 = bllContraVoucherDetails.ContraDetailsAddReturnWithhIdentity(infoCOntraDetails);
LedgerPosting(decLedgerId, decCredit, decDebit, decContraDetailsId, i);
}
}
}
bllContraVoucherDetails.ContraMasterEdit(infoContraMaster);
decLedgerPostId = BllLedgerPosting.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 (BllSettings.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>
/// Grid Fill function while coming from other form to update or delete
/// </summary>
public void FillFunction()
{
try
{
//PaymentMasterSP SpPaymentMaster = new PaymentMasterSP();
PaymentMasterInfo InfoPaymentMaster = new PaymentMasterInfo();
//PaymentDetailsSP SpPaymentDetails = new PaymentDetailsSP();
PaymentVoucherBll BllPaymentVoucher = new PaymentVoucherBll();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
InfoPaymentMaster = BllPaymentVoucher.PaymentMasterViewByMasterId(decPaymentmasterId);//view master details
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(InfoPaymentMaster.VoucherTypeId);
if (isAutomatic)
{
txtVoucherNo.ReadOnly = true;
txtVoucherNo.Text = InfoPaymentMaster.InvoiceNo;
txtDate.Focus();
}
else
{
txtVoucherNo.ReadOnly = false;
txtVoucherNo.Text = InfoPaymentMaster.InvoiceNo;
txtVoucherNo.Focus();
}
dtpDate.Text = InfoPaymentMaster.Date.ToString();
cmbBankorCash.SelectedValue = InfoPaymentMaster.LedgerId;
txtNarration.Text = InfoPaymentMaster.Narration;
txtTotal.Text = InfoPaymentMaster.TotalAmount.ToString();
decDailySuffixPrefixId = InfoPaymentMaster.SuffixPrefixId;
decPaymentVoucherTypeId = InfoPaymentMaster.VoucherTypeId;
strVoucherNo = InfoPaymentMaster.VoucherNo;
strInvoiceNo = InfoPaymentMaster.InvoiceNo;
//DataTable dtbl = new DataTable();
List<DataTable> listObj1 = new List<DataTable>();
listObj1 = BllPaymentVoucher.PaymentDetailsViewByMasterId(decPaymentmasterId);//view details details
for (int inI = 0; inI < listObj1[0].Rows.Count; inI++)
{
dgvPaymentVoucher.Rows.Add();
dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value = Convert.ToDecimal(listObj1[0].Rows[inI]["ledgerId"].ToString());
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtpaymentMasterId"].Value = listObj1[0].Rows[inI]["paymentMasterId"].ToString();
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtpaymentDetailsId"].Value = listObj1[0].Rows[inI]["paymentDetailsId"].ToString();
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtAmount"].Value = listObj1[0].Rows[inI]["amount"].ToString();
dgvPaymentVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(listObj1[0].Rows[inI]["exchangeRateId"].ToString());
decimal decDetailsId1 = Convert.ToDecimal(listObj1[0].Rows[inI]["paymentDetailsId"].ToString());
decimal decLedgerPostingId = BllLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, decPaymentVoucherTypeId);
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString();
decimal decLedgerId = Convert.ToDecimal(listObj1[0].Rows[inI]["ledgerId"].ToString());
bool IsBankAccount = bllAccountGroup.AccountGroupwithLedgerId(decLedgerId);
decimal decI = Convert.ToDecimal(bllAccountLedger.AccountGroupIdCheck(dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].FormattedValue.ToString()));
if (decI > 0)//to make amount and currency read only when party is choosen as ledger
{
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtAmount"].ReadOnly = true;
dgvPaymentVoucher.Rows[inI].Cells["dgvcmbCurrency"].ReadOnly = true;
}
else
{
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtAmount"].ReadOnly = false;
dgvPaymentVoucher.Rows[inI].Cells["dgvcmbCurrency"].ReadOnly = false;
}
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value = listObj1[0].Rows[inI]["ChequeNo"].ToString();
if (dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value = Convert.ToDateTime(listObj1[0].Rows[inI]["ChequeDate"].ToString()).ToString("dd-MMM-yyyy");
}
dgvPaymentVoucher.Rows[inI].HeaderCell.Value = string.Empty;
}
List<DataTable> listObj = new List<DataTable>();
listObj = BllPartyBalance.PartyBalanceViewByVoucherNoAndVoucherType(decPaymentVoucherTypeId, strVoucherNo, InfoPaymentMaster.Date);
dtblPartyBalance = listObj[0];
}
catch (Exception ex)
{
MessageBox.Show("PV36:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Ledger Posting Edit
/// </summary>
public void MasterLedgerPostingEdit()
{
try
{
LedgerPostingInfo InfoLedgerPosting = new LedgerPostingInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
InfoLedgerPosting.Credit = Convert.ToDecimal(txtTotal.Text);
InfoLedgerPosting.Date = dtpDate.Value;
InfoLedgerPosting.Debit = 0;
InfoLedgerPosting.DetailsId = 0;
InfoLedgerPosting.Extra1 = string.Empty;
InfoLedgerPosting.Extra2 = string.Empty;
InfoLedgerPosting.InvoiceNo = strInvoiceNo;
InfoLedgerPosting.ChequeNo = string.Empty;
InfoLedgerPosting.ChequeDate = DateTime.Now;
InfoLedgerPosting.LedgerId = Convert.ToDecimal(cmbBankorCash.SelectedValue.ToString());
if (!isAutomatic)
{
InfoLedgerPosting.VoucherNo = txtVoucherNo.Text.Trim();
}
else
{
InfoLedgerPosting.VoucherNo = strVoucherNo;
}
InfoLedgerPosting.VoucherTypeId = decPaymentVoucherTypeId;
InfoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
BllLedgerPosting.LedgerPostingEditByVoucherTypeAndVoucherNo(InfoLedgerPosting);
}
catch (Exception ex)
{
MessageBox.Show("PV22:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the fields for edit or delete
/// </summary>
public void FillFunction()
{
try
{
JournalMasterInfo infoJournalMaster = new JournalMasterInfo();
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
infoJournalMaster = bllJournalMaster.JournalMasterView(decJournalMasterIdForEdit);
VoucherTypeInfo infoVoucherType = new VoucherTypeInfo();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
infoVoucherType = BllVoucherType.VoucherTypeView(infoJournalMaster.VoucherTypeId);
this.Text = infoVoucherType.VoucherTypeName;
txtVoucherNo.ReadOnly = false;
strVoucherNo = infoJournalMaster.VoucherNo;
strInvoiceNo = infoJournalMaster.InvoiceNo;
txtVoucherNo.Text = strInvoiceNo;
decJournalSuffixPrefixId = infoJournalMaster.SuffixPrefixId;
decJournalVoucherTypeId = infoJournalMaster.VoucherTypeId;
dtpVoucherDate.Value = infoJournalMaster.Date;
txtNarration.Text = infoJournalMaster.Narration;
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(decJournalVoucherTypeId);
if (isAutomatic)
{
txtVoucherNo.ReadOnly = true;
}
else
{
txtVoucherNo.ReadOnly = false;
}
//GridFill
List<DataTable> ListObj = new List<DataTable>();
JournalVoucherBll bllJournalDetailsSp = new JournalVoucherBll();
ListObj = bllJournalDetailsSp.JournalDetailsViewByMasterId(decJournalMasterIdForEdit);
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
for (int inI = 0; inI < ListObj[0].Rows.Count; inI++)
{
dgvJournalVoucher.Rows.Add();
dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value = Convert.ToDecimal(ListObj[0].Rows[inI]["ledgerId"].ToString());
if (Convert.ToDecimal(ListObj[0].Rows[inI]["debit"].ToString()) == 0)
{
dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value = "Cr";
dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[inI]["credit"].ToString());
}
else
{
dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value = "Dr";
dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(ListObj[0].Rows[inI]["debit"].ToString());
}
dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(ListObj[0].Rows[inI]["exchangeRateId"].ToString());
if (ListObj[0].Rows[inI]["chequeNo"].ToString() != string.Empty)
{
dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value = ListObj[0].Rows[inI]["chequeNo"].ToString();
dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value = (Convert.ToDateTime(ListObj[0].Rows[inI]["chequeDate"].ToString())).ToString("dd-MMM-yyyy");
}
dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value = ListObj[0].Rows[inI]["journalDetailsId"].ToString();
decimal decDetailsId1 = Convert.ToDecimal(ListObj[0].Rows[inI]["journalDetailsId"].ToString());
decimal decLedgerPostingId = BllLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, decJournalVoucherTypeId);
dgvJournalVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString();
btnSave.Text = "Update";
}
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
List<DataTable> listObj = new List<DataTable>();
listObj = BllPartyBalance.PartyBalanceViewByVoucherNoAndVoucherType(decJournalVoucherTypeId, strVoucherNo, infoJournalMaster.Date);
dtblPartyBalance = listObj[0];
dgvJournalVoucher.ClearSelection();
txtDate.Focus();
}
catch (Exception ex)
{
MessageBox.Show("JV37:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit the debitnote voucher
/// </summary>
/// <param name="decJournalMasterId"></param>
public void Edit(decimal decJournalMasterId)
{
try
{
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
JournalMasterInfo infoJournalMaster = new JournalMasterInfo();
JournalVoucherBll bllJournalDetails = new JournalVoucherBll();
JournalDetailsInfo infoJournalDetails = new JournalDetailsInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
/*****************Update in JournalMaster table *************/
decimal decTotalDebit = 0;
decimal decTotalCredit = 0;
infoJournalMaster.JournalMasterId = decJournalMasterId;
infoJournalMaster.VoucherNo = strVoucherNo;
infoJournalMaster.InvoiceNo = txtVoucherNo.Text.Trim();
infoJournalMaster.SuffixPrefixId = decJournalSuffixPrefixId;
infoJournalMaster.Date = Convert.ToDateTime(txtDate.Text);
infoJournalMaster.Narration = txtNarration.Text.Trim();
infoJournalMaster.UserId = PublicVariables._decCurrentUserId;
infoJournalMaster.VoucherTypeId = decJournalVoucherTypeId;
infoJournalMaster.FinancialYearId = Convert.ToDecimal(PublicVariables._decCurrentFinancialYearId.ToString());
infoJournalMaster.ExtraDate = DateTime.Now;
infoJournalMaster.Extra1 = string.Empty;
infoJournalMaster.Extra2 = string.Empty;
decTotalDebit = Convert.ToDecimal(txtDebitTotal.Text.Trim());
decTotalCredit = Convert.ToDecimal(txtCreditTotal.Text.Trim());
infoJournalMaster.TotalAmount = decTotalDebit;
decimal decEffectRow = bllJournalMaster.JournalMasterEdit(infoJournalMaster);
/**********************JournalDetails Edit********************/
if (decEffectRow > 0)
{
infoJournalDetails.JournalMasterId = decJournalMasterId;
infoJournalDetails.ExtraDate = DateTime.Now;
infoJournalDetails.Extra1 = string.Empty;
infoJournalDetails.Extra2 = string.Empty;
//-----------to delete details, LedgerPosting and bankReconciliation of removed rows--------------//
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
foreach (object obj in arrlstOfRemove)
{
string str = Convert.ToString(obj);
bllJournalDetails.JournalDetailsDelete(Convert.ToDecimal(str));
BllLedgerPosting.LedgerPostDeleteByDetailsId(Convert.ToDecimal(str), strVoucherNo, decJournalVoucherTypeId);
}
BllLedgerPosting.LedgerPostingDeleteByVoucherNoVoucherTypeIdAndLedgerId(strVoucherNo, decJournalVoucherTypeId, 12);
//=============================================================================================//
decimal decLedgerId = 0;
decimal decDebit = 0;
decimal decCredit = 0;
decimal decJournalDetailsId = 0;
int inRowCount = dgvJournalVoucher.RowCount;
for (int inI = 0; inI < inRowCount; inI++)
{
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
infoJournalDetails.LedgerId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
decLedgerId = infoJournalDetails.LedgerId;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() != string.Empty)
{
//------------------Currency conversion------------------//
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value));
decAmount = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
//======================================================//
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() == "Dr")
{
infoJournalDetails.Debit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Credit = 0;
decDebit = decConvertRate;
decCredit = infoJournalDetails.Credit;
}
else
{
infoJournalDetails.Credit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Debit = 0;
decDebit = infoJournalDetails.Debit;
decCredit = decConvertRate;
}
infoJournalDetails.ExchangeRateId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString());
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeNo = dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoJournalDetails.ChequeNo = string.Empty;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeDate = Convert.ToDateTime(dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
infoJournalDetails.ChequeDate = DateTime.Now;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString() != string.Empty)
{
infoJournalDetails.JournalDetailsId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString());
bllJournalDetails.JournalDetailsEdit(infoJournalDetails);
PartyBalanceAddOrEdit(inI);
decJournalDetailsId = infoJournalDetails.JournalDetailsId;
decimal decLedgerPostId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value.ToString());
LedgerPostingEdit(decLedgerPostId, decLedgerId, decCredit, decDebit, decJournalDetailsId, inI);
}
else
{
decJournalDetailsId = bllJournalDetails.JournalDetailsAdd(infoJournalDetails);
PartyBalanceAddOrEdit(inI);
LedgerPosting(decLedgerId, decCredit, decDebit, decJournalDetailsId, inI);
}
}
}
DeletePartyBalanceOfRemovedRow();
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(infoJournalMaster.JournalMasterId);
}
else
{
Print(infoJournalMaster.JournalMasterId);
}
}
if (journalRegisterObj != null)
{
this.Close();
journalRegisterObj.Enabled = true;
}
else if (frmJournalReportObj != null)
{
this.Close();
frmJournalReportObj.Enabled = true;
}
else if (frmDayBookObj != null)
{
this.Close();
}
else if (frmBillallocationObj != null)
{
this.Close();
}
}
//----------------If print after save is enable-----------------------//
//===================================================================//
}
catch (Exception ex)
{
MessageBox.Show("JV16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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 save values to ledgerposting table
/// </summary>
public void ledgerPosting()
{
try
{
string strfinancialId;
decOpeningBlnc = Convert.ToDecimal(txtOpeningBalance.Text);
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
FinancialYearBll BllFinancialYear = new FinancialYearBll();
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
infoFinancialYear = BllFinancialYear.FinancialYearViewForAccountLedger(1);
strfinancialId = infoFinancialYear.FromDate.ToString("dd-MMM-yyyy");
if (cmbDrorCr.Text == "Dr")
{
infoLedgerPosting.Debit = decOpeningBlnc;
}
else
{
infoLedgerPosting.Credit = decOpeningBlnc;
}
infoLedgerPosting.VoucherTypeId = 1;
infoLedgerPosting.VoucherNo = decledgerid.ToString();
infoLedgerPosting.Date = Convert.ToDateTime(strfinancialId.ToString());
infoLedgerPosting.LedgerId = decledgerid;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = decledgerid.ToString();
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
catch (Exception ex)
{
MessageBox.Show("Cus14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Delete
/// </summary>
public void Delete()
{
try
{
StockPostingBll BllStockPosting=new StockPostingBll();
// StockPostingSP spStockPosting = new StockPostingSP();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
PurchaseInvoiceBll BllPurchaseInvoice = new PurchaseInvoiceBll();
PurchaseReturnBll BllPurchaseReturn = new PurchaseReturnBll();
PurchaseMasterInfo infoPurchaseMaster = new PurchaseMasterInfo();
PurchaseReturnMasterInfo infoPurchaseReturnMaster = new PurchaseReturnMasterInfo();
infoPurchaseReturnMaster = BllPurchaseReturn.PurchaseReturnMasterView(decPurchaseReturnMasterId);
if (infoPurchaseReturnMaster.PurchaseMasterId == 0)
{
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(0, "NA", infoPurchaseReturnMaster.VoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
if (infoPurchaseReturnMaster.PurchaseMasterId != 0)
{
infoPurchaseMaster = BllPurchaseInvoice.PurchaseMasterView(infoPurchaseReturnMaster.PurchaseMasterId);
BllStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(infoPurchaseMaster.VoucherTypeId, infoPurchaseMaster.VoucherNo, strVoucherNo, infoPurchaseReturnMaster.VoucherTypeId);
}
BllLedgerPosting.LedgerPostingAndPartyBalanceDeleteByVoucherTypeIdAndLedgerIdAndVoucherNo(decPurchaseReturnVoucherTypeId, strVoucherNo, txtReturnNo.Text);
BllPurchaseReturn.PurchaseReturnMasterAndDetailsDelete(decPurchaseReturnMasterId);
Messages.DeletedMessage();
if (frmPurchaseReturnRegisterObj != null)
{
this.Close();
frmPurchaseReturnRegisterObj.GridFill();
}
if (ObjPurchaseReturnReport != null)
{
this.Close();
ObjPurchaseReturnReport.PurchaseReturnReportGridFill();
}
if (frmLedgerDetailsObj != null)
{
this.Close();
frmLedgerDetailsObj.LedgerDetailsView();
}
if (objVoucherSearch != null)
{
this.Close();
objVoucherSearch.GridFill();
}
if (frmDayBookObj != null)
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("PR:50 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for delete
/// </summary>
public void DeleteFunction()
{
try
{
SalaryVoucherBll BllSalaryVoucher = new SalaryVoucherBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
BllSalaryVoucher.SalaryVoucherMasterDelete(decIsEditModeMasterId);
BllSalaryVoucher.SalaryVoucherDetailsDeleteUsingMasterId(decIsEditModeMasterId);
BllLedgerPosting.LedgerPostDelete(txtVoucherNo.Text, decMonthlyVoucherTypeId);
Messages.DeletedMessage();
Clear();
GridFill(isEditMode);
}
catch (Exception ex)
{
MessageBox.Show("MSV16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Details ledger posting edit
/// </summary>
/// <param name="inA"></param>
/// <param name="decLedgerPostingId"></param>
/// <param name="decPaymentDetailsId"></param>
public void DetailsLedgerPostingEdit(int inA, decimal decLedgerPostingId, decimal decPaymentDetailsId)
{
LedgerPostingInfo InfoLedgerPosting = new LedgerPostingInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
decimal decOldExchange = 0;
decimal decNewExchangeRate = 0;
decimal decNewExchangeRateId = 0;
decimal decOldExchangeId = 0;
try
{
if (!dgvPaymentVoucher.Rows[inA].Cells["dgvtxtAmount"].ReadOnly)
{
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvPaymentVoucher.Rows[inA].Cells["dgvcmbCurrency"].Value.ToString()));
decAmount = Convert.ToDecimal(dgvPaymentVoucher.Rows[inA].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
InfoLedgerPosting.Credit = 0;
InfoLedgerPosting.Date = dtpDate.Value;
InfoLedgerPosting.Debit = decConvertRate;
InfoLedgerPosting.DetailsId = decPaymentDetailsId;
InfoLedgerPosting.Extra1 = string.Empty;
InfoLedgerPosting.Extra2 = string.Empty;
InfoLedgerPosting.InvoiceNo = strInvoiceNo;
InfoLedgerPosting.LedgerId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inA].Cells["dgvcmbAccountLedger"].Value.ToString());
if (!isAutomatic)
{
InfoLedgerPosting.VoucherNo = txtVoucherNo.Text.Trim();
}
else
{
InfoLedgerPosting.VoucherNo = strVoucherNo;
}
if (dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeNo"].Value != null && dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
InfoLedgerPosting.ChequeNo = dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeNo"].Value.ToString();
if (dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeDate"].Value != null && dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
InfoLedgerPosting.ChequeDate = Convert.ToDateTime(dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
InfoLedgerPosting.ChequeDate = DateTime.Now;
}
else
{
InfoLedgerPosting.ChequeNo = string.Empty;
InfoLedgerPosting.ChequeDate = DateTime.Now;
}
InfoLedgerPosting.VoucherTypeId = decPaymentVoucherTypeId;
InfoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
InfoLedgerPosting.LedgerPostingId = decLedgerPostingId;
BllLedgerPosting.LedgerPostingEdit(InfoLedgerPosting);
}
else
{
InfoLedgerPosting.Date = dtpDate.Value;
InfoLedgerPosting.Extra1 = string.Empty;
InfoLedgerPosting.Extra2 = string.Empty;
InfoLedgerPosting.InvoiceNo = strInvoiceNo;
InfoLedgerPosting.VoucherTypeId = decPaymentVoucherTypeId;
InfoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
InfoLedgerPosting.Credit = 0;
InfoLedgerPosting.LedgerId = Convert.ToDecimal(dgvPaymentVoucher.Rows[inA].Cells["dgvcmbAccountLedger"].Value.ToString());
InfoLedgerPosting.VoucherNo = strVoucherNo;
InfoLedgerPosting.DetailsId = decPaymentDetailsId;
InfoLedgerPosting.InvoiceNo = txtVoucherNo.Text.Trim();
if (dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeNo"].Value != null && dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
InfoLedgerPosting.ChequeNo = dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeNo"].Value.ToString();
if (dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeDate"].Value != null && dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
InfoLedgerPosting.ChequeDate = Convert.ToDateTime(dgvPaymentVoucher.Rows[inA].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
InfoLedgerPosting.ChequeDate = DateTime.Now;
}
else
{
InfoLedgerPosting.ChequeNo = string.Empty;
InfoLedgerPosting.ChequeDate = DateTime.Now;
}
foreach (DataRow dr in dtblPartyBalance.Rows)
{
if (InfoLedgerPosting.LedgerId == Convert.ToDecimal(dr["LedgerId"].ToString()))
{
decOldExchange = Convert.ToDecimal(dr["OldExchangeRate"].ToString());
decNewExchangeRateId = Convert.ToDecimal(dr["CurrencyId"].ToString());
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(decOldExchange);
decAmount = Convert.ToDecimal(dr["Amount"].ToString());
decConvertRate = decConvertRate + (decAmount * decSelectedCurrencyRate);
}
}
InfoLedgerPosting.Debit = decConvertRate;
InfoLedgerPosting.LedgerPostingId = decLedgerPostingId;
BllLedgerPosting.LedgerPostingEdit(InfoLedgerPosting);
InfoLedgerPosting.LedgerId = 12;
foreach (DataRow dr in dtblPartyBalance.Rows)
{
if (Convert.ToDecimal(dgvPaymentVoucher.Rows[inA].Cells["dgvcmbAccountLedger"].Value.ToString()) == Convert.ToDecimal(dr["LedgerId"].ToString()))
{
if (dr["ReferenceType"].ToString() == "Against")
{
decNewExchangeRateId = Convert.ToDecimal(dr["CurrencyId"].ToString());
decNewExchangeRate = BllExchangeRate.GetExchangeRateByExchangeRateId(decNewExchangeRateId);
decOldExchangeId = Convert.ToDecimal(dr["OldExchangeRate"].ToString());
decOldExchange = BllExchangeRate.GetExchangeRateByExchangeRateId(decOldExchangeId);
decAmount = Convert.ToDecimal(dr["Amount"].ToString());
decimal decForexAmount = (decAmount * decNewExchangeRate) - (decAmount * decOldExchange);
if (decForexAmount >= 0)
{
InfoLedgerPosting.Debit = decForexAmount;
InfoLedgerPosting.Credit = 0;
}
else
{
InfoLedgerPosting.Credit = -1 * decForexAmount;
InfoLedgerPosting.Debit = 0;
}
BllLedgerPosting.LedgerPostingAdd(InfoLedgerPosting);
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PV24:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for edit
/// </summary>
public void EditFunction()
{
try
{
SalaryVoucherMasterInfo infoMaster = new SalaryVoucherMasterInfo();
SalaryVoucherBll BllSalaryVoucher = new SalaryVoucherBll();
SalaryVoucherDetailsInfo infoDetails = new SalaryVoucherDetailsInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
infoMaster.SalaryVoucherMasterId = decIsEditModeMasterId;
infoMaster.Date = Convert.ToDateTime(dtpVoucherDate.Value.ToString());
infoMaster.LedgerId = Convert.ToDecimal(cmbCashOrBankAcc.SelectedValue.ToString());
infoMaster.Narration = txtNarration.Text.Trim();
infoMaster.TotalAmount = Convert.ToDecimal(lblTotalAmount.Text.ToString());
if (isAutomatic)
{
infoMaster.VoucherNo = strVoucherNo;
}
else
{
infoMaster.VoucherNo = txtVoucherNo.Text;
}
if (isAutomatic)
{
infoMaster.InvoiceNo = strInvoiceNo;
}
else
{
infoMaster.InvoiceNo = txtVoucherNo.Text;
}
infoMaster.Extra1 = string.Empty;
infoMaster.Extra2 = string.Empty;
infoMaster.SuffixPrefixId = decMonthlySuffixPrefixId;
infoMaster.VoucherTypeId = decMonthlyVoucherTypeId;
infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoMaster.Month = Convert.ToDateTime(dtpMonth.Text.ToString());
infoDetails.Extra1 = string.Empty;
infoDetails.Extra2 = string.Empty;
int inRowCount = dgvMonthlySalary.RowCount;
for (int i = 0; i < inRowCount; i++)
{
if (dgvMonthlySalary.Rows[i].Cells["txtEmployeeId"].Value != null && dgvMonthlySalary.Rows[i].Cells["txtEmployeeId"].Value.ToString() != string.Empty)
{
infoDetails.EmployeeId = Convert.ToDecimal(dgvMonthlySalary.Rows[i].Cells["txtEmployeeId"].Value.ToString());
}
if (dgvMonthlySalary.Rows[i].Cells["txtBonus"].Value != null && dgvMonthlySalary.Rows[i].Cells["txtBonus"].Value.ToString() != string.Empty)
{
infoDetails.Bonus = Convert.ToDecimal(dgvMonthlySalary.Rows[i].Cells["txtBonus"].Value.ToString());
}
if (dgvMonthlySalary.Rows[i].Cells["txtDeduction"].Value != null && dgvMonthlySalary.Rows[i].Cells["txtDeduction"].Value.ToString() != string.Empty)
{
infoDetails.Deduction = Convert.ToDecimal(dgvMonthlySalary.Rows[i].Cells["txtDeduction"].Value.ToString());
}
if (dgvMonthlySalary.Rows[i].Cells["txtAdvance"].Value != null && dgvMonthlySalary.Rows[i].Cells["txtAdvance"].Value.ToString() != string.Empty)
{
infoDetails.Advance = Convert.ToDecimal(dgvMonthlySalary.Rows[i].Cells["txtAdvance"].Value.ToString());
}
if (dgvMonthlySalary.Rows[i].Cells["txtLop"].Value != null && dgvMonthlySalary.Rows[i].Cells["txtLop"].Value.ToString() != string.Empty)
{
infoDetails.Lop = Convert.ToDecimal(dgvMonthlySalary.Rows[i].Cells["txtLop"].Value.ToString());
}
if (dgvMonthlySalary.Rows[i].Cells["txtSalary"].Value != null && dgvMonthlySalary.Rows[i].Cells["txtSalary"].Value.ToString() != string.Empty)
{
infoDetails.Salary = Convert.ToDecimal(dgvMonthlySalary.Rows[i].Cells["txtSalary"].Value.ToString());
}
if (dgvMonthlySalary.Rows[i].Cells["cmbStatus"].Value != null && dgvMonthlySalary.Rows[i].Cells["cmbStatus"].Value.ToString() != string.Empty)
{
infoDetails.Status = dgvMonthlySalary.Rows[i].Cells["cmbStatus"].Value.ToString();
}
if (dgvMonthlySalary.Rows[i].Cells["cmbStatus"].Value.ToString() == string.Empty && dgvMonthlySalary.Rows[i].Cells["txtMasterId"].Value.ToString() != "0")
{
decimal SalaryVoucherDetailsId = Convert.ToDecimal(dgvMonthlySalary.Rows[i].Cells["txtDetailsId"].Value.ToString());
BllSalaryVoucher.SalaryVoucherDetailsDelete(SalaryVoucherDetailsId);
BllSalaryVoucher.SalaryVoucherMasterEdit(infoMaster);
LedgerUpdate();
}
if (dgvMonthlySalary.Rows[i].Cells["cmbStatus"].Value.ToString() == "Paid" && dgvMonthlySalary.Rows[i].Cells["txtMasterId"].Value.ToString() == "0")
{
infoDetails.SalaryVoucherMasterId = decIsEditModeMasterId;
BllSalaryVoucher.MonthlySalaryVoucherDetailsAdd(infoDetails);
BllSalaryVoucher.SalaryVoucherMasterEdit(infoMaster);
LedgerUpdate();
}
if (dgvMonthlySalary.Rows[i].Cells["cmbStatus"].Value.ToString() == string.Empty && dgvMonthlySalary.Rows[i].Cells["txtMasterId"].Value.ToString() == "0")
{
BllSalaryVoucher.SalaryVoucherMasterEdit(infoMaster);
LedgerUpdate();
}
}
if (BllSalaryVoucher.SalaryVoucherDetailsCount(decIsEditModeMasterId) == 0)
{
BllSalaryVoucher.SalaryVoucherMasterDelete(decIsEditModeMasterId);
}
Messages.UpdatedMessage();
GridFill(isEditMode);
if (frmMonthlySalaryRegisterObj != null)
{
this.Close();
}
if (frmLedgerDetailsObj != null)
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("MSV8:" + 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>
/// 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>
/// Edit Function
/// </summary>
public void EditFunction()
{
try
{
removeSalesInvoiceDetails();
SalesInvoiceBll BllSalesInvoice = new SalesInvoiceBll();
SalesMasterInfo InfoSalesMaster = new SalesMasterInfo();
InfoSalesMaster = BllSalesInvoice.SalesMasterView(decSalesInvoiceIdToEdit);
if (InfoSalesMaster.DeliveryNoteMasterId != 0)
{
DeliveryNoteMasterInfo infoDeliveryNote = new DeliveryNoteMasterInfo();
infoDeliveryNote = new DeliveryNoteBll().DeliveryNoteMasterView(InfoSalesMaster.DeliveryNoteMasterId);
new StockPostingBll().StockPostingDeleteForSalesInvoiceAgainstDeliveryNote
(InfoSalesMaster.VoucherTypeId, InfoSalesMaster.VoucherNo,
infoDeliveryNote.VoucherNo, infoDeliveryNote.VoucherTypeId);
}
new StockPostingBll().StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType
(0, "NA", InfoSalesMaster.VoucherNo, InfoSalesMaster.VoucherTypeId);
InfoSalesMaster.SalesMasterId = decSalesInvoiceIdToEdit;
InfoSalesMaster.AdditionalCost = Convert.ToDecimal(lblLedgerTotalAmount.Text);
InfoSalesMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text.Trim());
InfoSalesMaster.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text.Trim().ToString());
InfoSalesMaster.CustomerName = txtCustomer.Text.Trim();
InfoSalesMaster.Date = Convert.ToDateTime(txtDate.Text.ToString());
InfoSalesMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
InfoSalesMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
InfoSalesMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoSalesMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim());
InfoSalesMaster.InvoiceNo = txtInvoiceNo.Text.Trim();
InfoSalesMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
InfoSalesMaster.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
InfoSalesMaster.VoucherNo = strVoucherNo;
if (isAutomatic)
{
InfoSalesMaster.SuffixPrefixId = decSalseInvoiceSuffixPrefixId;
}
else
{
InfoSalesMaster.SuffixPrefixId = 0;
}
if (cmbSalesMode.Text == "Against SalesOrder")
{
InfoSalesMaster.OrderMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.OrderMasterId = 0;
}
if (cmbSalesMode.Text == "Against Delivery Note")
{
InfoSalesMaster.DeliveryNoteMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.DeliveryNoteMasterId = 0;
}
if (cmbSalesMode.Text == "Against Quotation")
{
InfoSalesMaster.QuotationMasterId = Convert.ToDecimal(cmbSalesModeOrderNo.SelectedValue.ToString());
}
else
{
InfoSalesMaster.QuotationMasterId = 0;
}
InfoSalesMaster.Narration = txtNarration.Text.Trim();
InfoSalesMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
InfoSalesMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
InfoSalesMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text.Trim());
if (dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible)
{
InfoSalesMaster.TaxAmount = Convert.ToDecimal(lblTaxTotalAmount.Text.Trim());
}
else
{
InfoSalesMaster.TaxAmount = 0;
}
InfoSalesMaster.UserId = PublicVariables._decCurrentUserId;
InfoSalesMaster.LrNo = txtVehicleNo.Text;
InfoSalesMaster.TransportationCompany = txtTransportCompany.Text.Trim();
InfoSalesMaster.POS = false;
InfoSalesMaster.CounterId = 0;
InfoSalesMaster.ExtraDate = DateTime.Now;
InfoSalesMaster.Extra1 = string.Empty;
InfoSalesMaster.Extra2 = string.Empty;
BllSalesInvoice.SalesMasterEdit(InfoSalesMaster);
removeSalesInvoiceDetails();
SalesInvoiceDetailsEditFill();
if (cmbCashOrParty.Enabled)
{
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
BllLedgerPosting.LedgerPostDelete(strVoucherNo, DecSalesInvoiceVoucherTypeId);
ledgerPostingAdd();
}
else
{
ledgerPostingEdit();
}
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
SettingsBll BllSettings = new SettingsBll();
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesInvoiceIdToEdit);
}
else
{
Print(decSalesInvoiceIdToEdit);
}
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("SI: 78" + 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
{
ContraVoucherDetailsBll bllContraVoucherDetails = new ContraVoucherDetailsBll();
ContraMasterInfo infoContraMaster = new ContraMasterInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
VoucherTypeBll BllVOucherType = new VoucherTypeBll();
infoContraMaster = bllContraVoucherDetails.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 = BllVOucherType.CheckMethodOfVoucherNumbering(DecContraVoucherTypeId);
if (isAutomatic)
{
txtVoucherNo.Enabled = false;
}
else
{
txtVoucherNo.Enabled = true;
}
List<DataTable> listObj = new List<DataTable>();
listObj = bllContraVoucherDetails.ContraDetailsViewWithMasterId(decMasterId);
for (int i = 0; i < listObj[0].Rows.Count; i++)
{
dgvContraVoucher.Rows.Add();
dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value = Convert.ToDecimal(listObj[0].Rows[i]["ledgerId"].ToString());
dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(listObj[0].Rows[i]["exchangeRateId"].ToString());
dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(listObj[0].Rows[i]["amount"].ToString());
if (listObj[0].Rows[i]["chequeNo"].ToString() != string.Empty)
{
dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value = listObj[0].Rows[i]["chequeNo"].ToString();
if (listObj[0].Rows[i]["chequeDate"].ToString() == "01 Jan 1753")
{
dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value = null;
}
else
{
dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value = listObj[0].Rows[i]["chequeDate"].ToString();
}
}
dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value = listObj[0].Rows[i]["contraDetailsId"].ToString();
decimal decDetailsId1 = Convert.ToDecimal(listObj[0].Rows[i]["contraDetailsId"].ToString());
decimal decLedgerPostingId = BllLedgerPosting.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>
/// Ledger posting edit function
/// </summary>
public void ledgerPostingEdit()
{
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
SalesMasterInfo InfoSalesMaster = new SalesMasterInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
decimal decRate = 0;
decimal decimalGrantTotal = 0;
decimal decTotalAmount = 0;
try
{
decimalGrantTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim());
decRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decimalGrantTotal = decimalGrantTotal * decRate;
infoLedgerPosting.Debit = decimalGrantTotal;
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Date = Convert.ToDateTime(txtDate.Text.ToString());
infoLedgerPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtInvoiceNo.Text.Trim();
infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEditByVoucherTypeAndVoucherNoAndLedgerId(infoLedgerPosting);
decTotalAmount = TotalNetAmountForLedgerPosting();
decRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decTotalAmount = decTotalAmount * decRate;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = decTotalAmount;
infoLedgerPosting.Date = Convert.ToDateTime(txtDate.Text.ToString());
infoLedgerPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtInvoiceNo.Text.Trim();
infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEditByVoucherTypeAndVoucherNoAndLedgerId(infoLedgerPosting);
decimal decBillDis = 0;
decBillDis = Convert.ToDecimal(txtBillDiscount.Text.Trim().ToString());
decRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decBillDis = decBillDis * decRate;
if (decBillDis > 0)
{
infoLedgerPosting.Debit = decBillDis;
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Date = Convert.ToDateTime(txtDate.Text.ToString());
infoLedgerPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtInvoiceNo.Text.Trim();
infoLedgerPosting.LedgerId = 8;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEditByVoucherTypeAndVoucherNoAndLedgerId(infoLedgerPosting);
}
if (dgvSalesInvoice.Columns["dgvcmbSalesInvoiceTaxName"].Visible)
{
foreach (DataGridViewRow dgvrow in dgvSalesInvoiceTax.Rows)
{
if (dgvrow.Cells["dgvtxtTtaxId"].Value != null && dgvrow.Cells["dgvtxtTtaxId"].Value.ToString() != string.Empty)
{
decimal decTaxAmount = 0;
decTaxAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtTtaxAmount"].Value.ToString());
decRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decTaxAmount = decTaxAmount * decRate;
if (decTaxAmount > 0)
{
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = decTaxAmount;
infoLedgerPosting.Date = Convert.ToDateTime(txtDate.Text.ToString());
infoLedgerPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtInvoiceNo.Text.Trim();
infoLedgerPosting.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvtxtTaxLedgerId"].Value.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEditByVoucherTypeAndVoucherNoAndLedgerId(infoLedgerPosting);
}
}
}
}
if (cmbDrorCr.SelectedItem.ToString() != "Cr")
{
foreach (DataGridViewRow dgvrow in dgvSalesInvoiceLedger.Rows)
{
if (dgvrow.Cells["dgvCmbAdditionalCostledgerName"].Value != null && dgvrow.Cells["dgvCmbAdditionalCostledgerName"].Value.ToString() != string.Empty)
{
decimal decAmount = 0;
decAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtAdditionalCoastledgerAmount"].Value.ToString());
decRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decAmount = decAmount * decRate;
if (decAmount > 0)
{
infoLedgerPosting.Debit = decAmount;
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Date = Convert.ToDateTime(txtDate.Text.ToString());
infoLedgerPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtInvoiceNo.Text.Trim();
infoLedgerPosting.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvCmbAdditionalCostledgerName"].Value.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEditByVoucherTypeAndVoucherNoAndLedgerId(infoLedgerPosting);
}
}
}
if (cmbCashOrbank.Visible)
{
decimal decBankOrCashId = 0;
decimal decAmountForCr = 0;
decBankOrCashId = Convert.ToDecimal(cmbCashOrbank.SelectedValue.ToString());
decAmountForCr = Convert.ToDecimal(lblLedgerTotalAmount.Text.ToString());
decRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decAmountForCr = decAmountForCr * decRate;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = decAmountForCr;
infoLedgerPosting.Date = Convert.ToDateTime(txtDate.Text.ToString());
infoLedgerPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtInvoiceNo.Text.Trim();
infoLedgerPosting.LedgerId = decBankOrCashId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = "AddCash";
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
else
{
decimal decBankOrCashId = 0;
decimal decAmountForCr = 0;
decBankOrCashId = Convert.ToDecimal(cmbCashOrbank.SelectedValue.ToString());
decAmountForCr = Convert.ToDecimal(lblLedgerTotalAmount.Text.ToString());
decRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decAmountForCr = decAmountForCr * decRate;
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = decAmountForCr;
infoLedgerPosting.Date = Convert.ToDateTime(txtDate.Text.ToString());
infoLedgerPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtInvoiceNo.Text.Trim();
infoLedgerPosting.LedgerId = decBankOrCashId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = "AddCash";
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEditByVoucherTypeAndVoucherNoAndLedgerId(infoLedgerPosting);
}
}
else
{
string strVno = string.Empty;
strVno = infoLedgerPosting.VoucherNo;
BllLedgerPosting.LedgerPostingDeleteByVoucherTypeIdAndLedgerIdAndVoucherNoAndExtra(DecSalesInvoiceVoucherTypeId, decBankOrCashIdForEdit, strVno, "AddCash");
foreach (DataGridViewRow dgvrow in dgvSalesInvoiceLedger.Rows)
{
if (dgvrow.Cells["dgvCmbAdditionalCostledgerName"].Value != null && dgvrow.Cells["dgvCmbAdditionalCostledgerName"].Value.ToString() != string.Empty)
{
decimal decAmount = 0;
decAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtAdditionalCoastledgerAmount"].Value.ToString());
decRate = BllExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
decAmount = decAmount * decRate;
if (decAmount > 0)
{
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Credit = decAmount;
infoLedgerPosting.Date = Convert.ToDateTime(txtDate.Text.ToString());
infoLedgerPosting.VoucherTypeId = DecSalesInvoiceVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.InvoiceNo = txtInvoiceNo.Text.Trim();
infoLedgerPosting.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvCmbAdditionalCostledgerName"].Value.ToString());
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingEditByVoucherTypeAndVoucherNoAndLedgerId(infoLedgerPosting);
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("SI: 82" + 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);
ObjotherdateValidation.DateValidationFunction(txtCheckDate, false);
DataTable dtblMaster = new DataTable();
SettingsBll BllSettings = new SettingsBll();
PDCRecivebleBll BllPdcreceivable = new PDCRecivebleBll();
PDCReceivableMasterInfo InfopdcRecivable = new PDCReceivableMasterInfo();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
InfopdcRecivable.VoucherNo = strVoucherNo;
InfopdcRecivable.InvoiceNo = txtVoucherNo.Text.Trim();
InfopdcRecivable.Date = DateTime.Parse(txtVoucherDate.Text);
InfopdcRecivable.LedgerId = Convert.ToDecimal(cmbAccountLedger.SelectedValue.ToString());
InfopdcRecivable.Amount = decimal.Parse(txtAmount.Text);
InfopdcRecivable.Narration = txtNarration.Text;
if (txtcheckNo.Text != string.Empty)
InfopdcRecivable.ChequeNo = txtcheckNo.Text;
else
InfopdcRecivable.ChequeNo = string.Empty;
if (txtCheckDate.Text != string.Empty)
InfopdcRecivable.ChequeDate = Convert.ToDateTime(txtCheckDate.Text);
else
InfopdcRecivable.ChequeDate = DateTime.Now;
InfopdcRecivable.UserId = PublicVariables._decCurrentUserId;
InfopdcRecivable.VoucherTypeId = decPDCReceivableVoucherTypeId;
if (cmbBank.SelectedValue != null && cmbBank.SelectedValue.ToString() != string.Empty)
{
InfopdcRecivable.BankId = Convert.ToDecimal(cmbBank.SelectedValue.ToString());
}
else
InfopdcRecivable.BankId = 0;
InfopdcRecivable.ExtraDate = DateTime.Now;
InfopdcRecivable.Extra1 = string.Empty;
InfopdcRecivable.Extra2 = string.Empty;
if (!isInEditMode)
{
decimal decIdentity = BllPdcreceivable.PDCReceivableMasterAdd(InfopdcRecivable);
LedgerPosting();
PartyBalanceAddOrEdit();
Messages.SavedMessage();
if (cbxPrint.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decIdentity);
}
else
{
Print(decIdentity);
}
}
ClearFunction();
}
else
{
decimal decIdentity = decPDCReceivableEditId;
InfopdcRecivable.PdcReceivableMasterId = decPDCReceivableEditId;
BllPdcreceivable.PDCReceivableMasterEdit(InfopdcRecivable);
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
BllLedgerPosting.LedgerPostingDeleteByVoucherNoVoucherTypeIdAndLedgerId(strVoucherNo, decPDCReceivableVoucherTypeId, 12);
BllPartyBalance.PartyBalanceDeleteByVoucherTypeAndVoucherNo(decPDCReceivableVoucherTypeId, strVoucherNo);
PartyBalanceAddOrEdit();
LedgerPostingEdit(decPDCReceivableEditId);
Messages.UpdatedMessage();
if (cbxPrint.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decIdentity);
}
else
{
Print(decIdentity);
}
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("PR9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save An items to table
/// </summary>
public void SaveFunction()
{
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
UnitConvertionBll bllUnitConversion = new UnitConvertionBll();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
try
{
InfoSalesMaster.InvoiceNo = txtVoucherNo.Text.Trim();
InfoSalesMaster.AdditionalCost = 0;
InfoSalesMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
InfoSalesMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text);
if (cmbCounter.SelectedIndex > -1)
{
InfoSalesMaster.CounterId = Convert.ToDecimal(cmbCounter.SelectedValue.ToString());
}
else
{
InfoSalesMaster.CounterId = 0;
}
InfoSalesMaster.CreditPeriod = 0;
InfoSalesMaster.CustomerName = string.Empty;
InfoSalesMaster.Date = Convert.ToDateTime(txtDate.Text);
InfoSalesMaster.DeliveryNoteMasterId = 0;
if (cmbSalesMan.SelectedValue.ToString() != null)
{
InfoSalesMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
else
{
InfoSalesMaster.EmployeeId = 0;
}
decimal decExachangeRateId = BllExchangeRate.ExchangerateViewByCurrencyId(PublicVariables._decCurrencyId);
InfoSalesMaster.ExchangeRateId = decExachangeRateId;
InfoSalesMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoSalesMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim());
InfoSalesMaster.LrNo = string.Empty;
InfoSalesMaster.Narration = txtNarration.Text.Trim();
InfoSalesMaster.OrderMasterId = 0;
InfoSalesMaster.POS = true;
if (cmbPricingLevel.SelectedValue.ToString() != null)
{
InfoSalesMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
}
else
{
InfoSalesMaster.PricinglevelId = 0;
}
InfoSalesMaster.QuotationMasterId = 0;
InfoSalesMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
InfoSalesMaster.TaxAmount = Convert.ToDecimal(lblTaxTotalAmount.Text.ToString());
InfoSalesMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
InfoSalesMaster.TransportationCompany = string.Empty;
InfoSalesMaster.UserId = PublicVariables._decCurrentUserId;
InfoSalesMaster.VoucherTypeId = DecPOSVoucherTypeId;
if (isAutomatic)
{
InfoSalesMaster.SuffixPrefixId = decPOSSuffixPrefixId;
InfoSalesMaster.VoucherNo = strVoucherNo;
}
else
{
InfoSalesMaster.SuffixPrefixId = 0;
InfoSalesMaster.VoucherNo = txtVoucherNo.Text;
}
InfoSalesMaster.ExtraDate = DateTime.Now;
InfoSalesMaster.Extra1 = string.Empty;
InfoSalesMaster.Extra2 = string.Empty;
decSalesMasterId = BllSalesInvoice.SalesMasterAdd(InfoSalesMaster);
int inRowCount = dgvPointOfSales.RowCount;
InfoSalesDetails.SalesMasterId = decSalesMasterId;
InfoSalesDetails.ExtraDate = DateTime.Now;
InfoSalesDetails.Extra1 = string.Empty;
InfoSalesDetails.Extra2 = string.Empty;
for (int inI = 0; inI < inRowCount; inI++)
{
if (dgvPointOfSales.Rows[inI].Cells["dgvtxtProductName"].Value != null && dgvPointOfSales.Rows[inI].Cells["dgvtxtProductName"].Value.ToString() != string.Empty)
{
if (dgvPointOfSales.Rows[inI].Cells["dgvtxtQuantity"].Value != null && dgvPointOfSales.Rows[inI].Cells["dgvtxtQuantity"].Value.ToString() != string.Empty)
{
InfoSalesDetails.SlNo = Convert.ToInt32(dgvPointOfSales.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
InfoSalesDetails.ProductId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtProductId"].Value.ToString());
InfoSalesDetails.Qty = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtQuantity"].Value.ToString());
InfoSalesDetails.Rate = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
InfoSalesDetails.UnitId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtUnitId"].Value.ToString());
InfoSalesDetails.UnitConversionId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtunitconversionId"].Value.ToString());
InfoSalesDetails.Discount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtDiscount"].Value.ToString());
InfoSalesDetails.TaxId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxttaxid"].Value.ToString());
InfoSalesDetails.BatchId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtBatchId"].Value.ToString());
InfoSalesDetails.GodownId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtGodownId"].Value.ToString());
InfoSalesDetails.RackId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtRackId"].Value.ToString());
InfoSalesDetails.TaxAmount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtTaxAmount"].Value.ToString());
InfoSalesDetails.GrossAmount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtGrossValue"].Value.ToString());
InfoSalesDetails.NetAmount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtNetAmount"].Value.ToString());
InfoSalesDetails.Amount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtTotalAmount"].Value.ToString());
BllSalesInvoice.SalesDetailsAdd(InfoSalesDetails);
infoStockPosting.Date = InfoSalesMaster.Date;
infoStockPosting.VoucherTypeId = DecPOSVoucherTypeId;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.InvoiceNo = txtVoucherNo.Text.Trim();
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.ProductId = InfoSalesDetails.ProductId;
infoStockPosting.BatchId = InfoSalesDetails.BatchId;
infoStockPosting.UnitId = InfoSalesDetails.UnitId;
infoStockPosting.GodownId = InfoSalesDetails.GodownId;
infoStockPosting.RackId = InfoSalesDetails.RackId;
infoStockPosting.InwardQty = 0;
infoStockPosting.OutwardQty = InfoSalesDetails.Qty / bllUnitConversion.UnitConversionRateByUnitConversionId(InfoSalesDetails.UnitConversionId); ;
infoStockPosting.Rate = InfoSalesDetails.Rate;
infoStockPosting.FinancialYearId = InfoSalesMaster.FinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
BllStockPosting.StockPostingAdd(infoStockPosting);
}
}
}
int inTaxRowCount = dgvPOSTax.RowCount;
InfoSalesBillTax.SalesMasterId = decSalesMasterId;
InfoSalesBillTax.ExtraDate = DateTime.Now;
InfoSalesBillTax.Extra1 = string.Empty;
InfoSalesBillTax.Extra2 = string.Empty;
for (int inI = 0; inI < inTaxRowCount; inI++)
{
if (dgvPOSTax.Rows[inI].Cells["dgvtxttax"].Value != null && dgvPOSTax.Rows[inI].Cells["dgvtxttax"].Value.ToString() != string.Empty)
{
if (dgvPOSTax.Rows[inI].Cells["dgvtxtTaxAmt"].Value != null && dgvPOSTax.Rows[inI].Cells["dgvtxtTaxAmt"].Value.ToString() != string.Empty)
{
InfoSalesBillTax.TaxId = Convert.ToInt32(dgvPOSTax.Rows[inI].Cells["dgvtxttax"].Value.ToString());
InfoSalesBillTax.TaxAmount = Convert.ToDecimal(dgvPOSTax.Rows[inI].Cells["dgvtxtTaxAmt"].Value.ToString());
BllSalesInvoice.SalesBillTaxAdd(InfoSalesBillTax);
}
}
}
ledgerPostingAdd();
if (BllSalesInvoice.SalesInvoiceInvoicePartyCheckEnableBillByBillOrNot(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString())))
{
partyBalanceAdd();
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
SettingsBll BllSettings = new SettingsBll();
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesMasterId);
}
else
{
Print(decSalesMasterId);
}
}
ClearFunctions();
}
catch (Exception ex)
{
MessageBox.Show("POS:44" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save the service voucher
/// </summary>
public void SaveFunction()
{
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;
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)
{
txtDiscount.Enabled = true;
infoServiceMaster.InvoiceNo = txtInvoiceNumber.Text;
if (isAutomatic)
{
infoServiceMaster.VoucherNo = strVoucherNo;
}
else
{
infoServiceMaster.VoucherNo = Convert.ToString(BllService.ServiceMasterGetMax(DecServicetVoucherTypeId) + 1);
}
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.Trim());
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;
decServiceMasterId = BllService.ServiceMasterAddReturnWithIdentity(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());
decAmount += Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value);
}
decServiceDetailsId = BllService.ServiceDetailsAddReturnWithIdentity(infoServiceDetails);
}
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(infoServiceMaster.ExchangeRateId);
decConvertRate = decAmount * decSelectedCurrencyRate;
decCredit = 0;
decDebit = decConvertRate;
decLedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString());
LedgerPosting(decLedgerId, decCredit, decDebit, decServiceDetailsId, infoServiceMaster.VoucherNo);
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
decimal decI = Convert.ToDecimal(bllAccountLedger.AccountGroupIdCheck(cmbCashParty.Text));
if (decI > 0)
{
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
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.PartyBalanceAdd(infoPartyBalance);
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decServiceMasterId);
}
else
{
Print(decServiceMasterId, infoServiceMaster.ExchangeRateId);
}
}
Clear();
}
else
{
Messages.InformationMessage("Can't save Service Voucher without atleast one ledger with complete details");
dgvServiceVoucher.ClearSelection();
dgvServiceVoucher.CurrentCell = dgvServiceVoucher.Rows[0].Cells["dgvcmbParticulars"];
dgvServiceVoucher.Rows[0].Cells["dgvcmbParticulars"].Selected = true;
}
}
catch (Exception ex)
{
MessageBox.Show("SV 19 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Delete
/// </summary>
public void DeleteFunction()
{
try
{
DailySalaryVoucherBll BllDailySalaryVoucherMaster = new DailySalaryVoucherBll();
DailySalaryVoucherBll BllDailySalaryVoucher = new DailySalaryVoucherBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
if (PublicVariables.isMessageDelete)
{
if (Messages.DeleteMessage())
{
BllDailySalaryVoucherMaster.DailySalaryVoucherMasterDelete(decMasterIdforEdit);
BllDailySalaryVoucher.DailySalaryVoucherDetailsDeleteUsingMasterId(decMasterIdforEdit);
BllLedgerPosting.LedgerPostDelete(txtVoucherNo.Text, decDailyVoucherTypeId);
Messages.DeletedMessage();
Clear();
DailySalaryVoucherDetailsGridfill(isEditmode);
}
}
else
{
BllDailySalaryVoucherMaster.DailySalaryVoucherMasterDelete(decMasterIdforEdit);
BllDailySalaryVoucher.DailySalaryVoucherDetailsDeleteUsingMasterId(decMasterIdforEdit);
BllLedgerPosting.LedgerPostDelete(txtVoucherNo.Text, decDailyVoucherTypeId);
Messages.DeletedMessage();
Clear();
DailySalaryVoucherDetailsGridfill(isEditmode);
}
}
catch (Exception ex)
{
MessageBox.Show("DSV13:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the fields for edit or delete
/// </summary>
public void FillFunction()
{
try
{
ServicesBll BllService = new ServicesBll();
//ServiceMasterSP spServiceMaster = new ServiceMasterSP();
ServiceMasterInfo infoServiceMaster = new ServiceMasterInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
VoucherTypeInfo infoVoucherType = new VoucherTypeInfo();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
decServiceMasterId = decMasterId;
infoServiceMaster = BllService.ServiceMasterView(decServiceMasterId);
infoVoucherType = BllVoucherType.VoucherTypeView(infoServiceMaster.VoucherTypeId);
this.Text = infoVoucherType.VoucherTypeName;
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(infoServiceMaster.VoucherTypeId);
txtInvoiceNumber.ReadOnly = true;
strVoucherNo = infoServiceMaster.VoucherNo.ToString();
txtInvoiceNumber.Text = infoServiceMaster.InvoiceNo;
txtCreditPeriod.Text = infoServiceMaster.CreditPeriod.ToString();
strInvoiceNo = infoServiceMaster.InvoiceNo.ToString();
decServiceSuffixPrefixId = Convert.ToDecimal(infoServiceMaster.SuffixPrefixId.ToString());
DecServicetVoucherTypeId = Convert.ToDecimal(infoServiceMaster.VoucherTypeId.ToString());
int inDecimalPlace = PublicVariables._inNoOfDecimalPlaces;
txtVoucherDate.Text = infoServiceMaster.Date.ToString("dd-MMM-yyyy");
dtpVoucherDate.Value = Convert.ToDateTime(infoServiceMaster.Date);
cmbCashParty.SelectedValue = infoServiceMaster.LedgerId;
cmbServiceAC.SelectedValue = infoServiceMaster.ServiceAccount;
cmbSalesman.SelectedValue = infoServiceMaster.EmployeeId;
txtCustomer.Text = infoServiceMaster.Customer;
txtNarration.Text = infoServiceMaster.Narration;
List<DataTable> listObjServiceDetails = new List<DataTable>();
listObjServiceDetails = BllService.ServiceDetailsViewWithMasterId(decServiceMasterId);
for (int i = 0; i < listObjServiceDetails[0].Rows.Count; i++)
{
dgvServiceVoucher.Rows.Add();
dgvServiceVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value = Convert.ToDecimal(listObjServiceDetails[0].Rows[i]["serviceDetailsId"].ToString());
dgvServiceVoucher.Rows[i].Cells["dgvtxtServiceMasterId"].Value = Convert.ToDecimal(listObjServiceDetails[0].Rows[i]["serviceMasterId"].ToString());
dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value = Convert.ToDecimal(listObjServiceDetails[0].Rows[i]["serviceId"].ToString());
dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value = listObjServiceDetails[0].Rows[i]["measure"].ToString();
dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value = listObjServiceDetails[0].Rows[i]["amount"].ToString();
decimal decDetailsId1 = Convert.ToDecimal(listObjServiceDetails[0].Rows[i]["serviceDetailsId"].ToString());
decimal decLedgerPostingId = BllLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, DecServicetVoucherTypeId);
dgvServiceVoucher.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString();
}
cmbCurrency.SelectedValue = infoServiceMaster.ExchangeRateId;
txtTotalAmount.Text = infoServiceMaster.TotalAmount.ToString();
txtDiscount.Text = infoServiceMaster.Discount.ToString();
txtGrandTotal.Text = infoServiceMaster.GrandTotal.ToString();
infoPartyBalance = BllPartyBalance.PartyBalanceViewByVoucherNoAndVoucherTypeId(DecServicetVoucherTypeId, strVoucherNo, infoServiceMaster.Date);
decPartyBalanceId = infoPartyBalance.PartyBalanceId;
}
catch (Exception ex)
{
MessageBox.Show("SV 32 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Edit
/// </summary>
public void EditFunction()
{
try
{
DailySalaryVoucherMasterInfo infoMaster = new DailySalaryVoucherMasterInfo();
DailySalaryVoucherBll BllDailySalaryVoucherMaster = new DailySalaryVoucherBll();
DailySalaryVoucherDetailsInfo infoDetails = new DailySalaryVoucherDetailsInfo();
DailySalaryVoucherBll BllDailySalaryVoucher = new DailySalaryVoucherBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
infoMaster.DailySalaryVoucehrMasterId = decMasterIdforEdit;
infoMaster.Date = Convert.ToDateTime(dtpDate.Value.ToString());
infoMaster.LedgerId = Convert.ToDecimal(cmbCashorBankAccount.SelectedValue.ToString());
infoMaster.Narration = txtNarration.Text;
infoMaster.TotalAmount = Convert.ToDecimal(lblShowTotelamount.Text.ToString());
if (isAutomatic)
{
infoMaster.VoucherNo = strVoucherNo;
}
else
{
infoMaster.VoucherNo = txtVoucherNo.Text.Trim();
}
if (isAutomatic)
{
infoMaster.InvoiceNo = strInvoiceNo;
}
else
{
infoMaster.InvoiceNo = txtVoucherNo.Text.Trim();
}
infoMaster.Extra1 = string.Empty;
infoMaster.Extra2 = string.Empty;
infoMaster.SuffixPrefixId = decDailySuffixPrefixId;
infoMaster.VoucherTypeId = decDailyVoucherTypeId;
infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoMaster.SalaryDate = Convert.ToDateTime(dtpSalaryDate.Text.ToString());
infoDetails.Extra1 = string.Empty;// Fields not in design//
infoDetails.Extra2 = string.Empty;// Fields not in design//
BllDailySalaryVoucherMaster.DailySalaryVoucherMasterEdit(infoMaster);
int inRowCount = dgvDailySalaryVoucher.RowCount;
for (int i = 0; i < inRowCount; i++)
{
if (dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString() != string.Empty)
{
infoDetails.EmployeeId = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString());
}
if (dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString() != string.Empty)
{
infoDetails.Wage = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString());
}
if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() != string.Empty)
{
infoDetails.Status = dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString();
}
if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == string.Empty && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() != string.Empty)
{
decimal DailySalaryVoucherDetailsId = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtdailySalaryVoucherDetailsId"].Value.ToString());
BllDailySalaryVoucher.DailySalaryVoucherDetailsDelete(DailySalaryVoucherDetailsId);
LedgerUpdate();
}
if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == "paid" && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() == string.Empty)
{
infoDetails.DailySalaryVocherMasterId = decMasterIdforEdit;
BllDailySalaryVoucher.DailySalaryVoucherDetailsAdd(infoDetails);
//spMaster.DailySalaryVoucherMasterEdit(infoMaster);
LedgerUpdate();
}
if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == string.Empty && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() == string.Empty)
{
BllDailySalaryVoucherMaster.DailySalaryVoucherMasterEdit(infoMaster);
LedgerUpdate();
}
}
if (BllDailySalaryVoucher.DailySalaryVoucherDetailsCount(decMasterIdforEdit) == 0)
{
BllDailySalaryVoucherMaster.DailySalaryVoucherMasterDelete(decMasterIdforEdit);
}
Messages.UpdatedMessage();
Clear();
if (frmDailySalaryRegisterobj != null)
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("DSV12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
// Function to edit LedgerPosting table
/// <summary>
/// Function to edit the ledger posting
/// </summary>
/// <param name="decLedgerPostingId"></param>
/// <param name="decLedgerId"></param>
/// <param name="decCredit"></param>
/// <param name="decDebit"></param>
public void LedgerPostingEdit(decimal decLedgerPostingId, decimal decLedgerId, decimal decCredit, decimal decDebit)
{
try
{
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
infoLedgerPosting.LedgerPostingId = decLedgerPostingId;
infoLedgerPosting.Date = PublicVariables._dtCurrentDate;
infoLedgerPosting.VoucherTypeId = DecServicetVoucherTypeId;
infoLedgerPosting.VoucherNo = strVoucherNo;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
if (isAutomatic) // Checking voucher number generation is automatic or not
{
infoLedgerPosting.InvoiceNo = strInvoiceNo;
}
else
{
infoLedgerPosting.InvoiceNo = txtInvoiceNumber.Text; //For Manual mode
}
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.LedgerId = decLedgerId;
infoLedgerPosting.Credit = decCredit;
infoLedgerPosting.Debit = decDebit;
BllLedgerPosting.LedgerPostingEdit(infoLedgerPosting);
}
catch (Exception ex)
{
MessageBox.Show("SV 03: " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save data to the database
/// </summary>
public void SaveFunction()
{
try
{
int inRowcount = dgvMultipleAccountLedger.RowCount;//edited by Runali
int inRowcountDec = (dgvMultipleAccountLedger.RowCount) - 1;
decimal decOpeningBalance = 0;
decimal decLedgerId = 0;
bool isSave = false;
AccountLedgerInfo infoAccountledger = new AccountLedgerInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
FinancialYearBll BllFinancialYear = new FinancialYearBll();
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
for (int i = 0; i < inRowcount - 1; i++)
{
infoAccountledger.AccountGroupId = Convert.ToDecimal(cmbAccountGroup.SelectedValue.ToString());
infoAccountledger.LedgerName = dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtLedgerName"].Value.ToString();
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value != null)
{
infoAccountledger.OpeningBalance = Convert.ToDecimal(dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value.ToString());
}
else
{
infoAccountledger.OpeningBalance = 0;
}
infoAccountledger.CrOrDr = dgvMultipleAccountLedger.Rows[i].Cells["dgvcmbDebitOrCredit"].Value.ToString();
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtNarration"].Value != null)
{
infoAccountledger.Narration = dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtNarration"].Value.ToString();
}
else
{
infoAccountledger.Narration = string.Empty;
}
infoAccountledger.MailingName = string.Empty;
infoAccountledger.Address = string.Empty;
infoAccountledger.State = string.Empty;
infoAccountledger.Phone = string.Empty;
infoAccountledger.Mobile = string.Empty;
infoAccountledger.Email = string.Empty;
infoAccountledger.CreditPeriod = 0;
infoAccountledger.CreditLimit = 0;
infoAccountledger.PricinglevelId = 0;
infoAccountledger.BillByBill = false;
infoAccountledger.Tin = string.Empty;
infoAccountledger.Cst = string.Empty;
infoAccountledger.Pan = string.Empty;
infoAccountledger.RouteId = 0;
infoAccountledger.BankAccountNumber = string.Empty;
infoAccountledger.BranchName = string.Empty;
infoAccountledger.BranchCode = string.Empty;
infoAccountledger.Extra1 = string.Empty;
infoAccountledger.Extra2 = string.Empty;
infoAccountledger.AreaId = 0;
infoAccountledger.IsDefault = false;
infoAccountledger.ExtraDate = PublicVariables._dtCurrentDate;
decLedgerId = bllAccountLedger.AccountLedgerAddWithIdentity(infoAccountledger);
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value != null && dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value.ToString() != "0")
{
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value.ToString() != string.Empty)
{
string strfinancialId;
decOpeningBalance = Convert.ToDecimal(dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value.ToString());
infoFinancialYear = BllFinancialYear.FinancialYearViewForAccountLedger(1);
strfinancialId = infoFinancialYear.FromDate.ToString("dd-MMM-yyyy");
infoLedgerPosting.VoucherTypeId = 1;
infoLedgerPosting.Date = Convert.ToDateTime(strfinancialId.ToString());
infoLedgerPosting.LedgerId = decLedgerId;
infoLedgerPosting.VoucherNo = decLedgerId.ToString();
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvcmbDebitOrCredit"].Value.ToString() == "Dr")
{
infoLedgerPosting.Debit = decOpeningBalance;
}
else
{
infoLedgerPosting.Credit = decOpeningBalance;
}
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = decLedgerId.ToString();
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
isSave = true;
}
if (isSave)
{
Messages.SavedMessage();
cmbAccountGroup.Focus();
cmbAccountGroup.SelectedIndex = -1;
dgvMultipleAccountLedger.Rows.Clear();
}
else
{
}
}
catch (Exception ex)
{
MessageBox.Show("MAL6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
