USP_GIVINGLISTMODE_SAVE

create procedure dbo.USP_GIVINGLISTMODE_SAVE
(
    @APPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @CURRENTDATE datetime,
    @REVENUEMODE as bit
)
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.GIVINGLISTMODE where APPUSERID = @APPUSERID)
        begin
            update dbo.GIVINGLISTMODE
            set REVENUEMODE = @REVENUEMODE,
                    DATECHANGED = @CURRENTDATE,
                    CHANGEDBYID = @CHANGEAGENTID
            where APPUSERID = @APPUSERID
        end
        else
        begin
            insert into dbo.GIVINGLISTMODE(APPUSERID,REVENUEMODE,DATEADDED, DATECHANGED, ADDEDBYID, CHANGEDBYID)
            values (@APPUSERID, @REVENUEMODE, @CURRENTDATE, @CURRENTDATE, @CHANGEAGENTID, @CHANGEAGENTID)
        end
    end
end