USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPEXPRESSPARTSETTINGS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@SITECONTENTID	int	INOUT
@ORDERPAGEID	int	INOUT
@INCLUDEPRIMARYTITLE	bit	INOUT
@REQUIREPRIMARYTITLE	bit	INOUT
@REQUIREPRIMARYFIRSTNAME	bit	INOUT
@REQUIREPRIMARYPHONE	bit	INOUT
@REQUIREPRIMARYEMAIL	bit	INOUT
@INCLUDEADDITIONALTITLE	bit	INOUT
@REQUIREADDITIONALTITLE	bit	INOUT
@REQUIREADDITIONALFIRSTNAME	bit	INOUT
@MEMBERADDONSETTINGS	xml	INOUT

Definition

Copy


                    create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPEXPRESSPARTSETTINGS_2
                    (
                        @ID uniqueidentifier, -- should be SiteContent Guid
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @SITECONTENTID int = null output,
                        @ORDERPAGEID int = null output,
                        @INCLUDEPRIMARYTITLE bit = null output,
                        @REQUIREPRIMARYTITLE bit = null output,
                        @REQUIREPRIMARYFIRSTNAME bit = null output,
                        @REQUIREPRIMARYPHONE bit = null output,
                        @REQUIREPRIMARYEMAIL bit = null output,
                        @INCLUDEADDITIONALTITLE bit = null output,
                        @REQUIREADDITIONALTITLE bit = null output,
                        @REQUIREADDITIONALFIRSTNAME bit = null output,
                        @MEMBERADDONSETTINGS xml = null output
                    )
                    as
                        set nocount on;

                        -- setting @DATALOADED because it's okay if the ID returns nothing
                        set @DATALOADED = 1
                        set @TSLONG = 0

                        select
                            @TSLONG = [TSLONG],
                            @SITECONTENTID = [SITECONTENTID], 
                            @ORDERPAGEID = [ORDERPAGEID],
                            @INCLUDEPRIMARYTITLE = [INCLUDEPRIMARYTITLE],
                            @REQUIREPRIMARYTITLE = [REQUIREPRIMARYTITLE],
                            @REQUIREPRIMARYFIRSTNAME = [REQUIREPRIMARYFIRSTNAME],
                            @REQUIREPRIMARYPHONE = [REQUIREPRIMARYPHONE],
                            @REQUIREPRIMARYEMAIL = [REQUIREPRIMARYEMAIL],
                            @INCLUDEADDITIONALTITLE = [INCLUDEADDITIONALTITLE],
                            @REQUIREADDITIONALTITLE = [REQUIREADDITIONALTITLE],
                            @REQUIREADDITIONALFIRSTNAME = [REQUIREADDITIONALFIRSTNAME],
                            @MEMBERADDONSETTINGS = [MEMBERADDONSETTINGS]
                        from dbo.[MEMBERSHIPEXPRESSPARTSETTINGS] with (nolock)
                        where ID = @ID

                        if @REQUIREPRIMARYFIRSTNAME is null
                            set @REQUIREPRIMARYFIRSTNAME = 1;

                        if @REQUIREPRIMARYEMAIL is null
                            set @REQUIREPRIMARYEMAIL = 1;

                        if @REQUIREADDITIONALFIRSTNAME is null
                            set @REQUIREADDITIONALFIRSTNAME = 1;

                    return 0;