internal DataTable SaveStockTransfer(StockTransferModel objSTModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPStockTransfer"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objSTModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSTModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objSTModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSTModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objSTModel.VchType); ClsCon.cmd.Parameters.AddWithValue("@TransferNo", objSTModel.TransferNo); ClsCon.cmd.Parameters.AddWithValue("@TransferDate", objSTModel.TransferDate); ClsCon.cmd.Parameters.AddWithValue("@Narration", objSTModel.Narration); ClsCon.cmd.Parameters.AddWithValue("@TransferFromWarehouseID", objSTModel.TransferFromWarehouseID); ClsCon.cmd.Parameters.AddWithValue("@TransferToWarehouseID", objSTModel.TransferToWarehouseID); ClsCon.cmd.Parameters.AddWithValue("@CCCodeTransferFrom", objSTModel.CCCodeTransferFrom); ClsCon.cmd.Parameters.AddWithValue("@CCCodeTransferTo", objSTModel.CCCodeTransferTo); ClsCon.cmd.Parameters.AddWithValue("@UserID", objSTModel.UserID); ClsCon.cmd.Parameters.AddWithValue("@IP", objSTModel.IP); ClsCon.cmd.Parameters.AddWithValue("@TblStockTransferItems", objSTModel.DtItemDetail); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtStockTransfer = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtStockTransfer); dtStockTransfer.TableName = "success"; } catch (Exception) { dtStockTransfer = new DataTable(); dtStockTransfer.TableName = "error"; return(dtStockTransfer); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtStockTransfer); }
public bool SaveStockVoucher(StockTransferModel objStock) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objStock.Series)); paramCollection.Add(new DBParameter("@Date", objStock.ST_Date, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@Voucher_Number", objStock.Voucher_Number)); paramCollection.Add(new DBParameter("@Fromdate", objStock.FromDate, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@Todate", objStock.ToDate, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@Narration", objStock.Narration)); paramCollection.Add(new DBParameter("@TotalQty", objStock.TotalQty)); paramCollection.Add(new DBParameter("@TotalAmount", objStock.TotalAmount)); paramCollection.Add(new DBParameter("@TotalBS", objStock.TotalBSAmount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime)); Query = "INSERT INTO Stock_Transfer_Voucher ([Series],[ST_Date],[VoucherNo],[FromDate],[ToDate],[Narration],[TotalQty]" + "[TotalAmount],[TotalBSTotal],[CreatedBy]) VALUES " + "(@Series,@Date,@Voucher_Number,@Fromdate,@Todate, " + "@Narration,@TotalQty,@TotalAmount,@TotalBS,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { SaveStockItems(objStock.StockItem_Voucher); SaveStockBillSundry(objStock.StockBillSundry_Voucher); isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
//-------------------------All Stock Transfer Report----------------------// public ActionResult StockTransfers() { var datastock = (from p in db.tblTransfers select p).ToList(); List <StockTransferModel> list = new List <StockTransferModel>(); foreach (var item in datastock) { StockTransferModel model = new StockTransferModel(); model.RawMaterialId = item.RawMaterialId; // model.OutletId = item.OutletId; model.TransferDate = item.TransferDate; model.TransferId = item.TransferId; model.TransferQuantity = item.TransferQuantity; model.ReciverOutletId = item.ReciverOutletId; model.SenderOutletId = item.SenderOutletId; list.Add(model); } return(View(list)); }
public bool UpdateStockTransferVoucher(StockTransferModel objStock) { string Query = string.Empty; bool isUpdated = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objStock.Series)); paramCollection.Add(new DBParameter("@STDate", objStock.ST_Date, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@VoucherNumber", objStock.Voucher_Number)); paramCollection.Add(new DBParameter("@fromdate", objStock.FromDate, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@Todate", objStock.ToDate, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@Narration", objStock.Narration)); paramCollection.Add(new DBParameter("@Createdby", "Admin")); paramCollection.Add(new DBParameter("@id", objStock.ST_Id)); Query = "UPDATE Stock_Transfer_Voucher SET [Series]=@Series,[ST_Date]=@STDate," + "[VoucherNo]=@VoucherNumber,[FromDate]=@fromdate,[ToDate]=@Todate," + "[Narration]=@Narration,[CreatedBy]=@Createdby " + "WHERE Stock_Id=@id"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { { UpdateItemandBS(objStock); isUpdated = true; } } } catch (Exception ex) { isUpdated = false; throw ex; } return(isUpdated); }
public bool SaveStockVoucher(StockTransferModel objStock) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@VoucherNumber", objStock.Voucher_Number)); paramCollection.Add(new DBParameter("@Series", objStock.Series)); paramCollection.Add(new DBParameter("@Date", objStock.ST_Date, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@StockFrom", objStock.FromDate)); paramCollection.Add(new DBParameter("@StockTo", objStock.ToDate)); paramCollection.Add(new DBParameter("@Narration", objStock.Narration)); paramCollection.Add(new DBParameter("@ItemTotalAmount", objStock.TotalAmount)); paramCollection.Add(new DBParameter("@ItemTotalQty", objStock.TotalQty)); paramCollection.Add(new DBParameter("@BSTotalAmount", objStock.BSTotalAmount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader("spInsertStockTransMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); int id = 0; dr.Read(); id = Convert.ToInt32(dr[0]); SaveStockItems(objStock.StockItem_Voucher, id); SaveStockBillSundry(objStock.StockBillSundry_Voucher, id); } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
private bool UpdateItemandBS(StockTransferModel objstock) { try { //UPDATE Item voucher -CHILD TABLE UPDATES foreach (Item_VoucherModel item in objstock.StockItem_Voucher) { if (item.Item_ID > 0) { UpdateStockTransferItems(item); } else { SaveStockTransferVoucherItem(item); } } //Update Bill Sundry Items foreach (BillSundry_VoucherModel bs in objstock.StockBillSundry_Voucher) { if (bs.BSId > 0) { UpdateStockTransferBillSundryVoucher(bs); } else { SaveStockTransferBillSundryVoucher(bs); } } } catch (Exception ex) { return(false); } return(true); }
internal DataSet BindStockTransferDDL(StockTransferModel objSTModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPStockTransfer"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objSTModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objSTModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objSTModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objSTModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objSTModel.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsStockTransfer = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsStockTransfer); dsStockTransfer.DataSetName = "success"; } catch (Exception) { dsStockTransfer = new DataSet(); dsStockTransfer.DataSetName = "error"; return(dsStockTransfer); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsStockTransfer); }
private void btnSave_Click(object sender, EventArgs e) { StockTransferModel objStockTrans = new StockTransferModel(); if (tbxVoucherNo.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objStockTrans.Series = tbxSeries.Text.Trim(); objStockTrans.FromDate = tbxFrom.Text.Trim(); objStockTrans.ToDate = tbxTo.Text.Trim(); objStockTrans.ST_Date = Convert.ToDateTime(dtDate.Text); objStockTrans.Voucher_Number = Convert.ToInt32(tbxVoucherNo.Text.Trim()); objStockTrans.Narration = tbxNarration.Text.Trim(); objStockTrans.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue); objStockTrans.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue); //Stock Transfer Items Item_VoucherModel objItem; List <Item_VoucherModel> lstItems = new List <Item_VoucherModel>(); for (int i = 0; i < gdvItem.DataRowCount; i++) { DataRow row = gdvItem.GetDataRow(i); objItem = new Item_VoucherModel(); objItem.Item = row["Item"].ToString(); objItem.Qty = Convert.ToDecimal(row["Qty"]); objItem.Unit = row["Unit"].ToString(); objItem.Amount = Convert.ToDecimal(row["Amount"].ToString()); objItem.Price = Convert.ToDecimal(row["Price"].ToString()); lstItems.Add(objItem); } objStockTrans.StockItem_Voucher = lstItems; //Bill Sundry BillSundry_VoucherModel objBS; List <BillSundry_VoucherModel> lstBS = new List <BillSundry_VoucherModel>(); for (int i = 0; i < gridBs.DataRowCount; i++) { DataRow row = gridBs.GetDataRow(i); objBS = new BillSundry_VoucherModel(); objBS.BillSundry = row["BillSundry"].ToString(); objBS.Narration = row["Narration"].ToString(); objBS.Percentage = Convert.ToDecimal(row["Percentage"]); objBS.Amount = Convert.ToDecimal(row["Amount"]); objBS.Type = row["Extra"].ToString(); lstBS.Add(objBS); } objStockTrans.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue); objStockTrans.StockBillSundry_Voucher = lstBS; bool isSuccess = objStockBL.SaveStockVoucher(objStockTrans); if (isSuccess) { MessageBox.Show("Saved Successfully!"); // Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!"); // d.ShowDialog(); } }
public async Task <Stream> UploadStockTransfer(MemoryStream memoryStream, StockTransferModel model) { var lineObjectDocId = 1010; var stockOrderTransfers = new List <StockTransferModel>(); using (var reader = new StreamReader(memoryStream)) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap <StockOrderTransferMapping>(); stockOrderTransfers.AddRange(csv.GetRecords <StockTransferModel>()); } List <SalesQuoteLine> quotesLineItems = new List <SalesQuoteLine>(); var itemId = 10; CustomerRequirementList customerRequirements = new CustomerRequirementList(); foreach (var record in stockOrderTransfers) { var customerRequirement = new CustomerRequirement(); customerRequirement.ActionCode = "01"; customerRequirement.ObjectNodeSenderTechnicalID = record.ObjectNodeSenderTechnicalID; customerRequirement.ShipFromSiteID = model.ShipFromSiteID; customerRequirement.ShipToSiteID = model.ShipToSiteID; customerRequirement.ShipToLocationID = model.ShipToLocationID; customerRequirement.CompleteDeliveryRequestedIndicator = model.CompleteDeliveryRequestedIndicator; customerRequirement.DeliveryPriorityCode = model.DeliveryPriorityCode; customerRequirement.ExternalRquestItem.ObjectNodeSenderTechnicalID = lineObjectDocId.ToString(); customerRequirement.ExternalRquestItem.ItemID = itemId.ToString(); customerRequirement.ExternalRquestItem.ProductKey.ProductID = record.ProductID; customerRequirement.ExternalRquestItem.ProductKey.ProductIdentifierTypeCode = string.Empty; customerRequirement.ExternalRquestItem.ProductKey.ProductTypeCode = string.Empty; customerRequirement.ExternalRquestItem.Description.Text = record.Description; customerRequirement.ExternalRquestItem.Description.LanguageCode = "EN"; customerRequirement.ExternalRquestItem.RequestedQuantity.Text = record.RequestedQuantity; customerRequirement.ExternalRquestItem.RequestedQuantity.UnitCode = "XCT"; customerRequirement.ExternalRquestItem.RequestedLocalDateTime.Text = Convert.ToDateTime(record.RequestedLocalDateTime).ToString("s") + "Z"; customerRequirement.ExternalRquestItem.RequestedLocalDateTime.TimeZoneCode = "UTC+1"; customerRequirements.CustomerRequirements.Add(customerRequirement); lineObjectDocId += 1; itemId += 10; if (model.RaiseSalesQuote) { quotesLineItems.Add(new SalesQuoteLine { ExternalReference = model.ExternalReference, ProductId = record.ProductID, Quantity = record.RequestedQuantity, TaxCode = record.TaxCode }); } } var customerRequirementXml = HelperExtensions.SerializeToXml(customerRequirements); string filePath = Path.Combine(HostingEnvironment.ContentRootPath, "xmlfiles/customerRequirement.xml"); //merge xml files XmlDocument doc = new XmlDocument(); doc.Load(filePath); var nsmgr = new XmlNamespaceManager(doc.NameTable); nsmgr.AddNamespace("soapenv", "http://schemas.xmlsoap.org/soap/envelope/"); nsmgr.AddNamespace("glob", "http://sap.com/xi/SAPGlobal20/Global"); var element = doc.SelectSingleNode("/soapenv:Envelope/soapenv:Body/glob:CustReqBundleMaintainRequest_sync", nsmgr); if (element != null) { var subDoc = new XmlDocument(); subDoc.LoadXml(customerRequirementXml); var nsmgr1 = new XmlNamespaceManager(subDoc.NameTable); nsmgr1.AddNamespace("xsd", "http://www.w3.org/2001/XMLSchema"); nsmgr1.AddNamespace("xsi", "http://www.w3.org/2001/XMLSchema-instance"); var customerRequirementListNodes = subDoc.SelectNodes("//CustomerRequirementList/CustomerRequirement", nsmgr1); var sb = new StringBuilder(); foreach (XmlNode child in customerRequirementListNodes) { sb.AppendLine("<CustomerRequirement>"); sb.AppendLine(child.InnerXml); sb.AppendLine("</CustomerRequirement>"); } element.InnerXml = sb.ToString(); var customerReqNodes = doc.SelectNodes("//CustomerRequirement"); foreach (XmlNode node in customerReqNodes) { XmlAttribute attribute = node.OwnerDocument.CreateAttribute("ActionCode"); attribute.Value = "01"; node.Attributes.Append(attribute); } //var basicMsgNode = doc.CreateNode(XmlNodeType.Element, "BasicMessageHeader", null); //XmlNode customerRequirementNode = doc.SelectSingleNode("//CustomerRequirement"); //element.InsertBefore(basicMsgNode, customerRequirementNode); doc.Save(filePath); StreamReader sr = new StreamReader(filePath); string soapXml = sr.ReadToEnd(); sr.Close(); var tenantSetting = await _tenantSettingService.GetSetting(); UriBuilder urlBuilder = new UriBuilder(tenantSetting.BaseUrl) { Path = "/sap/bc/srt/scs/sap/managecustomerrequirementin" }; var request = new HttpRequestMessage(HttpMethod.Post, urlBuilder.ToString()); request.Headers.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("text/xml")); var byteArray = Encoding.ASCII.GetBytes($"{tenantSetting.User}:{tenantSetting.Password}"); request.Headers.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Basic", Convert.ToBase64String(byteArray)); request.Content = new StringContent(soapXml, Encoding.UTF8, "text/xml"); var response = await _client.HttpClient.SendAsync(request); if (response.IsSuccessStatusCode) { var responseData = await response.Content.ReadAsStreamAsync(); if (quotesLineItems.Count > 0) { var salesQuoteRequest = await PostSalesQuote(new SalesQuoteHeader { AccountId = model.AccountId, Description = model.Description, DistributionChannelCode = model.DistributionChannelCode, EmployeeResponsible = model.EmployeeResponsible, ExternalReference = model.ExternalReference, PostingDate = model.PostingDate.ToString(), RequestedDate = model.RequestedDate.Value.ToString(), SalesUnitId = model.SalesUnitId }, quotesLineItems); return(salesQuoteRequest); } return(responseData); } } return(null); }
public DataTable SaveStockTransfer(StockTransferModel objSTModel) { DataTable dtSaveST = objSTDA.SaveStockTransfer(objSTModel); return(dtSaveST); }
public DataSet BindItemAndUnitDDL(StockTransferModel objSTModel) { DataSet ItemList = objSTDA.BindItemAndUnitDDL(objSTModel); return(ItemList); }
public DataSet BindStockTransferDDL(StockTransferModel objSTModel) { DataSet dsBindSTDDL = objSTDA.BindStockTransferDDL(objSTModel); return(dsBindSTDDL); }
public StockTransferModel GetAllStockTransferbyId(int id) { StockTransferModel objstock = new StockTransferModel(); string Query = "SELECT * FROM Stock_Transfer_Voucher WHERE Stock_Id=" + id; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objstock.ST_Id = Convert.ToInt32(dr["Stock_Id"]); objstock.Series = dr["series"].ToString(); objstock.ST_Date = DataFormat.GetDateTime(dr["ST_Date"]); objstock.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]); objstock.FromDate = Convert.ToDateTime(dr["FromDate"]); objstock.ToDate = Convert.ToDateTime(dr["ToDate"]); objstock.Narration = dr["Narration"].ToString(); //objSalesReturn.TotalQty = Convert.ToDecimal(dr["TotalQty"]); //objSalesReturn.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString()); //objSalesReturn.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]); string itemQuery = "SELECT * FROM Stock_Transfer_Items WHERE Stock_Id=" + id; System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); objstock.StockItem_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["Stock_Id"]); 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.TotalAmount = Convert.ToDecimal(drItems["TotalAmount"]); objitem.TotalQty = Convert.ToInt32(drItems["TotalQty"].ToString()); objstock.StockItem_Voucher.Add(objitem); } string BSQuery = "SELECT * FROM Stock_Transfer_BS WHERE Stock_Id=" + id; System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject()); objstock.StockBillSundry_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["Stock_Id"]); 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()); objstock.StockBillSundry_Voucher.Add(objbs); } } return(objstock); }
public List <StockTransferModel> GetAllStockTransfer() { List <StockTransferModel> lstST = new List <StockTransferModel>(); StockTransferModel objstock; string Query = "SELECT * FROM Stock_Transfer_Voucher"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objstock = new StockTransferModel(); objstock.ST_Id = DataFormat.GetInteger(dr["ST_Id"]); objstock.Series = dr["Series"].ToString(); objstock.SalesType = dr["SalesType"].ToString(); objstock.ST_Date = DataFormat.GetDateTime(dr["ST_Date"]); objstock.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]); objstock.BillNo = Convert.ToInt32(dr["BillNo"]); objstock.Party = dr["Party"].ToString(); objstock.MatCenter = dr["MatCentre"].ToString(); objstock.Narration = dr["Narration"].ToString(); //objsales. = Convert.ToDecimal(dr["TotalQty"]); //objsales.TotalAmount = Convert.ToDecimal(dr["TotalAmount"]); //objsales.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]); //SELECT ST Items string itemQuery = "SELECT * FROM Stock_Transfer_Items WHERE Stock_Id=" + objstock.ST_Id; System.Data.IDataReader drItem = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); objstock.StockItem_Voucher = new List <Item_VoucherModel>(); Item_VoucherModel objItemModel; while (drItem.Read()) { objItemModel = new Item_VoucherModel(); objItemModel.ParentId = DataFormat.GetInteger(drItem["StockId"]); objItemModel.Item_ID = DataFormat.GetInteger(drItem["ItemId"]); objItemModel.Item = drItem["Item"].ToString(); objItemModel.Price = Convert.ToDecimal(drItem["Price"]); objItemModel.Qty = Convert.ToDecimal(drItem["Qty"]); objItemModel.Unit = drItem["Unit"].ToString(); objItemModel.Amount = Convert.ToDecimal(drItem["Amount"]); objItemModel.TotalQty = Convert.ToDecimal(drItem["TotalQty"]); objItemModel.TotalAmount = Convert.ToDecimal(drItem["TotalAmount"]); objstock.StockItem_Voucher.Add(objItemModel); } //SELECT Bill Sundry Voucher items string bsQuery = "SELECT * FROM Trans_SalesReturn_BS WHERE StockId=" + objstock.ST_Id; System.Data.IDataReader drBS = _dbHelper.ExecuteDataReader(bsQuery, _dbHelper.GetConnObject()); objstock.StockBillSundry_Voucher = new List <BillSundry_VoucherModel>(); BillSundry_VoucherModel objBSModel; while (drBS.Read()) { objBSModel = new BillSundry_VoucherModel(); objBSModel.ParentId = DataFormat.GetInteger(drBS["StockId"]); objBSModel.BSId = DataFormat.GetInteger(drBS["BSId"]); objBSModel.BillSundry = drBS["BillSundry"].ToString(); objBSModel.Percentage = Convert.ToDecimal(drBS["Percentage"]); objBSModel.Amount = Convert.ToDecimal(drBS["Amount"]); objBSModel.TotalAmount = Convert.ToDecimal(drBS["TotalAmount"]); objstock.StockBillSundry_Voucher.Add(objBSModel); } lstST.Add(objstock); } return(lstST); }