private bool Save() { PurchaseVoucherModel sv = new PurchaseVoucherModel(); sv.Action = "insert"; sv.PartyId = txt_accountHeadName.Text; sv.InvoiceNo = txt_invoiceNo.Text; sv.PlaceOfSupply = ddl_state.SelectedValue.ToString(); sv.PartyGstinNo = txt_gstinNo.Text; sv.InvoiceDate = DateTime.Parse(dateTimePicker.Text); sv.ReciptRefNo = txt_referenceNo.Text; sv.Description = richTxt_Narration.Text; sv.item_XML = ConvertDatatableToXML(addData); //MessageBox.Show(sv.item_XML); //return true; DataSet ds = sv.PurchaseOperation(); if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "success") { MessageBox.Show("success", "MinifyERPBilling", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } else { MessageBox.Show(ds.Tables[0].Rows[0].ItemArray[0].ToString()); return(false); } }
//This BL is Used For Purchase Voucher Screen #region SAVE PURCHASE VOUCHER public bool SavePurcahseVoucher(PurchaseVoucherModel objPurc) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@VoucherType", objPurc.VoucherType)); paramCollection.Add(new DBParameter("@PurcDate", objPurc.PurcDate, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@Terms", objPurc.Terms)); paramCollection.Add(new DBParameter("@VoucherNumber", objPurc.VoucherNumber)); paramCollection.Add(new DBParameter("@BillNumber", objPurc.BillNo)); paramCollection.Add(new DBParameter("@LedgerId", objPurc.LedgerId)); paramCollection.Add(new DBParameter("@PurcType", objPurc.PurcType)); paramCollection.Add(new DBParameter("@MatCentre", objPurc.MatCentre)); paramCollection.Add(new DBParameter("@Narration", objPurc.Narration)); paramCollection.Add(new DBParameter("@TotalAmount", objPurc.TotalAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalQty", objPurc.TotalQty, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalFree", objPurc.TotalFree, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalBasicAmount", objPurc.TotalBasicAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalDisAmount", objPurc.TotalDisAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalTaxAmount", objPurc.TotalTaxAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@BSTotalAmount", objPurc.BSTotalAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", "")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime)); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader("spInsertPurchaseVoucherMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); int id = 0; dr.Read(); id = Convert.ToInt32(dr[0]); SavePurchaseVoucherItems(objPurc.Item_Voucher, id); SavePurchaseBillSundryVoucher(objPurc.BillSundry_Voucher, id); } catch (Exception ex) { isSaved = false; //throw ex; } return(isSaved); }
public bool SavePurchaseVoucher(PurchaseVoucherModel objSalesRet) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objSalesRet.Series)); paramCollection.Add(new DBParameter("@PurchaseType", objSalesRet.PurchaseType)); paramCollection.Add(new DBParameter("@PV_Date", objSalesRet.PV_Date)); paramCollection.Add(new DBParameter("@Voucher_Number", objSalesRet.Voucher_Number)); paramCollection.Add(new DBParameter("@BillNo", objSalesRet.BillNo)); paramCollection.Add(new DBParameter("@DueDate", objSalesRet.DueDate)); paramCollection.Add(new DBParameter("@Party", objSalesRet.Party)); paramCollection.Add(new DBParameter("@MatCenter", objSalesRet.MatCenter)); paramCollection.Add(new DBParameter("@Narration", objSalesRet.Narration)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); Query = "INSERT INTO Trans_Purchase_Voucher ([Series],[PV_Type],[PV_Date],[VoucherNo],[BillNo],[DueDate],[Party],[MatCenter],[Narration]," + "[CreatedBy]) VALUES " + "(@Series,@PurchaseType,@PV_Date,@Voucher_Number,@BillNo,@DueDate, " + " @Party, @MatCenter,@Narration,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { SavePVItems(objSalesRet.Item_Voucher); SavePVBillSundry(objSalesRet.BillSundry_Voucher); isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
private bool UpdatePurchaseItemandBS(PurchaseVoucherModel objpurchase) { try { //UPDATE Item voucher -CHILD TABLE UPDATES foreach (Item_VoucherModel item in objpurchase.Item_Voucher) { if (item.Item_ID > 0) { UpdatePurchaseVoucherItems(item); } else { SavePurchaseItems(item); } } //Update Bill Sundry Items foreach (BillSundry_VoucherModel bs in objpurchase.BillSundry_Voucher) { if (bs.BSId > 0) { UpdatePurchaseBillSundryVoucher(bs); } else { SavePurchaseBillSundryVoucher(bs); } } } catch (Exception ex) { return(false); } return(true); }
//Get All Purchase Vouchers Details By ID public PurchaseVoucherModel GetAllPurchaseVchDetailsbyId(long id) { PurchaseVoucherModel objPurcVch = new PurchaseVoucherModel(); StringBuilder sbQuery = new StringBuilder(); sbQuery.AppendLine("SELECT m.*,am.ACC_NAME FROM `purchasevoucher_master` AS m"); sbQuery.AppendLine("INNER JOIN accountmaster AS am ON m.LedgerId= am.Ac_ID"); sbQuery.AppendLine("WHERE m.`PurcVoucher_Id`='" + id + "'"); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(sbQuery.ToString(), _dbHelper.GetConnObject()); while (dr.Read()) { objPurcVch.Trans_Purc_Id = Convert.ToInt64(dr["PurcVoucher_Id"]); objPurcVch.VoucherType = dr["VoucherType"].ToString(); objPurcVch.PurcDate = DataFormat.GetDateTime(dr["PurcDate"]); objPurcVch.Terms = dr["Terms"].ToString(); objPurcVch.VoucherNumber = Convert.ToInt64(dr["VoucherNumber"]); objPurcVch.BillNo = Convert.ToInt64(dr["BillNumber"].ToString()); objPurcVch.PurcType = dr["PurcType"].ToString(); objPurcVch.Party = dr["ACC_NAME"].ToString(); objPurcVch.MatCentre = dr["MatCentre"].ToString(); objPurcVch.Narration = dr["Narration"].ToString(); objPurcVch.TotalQty = Convert.ToDecimal(dr["TotalQty"]); objPurcVch.TotalFree = Convert.ToDecimal(dr["TotalFree"]); objPurcVch.TotalBasicAmount = Convert.ToDecimal(dr["TotalBasicAmount"]); objPurcVch.TotalDisAmount = Convert.ToDecimal(dr["TotalDisAmount"]); objPurcVch.TotalTaxAmount = Convert.ToDecimal(dr["TotalTaxAmount"]); objPurcVch.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString()); objPurcVch.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]); //SELECT Item Details StringBuilder sbitemQuery = new StringBuilder(); sbitemQuery.AppendLine("SELECT i.*,im.ITEM_Name,ia.ACC_NAME FROM purchasevoucher_itemdetails as i"); sbitemQuery.AppendLine("left join itemmaster as im on i.ITM_ID=im.ITM_ID"); sbitemQuery.AppendLine("left join accountmaster as ia on i.LedgerId=ia.AC_ID"); sbitemQuery.AppendLine("WHERE PurcVoucher_Id='" + id + "'"); System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(sbitemQuery.ToString(), _dbHelper.GetConnObject()); objPurcVch.Item_Voucher = new List <Item_VoucherModel>(); Item_VoucherModel objitem; while (drItems.Read()) { objitem = new Item_VoucherModel(); objitem.Item_ID = Convert.ToInt64(drItems["Id"]); objitem.ITM_Id = Convert.ToInt64(drItems["ITM_ID"]); objitem.ParentId = DataFormat.GetInteger(drItems["PurcVoucher_Id"]); objitem.Item = drItems["ITEM_Name"].ToString(); objitem.Particulars = drItems["ACC_NAME"].ToString(); objitem.Qty = Convert.ToDecimal(drItems["qty"].ToString()); objitem.Unit = (drItems["Unit"].ToString()); objitem.Per = (drItems["Per"].ToString()); objitem.Batch = drItems["Batch"].ToString(); objitem.Price = Convert.ToDecimal(drItems["Price"]); objitem.Amount = Convert.ToDecimal(drItems["Amount"].ToString()); objitem.Free = Convert.ToDecimal(drItems["Free"]); objitem.BasicAmt = Convert.ToDecimal(drItems["BasicAmt"].ToString()); objitem.DiscountPercentage = Convert.ToDecimal(drItems["DiscountPercentage"].ToString()); objitem.DiscountAmount = Convert.ToDecimal(drItems["DiscountAmount"].ToString()); objitem.TaxAmount = Convert.ToDecimal(drItems["TaxAmount"].ToString()); objPurcVch.Item_Voucher.Add(objitem); } //Select BS Details StringBuilder sbBSQuery = new StringBuilder(); sbBSQuery.AppendLine("SELECT pbs.*,mbs.Name FROM purchasevoucher_bsdetails as pbs"); sbBSQuery.AppendLine("inner join billsundarymaster as mbs on pbs.BS_Id=mbs.BS_Id"); sbBSQuery.AppendLine("WHERE PurcVoucher_Id='" + id + "'"); System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(sbBSQuery.ToString(), _dbHelper.GetConnObject()); objPurcVch.BillSundry_Voucher = new List <BillSundry_VoucherModel>(); BillSundry_VoucherModel objbs; while (drbs.Read()) { objbs = new BillSundry_VoucherModel(); objbs.BSId = Convert.ToInt32(drbs["Id"]); objbs.ParentId = DataFormat.GetInteger(drbs["PurcVoucher_Id"]); objbs.BillSundry = drbs["Name"].ToString(); objbs.Percentage = Convert.ToDecimal(drbs["Percentage"].ToString()); objbs.Extra = drbs["Extra"].ToString(); objbs.Amount = Convert.ToDecimal((drbs["Amount"].ToString())); objPurcVch.BillSundry_Voucher.Add(objbs); } } return(objPurcVch); }
private void FillPurchaseVoucherInfo() { if (PurcId == 0) { cbxTerms.Focus(); lactrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lactrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; lactrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; return; } PurchaseVoucherModel objPurcVch = objPurcBL.GetAllPurchaseVchDetailsbyId(PurcId); cbxVoucherType.Text = objPurcVch.VoucherType.ToString(); dtDate.Text = objPurcVch.PurcDate.ToString(); cbxTerms.SelectedItem = objPurcVch.Terms.ToString(); tbxVoucherNumber.Text = objPurcVch.VoucherNumber.ToString(); tbxBillNo.Text = objPurcVch.BillNo.ToString(); cbxPurcType.Text = objPurcVch.PurcType.ToString(); cbxParty.Text = objPurcVch.Party; cbxMatcenter.Text = objPurcVch.MatCentre.ToString(); tbxNarration.Text = objPurcVch.Narration.ToString(); //Qty.SummaryItem= objSaleVch.TotalQty.ToString(); //objSaleVch.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString()); //objSaleVch.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]); //dvgMainItem.DataSource = objSaleVch.SalesItem_Voucher; //dvgBSMain.DataSource = objSaleVch.SalesBillSundry_Voucher; dtItem.Rows.Clear(); DataRow idr; foreach (Item_VoucherModel objItems in objPurcVch.Item_Voucher) { idr = dtItem.NewRow(); idr["Item"] = objItems.Item; idr["Particulars"] = objItems.Particulars; idr["Qty"] = objItems.Qty; idr["Unit"] = objItems.Unit; idr["Per"] = objItems.Per; idr["Price"] = objItems.Price; idr["Batch"] = objItems.Batch; idr["Free"] = objItems.Free; idr["BasicAmt"] = objItems.BasicAmt; idr["DiscountPercentage"] = objItems.DiscountPercentage; idr["DiscountAmount"] = objItems.DiscountAmount; idr["TaxAmount"] = objItems.TaxAmount; idr["Amount"] = objItems.Amount; idr["Item_ID"] = objItems.Item_ID; idr["ParentId"] = objItems.ParentId; dtItem.Rows.Add(idr); if (objItems.ITM_Id == 0) { AccountMode(); } else { ItemMode(); } } dtbs.Rows.Clear(); DataRow bsdr; foreach (BillSundry_VoucherModel objbs in objPurcVch.BillSundry_Voucher) { bsdr = dtbs.NewRow(); bsdr["BillSundry"] = objbs.BillSundry; bsdr["Percentage"] = objbs.Percentage; bsdr["Extra"] = objbs.Extra; bsdr["Amount"] = objbs.Amount; bsdr["BSId"] = objbs.BSId; bsdr["ParentId"] = objbs.ParentId; dtbs.Rows.Add(bsdr); } lactrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lactrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; lactrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization; cbxTerms.Focus(); }
private void btnUpdate_Click(object sender, EventArgs e) { PurchaseVoucherModel objPurcVch = new PurchaseVoucherModel(); if (tbxVoucherNumber.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objPurcVch.VoucherType = cbxVoucherType.Text.Trim(); objPurcVch.PurcDate = Convert.ToDateTime(dtDate.Text); objPurcVch.Terms = cbxTerms.SelectedItem.ToString(); objPurcVch.VoucherNumber = Convert.ToInt64(tbxVoucherNumber.Text.Trim() == string.Empty ? "0" : tbxVoucherNumber.Text.Trim()); objPurcVch.BillNo = Convert.ToInt64(tbxBillNo.Text.Trim() == string.Empty ? "0" : tbxBillNo.Text.Trim()); objPurcVch.LedgerId = objAccBL.GetLedgerIdByAccountName(cbxParty.Text.Trim()); objPurcVch.PurcType = cbxPurcType.Text.Trim() == null ? string.Empty : cbxPurcType.Text.Trim(); objPurcVch.MatCentre = cbxMatcenter.Text.Trim() == null?string.Empty : cbxMatcenter.Text.Trim(); objPurcVch.Narration = tbxNarration.Text.Trim() == null ? string.Empty : tbxNarration.Text.Trim(); objPurcVch.TotalQty = Convert.ToDecimal(colQty.SummaryItem.SummaryValue); objPurcVch.TotalFree = Convert.ToDecimal(colFree.SummaryItem.SummaryValue); objPurcVch.TotalBasicAmount = Convert.ToDecimal(colBasicAmt.SummaryItem.SummaryValue); objPurcVch.TotalDisAmount = Convert.ToDecimal(colDisAmt.SummaryItem.SummaryValue); objPurcVch.TotalTaxAmount = Convert.ToDecimal(colTaxAmt.SummaryItem.SummaryValue); objPurcVch.TotalAmount = Convert.ToDecimal(colItemAmount.SummaryItem.SummaryValue); objPurcVch.BSTotalAmount = Convert.ToDecimal(colBSAmt.SummaryItem.SummaryValue); //Items Details Item_VoucherModel objPurcItem; List <Item_VoucherModel> lstPurcItems = new List <Item_VoucherModel>(); for (int i = 0; i < dvgItemDetails.DataRowCount; i++) { DataRow row = dvgItemDetails.GetDataRow(i); objPurcItem = new Item_VoucherModel(); objPurcItem.ITM_Id = objIMBL.GetItemIdByItemName(row["Item"].ToString() == null ? string.Empty : row["Item"].ToString()); objPurcItem.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Particulars"].ToString() == null ? string.Empty : row["Particulars"].ToString()); objPurcItem.Qty = Convert.ToDecimal(row["Qty"].ToString() == string.Empty ? "0.00" : row["Qty"]); objPurcItem.Unit = row["Unit"].ToString() == null ? string.Empty : row["Unit"].ToString(); objPurcItem.Per = row["Per"].ToString() == null ? string.Empty : row["Per"].ToString(); objPurcItem.Price = Convert.ToDecimal(row["Price"].ToString() == string.Empty ? "0.00" : row["Price"].ToString()); objPurcItem.Batch = row["Batch"].ToString() == null ? string.Empty : row["Batch"].ToString(); objPurcItem.Free = Convert.ToDecimal(row["Free"].ToString() == string.Empty ? "0.00" : row["Free"].ToString()); objPurcItem.BasicAmt = Convert.ToDecimal(row["BasicAmt"].ToString() == string.Empty ? "0.00" : row["BasicAmt"].ToString()); objPurcItem.DiscountPercentage = Convert.ToDecimal(row["DiscountPercentage"].ToString() == string.Empty ? "0.00" : row["DiscountPercentage"].ToString()); objPurcItem.DiscountAmount = Convert.ToDecimal(row["DiscountAmount"].ToString() == string.Empty ? "0.00" : row["DiscountAmount"].ToString()); objPurcItem.TaxAmount = Convert.ToDecimal(row["TaxAmount"].ToString() == string.Empty ? "0.00" : row["TaxAmount"].ToString()); objPurcItem.Amount = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString()); objPurcItem.Item_ID = Convert.ToInt64(row["Item_ID"].ToString() == string.Empty ? "0" : row["Item_ID"].ToString()); objPurcItem.ParentId = Convert.ToInt64(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"].ToString()); lstPurcItems.Add(objPurcItem); } objPurcVch.Item_Voucher = lstPurcItems; //Bill Sundry Details BillSundry_VoucherModel objPurcBS; List <BillSundry_VoucherModel> lstPurcBS = new List <BillSundry_VoucherModel>(); for (int i = 0; i < dvgBSDetails.DataRowCount; i++) { DataRow row = dvgBSDetails.GetDataRow(i); objPurcBS = new BillSundry_VoucherModel(); objPurcBS.BS_Id = objBSBL.GetBSIdByBSName(row["BillSundry"].ToString() == null ? string.Empty : row["BillSundry"].ToString()); objPurcBS.Percentage = Convert.ToDecimal(row["Percentage"].ToString() == string.Empty ? "0.00" : row["Percentage"].ToString()); objPurcBS.Extra = row["Extra"].ToString() == null ? string.Empty : row["Extra"].ToString(); objPurcBS.Amount = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString()); objPurcBS.BSId = Convert.ToInt64(row["BSID"].ToString() == string.Empty ? "0" : row["BSID"].ToString()); objPurcBS.ParentId = Convert.ToInt64(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"].ToString()); lstPurcBS.Add(objPurcBS); } objPurcVch.BillSundry_Voucher = lstPurcBS; objPurcVch.Trans_Purc_Id = PurcId; bool isSuccess = objPurcBL.UpdatePurchaseVoucher(objPurcVch); if (isSuccess) { MessageBox.Show("Update Successfully!"); PurcId = 0; ClearControls(); Transaction.List.PurchaseVouchersList frmPurcVchList = new Transaction.List.PurchaseVouchersList(); frmPurcVchList.StartPosition = FormStartPosition.CenterParent; frmPurcVchList.ShowDialog(); FillPurchaseVoucherInfo(); } }
public PurchaseVoucherModel GetAllPurcahseVoucherbyId(int id) { PurchaseVoucherModel objpurchase = new PurchaseVoucherModel(); string Query = "SELECT * FROM Trans_purchase_voucher WHERE transpvId=" + id; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objpurchase.PV_Id = DataFormat.GetInteger(dr["TransPVId"]); objpurchase.Series = dr["series"].ToString(); objpurchase.PV_Date = DataFormat.GetDateTime(dr["pv_Date"]); objpurchase.Voucher_Number = DataFormat.GetInteger(dr["Voucherno"]); objpurchase.BillNo = DataFormat.GetInteger(dr["BillNo"]); objpurchase.PurchaseType = dr["pv_Type"].ToString(); objpurchase.Party = dr["party"].ToString(); objpurchase.MatCenter = dr["MatCenter"].ToString(); objpurchase.Narration = dr["Narration"].ToString(); //objpurchase.t = Convert.ToDecimal(dr["TotalQty"]); //objpurchase.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString()); //objpurchase.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]); //SELECT Purchase Items string itemQuery = "SELECT * FROM Trans_pv_items WHERE TranspvId=" + id; System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); objpurchase.Item_Voucher = new List <Item_VoucherModel>(); Item_VoucherModel objitem; while (drItems.Read()) { objitem = new Item_VoucherModel(); objitem.Item_ID = Convert.ToInt32(drItems["ItemId"]); objitem.ParentId = DataFormat.GetInteger(drItems["TranspvId"]); objitem.Item = drItems["item"].ToString(); objitem.Batch = drItems["Batch"].ToString(); objitem.Qty = Convert.ToInt32(drItems["qty"].ToString()); objitem.Unit = (drItems["unit"].ToString()); objitem.Price = Convert.ToDecimal(drItems["price"]); objitem.Amount = Convert.ToInt32(drItems["amount"].ToString()); objitem.TotalQty = Convert.ToInt32(drItems["TotalQty"].ToString()); objitem.TotalAmount = Convert.ToDecimal(drItems["TotalAmount"]); objpurchase.Item_Voucher.Add(objitem); } string BSQuery = "SELECT * FROM Trans_pv_BS WHERE TranspvId=" + id; System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject()); objpurchase.BillSundry_Voucher = new List <BillSundry_VoucherModel>(); BillSundry_VoucherModel objbs; while (drbs.Read()) { objbs = new BillSundry_VoucherModel(); objbs.BSId = Convert.ToInt32(drbs["BSId"]); objbs.ParentId = DataFormat.GetInteger(drbs["TranspvId"]); objbs.BillSundry = drbs["BillSundry"].ToString(); objbs.Percentage = Convert.ToDecimal(drbs["Percentage"].ToString()); objbs.Amount = Convert.ToDecimal((drbs["Amount"].ToString())); objbs.TotalAmount = Convert.ToDecimal(drbs["TotalAmount"].ToString()); objpurchase.BillSundry_Voucher.Add(objbs); } } return(objpurchase); }