protected static FR_L5CO_GCOWAD_1330 Execute(DbConnection Connection, DbTransaction Transaction, P_L5CO_GCOWAD_1330 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5CO_GCOWAD_1330(); //Put your code here var customerOrderParam = new P_L5CO_GACOfToO_1214(); customerOrderParam.OrderID = Parameter.OrderHeaderID; var customerOrder = cls_Get_AllCustomerOrders_for_Tenant_or_OrderID.Invoke(Connection, Transaction, customerOrderParam, securityTicket).Result.FirstOrDefault(); if (customerOrder != null) { var positionsQuery = new P_L2CO_GAOPfToO_1239(); positionsQuery.OrderHeaderID = customerOrder.ORD_CUO_CustomerOrder_HeaderID; var customerOrderPositions = cls_Get_AllOrderPositions_for_Tenant_or_OrderHeader.Invoke(Connection, Transaction, positionsQuery, securityTicket).Result; var positionsWithDetailsQuery = new P_L5CO_GCOPwDfH_1421(); positionsWithDetailsQuery.OrderHeaderID = customerOrder.ORD_CUO_CustomerOrder_HeaderID; var customerOrderPositionsWithDetails = cls_Get_CustomerOrderPositions_with_Details_for_HeaderID.Invoke(Connection, Transaction, positionsWithDetailsQuery, securityTicket).Result; returnValue.Result = new L5CO_GCOWAD_1330(); returnValue.Result.Order = customerOrder; returnValue.Result.NumberOfOrderPositions = customerOrderPositions.Length; if (Parameter.PositionsDetailsFetched) { returnValue.Result.OrderPositionsWithAllDetails = customerOrderPositionsWithDetails; } else { returnValue.Result.OrderPositions = customerOrderPositions; } } return(returnValue); #endregion UserCode }
protected static FR_L5CO_GPDfD_1428 Execute(DbConnection Connection, DbTransaction Transaction, P_L5CO_GPDfD_1428 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5CO_GPDfD_1428(); //Put your code here returnValue.Result = new L5CO_GPDfD_1428(); var customerOrderQuery = new P_L5CO_GACOfToO_1214(); customerOrderQuery.OrderID = Parameter.OrderHeaderID; var customerOrder = cls_Get_AllCustomerOrders_for_Tenant_or_OrderID.Invoke(Connection, Transaction, customerOrderQuery, securityTicket).Result.Single(); var positionsQuery = new P_L5CO_GCOPwDfH_1421(); positionsQuery.OrderHeaderID = Parameter.OrderHeaderID; var customerOrderPositions = cls_Get_CustomerOrderPositions_with_Details_for_HeaderID.Invoke(Connection, Transaction, positionsQuery, securityTicket).Result; returnValue.Result.CustomerOrderWithDetails = customerOrder; returnValue.Result.PositionsForOrder = customerOrderPositions; return(returnValue); #endregion UserCode }