USP_DATAFORMTEMPLATE_ADD_DONORCHALLENGENOTE

The save procedure used by the add dataform template "Donor Challenge 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
@DONORCHALLENGEID	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_DONORCHALLENGENOTE
                  (
                      @ID uniqueidentifier = null output,
                      @CHANGEAGENTID uniqueidentifier = null,    
                      @DATEENTERED datetime = null,
                      @TITLE nvarchar(50) = '',
                      @AUTHORID uniqueidentifier = null,
                      @TEXTNOTE nvarchar(max) = '',
                      @NOTETYPECODEID uniqueidentifier,
                      @DONORCHALLENGEID 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.[DONORCHALLENGENOTE] (
                              [ID],
                              [DATEENTERED],
                              [TITLE],
                              [AUTHORID],
                              [TEXTNOTE],
                              [DONORCHALLENGENOTETYPECODEID],
                              [DONORCHALLENGEID],
                              [HTMLNOTE],
                              [ADDEDBYID],
                              [CHANGEDBYID],
                              [DATEADDED],
                              [DATECHANGED]
                          ) values (
                              @ID,
                              @DATEENTERED,
                              @TITLE,
                              @AUTHORID,
                              @TEXTNOTE, 
                              @NOTETYPECODEID,
                              @DONORCHALLENGEID,
                              @HTMLNOTE,
                              @CHANGEAGENTID,
                              @CHANGEAGENTID,
                              @CURRENTDATE,
                              @CURRENTDATE
                          );

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

                      return 0;