USP_DATAFORMTEMPLATE_EDIT_WEALTHPOINTSEARCHPARAMETERS

The save procedure used by the edit dataform template "WealthPoint Search Parameters Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@USERNAME	nvarchar(100)	IN	User name
@PASSWORD	nvarchar(100)	IN	Password
@REQUESTEDDATASOURCES	nvarchar(255)	IN	Requested data sources

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_WEALTHPOINTSEARCHPARAMETERS (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @USERNAME nvarchar(100),
    @PASSWORD nvarchar(100),
    @REQUESTEDDATASOURCES nvarchar(255)
)
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_GET_KEY_ACCESS;

        -- handle inserting the data

        if not exists(select 1 from dbo.WEALTHPOINTSEARCHPARAMETERS where ID = @ID) begin
            insert into dbo.WEALTHPOINTSEARCHPARAMETERS
                (ID, NAME, USERNAME, PASSWORD, REQUESTEDDATASOURCES, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values
                (@ID, coalesce(nullif(@NAME, ''), newid()), @USERNAME, case when nullif(@PASSWORD, '') is null then '' else EncryptByKey(key_GUID('sym_BBInfinity'), @PASSWORD) end, @REQUESTEDDATASOURCES, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

        end
        else begin
            update dbo.WEALTHPOINTSEARCHPARAMETERS
            set
                NAME = coalesce(nullif(@NAME, ''), newid()),
                USERNAME = @USERNAME,
                PASSWORD = case when nullif(@PASSWORD, '') is null then '' else EncryptByKey(key_GUID('sym_BBInfinity'), @PASSWORD) end,
                REQUESTEDDATASOURCES = @REQUESTEDDATASOURCES,
                DATECHANGED = @CURRENTDATE,
                CHANGEDBYID = @CHANGEAGENTID
            where
                ID = @ID
        end

        close symmetric key sym_BBInfinity;

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;