USP_DATAFORMTEMPLATE_EDITLOAD_SALESORDERITEMMEMBERSHIP_ONLINE_GENERIC

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@SALESORDERID	uniqueidentifier	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@QUANTITY	decimal(18, 0)	INOUT
@AMOUNT	money	INOUT
@DATA	xml	INOUT
@OPTIONS	xml	INOUT
@CALLBACKURL	nvarchar(255)	INOUT
@SYSTEMTYPENAME	nvarchar(255)	INOUT
@ASSEMBLYNAME	nvarchar(255)	INOUT
@ATTRIBUTES	xml	INOUT
@CATEGORYNAME	nvarchar(255)	INOUT
@ACKNOWLEDGEMENT	nvarchar(max)	INOUT
@MEMBERSHIPID	uniqueidentifier	INOUT
@MEMBERSHIPPROGRAMID	uniqueidentifier	INOUT
@MEMBERSHIPLEVELID	uniqueidentifier	INOUT
@MEMBERSHIPLEVELTERMID	uniqueidentifier	INOUT
@MEMBERSHIPLEVELTYPEID	uniqueidentifier	INOUT
@MEMBERSHIPADDONS	xml	INOUT
@NUMBEROFCHILDREN	tinyint	INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SALESORDERITEMMEMBERSHIP_ONLINE_GENERIC(
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @SALESORDERID uniqueidentifier = null output,
                        @DESCRIPTION nvarchar(255) = null output,        
                        @QUANTITY decimal = null output,
                        @AMOUNT money = null output,            
                        @DATA xml = null output,
                        @OPTIONS xml = null output,
                        @CALLBACKURL nvarchar(255) = null output,
                        @SYSTEMTYPENAME nvarchar(255) = null output,
                        @ASSEMBLYNAME nvarchar(255) = null output,
                        @ATTRIBUTES xml = null output,
                        @CATEGORYNAME nvarchar(255) = null output,
                        @ACKNOWLEDGEMENT nvarchar(max) = null output,
                        @MEMBERSHIPID uniqueidentifier = null output,
                        @MEMBERSHIPPROGRAMID uniqueidentifier = null  output,
                        @MEMBERSHIPLEVELID uniqueidentifier = null  output,
                        @MEMBERSHIPLEVELTERMID uniqueidentifier = null  output,
                        @MEMBERSHIPLEVELTYPEID uniqueidentifier = null output,
                        @MEMBERSHIPADDONS xml= null output, --Not currently using, so not loading. Feel free to populate the xml (and delete this comment) if you have the need
                        @NUMBEROFCHILDREN tinyint = null output
                    )
                    as
                        set nocount on;

                        set @DATALOADED = 0
                        set @TSLONG = 0

                        select
                            @DATALOADED = 1,
                            @TSLONG = [SALESORDERITEM].[TSLONG],
                            @SALESORDERID = [SALESORDERITEM].[SALESORDERID],
                            @DESCRIPTION = [SALESORDERITEM].[DESCRIPTION],
                            @QUANTITY = [SALESORDERITEM].[QUANTITY],
                            @AMOUNT = [SALESORDERITEM].[PRICE],            
                            @DATA = [SALESORDERITEM].[DATA],
                            @OPTIONS = [SALESORDERITEM].[OPTIONS],
                            @CALLBACKURL = [SALESORDERITEM].[CALLBACKURL],
                            @SYSTEMTYPENAME = [SALESORDERITEM].[SYSTEMTYPENAME],
                            @ASSEMBLYNAME = [SALESORDERITEM].[ASSEMBLYNAME],
                            @ATTRIBUTES = [SALESORDERITEM].[ATTRIBUTES],
                            @CATEGORYNAME = [SALESORDERITEM].[CATEGORYNAME],
                            @ACKNOWLEDGEMENT = [SALESORDERITEM].[ACKNOWLEDGEMENT],
                            @MEMBERSHIPID = [SALESORDERITEMMEMBERSHIP].[MEMBERSHIPID],
                            @MEMBERSHIPPROGRAMID = [SALESORDERITEMMEMBERSHIP].[MEMBERSHIPPROGRAMID],
                            @MEMBERSHIPLEVELID = [SALESORDERITEMMEMBERSHIP].[MEMBERSHIPLEVELID],
                            @MEMBERSHIPLEVELTERMID = [SALESORDERITEMMEMBERSHIP].[MEMBERSHIPLEVELTERMID],
                            @MEMBERSHIPLEVELTYPEID = [SALESORDERITEMMEMBERSHIP].[MEMBERSHIPLEVELTYPECODEID],
                            @NUMBEROFCHILDREN = [SALESORDERITEMMEMBERSHIP].[NUMBEROFCHILDREN]
                        from dbo.[SALESORDERITEM]
                        inner join dbo.[SALESORDERITEMMEMBERSHIP]
                            on [SALESORDERITEM].[ID] =  [SALESORDERITEMMEMBERSHIP].[ID]
                        where @ID = [SALESORDERITEM].[ID]

                    return 0;