protected static FR_L5SO_DSP_1449 Execute(DbConnection Connection, DbTransaction Transaction, P_L5SO_DSP_1449 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5SO_DSP_1449(); //get shipment position by ID CL1_LOG_SHP.ORM_LOG_SHP_Shipment_Position shipmentPositionToDelete = new ORM_LOG_SHP_Shipment_Position(); shipmentPositionToDelete.Load(Connection, Transaction, Parameter.PositionID); ORM_LOG_RSV_Reservation.Query.SoftDelete(Connection, Transaction, new ORM_LOG_RSV_Reservation.Query { LOG_SHP_Shipment_Position_RefID = shipmentPositionToDelete.LOG_SHP_Shipment_PositionID, IsDeleted = false }); //remove shipment position shipmentPositionToDelete.Remove(Connection, Transaction); // update header total value cls_Update_Current_TotalValue_on_ShipmentHeader_from_Positions.Invoke(Connection, Transaction, new P_L5SO_UCTVoSHfP_1549 { ShipmentHeaderID = Parameter.ShipmentHeaderID }, securityTicket); returnValue.Result = new L5SO_DSP_1449(); returnValue.Result.DeletedPosition = Parameter.PositionID; return(returnValue); #endregion UserCode }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_L5SO_DSP_1449 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L5SO_DSP_1449 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_L5SO_DSP_1449 functionReturn = new FR_L5SO_DSP_1449(); 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 ex; } return(functionReturn); }