protected static FR_L5RS_GRSPwAfP_1526_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5RS_GRSPwAfP_1526 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5RS_GRSPwAfP_1526_Array();
#region Get Return Shipment Positions
var returnShipmentPositions = cls_Get_ReturnShipmentPositions_for_PositionIDs.Invoke(Connection, Transaction, Parameter.SearchCriteria, securityTicket).Result;
#endregion
#region Get Articles
var articleIDs = returnShipmentPositions.Select(rsp => rsp.CMN_PRO_Product_RefID).Distinct().ToArray <Guid>();
var articles = new L3AR_GAfAL_0942[0];
var prices = new L3PR_GSPfPIL_1645[0];
if (articleIDs.Length != 0)
{
var parameterArticles = new P_L3AR_GAfAL_0942
{
ProductID_List = articleIDs
};
articles = cls_Get_Articles_for_ArticleList.Invoke(Connection, Transaction, parameterArticles, securityTicket).Result;
var parameterPrices = new P_L3PR_GSPfPIL_1645
{
ProductIDList = articleIDs
};
prices = cls_Get_StandardPrices_for_ProductIDList.Invoke(Connection, Transaction, parameterPrices, securityTicket).Result;
}
#endregion
#region Set Return Value
var returnElements = new List <L5RS_GRSPwAfP_1526>();
foreach (var position in returnShipmentPositions)
{
var returnElement = new L5RS_GRSPwAfP_1526
{
Article = articles.FirstOrDefault(a => a.CMN_PRO_ProductID == position.CMN_PRO_Product_RefID),
Price = prices.FirstOrDefault(a => a.ProductID == position.CMN_PRO_Product_RefID),
Position = position
};
returnElements.Add(returnElement);
}
returnValue.Result = returnElements.ToArray();
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_L5PO_GOEDPwAD_1719_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5PO_GOEDPwAD_1719_Array();
List <L5PO_GOEDPwAD_1719> list = new List <L5PO_GOEDPwAD_1719>();
var extraDemandProducts = cls_Get_Open_ExtraDemandProducts.Invoke(Connection, Transaction, securityTicket).Result;
L3AR_GAfAL_0942[] articles = new L3AR_GAfAL_0942[0];
L3PR_GSPfPIL_1645[] prices = new L3PR_GSPfPIL_1645[0];
if (extraDemandProducts.Count() != 0)
{
var articleIds = extraDemandProducts.Select(x => x.Product_RefID).Distinct().ToArray();
var articleParam = new P_L3AR_GAfAL_0942 {
ProductID_List = articleIds
};
articles = CL3_Articles.Atomic.Retrieval.cls_Get_Articles_for_ArticleList.Invoke(Connection, Transaction, articleParam, securityTicket).Result;
var priceParam = new P_L3PR_GSPfPIL_1645 {
ProductIDList = articleIds
};
prices = cls_Get_StandardPrices_for_ProductIDList.Invoke(Connection, Transaction, priceParam, securityTicket).Result;
}
L5PO_GOEDPwAD_1719 listItem = null;
foreach (var item in extraDemandProducts)
{
listItem = new L5PO_GOEDPwAD_1719();
listItem.ExtraDemandProduct = item;
listItem.Article = articles.Single(x => x.CMN_PRO_ProductID == item.Product_RefID);
listItem.Price = prices.Single(x => x.ProductID == item.Product_RefID);
list.Add(listItem);
}
returnValue.Result = list.ToArray();
return(returnValue);
#endregion UserCode
}
