USP_TOKENIZERUSERCONFIG_SAVE

create procedure dbo.USP_TOKENIZERUSERCONFIG_SAVE
(
    @APPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @CURRENTDATE datetime,
    @FIELDMAPPING as xml
)
as
begin
    if @APPUSERID is not null 
    begin

        if @CURRENTDATE is null
        begin
            set @CURRENTDATE = getdate();
        end

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

        if exists(select 1 from dbo.TOKENIZERUSERCONFIG where APPUSERID = @APPUSERID)
        begin
            update dbo.TOKENIZERUSERCONFIG
            set FIELDMAPPING = @FIELDMAPPING,
                    DATECHANGED = @CURRENTDATE,
                    CHANGEDBYID = @CHANGEAGENTID
            where APPUSERID = @APPUSERID
        end
        else
        begin
            insert into dbo.TOKENIZERUSERCONFIG(APPUSERID,FIELDMAPPING,DATEADDED, DATECHANGED, ADDEDBYID, CHANGEDBYID)
            values (@APPUSERID, @FIELDMAPPING, @CURRENTDATE, @CURRENTDATE, @CHANGEAGENTID, @CHANGEAGENTID)
        end
    end
end