USP_DATAFORMTEMPLATE_EDIT_WEBFORMSUSERREGISTRATIONPARTSETTING

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SITECONTENTID	int	IN
@ALLOWREGISTRATION	bit	IN
@REQUIREFIRSTNAME	bit	IN
@REQUIRETITLE	bit	IN
@REQUIREPHONE	bit	IN
@SENDEMAIL	bit	IN

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_WEBFORMSUSERREGISTRATIONPARTSETTING (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @SITECONTENTID integer,
                        @ALLOWREGISTRATION bit,
                        @REQUIREFIRSTNAME bit,
                        @REQUIRETITLE bit,
                        @REQUIREPHONE bit,
                        @SENDEMAIL bit
                    )
                    as
                        set nocount on;

                        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,
                                @ALLOWREGISTRATION,
                                @REQUIREFIRSTNAME,
                                @REQUIRETITLE,
                                @REQUIREPHONE,
                                @SENDEMAIL
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;