USP_REVENUECATEGORY_ADDEDIT

CREATE procedure dbo.USP_REVENUECATEGORY_ADDEDIT
(
    @REVENUESPLITID uniqueidentifier,
    @CATEGORYCODEID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin

    set nocount on;

        declare @CURRENTDATE datetime;

        set @CURRENTDATE = GetDate();

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

        begin try

            if exists(select ID from dbo.REVENUECATEGORY where ID = @REVENUESPLITID)
                if not @CATEGORYCODEID is null
                    update dbo.REVENUECATEGORY 
                    set GLREVENUECATEGORYMAPPINGID = @CATEGORYCODEID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE 
                    where ID = @REVENUESPLITID and GLREVENUECATEGORYMAPPINGID <> @CATEGORYCODEID;
                else
                    delete dbo.REVENUECATEGORY where ID = @REVENUESPLITID;
            else
                if not @CATEGORYCODEID is null
                    insert into dbo.REVENUECATEGORY (ID, GLREVENUECATEGORYMAPPINGID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        values (@REVENUESPLITID, @CATEGORYCODEID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

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

        return 0;


end