USP_DATAFORMTEMPLATE_EDIT_GIVINGLISTSUMMARYSETTINGS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GIVINGLISTSUMMARYSETTINGS
(
    @CURRENTAPPUSERID uniqueidentifier = null,
    @CHANGEAGENTID uniqueidentifier = null,
    @SUMMARYSETTINGS xml

)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    declare @RECORDEXISTS bit
    select @RECORDEXISTS = 1 from dbo.GIVINGLISTSUMMARYSETTINGS where APPUSERID = @CURRENTAPPUSERID

    if @RECORDEXISTS = 1
        begin try
            update dbo.GIVINGLISTSUMMARYSETTINGS set
                SUMMARYSETTINGS = @SUMMARYSETTINGS,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
            where APPUSERID = @CURRENTAPPUSERID
        end try

        begin catch
            exec dbo.USP_RAISE_ERROR
            return 1
        end catch
    else
        begin try
            insert into dbo.GIVINGLISTSUMMARYSETTINGS
                (
                    APPUSERID,
                    SUMMARYSETTINGS,
                    ADDEDBYID,
                    CHANGEDBYID,
                    DATEADDED,
                    DATECHANGED
                )
            values
                (
                    @CURRENTAPPUSERID,
                    @SUMMARYSETTINGS,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE
                )
        end try
        begin catch
            exec dbo.USP_RAISE_ERROR
            return 1
        end catch

return 0;