protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5SR_PTSfSR Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var paramQCI = new P_L5SR_GQCIfRHId_1359()
{
HeaderID = Parameter.ReceiptHeaderID
};
var qualityControlItems = cls_Get_QualityControlItems_for_ReceiptHeaderID.Invoke(Connection, Transaction, paramQCI, securityTicket).Result;
Guid[] articleIDs = qualityControlItems.Select(x => x.ProductID).Distinct().ToArray();
var paramArticleStorage = new P_L3WH_GASfA_1924
{
ArticleID_List = articleIDs
};
var storages = CL3_Warehouse.Atomic.Retrieval.cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, paramArticleStorage, securityTicket).Result.
Where(x => x.QLShelfID != Guid.Empty && x.IsPointOfSalesArea == true);
foreach (var item in qualityControlItems)
{
var shelf = storages.FirstOrDefault(x => x.ArticleID == item.ProductID);
if (shelf == null || shelf.ShelfID == Guid.Empty)
{
continue;
}
var query = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query
{
LOG_RCP_Receipt_Position_QualityControlItem = item.LOG_RCP_Receipt_Position_QualityControlItem,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
};
var values = new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query
{
Target_WRH_Shelf_RefID = shelf.ShelfID
};
CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Position_QualityControlItem.Query.Update(Connection, Transaction, query, values);
}
return(returnValue);
#endregion UserCode
}
protected static FR_L3SP_GDSfP_1401 Execute(DbConnection Connection, DbTransaction Transaction, P_L3SP_GDSfP_1401 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3SP_GDSfP_1401();
//Put your code here
List <Guid> article = new List <Guid>()
{
Parameter.ArticleID
};
var storageParam = new P_L3WH_GASfA_1924();
storageParam.ArticleID_List = article.ToArray();
var storages = cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, storageParam, securityTicket).Result;
L3SP_GDSfP_1401 resultingSupplier = new L3SP_GDSfP_1401();
foreach (var storage in storages)
{
P_L3SP_GDSfS_1347 supplierParam = new P_L3SP_GDSfS_1347();
supplierParam.AreaID = storage.AreaID;
supplierParam.RackID = storage.RackID;
supplierParam.WarehouseID = storage.WarehouseID;
var supplier = cls_Get_Default_Supplier_from_Storage.Invoke(Connection, Transaction, supplierParam, securityTicket).Result;
if (supplier != null)
{
resultingSupplier.Supplier = supplier;
break;
}
}
returnValue.Result = resultingSupplier;
return(returnValue);
#endregion UserCode
}
protected static FR_L3PR_GAwSPfT_1002_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3PR_GAwSPfT_1002 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3PR_GAwSPfT_1002_Array();
//Put your code here
List <L3PR_GAwSPfT_1002> retVal = new List <L3PR_GAwSPfT_1002>();
P_L3WH_GASfA_1924 par = new P_L3WH_GASfA_1924();
par.ArticleID_List = Parameter.ArticleID_List.Select(i => i).ToArray();
var articleStorages = cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, par, securityTicket).Result.Where(i => i.ShelfID != Guid.Empty).ToList();
#region Get All StoragePlaces for TenantID
var shelfIDs = articleStorages.Select(i => i.ShelfID).Distinct().ToArray();
var productIDs = articleStorages.Select(i => i.ArticleID).Distinct().ToArray();
var filterCriteria = new P_L3WH_GSPfFC_1504()
{
WarehouseGroupID = null,
WarehouseID = null,
AreaID = null,
RackID = null,
UseShelfIDList = shelfIDs.Length != 0,
ShelfIDs = shelfIDs.Length == 0 ? new Guid[] { Guid.Empty } : shelfIDs,
UseProductIDList = productIDs.Length != 0,
ProductIDs = productIDs.Length == 0 ? new Guid[] { Guid.Empty } : productIDs,
BottomShelfQuantity = null,
TopShelfQuantity = null,
UseProductTrackingInstanceIDList = false,
ProductTrackingInstanceIDs = new Guid[] { Guid.Empty },
StartExpirationDate = null,
EndExpirationDate = null
};
var allStoragePlacesForTenant = cls_Get_StoragePlaces_for_FilterCriteria.Invoke(Connection, Transaction, filterCriteria, securityTicket).Result;
#endregion
L3PR_GAwSPfT_1002 retValItem;
L3WH_GSPfFC_1504 storagePlace;
foreach (var storage in articleStorages)
{
retValItem = new L3PR_GAwSPfT_1002();
retValItem.ArticleID = storage.ArticleID;
retValItem.ShelfID = storage.ShelfID;
retValItem.StoragePlace = "-";
storagePlace = allStoragePlacesForTenant.Where(i => i.LOG_WRH_ShelfID == storage.ShelfID).FirstOrDefault();
if (storagePlace != null && !String.IsNullOrEmpty(storagePlace.Area_Name) &&
!String.IsNullOrEmpty(storagePlace.Rack_Name) &&
!String.IsNullOrEmpty(storagePlace.Shelf_Name))
{
retValItem.StoragePlace = String.Format("{0}-{1}-{2}-{3}",
storagePlace.WarehouseCoordinateCode,
storagePlace.AreaCoordinateCode,
storagePlace.RackCoordinateCode,
storagePlace.ShelfCoordinateCode);
}
retVal.Add(retValItem);
}
returnValue.Result = retVal.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_L5AR_GAADfAL_1426_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_GAADfAL_1426 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5AR_GAADfAL_1426_Array();
if (Parameter.ProductITLList != null && Parameter.ProductITLList.Length > 0)
{
P_L3AR_GAIDfAITLs_1641 articleParam = new P_L3AR_GAIDfAITLs_1641();
articleParam.ProductITLList = Parameter.ProductITLList;
var articles = cls_Get_ArticleID_for_ArticleITLs.Invoke(Connection, Transaction, articleParam, securityTicket).Result;
Guid[] productIDList = articles.Select(x => x.CMN_PRO_ProductID).ToArray();
#region Get Msr
var msrForProducts = cls_Get_MSR_for_ProductIDList.Invoke(Connection, Transaction, new P_L3AS_GSMRfPL_1508 {
ProductIDList = productIDList
}, securityTicket).Result;
#endregion
#region Get storage data for ariticle list
List <L5AR_GAADfAL_1426> returnValuesList = new List <L5AR_GAADfAL_1426>();
L3WH_GASfA_1924[] storages = new L3WH_GASfA_1924[] { };
Guid[] articlesWithExpectedDelivery = new Guid[] { };
if (productIDList != null && productIDList.Count() > 0)
{
var storageParam = new P_L3WH_GASfA_1924();
storageParam.ArticleID_List = productIDList;
storages = cls_Get_ArticleStorages_for_ArticleIDList.Invoke(Connection, Transaction, storageParam, securityTicket).Result;
var expectedDeliveryParam = new P_L3AR_GIHEDfPL_0911 {
ProductIDList = productIDList
};
articlesWithExpectedDelivery = cls_Get_If_Has_Expected_Delivery_for_ProductIDList.Invoke(
Connection, Transaction, expectedDeliveryParam, securityTicket).Result.Select(x => x.ProductID).ToArray();
}
foreach (var item in productIDList)
{
var storage = storages.FirstOrDefault(x => x.ArticleID == item);
#region get supplier data
string supplierName = String.Empty;
Guid supplierID = Guid.Empty;
string storagePlace = String.Empty;
if (storage != null)
{
storagePlace = storage.WarehouseCode + storage.AreaCode + storage.RackCode + storage.ShelfCode;
P_L3SP_GDSfS_1347 supplierParam = new P_L3SP_GDSfS_1347();
supplierParam.AreaID = storage.AreaID;
supplierParam.RackID = storage.RackID;
supplierParam.WarehouseID = storage.WarehouseID;
var supplier = cls_Get_Default_Supplier_from_Storage.Invoke(Connection, Transaction, supplierParam, securityTicket).Result;
supplierName = supplier.SupplierName;
supplierID = supplier.SupplierID;
}
#endregion
#region stock quantities
P_L3AR_GSQfP_1220 stockParam = new P_L3AR_GSQfP_1220();
stockParam.ProductID = item;
var stockQuantities = cls_Get_StockQuantities_for_ProductID.Invoke(Connection, Transaction, stockParam, securityTicket).Result;
#endregion
var productMSR = msrForProducts.SingleOrDefault(x => x.ProductID == item);
#region form output parameter
L5AR_GAADfAL_1426 result = new L5AR_GAADfAL_1426();
result.ProductID = item;
result.SupplierID = supplierID;
result.SupplierName = supplierName;
result.StockQuantities = stockQuantities;
result.StoragePlace = storagePlace;
result.ProductITL = articles.SingleOrDefault(x => x.CMN_PRO_ProductID == item).ProductITL;
var expDel = articlesWithExpectedDelivery.SingleOrDefault(x => x == item);
result.HasExpectedDelivery = (expDel == Guid.Empty) ? false : true;
result.MSR = (productMSR != null) ? productMSR.MSR : (double)0.0;
returnValuesList.Add(result);
#endregion
}
#endregion
returnValue.Result = returnValuesList.ToArray();
}
return(returnValue);
#endregion UserCode
}
