USP_DATAFORMTEMPLATE_ADD_WEBFORMSUSERREGISTRATIONPARTSETTING

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier INOUT
@CHANGEAGENTID uniqueidentifier IN
@SITECONTENTID int IN

Definition

Copy

                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_WEBFORMSUSERREGISTRATIONPARTSETTING
                (
                    @ID uniqueidentifier = null output,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @SITECONTENTID integer
                )
                as
                set nocount on;

                if @ID is null
                    set @ID = newid()

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                begin try
                    exec dbo.USP_WEBFORMSUSERREGISTRATIONPARTSETTING_ADDUPDATE
                        @ID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @SITECONTENTID,
                        null,
                        null,
                        null,
                        null,
                        1
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0