USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPEXPRESSPARTSETTINGS

The load procedure used by the edit dataform template "Membership Express Part Settings Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@SITECONTENTID	int	INOUT	Site content
@ORDERPAGEID	int	INOUT	Order page
@INCLUDEPRIMARYTITLE	bit	INOUT	Include primary member title
@REQUIREPRIMARYTITLE	bit	INOUT	Require primary member title
@REQUIREPRIMARYFIRSTNAME	bit	INOUT	Require primary member first name
@REQUIREPRIMARYPHONE	bit	INOUT	Include primary member phone
@REQUIREPRIMARYEMAIL	bit	INOUT	Require primary member phone
@INCLUDEADDITIONALTITLE	bit	INOUT	Include additional member title
@REQUIREADDITIONALTITLE	bit	INOUT	Require additional member title
@REQUIREADDITIONALFIRSTNAME	bit	INOUT	Require additional member first name

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPEXPRESSPARTSETTINGS
                    (
                        @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
                    )
                    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]
                        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;