USP_APPUSERTHIRDPARTYAUTH_UPDATEINVITATIONSTATUS

create procedure dbo.USP_APPUSERTHIRDPARTYAUTH_UPDATEINVITATIONSTATUS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @INVITATIONID uniqueidentifier,
    @INVITATIONSTATUSCODE tinyint    
)
as
    set nocount on;

    declare @CURRENTDATE datetime = getdate();
    declare @CURRENTDATETIMEOFFSET datetimeoffset = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(GETUTCDATE(), 1)

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

    begin try

        if exists(
                select ID
                from dbo.APPUSERTHIRDPARTYAUTH
                where ID = @ID
            )
            update dbo.APPUSERTHIRDPARTYAUTH set
                INVITATIONID  = @INVITATIONID,
                INVITATIONSTATUSCODE = @INVITATIONSTATUSCODE,
                INVITATIONDATE = @CURRENTDATETIMEOFFSET,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
            where ID = @ID;

        else
            insert into dbo.APPUSERTHIRDPARTYAUTH
                (ID, INVITATIONID, INVITATIONSTATUSCODE, INVITATIONDATE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values
                (@ID, @INVITATIONID, @INVITATIONSTATUSCODE, @CURRENTDATETIMEOFFSET, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

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

    return 0;