USP_DATAFORMTEMPLATE_EDIT_WEALTHPOINTURL3

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@WEALTHPOINTURL	UDT_WEBADDRESS	IN
@LOGERRORS	bit	IN
@NUMADDRESSES	int	IN
Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_WEALTHPOINTURL3 (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @WEALTHPOINTURL dbo.UDT_WEBADDRESS,
                        @LOGERRORS bit,
                        @NUMADDRESSES int
                    ) as
                        set nocount on;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

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

                        declare @WEALTHPOINTCONFIGURATIONID uniqueidentifier;
                        select top 1
                            @WEALTHPOINTCONFIGURATIONID = WEALTHPOINTCONFIGURATION.ID
                        from
                            dbo.WEALTHPOINTCONFIGURATION;

                        if @WEALTHPOINTCONFIGURATIONID is not null begin
                            update
                                dbo.WEALTHPOINTCONFIGURATION
                            set
                                WEALTHPOINTURL = @WEALTHPOINTURL,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE,
                                LOGERRORS = @LOGERRORS,
                                NUMADDRESSES = @NUMADDRESSES
                            where
                                ID = @WEALTHPOINTCONFIGURATIONID;
                        end
                        else begin
                            insert into dbo.WEALTHPOINTCONFIGURATION (
                                WEALTHPOINTURL,
                                ADDEDBYID,
                                CHANGEDBYID,
                                DATEADDED,
                                DATECHANGED,
                                LOGERRORS,
                                        NUMADDRESSES
                            )
                            values (
                                @WEALTHPOINTURL,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID,
                                @CURRENTDATE,
                                @CURRENTDATE,
                                @LOGERRORS,
                                        @NUMADDRESSES
                            );
                        end

                        return 0;