USP_DATAFORMTEMPLATE_ADD_AWARDMANAGEMENTCONFIGURATION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_AWARDMANAGEMENTCONFIGURATION
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @AWARDMANAGEMENTTOKEN nvarchar(100) = '',
  @AWARDMANAGEMENTURL nvarchar(2047) = ''
)
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();

  if exists (select top 1 1 from dbo.AWARDMANAGEMENTCONFIGURATION)
    raiserror('BBERR_AWARDMANAGEMENTCONFIGURATION_ONLYONEROWALLOWED',13,1);

  begin try
    -- handle inserting the data

    insert into dbo.AWARDMANAGEMENTCONFIGURATION
      (ID, AWARDMANAGEMENTTOKEN, AWARDMANAGEMENTURL, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
      (@ID, @AWARDMANAGEMENTTOKEN, @AWARDMANAGEMENTURL, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

  end try

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

  return 0;