USP_DATAFORMTEMPLATE_ADD_APPEALNOTE

The save procedure used by the add dataform template "Appeal Note Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DATEENTERED	datetime	IN	Date
@TITLE	nvarchar(50)	IN	Title
@AUTHORID	uniqueidentifier	IN	Author
@TEXTNOTE	nvarchar(max)	IN	Notes
@NOTETYPECODEID	uniqueidentifier	IN	Type
@APPEALID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@HTMLNOTE	nvarchar(max)	IN	Notes

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_APPEALNOTE
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,    
  @DATEENTERED datetime = null,
  @TITLE nvarchar(50) = '',
  @AUTHORID uniqueidentifier = null,
  @TEXTNOTE nvarchar(max) = '',
  @NOTETYPECODEID uniqueidentifier,
  @APPEALID uniqueidentifier,
  @HTMLNOTE nvarchar(max) = ''
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

  begin try
    if @ID is null
      set @ID = newid();

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

    set @CURRENTDATE = getdate();


    insert into dbo.[APPEALNOTE] (
      [ID],
      [DATEENTERED],
      [TITLE],
      [AUTHORID],
      [TEXTNOTE],
      [APPEALNOTETYPECODEID],
      [APPEALID],
      [HTMLNOTE],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      @ID,
      @DATEENTERED,
      @TITLE,
      @AUTHORID,
      @TEXTNOTE, 
      @NOTETYPECODEID,
      @APPEALID,
      @HTMLNOTE,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );

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

  return 0;