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
        }
Beispiel #3
0
        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
        }