public void AddMajorHandHeldCounterMainHoldToSap(string branchCode, string documentNo, string officerID1, string officerID2)
{
var counterHolds = GetHandHeldCounterMainHoldByDocumentNo(branchCode, documentNo);
string accountingYear = string.Empty;
string officerID = string.Empty;
SAPProxyIII.ZDD_HH_CHKSTOCKTable tables = new SAPProxyIII.ZDD_HH_CHKSTOCKTable();
using (var sapConnection = new SAP.Connector.SAPConnection(GlobalContext.SapDestination))
{
using (var prx = new SAPProxyIII.UWProxy())
{
prx.Connection = sapConnection;
foreach (var item in counterHolds)
{
var zdd = new SAPProxyIII.ZDD_HH_CHKSTOCK();
zdd.Iblnr = item.Iblnr;
zdd.Gjahr = item.Gjahr;
zdd.Zeili = item.Zeili;
zdd.Matnr = item.Matnr;
zdd.Ean11 = item.Ean11;
zdd.Maktx = item.Maktx;
zdd.Shelf = item.Shelf;
zdd.Bin_Code = item.BinCode;
zdd.Erfmg_Sku = item.ErfmgSku;
zdd.Erfme_Sku = item.ErfmeSku;
zdd.Ratio = item.Ratio;
zdd.Erfmg_Sales = item.ErfmgSales;
zdd.Erfme_Sales = item.ErfmeSales;
accountingYear = item.Gjahr;
officerID = item.Createuser;
tables.Add(zdd);
}
try
{
prx.Zdd_Handheld_Checkstock(accountingYear, documentNo, "X", officerID1, officerID1, ref tables);
using (var db = new DbManager(branchCode))
{
db.SetCommand(GetSql(33), db.Parameter("@DocumentNo", documentNo)).ExecuteNonQuery();
}
prx.CommitWork();
}
catch (Exception ex)
{
prx.RollbackWork();
throw ex;
}
}
}
}
public List <HandHeldCounterMainHold> GetHandHeldCounterMainHoldZDDHandHeldCheckStockFromSap(string branchCode, string iblnr, string Gjahr, string officerID)
{
using (var sapConnection = new SAP.Connector.SAPConnection(GlobalContext.SapDestination))
{
using (var prx = new SAPProxyIII.UWProxy())
{
prx.Connection = sapConnection;
SAPProxyIII.PERNR pernr = new SAPProxyIII.PERNR();
SAPProxyIII.ZDD_HH_CHKSTOCKTable tables = new SAPProxyIII.ZDD_HH_CHKSTOCKTable();
pernr.Pernr = officerID;
prx.Zdd_Handheld_Checkstock(Gjahr, iblnr, string.Empty, string.Empty, string.Empty, ref tables);
var zDDHandHeldCheckStockList = new List <HandHeldCounterMainHold>();
foreach (SAPProxyIII.ZDD_HH_CHKSTOCK item in tables)
{
var zdd = new HandHeldCounterMainHold();
zdd.Matnr = item.Matnr;
zdd.ProductCode = FormatedProductCode(item.Matnr);
zdd.Maktx = item.Maktx;
zdd.BinCode = item.Bin_Code;
zdd.ErfmeSales = item.Erfme_Sales;
zdd.UnitNameForSale = GetUnitByCode(branchCode, item.Erfme_Sales);
zdd.ErfmeSku = item.Erfme_Sku;
zdd.UnitNameForSKU = GetUnitByCode(branchCode, item.Erfme_Sku);
zdd.Iblnr = item.Iblnr;
zdd.Gjahr = item.Gjahr;
zdd.Zeili = item.Zeili;
zdd.Ean11 = item.Ean11;
zdd.Shelf = zdd.Shelf;
zdd.ErfmgSku = item.Erfmg_Sku;
zdd.Ratio = item.Ratio;
zdd.ErfmgSales = item.Erfmg_Sales;
zDDHandHeldCheckStockList.Add(zdd);
}
return(zDDHandHeldCheckStockList);
}
}
}