USP_BENEFITOPTION_ADD_EDIT

create procedure dbo.USP_BENEFITOPTION_ADD_EDIT
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(50) = '',
  @DESCRIPTION nvarchar(500) = ''    
)
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

    IF NOT EXISTS (SELECT * FROM dbo.BENEFITOPTION (NOLOCK) WHERE ID= @ID)    
      INSERT INTO dbo.BENEFITOPTION    
       (ID, NAME, DESCRIPTION, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      VALUES    
       (@ID, @NAME, @DESCRIPTION, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
    ELSE
      UPDATE dbo.BENEFITOPTION SET NAME = @NAME, DESCRIPTION = @DESCRIPTION WHERE ID= @ID

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

return 0;