///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_CL6_GCODaSHfCO_0753 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_CL6_GCODaSHfCO_0753 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_CL6_GCODaSHfCO_0753 functionReturn = new FR_CL6_GCODaSHfCO_0753(); 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_Get_CustomerOrderData_and_ShipmentHeaders_for_CustomerOrderID", ex); } return(functionReturn); }
protected static FR_CL6_GCODaSHfCO_0753 Execute(DbConnection Connection, DbTransaction Transaction, P_CL6_GCODaSHfCO_0753 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_CL6_GCODaSHfCO_0753(); returnValue.Result = new CL6_GCODaSHfCO_0753(); #region Get Header Data var resultHeader = cls_Get_CustomerOrderData_for_HeaderID .Invoke(Connection, Transaction, new P_CL3_GCODfH_1537() { CustomerOrderHeaderID = Parameter.CustomerOrderHeaderID }, securityTicket); if (resultHeader.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; returnValue.Result = null; return(returnValue); } #endregion #region Get ShipmentHeaders var resultShipments = cls_Get_ShipmentHeader_with_BillHeaders_for_CustomerOrderHeaderID .Invoke(Connection, Transaction, new P_CL6_GSHwBHNfCOH_1141() { CustomerOrderHeaderID = Parameter.CustomerOrderHeaderID }, securityTicket); if (resultShipments.Status != FR_Status.Success) { returnValue.Status = FR_Status.Error_Internal; returnValue.Result.CustomerOrderData = resultHeader.Result; return(returnValue); } #endregion returnValue.Result = new CL6_GCODaSHfCO_0753() { CustomerOrderData = resultHeader.Result, ShipmentHeaders = resultShipments.Result }; return(returnValue); #endregion UserCode }