USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPEXPRESSPARTSETTINGS_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SITECONTENTID	int	IN
@ORDERPAGEID	int	IN
@INCLUDEPRIMARYTITLE	bit	IN
@REQUIREPRIMARYTITLE	bit	IN
@REQUIREPRIMARYFIRSTNAME	bit	IN
@REQUIREPRIMARYPHONE	bit	IN
@REQUIREPRIMARYEMAIL	bit	IN
@INCLUDEADDITIONALTITLE	bit	IN
@REQUIREADDITIONALTITLE	bit	IN
@REQUIREADDITIONALFIRSTNAME	bit	IN
@MEMBERADDONSETTINGS	xml	IN
Definition

Copy

                    create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPEXPRESSPARTSETTINGS_2
                    (
                        @ID uniqueidentifier,  -- use SiteContent Guid
                        @CHANGEAGENTID uniqueidentifier = null,
                        @SITECONTENTID int,
                        @ORDERPAGEID int,
                        @INCLUDEPRIMARYTITLE bit,
                        @REQUIREPRIMARYTITLE bit,
                        @REQUIREPRIMARYFIRSTNAME bit,
                        @REQUIREPRIMARYPHONE bit,
                        @REQUIREPRIMARYEMAIL bit,
                        @INCLUDEADDITIONALTITLE bit,
                        @REQUIREADDITIONALTITLE bit,
                        @REQUIREADDITIONALFIRSTNAME bit,
                        @MEMBERADDONSETTINGS xml
                    )
                    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 isnull(@INCLUDEPRIMARYTITLE,0) = 0
                            set @REQUIREPRIMARYTITLE = 0;

                        if isnull(@INCLUDEADDITIONALTITLE,0) = 0
                            set @REQUIREADDITIONALTITLE = 0;

                        begin try                    
                            merge dbo.[MEMBERSHIPEXPRESSPARTSETTINGS] as [TARGET]
                            using (select @ID as ID) as [SOURCE]
                            on (TARGET.ID = SOURCE.ID)
                            when matched then
                                update 
                                set 
                                    SITECONTENTID = @SITECONTENTID,
                                    ORDERPAGEID = @ORDERPAGEID,
                                    INCLUDEPRIMARYTITLE = isnull(@INCLUDEPRIMARYTITLE, 0),
                                    REQUIREPRIMARYTITLE = isnull(@REQUIREPRIMARYTITLE, 0),
                                    REQUIREPRIMARYFIRSTNAME = isnull(@REQUIREPRIMARYFIRSTNAME, 1),
                                    REQUIREPRIMARYPHONE = isnull(@REQUIREPRIMARYPHONE, 0),
                                    REQUIREPRIMARYEMAIL = isnull(@REQUIREPRIMARYEMAIL, 1),
                                    INCLUDEADDITIONALTITLE = isnull(@INCLUDEADDITIONALTITLE, 0),
                                    REQUIREADDITIONALTITLE = isnull(@REQUIREADDITIONALTITLE, 0),
                                    REQUIREADDITIONALFIRSTNAME = isnull(@REQUIREADDITIONALFIRSTNAME,1), 
                                    MEMBERADDONSETTINGS = @MEMBERADDONSETTINGS,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                            when not matched then
                                insert (
                                    ID, 
                                    SITECONTENTID, 
                                    ORDERPAGEID, 
                                    INCLUDEPRIMARYTITLE,
                                    REQUIREPRIMARYTITLE,
                                    REQUIREPRIMARYFIRSTNAME,
                                    REQUIREPRIMARYPHONE,
                                    REQUIREPRIMARYEMAIL,
                                    INCLUDEADDITIONALTITLE,
                                    REQUIREADDITIONALTITLE,
                                    REQUIREADDITIONALFIRSTNAME,
                                    MEMBERADDONSETTINGS,
                                    ADDEDBYID, 
                                    CHANGEDBYID, 
                                    DATEADDED, 
                                    DATECHANGED
                                ) 
                                values (
                                    @ID, 
                                    @SITECONTENTID, 
                                    @ORDERPAGEID,
                                    isnull(@INCLUDEPRIMARYTITLE, 0),
                                    isnull(@REQUIREPRIMARYTITLE, 0),
                                    isnull(@REQUIREPRIMARYFIRSTNAME, 1),
                                    isnull(@REQUIREPRIMARYPHONE, 0),
                                    isnull(@REQUIREPRIMARYEMAIL, 1),
                                    isnull(@INCLUDEADDITIONALTITLE, 0),
                                    isnull(@REQUIREADDITIONALTITLE, 0),
                                    isnull(@REQUIREADDITIONALFIRSTNAME, 1),
                                    @MEMBERADDONSETTINGS,
                                    @CHANGEAGENTID, 
                                    @CHANGEAGENTID, 
                                    @CURRENTDATE, 
                                    @CURRENTDATE
                                );
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                        return 0;