protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2SA_SSCA_1503 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { var returnValue = new FR_Guid(); var item = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment(); if (Parameter.LOG_WRH_Shelf_ContentAdjustmentID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.LOG_WRH_Shelf_ContentAdjustmentID); if (result.Status != FR_Status.Success || item.LOG_WRH_Shelf_ContentAdjustmentID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } if (Parameter.IsDeleted == true) { item.IsDeleted = true; return(new FR_Guid(item.Save(Connection, Transaction), item.LOG_WRH_Shelf_ContentAdjustmentID)); } //Creation specific parameters (Tenant, Account ... ) if (Parameter.LOG_WRH_Shelf_ContentAdjustmentID == Guid.Empty) { item.Tenant_RefID = securityTicket.TenantID; Parameter.LOG_WRH_Shelf_ContentAdjustmentID = Guid.NewGuid(); } item.ShelfContent_RefID = Parameter.ShelfContent_RefID; item.QuantityChangedAmount = Parameter.QuantityChangedAmount; item.QuantityChangedDate = Parameter.QuantityChangedDate; item.IsInitialReceipt = Parameter.IsInitialReceipt; item.IfInitialReceipt_ReceiptPosition_QualityControlItem_RefID = Parameter.IfInitialReceipt_ReceiptPosition_QualityControlItem_RefID; item.IsInventoryJobCorrection = Parameter.IsInventoryJobCorrection; item.IfInventoryJobCorrection_InvenoryJobProcess_RefID = Parameter.IfInventoryJobCorrection_InvenoryJobProcess_RefID; item.IsShipmentWithdrawal = Parameter.IsShipmentWithdrawal; item.IfShipmentWithdrawal_ShipmentPosition_RefID = Parameter.IfShipmentWithdrawal_ShipmentPosition_RefID; item.IsManualCorrection = Parameter.IsManualCorrection; item.IfManualCorrection_InventoryChangeReason_RefID = Parameter.IfManualCorrection_InventoryChangeReason_RefID; item.PerformedBy_Account_RefID = Parameter.PerformedBy_Account_RefID; item.PerformedAt_Date = Parameter.PerformedAt_Date; item.ContentAdjustmentComment = Parameter.ContentAdjustmentComment; return(new FR_Guid(item.Save(Connection, Transaction), item.LOG_WRH_Shelf_ContentAdjustmentID)); }
protected static FR_L6CN_SCNaURS_0910 Execute(DbConnection Connection, DbTransaction Transaction, P_L6CN_SCNaURS_0910 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L6CN_SCNaURS_0910(); returnValue.Result = new L6CN_SCNaURS_0910(); var newShipmentHeaderGuids = new List <Guid>(); var shipmentPositionsToBeCredited = new List <Guid>(); var newShipmentPositions = new List <P_L5RS_CSaRSPfH_0449a>(); foreach (var header in Parameter.ShipmentHeaders) { var shipmentHeader = new ORM_LOG_SHP_Shipment_Header(); var shipmentHeaderPositions = new List <ORM_LOG_SHP_Shipment_Position>(); #region Load Shipment Header and Positions var result = shipmentHeader.Load(Connection, Transaction, header.ShipmentHeaderID); if (result.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } shipmentHeaderPositions = ORM_LOG_SHP_Shipment_Position.Query.Search( Connection, Transaction, new ORM_LOG_SHP_Shipment_Position.Query() { LOG_SHP_Shipment_Header_RefID = header.ShipmentHeaderID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }); #endregion L5RS_CSaRSH_0244 newHeader = null; decimal updatedHeaderTotalValue = 0; foreach (var position in shipmentHeaderPositions) { var positionToBeCredited = header.ShipmentPositions.FirstOrDefault(hsp => hsp.ShipmentPositionID == position.LOG_SHP_Shipment_PositionID); // Split Shipment in case that not all positions of one header are selected for crediting // or in case that selected positions quantities are edited. #region Create New Header and Position Object if position is not selected or dirty if (positionToBeCredited == null || positionToBeCredited.Quantity != positionToBeCredited.OriginalQuantity) { if (Parameter.ReturnToStock == false) { #region Create New Header if (newHeader == null) { var newHeaderParameter = new P_L5RS_CSaRSH_0244() { SupplierID = Parameter.SupplierId }; var createResult = cls_Create_Shipment_and_ReturnShipment_Header.Invoke(Connection, Transaction, newHeaderParameter, securityTicket); if (createResult.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } newHeader = createResult.Result; newShipmentHeaderGuids.Add(newHeader.ShipmentHeaderID); } #endregion #region Set New Position Object P_L5RS_CSaRSPfH_0449a newPosition; if (positionToBeCredited == null) { var productTrackingInstance = cls_Get_ProductTrackingInstance_for_StockReceiptPosition.Invoke( Connection, Transaction, new P_L5SR_GPTIfSRP_1322() { ReceiptPositionsID = header.ShipmentPositions[0].ReceiptPositionID }, securityTicket).Result; newPosition = new P_L5RS_CSaRSPfH_0449a() { Quantity = Convert.ToInt32(position.QuantityToShip), PricePerUnit = position.ShipmentPosition_PricePerUnitValueWithoutTax, ProductId = position.CMN_PRO_Product_RefID, ReceiptPositionId = header.ShipmentPositions[0].ReceiptPositionID, ReturnPolicyId = header.ShipmentPositions[0].ReturnPolicyID, ShipmentHeaderID = newHeader.ShipmentHeaderID, ReturnShipmentHeaderID = newHeader.ReturnShipmentHeaderID, ProductTrackingInstance = productTrackingInstance.LOG_ProductTrackingInstanceID, ShelfContentID = productTrackingInstance.LOG_WRH_Shelf_ContentID }; } else { var productTrackingInstance = cls_Get_ProductTrackingInstance_for_StockReceiptPosition.Invoke( Connection, Transaction, new P_L5SR_GPTIfSRP_1322() { ReceiptPositionsID = positionToBeCredited.ReceiptPositionID }, securityTicket).Result; newPosition = new P_L5RS_CSaRSPfH_0449a() { Quantity = positionToBeCredited.OriginalQuantity - positionToBeCredited.Quantity, PricePerUnit = positionToBeCredited.OriginalTotalValue / positionToBeCredited.OriginalQuantity, ProductId = positionToBeCredited.ProductId, ReceiptPositionId = positionToBeCredited.ReceiptPositionID, ReturnPolicyId = positionToBeCredited.ReturnPolicyID, ShipmentHeaderID = newHeader.ShipmentHeaderID, ReturnShipmentHeaderID = newHeader.ReturnShipmentHeaderID, ProductTrackingInstance = productTrackingInstance.LOG_ProductTrackingInstanceID, ShelfContentID = productTrackingInstance.LOG_WRH_Shelf_ContentID }; } newShipmentPositions.Add(newPosition); #endregion } else { #region Return to Stock //The difference in the credited quantity compared to the returned position is taken back to stock. if (positionToBeCredited == null) { var productTrackingInstance = cls_Get_ProductTrackingInstance_for_StockReceiptPosition.Invoke( Connection, Transaction, new P_L5SR_GPTIfSRP_1322() { ReceiptPositionsID = header.ShipmentPositions[0].ReceiptPositionID }, securityTicket).Result; CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content shelfContent = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content(); shelfContent.Load(Connection, Transaction, productTrackingInstance.LOG_WRH_Shelf_ContentID); shelfContent.Quantity_Current = Convert.ToInt32(position.QuantityToShip); shelfContent.Save(Connection, Transaction); CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment shelfContentAdjustment = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment(); shelfContentAdjustment.ShelfContent_RefID = shelfContent.Shelf_RefID; shelfContentAdjustment.QuantityChangedAmount = shelfContent.Quantity_Current; shelfContentAdjustment.QuantityChangedDate = DateTime.Now; shelfContentAdjustment.Creation_Timestamp = DateTime.Now; shelfContentAdjustment.Tenant_RefID = securityTicket.TenantID; shelfContentAdjustment.Save(Connection, Transaction); } else { var productTrackingInstance = cls_Get_ProductTrackingInstance_for_StockReceiptPosition.Invoke( Connection, Transaction, new P_L5SR_GPTIfSRP_1322() { ReceiptPositionsID = positionToBeCredited.ReceiptPositionID }, securityTicket).Result; CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content shelfContent = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content(); shelfContent.Load(Connection, Transaction, productTrackingInstance.LOG_WRH_Shelf_ContentID); shelfContent.Quantity_Current = positionToBeCredited.OriginalQuantity - positionToBeCredited.Quantity; shelfContent.Save(Connection, Transaction); CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment shelfContentAdjustment = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment(); shelfContentAdjustment.ShelfContent_RefID = shelfContent.Shelf_RefID; shelfContentAdjustment.QuantityChangedAmount = shelfContent.Quantity_Current; shelfContentAdjustment.QuantityChangedDate = DateTime.Now; shelfContentAdjustment.Creation_Timestamp = DateTime.Now; shelfContentAdjustment.Tenant_RefID = securityTicket.TenantID; shelfContentAdjustment.Save(Connection, Transaction); } #endregion } } #endregion if (positionToBeCredited == null) { #region Cancel Position #region Get Account var account = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, USR_AccountID = securityTicket.AccountID }).FirstOrDefault(); #endregion position.IsCancelled = true; position.CancelledOnDate = DateTime.Now; position.CancelledBy_BusinessParticipant_RefID = account.BusinessParticipant_RefID; var resultUpdate = position.Save(Connection, Transaction); if (resultUpdate.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } #endregion } else { shipmentPositionsToBeCredited.Add(positionToBeCredited.ReturnShipmentPositionID); updatedHeaderTotalValue += positionToBeCredited.TotalValue; #region Update Position if data is dirty if (positionToBeCredited.Quantity != positionToBeCredited.OriginalQuantity || positionToBeCredited.TotalValue != positionToBeCredited.OriginalTotalValue) { position.QuantityToShip = positionToBeCredited.Quantity; position.ShipmentPosition_ValueWithoutTax = positionToBeCredited.TotalValue; var resultUpdate = position.Save(Connection, Transaction); if (resultUpdate.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } } #endregion } } #region Update shipmentHeader #region Create Credited Status History // fetch 'credited' status id var returnedStatusId = ORM_LOG_SHP_Shipment_Status.Query.Search( Connection, Transaction, new ORM_LOG_SHP_Shipment_Status.Query() { GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EShipmentStatus.Credited), Tenant_RefID = securityTicket.TenantID }).FirstOrDefault().LOG_SHP_Shipment_StatusID; // fetch Status History 'credited by' User Account var performedByAccount = ORM_USR_Account.Query.Search( Connection, Transaction, new ORM_USR_Account.Query() { USR_AccountID = securityTicket.AccountID }) .FirstOrDefault(); // create status Shipment Status history entry var statusHistoryCredited = new ORM_LOG_SHP_Shipment_StatusHistory(); statusHistoryCredited.Creation_Timestamp = DateTime.Now; statusHistoryCredited.IsDeleted = false; statusHistoryCredited.LOG_SHP_Shipment_Header_RefID = shipmentHeader.LOG_SHP_Shipment_HeaderID; statusHistoryCredited.LOG_SHP_Shipment_Status_RefID = returnedStatusId; statusHistoryCredited.LOG_SHP_Shipment_StatusHistoryID = Guid.NewGuid(); statusHistoryCredited.PerformedBy_BusinessParticipant_RefID = performedByAccount == null ? Guid.Empty : performedByAccount.BusinessParticipant_RefID; statusHistoryCredited.Tenant_RefID = securityTicket.TenantID; var resultSave = statusHistoryCredited.Save(Connection, Transaction); if (resultSave.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } #endregion shipmentHeader.ShipmentType_RefID = statusHistoryCredited.LOG_SHP_Shipment_StatusHistoryID; shipmentHeader.ShipmentHeader_ValueWithoutTax = updatedHeaderTotalValue; resultSave = shipmentHeader.Save(Connection, Transaction); if (resultSave.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } #endregion } #region Create New Positions foreach (var shipmentHeaderId in newShipmentHeaderGuids) { var positions = new P_L5RS_CSaRSPfH_0449(); positions.Positions = newShipmentPositions.FindAll(nsp => nsp.ShipmentHeaderID == shipmentHeaderId).ToArray(); var returnShipment = new P_L5RS_SRSHaP_0807a() { CreateNewHeader = false, ShipmentHeader = null, ShipmentPositions = positions }; var savePositionsInputParameter = new P_L5RS_SRSHaP_0807() { ReturnShipments = new P_L5RS_SRSHaP_0807a[] { returnShipment } }; var resultCreate = cls_Save_ReturnShipment_Header_and_Position.Invoke(Connection, Transaction, savePositionsInputParameter, securityTicket); if (resultCreate.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } } #endregion #region Save CreditNote Header and Positions var inputParameter = new P_L5RS_CNfRS_1119() { headerId = Guid.Empty, headerNumber = Parameter.CreditNoteHeaderNumber, headerValue = Parameter.CreditNoteHeaderValue, currencyRef = Parameter.CreditNoteHeaderCurrencyId, creditNoteDate = Parameter.CreditNoteHeaderDate, returnShipmentPositions = shipmentPositionsToBeCredited.ToArray(), receiptPositions = null }; var resultCreditNote = cls_Save_CreditNote_for_ReturnShipment.Invoke(Connection, Transaction, inputParameter, securityTicket); if (resultCreditNote.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; return(returnValue); } #endregion returnValue.Status = FR_Status.Success; returnValue.Result.CreditNoteHeaderId = resultCreditNote.Result; return(returnValue); #endregion UserCode }
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L3WH_SSCA_1732 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Bool(); returnValue.Result = false; double adjustedQuantity = 0.0; CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment adjustment = null; CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment_TrackingInstance contentAdjustmentTrackingInstance = null; CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content shelfContent = null; if (Parameter.Adjustments == null) { return(returnValue); } var adjustmentsShelfContent = new Dictionary <Guid, Double>(); #region Adjustments without TrackingInstances foreach (var item in Parameter.Adjustments.Where(x => x.TrackingInstanceID == Guid.Empty)) { var productTrackingInstaces = CL1_LOG_WRH.ORM_LOG_WRH_ShelfContent_2_TrackingInstance.Query.Search(Connection, Transaction, new CL1_LOG_WRH.ORM_LOG_WRH_ShelfContent_2_TrackingInstance.Query { LOG_WRH_Shelf_Content_RefID = item.ShelfContentID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).ToArray(); shelfContent = CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content.Query.Search(Connection, Transaction, new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content.Query() { LOG_WRH_Shelf_ContentID = item.ShelfContentID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).Single(); double shelfContent_CurrentQuantity_Minus_TrackingInstances_CurrentQuantity = shelfContent.Quantity_Current; if (productTrackingInstaces != null) { foreach (var assignment in productTrackingInstaces) { var productTrackingInstancesByShelfContent = CL1_LOG.ORM_LOG_ProductTrackingInstance.Query.Search(Connection, Transaction, new CL1_LOG.ORM_LOG_ProductTrackingInstance.Query { LOG_ProductTrackingInstanceID = assignment.LOG_ProductTrackingInstance_RefID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).Single(); shelfContent_CurrentQuantity_Minus_TrackingInstances_CurrentQuantity -= productTrackingInstancesByShelfContent.CurrentQuantityOnTrackingInstance; } } adjustedQuantity = item.AdjustedQuantity - shelfContent_CurrentQuantity_Minus_TrackingInstances_CurrentQuantity; adjustment = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment { LOG_WRH_Shelf_ContentAdjustmentID = item.IsRelocation ? item.RelocationAdjustmentID : Guid.NewGuid(), ShelfContent_RefID = item.ShelfContentID, QuantityChangedAmount = adjustedQuantity, QuantityChangedDate = DateTime.Now, IsManualCorrection = item.IsManualCorrection, IfManualCorrection_InventoryChangeReason_RefID = item.IfManualCorrection_InventoryChangeReason_RefID, IsRelocation = item.IsRelocation, IfRelocation_CorrespondingAdjustment_RefID = item.IfRelocation_CorrespondingAdjustment_RefID, IsShipmentWithdrawal = item.IsShipmentWithdrawal, IfShipmentWithdrawal_ShipmentPosition_RefID = item.IfShipmentWithdrawal_ShipmentPosition_RefID, PerformedAt_Date = DateTime.Now, PerformedBy_Account_RefID = securityTicket.AccountID, Creation_Timestamp = DateTime.Now, Tenant_RefID = securityTicket.TenantID }; adjustment.Save(Connection, Transaction); if (adjustmentsShelfContent.ContainsKey(item.ShelfContentID)) { adjustmentsShelfContent[item.ShelfContentID] += adjustedQuantity; } else { adjustmentsShelfContent[item.ShelfContentID] = adjustedQuantity; } } #endregion #region Adjustments with TrackingInstances // Adjustements that have tracking instances and memorize relative adjustement values by ShelfID foreach (var item in Parameter.Adjustments.Where(x => x.TrackingInstanceID != Guid.Empty)) { var productTrackingInstance = new CL1_LOG.ORM_LOG_ProductTrackingInstance(); productTrackingInstance.Load(Connection, Transaction, item.TrackingInstanceID); if (productTrackingInstance.LOG_ProductTrackingInstanceID == Guid.Empty || productTrackingInstance.IsDeleted == true) { throw new Exception("Wrong Product tracking instance"); } adjustedQuantity = item.AdjustedQuantity - productTrackingInstance.CurrentQuantityOnTrackingInstance; adjustment = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment { LOG_WRH_Shelf_ContentAdjustmentID = item.IsRelocation ? item.RelocationAdjustmentID : Guid.NewGuid(), ShelfContent_RefID = item.ShelfContentID, QuantityChangedAmount = adjustedQuantity, QuantityChangedDate = DateTime.Now, IsManualCorrection = item.IsManualCorrection, IfManualCorrection_InventoryChangeReason_RefID = item.IfManualCorrection_InventoryChangeReason_RefID, IsRelocation = item.IsRelocation, IfRelocation_CorrespondingAdjustment_RefID = item.IfRelocation_CorrespondingAdjustment_RefID, IsShipmentWithdrawal = item.IsShipmentWithdrawal, IfShipmentWithdrawal_ShipmentPosition_RefID = item.IfShipmentWithdrawal_ShipmentPosition_RefID, PerformedAt_Date = DateTime.Now, PerformedBy_Account_RefID = securityTicket.AccountID, Creation_Timestamp = DateTime.Now, Tenant_RefID = securityTicket.TenantID, }; adjustment.Save(Connection, Transaction); contentAdjustmentTrackingInstance = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment_TrackingInstance { LOG_WRH_Shelf_ContentAdjustment_TrackingInstanceID = Guid.NewGuid(), Creation_Timestamp = DateTime.Now, Tenant_RefID = securityTicket.TenantID, LOG_ProductTrackingInstance_RefID = item.TrackingInstanceID, LOG_WRH_Shelf_ContentAdjustment_RefID = adjustment.LOG_WRH_Shelf_ContentAdjustmentID, QuantityChangedAmount = item.AdjustedQuantity }; contentAdjustmentTrackingInstance.Save(Connection, Transaction); productTrackingInstance.CurrentQuantityOnTrackingInstance = item.AdjustedQuantity; productTrackingInstance.Save(Connection, Transaction); if (adjustmentsShelfContent.ContainsKey(item.ShelfContentID)) { adjustmentsShelfContent[item.ShelfContentID] += adjustedQuantity; } else { adjustmentsShelfContent[item.ShelfContentID] = adjustedQuantity; } } #endregion // update shelf content for all adjustments foreach (var item in adjustmentsShelfContent.Keys) { shelfContent = CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content.Query.Search(Connection, Transaction, new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content.Query() { LOG_WRH_Shelf_ContentID = item, IsDeleted = false, Tenant_RefID = securityTicket.TenantID }).Single(); shelfContent.Quantity_Current += adjustmentsShelfContent[item]; shelfContent.Save(Connection, Transaction); } returnValue.Result = true; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3WH_SRIC_1421 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); #region LOG_RCP_Receipt_Headers (Update) var receiptHeader = CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Header.Query.Search(Connection, Transaction, new CL1_LOG_RCP.ORM_LOG_RCP_Receipt_Header.Query() { LOG_RCP_Receipt_HeaderID = Parameter.ReceiptHeaderID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).Single(); receiptHeader.IsTakenIntoStock = true; receiptHeader.TakenIntoStock_ByAccount_RefID = securityTicket.AccountID; receiptHeader.TakenIntoStock_AtDate = DateTime.Now; receiptHeader.DeliverySlip_Date = Parameter.DeliveryDate; receiptHeader.DeliverySlip_Number = Parameter.DeliveryNumber; receiptHeader.Save(Connection, Transaction); #endregion #region ORD_PRC_ExpectedDelivery_Headers (Update) var expectedDeliveryHeader = CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Header.Query.Search(Connection, Transaction, new CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Header.Query() { ORD_PRC_ExpectedDelivery_HeaderID = receiptHeader.ExpectedDeliveryHeader_RefID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); if (expectedDeliveryHeader != default(CL1_ORD_PRC.ORM_ORD_PRC_ExpectedDelivery_Header)) { expectedDeliveryHeader.IsDeliveryOpen = false; expectedDeliveryHeader.IsDeliveryClosed = true; expectedDeliveryHeader.Save(Connection, Transaction); } #endregion #region Receipt_Positions, Position_QualityControlItems ProcurementOrderPositions_and_ProcurementOrderHeader_for_ReceiptHeaderID (Read) var positionsAndQualityControlItems = CL3_Warehouse.Atomic.Retrieval.cls_Get_ReceiptPositions_and_QualityControlItems_for_HeaderID. Invoke(Connection, Transaction, new CL3_Warehouse.Atomic.Retrieval.P_L3WH_GRPaQCIfH_0905 { ReceiptHeaderID = Parameter.ReceiptHeaderID }, securityTicket).Result; var procurementOrderPositions = CL3_Warehouse.Atomic.Retrieval.cls_Get_ProcurementOrderPositions_and_ProcurementOrderHeader_for_ReceiptHeaderID. Invoke(Connection, Transaction, new CL3_Warehouse.Atomic.Retrieval.P_L3WH_GPOPaPOHfRH_0918 { ReceiptHeaderID = Parameter.ReceiptHeaderID }, securityTicket).Result; #endregion #region LOG_WRH_Shelf_Contents (Save) foreach (var item in positionsAndQualityControlItems) { #region ORM_LOG_WRH_Shelf_Content var shelfContent = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content(); shelfContent.LOG_WRH_Shelf_ContentID = Guid.NewGuid(); shelfContent.Shelf_RefID = item.Target_WRH_Shelf_RefID; shelfContent.Quantity_Current = item.Quantity; shelfContent.Quantity_Initial = item.Quantity; shelfContent.PlacedIntoStock_Date = DateTime.Now; // WithoutProcurement -needed when called from Backoffice for return shipments if (Parameter.WithoutProcurement == false) { var procurementPosition = procurementOrderPositions.Where(x => x.LOG_RCP_Receipt_PositionID == item.Receipt_Position_RefID).Single(); shelfContent.ReceivedAsFulfillmentOf_ProcurementOrderHeader_RefID = procurementPosition.ORD_PRC_ProcurementOrder_HeaderID; shelfContent.ReceivedAsFulfillmentOf_ProcurementOrderPosition_RefID = procurementPosition.ORD_PRC_ProcurementOrder_PositionID; shelfContent.R_ProcurementValue = procurementPosition.Position_ValueTotal; shelfContent.R_ProcurementValue_Currency_RefID = procurementPosition.ProcurementOrder_Currency_RefID; } shelfContent.Product_RefID = item.ReceiptPosition_Product_RefID; shelfContent.R_FreeQuantity = item.Quantity; shelfContent.Creation_Timestamp = DateTime.Now; shelfContent.Tenant_RefID = securityTicket.TenantID; shelfContent.Save(Connection, Transaction); #endregion #region LOG_WRH_Shelf_ContentAdjustments var contentAdjustment = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment(); contentAdjustment.LOG_WRH_Shelf_ContentAdjustmentID = Guid.NewGuid(); contentAdjustment.ShelfContent_RefID = shelfContent.LOG_WRH_Shelf_ContentID; contentAdjustment.QuantityChangedAmount = item.Quantity; contentAdjustment.QuantityChangedDate = DateTime.Now; contentAdjustment.IsInitialReceipt = true; contentAdjustment.IfInitialReceipt_ReceiptPosition_QualityControlItem_RefID = item.LOG_RCP_Receipt_Position_QualityControlItem; contentAdjustment.IsInventoryJobCorrection = false; contentAdjustment.IsShipmentWithdrawal = false; contentAdjustment.IsManualCorrection = false; contentAdjustment.PerformedBy_Account_RefID = securityTicket.AccountID; contentAdjustment.PerformedAt_Date = DateTime.Now; contentAdjustment.ContentAdjustmentComment = "Product is being added on the shelf after intake confirmation of stock receipt"; contentAdjustment.Tenant_RefID = securityTicket.TenantID; contentAdjustment.Creation_Timestamp = DateTime.Now; contentAdjustment.Save(Connection, Transaction); #endregion bool isTrackable = (!String.IsNullOrEmpty(item.BatchNumber) || (DateTime.MinValue != item.ExpiryDate)); if (isTrackable) { #region ORM_LOG_ProductTrackingInstance var trackingInstance = new CL1_LOG.ORM_LOG_ProductTrackingInstance(); trackingInstance.LOG_ProductTrackingInstanceID = Guid.NewGuid(); trackingInstance.TrackingInstanceTakenFromSourceTrackingInstance_RefID = Guid.Empty; trackingInstance.TrackingCode = String.Empty; trackingInstance.SerialNumber = String.Empty; trackingInstance.BatchNumber = item.BatchNumber; trackingInstance.OwnedBy_BusinessParticipant_RefID = Guid.Empty; //this is important if we want to persist owner of product (mobile phone in a service) trackingInstance.CMN_PRO_Product_RefID = item.ReceiptPosition_Product_RefID;; trackingInstance.CMN_PRO_Product_Release_RefID = Guid.Empty; trackingInstance.CMN_PRO_Product_Variant_RefID = Guid.Empty; trackingInstance.ExpirationDate = item.ExpiryDate; trackingInstance.InitialQuantityOnTrackingInstance = item.Quantity; trackingInstance.CurrentQuantityOnTrackingInstance = item.Quantity; trackingInstance.R_ReservedQuantity = 0; trackingInstance.R_FreeQuantity = item.Quantity; trackingInstance.Creation_Timestamp = DateTime.Now; trackingInstance.Tenant_RefID = securityTicket.TenantID; trackingInstance.Save(Connection, Transaction); #endregion #region ORM_LOG_ProductTrackingInstance_HistoryEntry var trackingInstanceHistory = new CL1_LOG.ORM_LOG_ProductTrackingInstance_HistoryEntry(); trackingInstanceHistory.LOG_ProductTrackingInstance_HistoryEntryID = Guid.NewGuid(); trackingInstanceHistory.ProductTrackingInstance_RefID = trackingInstance.LOG_ProductTrackingInstanceID; trackingInstanceHistory.HistoryEntry_Text = "Product is being added on the shelf after intake confirmation of stock receipt"; trackingInstanceHistory.Creation_Timestamp = DateTime.Now; trackingInstanceHistory.Tenant_RefID = securityTicket.TenantID; trackingInstanceHistory.Save(Connection, Transaction); #endregion #region ORM_LOG_WRH_Shelf_ContentAdjustment_TrackingInstance var adjustment2tracking = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment_TrackingInstance(); adjustment2tracking.LOG_WRH_Shelf_ContentAdjustment_TrackingInstanceID = Guid.NewGuid(); adjustment2tracking.LOG_ProductTrackingInstance_RefID = trackingInstance.LOG_ProductTrackingInstanceID; adjustment2tracking.LOG_WRH_Shelf_ContentAdjustment_RefID = contentAdjustment.LOG_WRH_Shelf_ContentAdjustmentID; adjustment2tracking.QuantityChangedAmount = item.Quantity; adjustment2tracking.Creation_Timestamp = DateTime.Now; adjustment2tracking.Tenant_RefID = securityTicket.TenantID; adjustment2tracking.Save(Connection, Transaction); #endregion #region ORM_LOG_WRH_ShelfContent_2_TrackingInstance var shelf2tracking = new CL1_LOG_WRH.ORM_LOG_WRH_ShelfContent_2_TrackingInstance(); shelf2tracking.AssignmentID = Guid.NewGuid(); shelf2tracking.LOG_ProductTrackingInstance_RefID = trackingInstance.LOG_ProductTrackingInstanceID; shelf2tracking.LOG_WRH_Shelf_Content_RefID = shelfContent.LOG_WRH_Shelf_ContentID; shelf2tracking.Creation_Timestamp = DateTime.Now; shelf2tracking.Tenant_RefID = securityTicket.TenantID; shelf2tracking.Save(Connection, Transaction); #endregion } } #endregion return(returnValue); #endregion UserCode }
protected static FR_L3WH_SSCfP_1635 Execute(DbConnection Connection, DbTransaction Transaction, P_L3WH_SSCfP_1635 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L3WH_SSCfP_1635(); //Put your code here #region create shelf content var shelfContent = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content(); shelfContent.LOG_WRH_Shelf_ContentID = Guid.NewGuid(); shelfContent.Shelf_RefID = Parameter.ShelfID; shelfContent.Quantity_Current = Parameter.Quantity; shelfContent.Quantity_Initial = Parameter.Quantity; shelfContent.Product_RefID = Parameter.ProductID; shelfContent.R_FreeQuantity = Parameter.Quantity; shelfContent.IsLocked = false; shelfContent.Creation_Timestamp = DateTime.Now; shelfContent.Tenant_RefID = securityTicket.TenantID; shelfContent.Save(Connection, Transaction); #endregion #region LOG_WRH_Shelf_ContentAdjustments var contentAdjustment = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment(); contentAdjustment.LOG_WRH_Shelf_ContentAdjustmentID = Guid.NewGuid(); contentAdjustment.ShelfContent_RefID = shelfContent.LOG_WRH_Shelf_ContentID; contentAdjustment.QuantityChangedAmount = Parameter.Quantity; contentAdjustment.QuantityChangedDate = DateTime.Now; contentAdjustment.IsInitialReceipt = true; /* PITATI PEJU SUTRA * contentAdjustment.IsInventoryJobCorrection = false; * contentAdjustment.IsShipmentWithdrawal = false; * contentAdjustment.IsManualCorrection = false; */ contentAdjustment.PerformedBy_Account_RefID = securityTicket.AccountID; contentAdjustment.PerformedAt_Date = DateTime.Now; contentAdjustment.Tenant_RefID = securityTicket.TenantID; contentAdjustment.Creation_Timestamp = DateTime.Now; contentAdjustment.Save(Connection, Transaction); #endregion #region create tracking instance var trackingInstance = new CL1_LOG.ORM_LOG_ProductTrackingInstance(); trackingInstance.LOG_ProductTrackingInstanceID = Guid.NewGuid(); trackingInstance.TrackingInstanceTakenFromSourceTrackingInstance_RefID = Guid.Empty; trackingInstance.TrackingCode = String.Empty; trackingInstance.SerialNumber = String.Empty; trackingInstance.BatchNumber = Parameter.BatchNumber; trackingInstance.OwnedBy_BusinessParticipant_RefID = Guid.Empty; //this is important if we want to persist owner of product (mobile phone in a service) trackingInstance.CMN_PRO_Product_RefID = Parameter.ProductID; trackingInstance.CMN_PRO_Product_Release_RefID = Guid.Empty; trackingInstance.CMN_PRO_Product_Variant_RefID = Guid.Empty; trackingInstance.ExpirationDate = Parameter.ExpirationDate; trackingInstance.InitialQuantityOnTrackingInstance = Parameter.Quantity; trackingInstance.CurrentQuantityOnTrackingInstance = Parameter.Quantity; trackingInstance.R_ReservedQuantity = 0; trackingInstance.R_FreeQuantity = Parameter.Quantity; trackingInstance.Creation_Timestamp = DateTime.Now; trackingInstance.Tenant_RefID = securityTicket.TenantID; trackingInstance.Save(Connection, Transaction); #endregion #region create tracking instance history var trackingInstanceHistory = new CL1_LOG.ORM_LOG_ProductTrackingInstance_HistoryEntry(); trackingInstanceHistory.LOG_ProductTrackingInstance_HistoryEntryID = Guid.NewGuid(); trackingInstanceHistory.ProductTrackingInstance_RefID = trackingInstance.LOG_ProductTrackingInstanceID; trackingInstanceHistory.HistoryEntry_Text = "Product is added to inventory job process"; trackingInstanceHistory.Creation_Timestamp = DateTime.Now; trackingInstanceHistory.Tenant_RefID = securityTicket.TenantID; trackingInstanceHistory.Save(Connection, Transaction); #endregion #region ORM_LOG_WRH_Shelf_ContentAdjustment_TrackingInstance var adjustment2tracking = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_ContentAdjustment_TrackingInstance(); adjustment2tracking.LOG_WRH_Shelf_ContentAdjustment_TrackingInstanceID = Guid.NewGuid(); adjustment2tracking.LOG_ProductTrackingInstance_RefID = trackingInstance.LOG_ProductTrackingInstanceID; adjustment2tracking.LOG_WRH_Shelf_ContentAdjustment_RefID = contentAdjustment.LOG_WRH_Shelf_ContentAdjustmentID; adjustment2tracking.QuantityChangedAmount = Parameter.Quantity; adjustment2tracking.Creation_Timestamp = DateTime.Now; adjustment2tracking.Tenant_RefID = securityTicket.TenantID; adjustment2tracking.Save(Connection, Transaction); #endregion #region create ShelfContent_2_TrackingInstance var shelf2tracking = new CL1_LOG_WRH.ORM_LOG_WRH_ShelfContent_2_TrackingInstance(); shelf2tracking.AssignmentID = Guid.NewGuid(); shelf2tracking.LOG_ProductTrackingInstance_RefID = trackingInstance.LOG_ProductTrackingInstanceID; shelf2tracking.LOG_WRH_Shelf_Content_RefID = shelfContent.LOG_WRH_Shelf_ContentID; shelf2tracking.Creation_Timestamp = DateTime.Now; shelf2tracking.Tenant_RefID = securityTicket.TenantID; shelf2tracking.Save(Connection, Transaction); #endregion L3WH_SSCfP_1635 resultItem = new L3WH_SSCfP_1635(); resultItem.ShelfContentID = shelfContent.LOG_WRH_Shelf_ContentID; resultItem.TrackingInstanceID = trackingInstance.LOG_ProductTrackingInstanceID; returnValue.Result = resultItem; return(returnValue); #endregion UserCode }