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_UPTI_1439 Execute(DbConnection Connection, DbTransaction Transaction, P_L3WH_UPTI_1439 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3WH_UPTI_1439();
returnValue.Result = new L3WH_UPTI_1439();
//Put your code here
List <P_L3WH_SSCA_1732a> contentAdjustments = new List <P_L3WH_SSCA_1732a>();
List <L3WH_UPTI_1439a> returnVal = new List <L3WH_UPTI_1439a>();
foreach (var trackingInstance in Parameter.ProductTrackingInstance)
{
P_L3WH_SSCA_1732a ca = new P_L3WH_SSCA_1732a();
L3WH_UPTI_1439a retItem = new L3WH_UPTI_1439a();
#region TrackingInstance
var newTrackingInstance = new CL1_LOG.ORM_LOG_ProductTrackingInstance();
var oldTrackingInstance = new CL1_LOG.ORM_LOG_ProductTrackingInstance();
oldTrackingInstance.Load(Connection, Transaction, trackingInstance.ProductTrackingInstanceID);
newTrackingInstance.BatchNumber = trackingInstance.BatchNumber;
newTrackingInstance.ExpirationDate = trackingInstance.ExpirationDate;
newTrackingInstance.Creation_Timestamp = DateTime.Now;
newTrackingInstance.OwnedBy_BusinessParticipant_RefID = oldTrackingInstance.OwnedBy_BusinessParticipant_RefID;
newTrackingInstance.R_FreeQuantity = oldTrackingInstance.R_FreeQuantity;
newTrackingInstance.R_ReservedQuantity = oldTrackingInstance.R_ReservedQuantity;
newTrackingInstance.SerialNumber = oldTrackingInstance.SerialNumber;
newTrackingInstance.Tenant_RefID = securityTicket.TenantID;
newTrackingInstance.TrackingCode = (oldTrackingInstance.TrackingCode == null) ? String.Empty : oldTrackingInstance.TrackingCode;
newTrackingInstance.TrackingInstanceTakenFromSourceTrackingInstance_RefID = oldTrackingInstance.TrackingInstanceTakenFromSourceTrackingInstance_RefID;
newTrackingInstance.CMN_PRO_Product_RefID = oldTrackingInstance.CMN_PRO_Product_RefID;
newTrackingInstance.CMN_PRO_Product_Release_RefID = oldTrackingInstance.CMN_PRO_Product_Release_RefID;
newTrackingInstance.CMN_PRO_Product_Variant_RefID = oldTrackingInstance.CMN_PRO_Product_Variant_RefID;
newTrackingInstance.CurrentQuantityOnTrackingInstance = oldTrackingInstance.CurrentQuantityOnTrackingInstance;
newTrackingInstance.InitialQuantityOnTrackingInstance = oldTrackingInstance.InitialQuantityOnTrackingInstance;
newTrackingInstance.IsDeleted = false;
newTrackingInstance.Save(Connection, Transaction);
oldTrackingInstance.TrackingCode = (oldTrackingInstance.TrackingCode == null) ? String.Empty : oldTrackingInstance.TrackingCode;
oldTrackingInstance.IsDeleted = true;
oldTrackingInstance.Save(Connection, Transaction);
#endregion
#region ShelfContent
CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content newShelfContent = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content();
CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content oldShelfContent = new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content();
oldShelfContent.Load(Connection, Transaction, trackingInstance.ShelfContentID);
newShelfContent.GlobalPropertyMatchingID = oldShelfContent.GlobalPropertyMatchingID;
newShelfContent.IntakeIntoInventoryDate = oldShelfContent.IntakeIntoInventoryDate;
newShelfContent.IsLocked = oldShelfContent.IsLocked;
newShelfContent.PlacedIntoStock_Date = oldShelfContent.PlacedIntoStock_Date;
newShelfContent.Product_RefID = oldShelfContent.Product_RefID;
newShelfContent.Product_Release_RefID = oldShelfContent.Product_Release_RefID;
newShelfContent.Product_Variant_RefID = oldShelfContent.Product_Variant_RefID;
newShelfContent.Quantity_Current = oldShelfContent.Quantity_Current;
newShelfContent.Quantity_Initial = oldShelfContent.Quantity_Initial;
newShelfContent.R_FreeQuantity = oldShelfContent.R_FreeQuantity;
newShelfContent.R_ProcurementValue = oldShelfContent.R_ProcurementValue;
newShelfContent.R_ProcurementValue_Currency_RefID = oldShelfContent.R_ProcurementValue_Currency_RefID;
newShelfContent.R_ReservedQuantity = oldShelfContent.R_ReservedQuantity;
newShelfContent.ReceivedAsFulfillmentOf_ProcurementOrderHeader_RefID = oldShelfContent.ReceivedAsFulfillmentOf_ProcurementOrderHeader_RefID;
newShelfContent.ReceivedAsFulfillmentOf_ProcurementOrderPosition_RefID = oldShelfContent.ReceivedAsFulfillmentOf_ProcurementOrderPosition_RefID;
newShelfContent.ReceptionDate = oldShelfContent.ReceptionDate;
newShelfContent.Shelf_RefID = oldShelfContent.Shelf_RefID;
newShelfContent.Tenant_RefID = securityTicket.TenantID;
newShelfContent.UsedShelfCapacityAmount = oldShelfContent.UsedShelfCapacityAmount;
newShelfContent.LOG_WRH_Shelf_ContentID = Guid.NewGuid();
newShelfContent.Creation_Timestamp = DateTime.Now;
newShelfContent.Save(Connection, Transaction);
CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content.Query.SoftDelete(Connection, Transaction, new CL1_LOG_WRH.ORM_LOG_WRH_Shelf_Content.Query()
{
LOG_WRH_Shelf_ContentID = trackingInstance.ShelfContentID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
CL1_LOG_WRH.ORM_LOG_WRH_ShelfContent_2_TrackingInstance shelfContent2TrackingInstance = new CL1_LOG_WRH.ORM_LOG_WRH_ShelfContent_2_TrackingInstance();
shelfContent2TrackingInstance.LOG_ProductTrackingInstance_RefID = newTrackingInstance.LOG_ProductTrackingInstanceID;
shelfContent2TrackingInstance.LOG_WRH_Shelf_Content_RefID = newShelfContent.LOG_WRH_Shelf_ContentID;
shelfContent2TrackingInstance.Tenant_RefID = securityTicket.TenantID;
shelfContent2TrackingInstance.Save(Connection, Transaction);
var oldsc2ti = CL1_LOG_WRH.ORM_LOG_WRH_ShelfContent_2_TrackingInstance.Query.SoftDelete(Connection, Transaction, new CL1_LOG_WRH.ORM_LOG_WRH_ShelfContent_2_TrackingInstance.Query()
{
LOG_WRH_Shelf_Content_RefID = oldShelfContent.LOG_WRH_Shelf_ContentID,
Tenant_RefID = securityTicket.TenantID
});
#endregion
ca.ProductID = newTrackingInstance.CMN_PRO_Product_RefID;
ca.ShelfContentID = newShelfContent.LOG_WRH_Shelf_ContentID;
ca.TrackingInstanceID = newTrackingInstance.LOG_ProductTrackingInstanceID;
ca.AdjustedQuantity = trackingInstance.Quantity;
contentAdjustments.Add(ca);
retItem.ProductID = trackingInstance.ProductID;
retItem.TrackingInstanceID = newTrackingInstance.LOG_ProductTrackingInstanceID;
retItem.LOG_WRH_Shelf_ContentID = newShelfContent.LOG_WRH_Shelf_ContentID;
returnVal.Add(retItem);
}
P_L3WH_SSCA_1732 param = new P_L3WH_SSCA_1732();
param.Adjustments = contentAdjustments.ToArray();
cls_Save_Shelf_ContentAdjustments.Invoke(Connection, Transaction, param, securityTicket);
returnValue.Result.newTrackingInstance = returnVal.ToArray();
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
}
