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);
}
