USP_DATAFORMTEMPLATE_EDIT_REGISTRATION_WAIVER_2

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRATION_WAIVER_2 (
    @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @EVENTID uniqueidentifier,
  @WAIVERTEXT nvarchar(max),
  @ISCURRENT bit,
  @SEQUENCE int
)
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    
    set @CURRENTDATE = getdate()    

    begin try

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

        UPDATE dbo.REGISTRATIONWAIVER
      set ISCURRENT = 0
        WHERE    EVENTID = @EVENTID 
    and SEQUENCE = @SEQUENCE
    and ISCURRENT = 1

        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;