USP_DATAFORMTEMPLATE_EDIT_BBWSURL

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@BBWSURL	UDT_WEBADDRESS	IN
@BBWSUSERNAME	nvarchar(100)	IN
@BBWSPASSWORD	nvarchar(100)	IN
Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBWSURL (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @BBWSURL dbo.UDT_WEBADDRESS,
            @BBWSUSERNAME nvarchar(100),
            @BBWSPASSWORD nvarchar(100)
                    ) as
                        set nocount on;

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

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

            exec dbo.USP_GET_KEY_ACCESS

                        begin try
              if exists(select top 1 1 from dbo.[WEALTHPOINTCONFIGURATION])
                              update
                                  dbo.[WEALTHPOINTCONFIGURATION]
                              set
                                  [BBWSURL] = @BBWSURL,
                  [BBWSUSERNAME] = EncryptByKey(key_GUID('sym_BBInfinity'), @BBWSUSERNAME),
                  [BBWSPASSWORD] = EncryptByKey(key_GUID('sym_BBInfinity'), @BBWSPASSWORD),                
                                  [CHANGEDBYID] = @CHANGEAGENTID,
                                  [DATECHANGED] = @CURRENTDATE;
              else
                              insert into dbo.[WEALTHPOINTCONFIGURATION](
                                  [BBWSURL],
                  [BBWSUSERNAME],
                  [BBWSPASSWORD],
                                  [ADDEDBYID],
                                  [CHANGEDBYID],
                                  [DATECHANGED],
                                  [DATEADDED])
                              values(
                                  @BBWSURL,
                  EncryptByKey(key_GUID('sym_BBInfinity'), @BBWSUSERNAME),
                  EncryptByKey(key_GUID('sym_BBInfinity'), @BBWSPASSWORD),                
                                  @CHANGEAGENTID,
                                  @CHANGEAGENTID,
                                  @CURRENTDATE,
                                  @CURRENTDATE);

              close symmetric key sym_BBInfinity
                        end try
                        begin catch
              close symmetric key sym_BBInfinity
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;