private void btnSave_Click(object sender, EventArgs e) { DebitNoteModel objdebit = new DebitNoteModel(); if (tbxVchNumber.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objdebit.Voucher_Number = Convert.ToInt32(tbxVchNumber.Text.Trim()); objdebit.DN_Date = Convert.ToDateTime(dtDate.Text); objdebit.Voucher_Series = tbxVoucherSeries.Text.Trim(); objdebit.Type = cbxType.SelectedItem.ToString(); objdebit.PDC_Date = Convert.ToDateTime(dtPDC.Text); objdebit.LongNarration = tbxLongNarratin.Text.Trim() == null ? string.Empty : tbxLongNarratin.Text.Trim(); objdebit.TotalCreditAmount = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue); objdebit.TotalDebitAmount = Convert.ToDecimal(colDebit.SummaryItem.SummaryValue); //Debite Details AccountModel objDebit; List <AccountModel> lstDebitNotes = new List <AccountModel>(); for (int i = 0; i < gdvDebit.DataRowCount; i++) { DataRow row = gdvDebit.GetDataRow(i); objDebit = new AccountModel(); objDebit.DC = row["DC"].ToString(); objDebit.Account = row["Account"].ToString(); objDebit.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString()); objDebit.Debit = row["Debit"].ToString().Length > 0 ? Convert.ToDecimal(row["Debit"].ToString()) : 0; objDebit.Credit = row["Credit"].ToString().Length > 0 ? Convert.ToDecimal(row["Credit"].ToString()):0; objDebit.Narration = row["Narration"].ToString() == null?string.Empty: row["Narration"].ToString(); lstDebitNotes.Add(objDebit); } objdebit.DebitAccountModel = lstDebitNotes; bool isSuccess = objDNbl.SaveDebitNote(objdebit); if (isSuccess) { MessageBox.Show("Saved Successfully!"); DNId = 0; ClearControls(); } }
private void btnSave_Click(object sender, EventArgs e) { JournalVoucherModel objJVmodel = new JournalVoucherModel(); if (tbxVchNo.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objJVmodel.Voucher_Series = tbxVoucherSeries.Text.Trim(); objJVmodel.JV_Date = Convert.ToDateTime(dtDate.Text); objJVmodel.Type = tbxType.Text.Trim() == null?string.Empty:tbxType.Text.Trim(); objJVmodel.Voucher_Number = Convert.ToInt32(tbxVchNo.Text.Trim()); objJVmodel.PDCDate = Convert.ToDateTime(dtPDCDate.Text); objJVmodel.LongNarration = tbxLongNarration.Text.Trim() == null ? string.Empty : tbxLongNarration.Text.Trim(); objJVmodel.TotalCreditAmt = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue); objJVmodel.TotalDebitAmt = Convert.ToDecimal(colDebit.SummaryItem.SummaryValue); //Journal details AccountModel objacc; List <AccountModel> lstAccounts = new List <AccountModel>(); for (int i = 0; i < gdvJournalDetails.DataRowCount; i++) { DataRow row = gdvJournalDetails.GetDataRow(i); objacc = new AccountModel(); objacc.DC = row["DC"].ToString(); objacc.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString()); objacc.Account = row["Account"].ToString(); objacc.Debit = Convert.ToDecimal(row["Debit"].ToString() == string.Empty?"0":row["Debit"].ToString()); objacc.Credit = Convert.ToDecimal(row["Credit"].ToString() == string.Empty ? "0" : row["Credit"].ToString()); objacc.Narration = row["Narration"].ToString() == string.Empty ? string.Empty : row["Narration"].ToString(); lstAccounts.Add(objacc); } objJVmodel.JournalAccountModel = lstAccounts; bool isSuccess = objJVbal.SaveJournalVoucher(objJVmodel); if (isSuccess) { MessageBox.Show("Saved Successfully!"); ClearFormValues(); } }
private void btnSave_Click(object sender, EventArgs e) { ContraVoucherModel objcontra = new ContraVoucherModel(); if (tbxVoucherNo.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objcontra.Voucher_Series = tbxVoucherSeries.SelectedItem.ToString(); objcontra.Voucher_Number = Convert.ToInt64(tbxVoucherNo.Text.Trim()); objcontra.CV_Date = Convert.ToDateTime(dtDate.Text.Trim()); objcontra.PDCDate = Convert.ToDateTime(dtPdc.Text.Trim()); objcontra.Type = cbxType.SelectedItem.ToString(); objcontra.LongNarration = tbxLongNarration.Text.Trim(); objcontra.TotalCreditAmount = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue); objcontra.TotalDebitAmount = Convert.ToDecimal(colDebit.SummaryItem.SummaryValue); //Contra Account Details AccountModel objacc; List <AccountModel> lstAccounts = new List <AccountModel>(); for (int i = 0; i < dvgContraDetails.DataRowCount; i++) { DataRow row = dvgContraDetails.GetDataRow(i); objacc = new AccountModel(); objacc.DC = row["DC"].ToString(); objacc.Account = row["Account"].ToString(); objacc.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString()); objacc.Debit = Convert.ToDecimal(row["Debit"].ToString() == string.Empty?"0.00": row["Debit"].ToString()); objacc.Credit = Convert.ToDecimal(row["Credit"].ToString() == string.Empty?"0.00": row["Credit"].ToString()); objacc.Narration = row["Narration"].ToString() == null?string.Empty: row["Narration"].ToString(); lstAccounts.Add(objacc); } objcontra.ContraAccountModel = lstAccounts; bool isSuccess = objconBL.SaveContraVoucher(objcontra); if (isSuccess) { MessageBox.Show("Saved Successfully!"); ClearFormValues(); } }
//Get The Sale Ledger Id Under Sale Type Name public long GetSaleLedgerId(string TypeName) { long id = 0; string AccName; try { string Query = "SELECT * FROM `saletypemaster` WHERE `SalesType`='" + TypeName + "'"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { AccName = dr["LedgerAccountBox"].ToString(); id = objAccBL.GetLedgerIdByAccountName(AccName); } } catch (Exception ex) { } return(id); }
//Get LedgerId By BillSundary public long GetBSLedgerId(string BSName) { long id = 0; string AccName; try { string Query = "SELECT * FROM `billsundarymaster` WHERE `Name`='" + BSName + "'"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { AccName = dr["SaleAccounttoHeadPost"].ToString(); id = objAccBL.GetLedgerIdByAccountName(AccName); } } catch (Exception ex) { } return(id); }
private void btnSave_Click(object sender, EventArgs e) { PaymentVoucherModel objPayment = new PaymentVoucherModel(); if (tbxVchNumber.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objPayment.Voucher_Series = tbxVoucherSeries.Text.Trim(); objPayment.Voucher_Number = Convert.ToInt32(tbxVchNumber.Text.Trim()); objPayment.Pay_Date = Convert.ToDateTime(dtDate.Text); objPayment.Type = tbxType.Text.Trim() == null ? string.Empty : tbxType.Text.Trim(); objPayment.PDCDate = Convert.ToDateTime(dtPDCDate.Text); objPayment.LongNarration = tbxLongNarration.Text.Trim() == null?string.Empty:tbxLongNarration.Text.Trim(); objPayment.PaymentModeId = objAccBL.GetLedgerIdByAccountName(cbxPayMode.Text.Trim() == null ? string.Empty : cbxPayMode.Text.Trim()); if (objPayment.PaymentModeId == 0) { objPayment.TotalDebitAmt = Convert.ToDecimal(colDebit.SummaryItem.SummaryValue); objPayment.TotalCreditAmt = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue); } else { objPayment.TotalCreditAmt = Convert.ToDecimal(colAmount.SummaryItem.SummaryValue); } //Payment details AccountModel objacc; List <AccountModel> lstAccounts = new List <AccountModel>(); for (int i = 0; i < gdvPayment.DataRowCount; i++) { DataRow row = gdvPayment.GetDataRow(i); objacc = new AccountModel(); objacc.DC = row["DC"].ToString(); objacc.Account = row["Account"].ToString(); objacc.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString()); if (objPayment.PaymentModeId == 0) { objacc.Debit = Convert.ToDecimal(row["Debit"].ToString() == string.Empty ? "0.00" : row["Debit"].ToString()); objacc.Credit = Convert.ToDecimal(row["Credit"].ToString() == string.Empty ? "0.00" : row["Credit"].ToString()); } else { objacc.Debit = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString()); } objacc.Narration = row["Narration"].ToString() == null?string.Empty: row["Narration"].ToString(); lstAccounts.Add(objacc); } objPayment.PaymentAccountModel = lstAccounts; //Ledger Posting if (objPayment.PaymentModeId != 0) { //Single Entery Ledger Debit Posting LedgerPostingModel objLedger; List <LedgerPostingModel> lstLedgerDebit = new List <LedgerPostingModel>(); for (int i = 0; i < gdvPayment.DataRowCount; i++) { DataRow row = gdvPayment.GetDataRow(i); objLedger = new LedgerPostingModel(); objLedger.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString()); objLedger.Date = Convert.ToDateTime(dtDate.Text.Trim()); objLedger.Debit = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString()); objLedger.Credit = 0; objLedger.VoucherNo = tbxVchNumber.Text.Trim(); objLedger.VoucherTypeId = 1; objLedger.ChequeNo = string.Empty; objLedger.ChequeDate = DateTime.Now; objLedger.Extra1 = string.Empty; objLedger.Extra2 = string.Empty; objLedger.DetailsId = 0; objLedger.YearId = 1; lstLedgerDebit.Add(objLedger); } objPayment.PaymentLPDebit = lstLedgerDebit; //Single Entery Ledger Credit Posting LedgerPostingModel objLedgerCredit; List <LedgerPostingModel> lstLedgerCredit = new List <LedgerPostingModel>(); for (int i = 0; i < gdvPayment.DataRowCount; i++) { DataRow row = gdvPayment.GetDataRow(i); objLedgerCredit = new LedgerPostingModel(); objLedgerCredit.LedgerId = objPayment.PaymentModeId; objLedgerCredit.Date = Convert.ToDateTime(dtDate.Text.Trim()); objLedgerCredit.Credit = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString()); objLedgerCredit.Debit = 0; objLedgerCredit.VoucherNo = tbxVchNumber.Text.Trim(); objLedgerCredit.VoucherTypeId = 1; objLedgerCredit.ChequeNo = string.Empty; objLedgerCredit.ChequeDate = DateTime.Now; objLedgerCredit.Extra1 = string.Empty; objLedgerCredit.Extra2 = string.Empty; objLedgerCredit.DetailsId = 0; objLedgerCredit.DetailsId = 1; lstLedgerCredit.Add(objLedgerCredit); } objPayment.PaymentLPCredit = lstLedgerCredit; } else { } bool isSuccess = objpaybl.SavePaymentVoucher(objPayment); if (isSuccess) { MessageBox.Show("Saved Successfully!"); Payid = 0; //ClearFormValues(); } }
private void btnSave_Click(object sender, EventArgs e) { TransSalesModel objSaleVch = new TransSalesModel(); if (tbxVoucherNumber.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objSaleVch.VoucherType = tbxVoucherType.Text.Trim(); objSaleVch.SaleDate = Convert.ToDateTime(dtDate.Text); objSaleVch.Terms = cbxTerms.SelectedItem.ToString(); objSaleVch.VoucherNumber = Convert.ToInt64(tbxVoucherNumber.Text.Trim() == string.Empty ? "0" : tbxVoucherNumber.Text.Trim()); objSaleVch.BillNo = Convert.ToInt64(tbxBillNo.Text.Trim() == string.Empty ? "0" : tbxBillNo.Text.Trim()); objSaleVch.LedgerId = objAccBL.GetLedgerIdByAccountName(tbxParty.Text.Trim()); objSaleVch.SalesType = tbxSaleType.Text.Trim() == null?string.Empty:tbxSaleType.Text.Trim(); objSaleVch.MatCentre = tbxMatcenter.Text.Trim() == null?string.Empty: tbxMatcenter.Text.Trim(); objSaleVch.PriceList = cbxPriceList.Text.Trim() == null?string.Empty: cbxPriceList.Text.Trim(); objSaleVch.Narration = tbxNarration.Text.Trim() == null?string.Empty :tbxNarration.Text.Trim(); objSaleVch.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue); objSaleVch.TotalFree = Convert.ToDecimal(colFree.SummaryItem.SummaryValue); objSaleVch.TotalBasicAmount = Convert.ToDecimal(colBasicAmt.SummaryItem.SummaryValue); objSaleVch.TotalDisAmount = Convert.ToDecimal(colDisAmt.SummaryItem.SummaryValue); objSaleVch.TotalTaxAmount = Convert.ToDecimal(colTaxAmont.SummaryItem.SummaryValue); objSaleVch.TotalQty = Convert.ToDecimal(Qty.SummaryItem.SummaryValue); objSaleVch.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue); //Items Details Item_VoucherModel objSaleItem; List <Item_VoucherModel> lstSaleItems = new List <Item_VoucherModel>(); for (int i = 0; i < dvgItemDetails.DataRowCount; i++) { DataRow row = dvgItemDetails.GetDataRow(i); objSaleItem = new Item_VoucherModel(); objSaleItem.ITM_Id = objIMBL.GetItemIdByItemName(row["Item"].ToString() == null?string.Empty: row["Item"].ToString()); objSaleItem.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Particulars"].ToString() == null ? string.Empty : row["Particulars"].ToString()); objSaleItem.Qty = Convert.ToDecimal(row["Qty"].ToString() == string.Empty?"0.00": row["Qty"]); objSaleItem.Unit = row["Unit"].ToString() == null ? string.Empty : row["Unit"].ToString(); objSaleItem.Per = row["Per"].ToString() == null ? string.Empty : row["Per"].ToString(); objSaleItem.Price = Convert.ToDecimal(row["Price"].ToString() == string.Empty ? "0.00" : row["Price"].ToString()); objSaleItem.Batch = row["Batch"].ToString() == null ? string.Empty : row["Batch"].ToString(); objSaleItem.Free = Convert.ToDecimal(row["Free"].ToString() == string.Empty ? "0.00" : row["Free"].ToString()); objSaleItem.BasicAmt = Convert.ToDecimal(row["BasicAmt"].ToString() == string.Empty ? "0.00" : row["BasicAmt"].ToString()); objSaleItem.DiscountPercentage = Convert.ToDecimal(row["DiscountPercentage"].ToString() == string.Empty ? "0.00" : row["DiscountPercentage"].ToString()); objSaleItem.DiscountAmount = Convert.ToDecimal(row["DiscountAmount"].ToString() == string.Empty ? "0.00" : row["DiscountAmount"].ToString()); objSaleItem.TaxAmount = Convert.ToDecimal(row["TaxAmount"].ToString() == string.Empty ? "0.00" : row["TaxAmount"].ToString()); objSaleItem.Amount = Convert.ToDecimal(row["Amount"].ToString() == string.Empty?"0.00":row["Amount"].ToString()); if (objSaleVch.Trans_Sales_Id != 0) { objSaleItem.Item_ID = Convert.ToInt64(row["Item_ID"].ToString() == string.Empty ? "0" : row["Item_ID"].ToString()); objSaleItem.ParentId = Convert.ToInt64(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"].ToString()); } lstSaleItems.Add(objSaleItem); } objSaleVch.SalesItem_Voucher = lstSaleItems; //Bill Sundry Details BillSundry_VoucherModel objSaleBS; List <BillSundry_VoucherModel> lstSaleBS = new List <BillSundry_VoucherModel>(); for (int i = 0; i < dvgBsDetails.DataRowCount; i++) { DataRow row = dvgBsDetails.GetDataRow(i); objSaleBS = new BillSundry_VoucherModel(); objSaleBS.BS_Id = objBSBL.GetBSIdByBSName(row["BillSundry"].ToString() == null?string.Empty: row["BillSundry"].ToString()); objSaleBS.Percentage = Convert.ToDecimal(row["Percentage"].ToString() == string.Empty?"0.00":row["Percentage"].ToString()); objSaleBS.Extra = row["Extra"].ToString() == null ? string.Empty : row["Extra"].ToString(); objSaleBS.Amount = Convert.ToDecimal(row["Amount"].ToString() == string.Empty?"0.00": row["Amount"].ToString()); lstSaleBS.Add(objSaleBS); } objSaleVch.SalesBillSundry_Voucher = lstSaleBS; bool isSuccess = objSVBL.SaveSalesVoucher(objSaleVch); if (isSuccess) { ledgerPostingAdd(); MessageBox.Show("Saved Successfully!"); SalesId = 0; //ClearControls(); } }
private void btnSave_Click(object sender, EventArgs e) { objbsmod.Name = tbxName.Text; objbsmod.Alias = tbxAlias.Text == null ? string.Empty : tbxAlias.Text.Trim(); objbsmod.PrintName = tbxPrintName.Text == null ? string.Empty : tbxPrintName.Text.Trim(); objbsmod.BillSundryType = cbxBillsundrytype.SelectedItem.ToString(); objbsmod.BillSundryNature = cbxBillsundrynature.SelectedItem.ToString(); objbsmod.DefaultValue = Convert.ToDecimal(tbxdefaultvalue.Text == string.Empty ? "0.00" : tbxdefaultvalue.Text); objbsmod.subtotalheading = cbxSubtotalheading.SelectedItem.ToString(); objbsmod.AffectstheCostofGoodsinSale = Convert.ToBoolean(cbxAffectsthecostofgoodsinsale.Text.ToString() == "Y" ? true : false); objbsmod.AffectstheCostofGoodsinPurchase = Convert.ToBoolean(cbxaffectsthecostofgoodsinpurchase.Text.ToString() == "Y" ? true : false); objbsmod.AffectstheCostofGoodsinMaterialIssue = Convert.ToBoolean(cbxAffecsthecostofgoodsinMaterialissue.Text.ToString() == "Y" ? true : false); objbsmod.AffectstheCostofGoodsinMaterialReceipt = Convert.ToBoolean(cbxAffectsthecostofgoodsinmaterialreceipt.Text.ToString() == "Y" ? true : false); objbsmod.AffectstheCostofGoodsinStockTransfer = Convert.ToBoolean(cbxAffectsthecostofgoodsinstockTransfer.Text.ToString() == "Y" ? true : false); //Accounting In Sales objbsmod.SaleAffectsAccounting = Convert.ToBoolean(cbxSaleaffectsAcc.Text.ToString() == "Y" ? true : false); objbsmod.SaleAdjustInSaleAmount = Convert.ToBoolean(cbxSaleAdjustsaleamount.Text.ToString() == "Y" ? true : false); objbsmod.SaleSpecifyAccountHere = cbxSaleAccountLedgerSpecify.SelectedItem.ToString(); objbsmod.SaleAccounttoHeadPost = objAccBl.GetLedgerIdByAccountName(cbxSaleAccHeadpost.SelectedItem.ToString()).ToString(); objbsmod.SaleAdjustInPartyAmount = Convert.ToBoolean(cbxSaleAdjustinpartyAmount.Text.ToString() == "Y" ? true : false); objbsmod.SalePartSpecifyAccountHere = cbxPartysaleAccountLedgerSpecify.Text.ToString(); objbsmod.SaleAccounttoHeadPostParty = objAccBl.GetLedgerIdByAccountName(cbxSaleAccHeadpostParty.SelectedItem.ToString()).ToString(); if (objbsmod.SaleAdjustInSaleAmount) { objbsmod.SalePostOverandAbove = cbxSalePostoverandAbove.SelectedItem.ToString() == "Y" ? true : false; } //Accounting In Purchase objbsmod.PurcAffectsAccounting = Convert.ToBoolean(cbxPurcAftAccount.Text.ToString() == "Y" ? true : false); objbsmod.PurcAdjustInPurcAmount = Convert.ToBoolean(cbxPurcPurchaseAmount.Text.ToString() == "Y" ? true : false); objbsmod.PurcSpecifyAccountHere = cbxPurcAccountLedgerSpecify.SelectedItem.ToString(); objbsmod.PurcAccounttoHeadPost = cbxPurcHeadPost.SelectedItem.ToString(); objbsmod.PurcAdjustInPartyAmount = Convert.ToBoolean(cbxPurcPartyAmount.Text.ToString() == "Y" ? true : false); objbsmod.PurcParySpecifyAccountHere = cbxPartyPurcAccountLedgerSpecify.SelectedItem.ToString(); objbsmod.PurcAccounttoHeadPostParty = cbxPurcAccountHeadPostParty.Text.ToString(); if (objbsmod.PurcAdjustInPurcAmount) { objbsmod.PurcPostOverandAbove = cbxPurcPostOverAbove.SelectedItem.ToString() == "Y" ? true : false; } objbsmod.typeMaterialIssue = false; objbsmod.typeMaterialReceipt = false; objbsmod.StockTransfer = false; if (rbnMaterial.SelectedIndex == 0) { objbsmod.typeMaterialIssue = true; } if (rbnMaterial.SelectedIndex == 1) { objbsmod.typeMaterialReceipt = true; } if (rbnMaterial.SelectedIndex == 2) { objbsmod.StockTransfer = true; } objbsmod.AffectAccounting = Convert.ToBoolean(cbxAffectAccounting.Text.ToString() == "Y" ? true : false); objbsmod.OtherSide = cbxotherside.SelectedItem == null ? string.Empty : cbxotherside.SelectedItem.ToString(); objbsmod.Accountheadtopost = cbxAccountHeadPost.Text.Trim(); objbsmod.AdjustinMC = cbxAdjustinmc.SelectedItem.ToString().Equals("Y") ? true : false; objbsmod.AdjustSpecifyAccountLedger = cbxAccountAdjustinParty.SelectedItem.ToString(); objbsmod.AccountheadtopostParty = cbxAccountPost.SelectedItem.ToString() == null ? string.Empty : cbxAccountPost.SelectedItem.ToString(); objbsmod.postoverandabove = Convert.ToBoolean(cbxPostoverabove.Text.ToString() == "Y" ? true : false); //Amount Of Bill Sundary objbsmod.typeAbsoluteAmount = false; objbsmod.typePercentage = false; objbsmod.typePerMainQty = false; objbsmod.PerAltQty = false; if (rbnAmtBillsundary.SelectedIndex == 0) { objbsmod.typeAbsoluteAmount = true; } if (rbnAmtBillsundary.SelectedIndex == 1) { objbsmod.typePercentage = true; } if (rbnAmtBillsundary.SelectedIndex == 2) { objbsmod.typePerMainQty = true; } if (rbnAmtBillsundary.SelectedIndex == 3) { objbsmod.PerAltQty = true; } objbsmod.typeNetBillAmount = false; objbsmod.tyeItemsBasicAmt = false; objbsmod.typeTotalMRPofItems = false; objbsmod.typeTaxableAmount = false; objbsmod.typePreviousBillSundryAmount = false; objbsmod.typeOtherBillsundry = false; if (rbnbillsOf.SelectedIndex == 0) { objbsmod.typeNetBillAmount = true; } if (rbnbillsOf.SelectedIndex == 1) { objbsmod.tyeItemsBasicAmt = true; } if (rbnbillsOf.SelectedIndex == 2) { objbsmod.typeTotalMRPofItems = true; } if (rbnbillsOf.SelectedIndex == 3) { objbsmod.typeTaxableAmount = true; } if (rbnbillsOf.SelectedIndex == 4) { objbsmod.typePreviousBillSundryAmount = true; } if (rbnbillsOf.SelectedIndex == 5) { objbsmod.typeOtherBillsundry = true; } objbsmod.Percentoff = Convert.ToDecimal(tbxPersentage.Text.ToString()); objbsmod.SelectiveCalculation = Convert.ToBoolean(cbxselectivecalculation.SelectedItem.ToString() == "Y" ? true : false); objbsmod.IncludeFreeQty = Convert.ToBoolean(chkIncludefreequantity.Checked ? true : false); objbsmod.NoOfBillSundry = Convert.ToInt32(tbxNofbillsundrys.Text == null ? "0" : tbxNofbillsundrys.Text.Trim()); objbsmod.ConsolidateBillSundriesAmount = Convert.ToBoolean(cbxConsoilatedbillsundariesamt.SelectedItem.ToString() == "Y" ? true : false); objbsmod.BillSundaryName = cbxBillSundary.Text.Trim(); objbsmod.BSAmt = false; objbsmod.BSAppOn = false; if (rbnBillsundaryCal.SelectedIndex == 0) { objbsmod.BSAmt = true; } if (rbnBillsundaryCal.SelectedIndex == 1) { objbsmod.BSAppOn = true; } objbsmod.roundoffBillsundry = Convert.ToBoolean(cbxRoundoffBillsundryamount.SelectedItem.ToString() == "Y" ? true : false); if (objbsmod.roundoffBillsundry) { objbsmod.RoundoffValues = cbxRoundofValues.SelectedItem.ToString(); } bool isSuccess = objbsBL.SaveBSM(objbsmod); if (isSuccess) { MessageBox.Show("Saved Successfully!"); tbxName.Focus(); cbxBillSundary.Properties.Items.Clear(); List <BillSundryMasterModel> lstBillSundary = objbsBL.GetAllBillSundry(); foreach (BillSundryMasterModel objBill in lstBillSundary) { cbxBillSundary.Properties.Items.Add(objBill.Name); } } }
private void btnSave_Click(object sender, EventArgs e) { RecieptVoucherModel objRecipt = new RecieptVoucherModel(); if (tbxVchNumber.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objRecipt.Voucher_Series = tbxVoucherSeries.Text.Trim(); objRecipt.Voucher_Number = Convert.ToInt32(tbxVchNumber.Text.Trim()); objRecipt.RV_Date = Convert.ToDateTime(dtDate.Text); objRecipt.Type = tbxType.Text.Trim(); objRecipt.PDCDate = Convert.ToDateTime(dtPDCDate.Text); objRecipt.LongNarration = tbxLongNarration.Text.Trim() == string.Empty?string.Empty:tbxLongNarration.Text.Trim(); objRecipt.LedgerId = objAccBL.GetLedgerIdByAccountName(cbxPayMode.Text.Trim() == null ? string.Empty : cbxPayMode.Text.Trim()); if (objRecipt.LedgerId == 0) { if (Convert.ToDecimal(colCredit.SummaryItem.SummaryValue) != Convert.ToDecimal(colDebit.SummaryItem.SummaryValue)) { gdvReceipt.Focus(); return; } objRecipt.TotalDebitAmt = Convert.ToDecimal(colDebit.SummaryItem.SummaryValue); objRecipt.TotalCreditAmt = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue); } else { objRecipt.TotalDebitAmt = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue); } //Receipt Account Details AccountModel objacc; List <AccountModel> lstAccounts = new List <AccountModel>(); for (int i = 0; i < gdvReceipt.DataRowCount; i++) { DataRow row = gdvReceipt.GetDataRow(i); objacc = new AccountModel(); objacc.DC = row["DC"].ToString(); objacc.Account = row["Account"].ToString(); objacc.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString()); if (objRecipt.LedgerId == 0) { objacc.Debit = Convert.ToDecimal(row["Debit"].ToString() == string.Empty ? "0.00" : row["Debit"]); objacc.Credit = Convert.ToDecimal(row["Credit"].ToString() == string.Empty ? "0.00" : row["Credit"]); } else { objacc.Credit = Convert.ToDecimal(row["Credit"].ToString() == string.Empty ? "0.00" : row["Credit"]); } objacc.Narration = row["Narration"].ToString() == string.Empty ? string.Empty : row["Narration"].ToString(); lstAccounts.Add(objacc); } objRecipt.RecieptAccountModel = lstAccounts; bool isSuccess = objRecBL.SaveRecieptVoucher(objRecipt); if (isSuccess) { MessageBox.Show("Saved Successfully!"); Recpt_Id = 0; //ClearFormValues(); } }