USP_DATAFORMTEMPLATE_ADD_MEMBERSHIPEXPRESSPARTSETTINGS

The save procedure used by the add dataform template "Membership Express Part Settings Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SITECONTENTID	int	IN	Site content
@ORDERPAGEID	int	IN	Order page
@INCLUDEPRIMARYTITLE	bit	IN	Include primary member title
@REQUIREPRIMARYTITLE	bit	IN	Require primary member title
@REQUIREPRIMARYFIRSTNAME	bit	IN	Require primary member first name
@REQUIREPRIMARYPHONE	bit	IN	Include primary member phone
@REQUIREPRIMARYEMAIL	bit	IN	Require primary member phone
@INCLUDEADDITIONALTITLE	bit	IN	Include additional member title
@REQUIREADDITIONALTITLE	bit	IN	Require additional member title
@REQUIREADDITIONALFIRSTNAME	bit	IN	Require additional member first name

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MEMBERSHIPEXPRESSPARTSETTINGS
                    (
                        @ID uniqueidentifier output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @SITECONTENTID int,
                        @ORDERPAGEID int = 0,
                        @INCLUDEPRIMARYTITLE bit = 0,
                        @REQUIREPRIMARYTITLE bit = 0,
                        @REQUIREPRIMARYFIRSTNAME bit = 1,
                        @REQUIREPRIMARYPHONE bit = 0,
                        @REQUIREPRIMARYEMAIL bit = 1,
                        @INCLUDEADDITIONALTITLE bit = 0,
                        @REQUIREADDITIONALTITLE bit = 0,
                        @REQUIREADDITIONALFIRSTNAME bit = 1
                    )
                    as
                        set nocount on;

                        if @CHANGEAGENTID is null  
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                        declare @CURRENTDATE datetime
                        set @CURRENTDATE = getdate()

                        select @ID = [Guid] --Making sure we're using the right ID

                        from dbo.[SiteContent] with (nolock)
                        where ID = @SITECONTENTID

                        if @INCLUDEPRIMARYTITLE = 0
                            set @REQUIREPRIMARYTITLE = 0;

                        if @INCLUDEADDITIONALTITLE = 0
                            set @REQUIREADDITIONALTITLE = 0;

                        begin try
                            insert into dbo.[MEMBERSHIPEXPRESSPARTSETTINGS] (
                                ID, 
                                SITECONTENTID, 
                                ORDERPAGEID, 
                                INCLUDEPRIMARYTITLE,
                                REQUIREPRIMARYTITLE,
                                REQUIREPRIMARYFIRSTNAME,
                                REQUIREPRIMARYPHONE,
                                REQUIREPRIMARYEMAIL,
                                INCLUDEADDITIONALTITLE,
                                REQUIREADDITIONALTITLE,
                                REQUIREADDITIONALFIRSTNAME,
                                ADDEDBYID, 
                                CHANGEDBYID, 
                                DATEADDED, 
                                DATECHANGED
                            ) 
                            values (
                                @ID, 
                                @SITECONTENTID, 
                                @ORDERPAGEID,
                                @INCLUDEPRIMARYTITLE,
                                @REQUIREPRIMARYTITLE,
                                @REQUIREPRIMARYFIRSTNAME,
                                @REQUIREPRIMARYPHONE,
                                @REQUIREPRIMARYEMAIL,
                                @INCLUDEADDITIONALTITLE,
                                @REQUIREADDITIONALTITLE,
                                @REQUIREADDITIONALFIRSTNAME,
                                @CHANGEAGENTID, 
                                @CHANGEAGENTID, 
                                @CURRENTDATE, 
                                @CURRENTDATE
                            ) 
                        end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;