///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_L3WH_UPTI_1439 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L3WH_UPTI_1439 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_L3WH_UPTI_1439 functionReturn = new FR_L3WH_UPTI_1439(); try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } functionReturn = Execute(Connection, Transaction, Parameter, securityTicket); #region Cleanup Connection/Transaction //Commit the transaction if (cleanupTransaction == true) { Transaction.Commit(); } //Close the connection if (cleanupConnection == true) { Connection.Close(); } #endregion } catch (Exception ex) { try { if (cleanupTransaction == true && Transaction != null) { Transaction.Rollback(); } } catch { } try { if (cleanupConnection == true && Connection != null) { Connection.Close(); } } catch { } throw new Exception("Exception occured in method cls_Update_ProductTrackingInstance", ex); } return(functionReturn); }
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 }