USP_REGISTRATIONWAIVER_ADD_EDIT

CREATE procedure dbo.USP_REGISTRATIONWAIVER_ADD_EDIT
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @EVENTID uniqueidentifier = null,
  @WAIVERTEXT nvarchar(max)= null
)
as
    set nocount on;
    if @ID is null
        set @ID = newid()

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

    declare @CURRENTDATE datetime,
          @SEQUENCE int
    set @CURRENTDATE = getdate()    

    begin try


    exec dbo.USP_DATAFORMTEMPLATE_VIEW_REGISTRATION_WAIVER @ID=@EVENTID, @SEQUENCE=@SEQUENCE output

    IF EXISTS (SELECT * FROM dbo.REGISTRATIONWAIVER (NOLOCK) WHERE EVENTID= @EVENTID)    
        UPDATE dbo.REGISTRATIONWAIVER
            SET    ISCURRENT= 0
        WHERE    EVENTID = @EVENTID 
        AND        ISCURRENT = 1
    and   SEQUENCE = @SEQUENCE

    IF NOT EXISTS (SELECT * FROM dbo.REGISTRATIONWAIVER (NOLOCK) WHERE ID= @ID)    
        INSERT INTO dbo.REGISTRATIONWAIVER    
            (ID, EVENTID, WAIVERTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, ISCURRENT, SEQUENCE)    
        VALUES    
            (@ID, @EVENTID, @WAIVERTEXT, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, 1, @SEQUENCE + 1)    

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

return 0;