USP_DATAFORMTEMPLATE_ADD_SURVEYNOTE

The save procedure used by the add dataform template "Survey 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
@SURVEYID	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_SURVEYNOTE
            (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,    
                @DATEENTERED datetime = null,
                @TITLE nvarchar(50) = '',
                @AUTHORID uniqueidentifier = null,
                @TEXTNOTE nvarchar(max) = '',
                @NOTETYPECODEID uniqueidentifier,
                @SURVEYID 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.SURVEYNOTE 
                        (ID, DATEENTERED, TITLE, AUTHORID, TEXTNOTE, SURVEYNOTETYPECODEID, SURVEYID, [HTMLNOTE], ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values 
                        (@ID, @DATEENTERED, @TITLE, @AUTHORID, @TEXTNOTE, @NOTETYPECODEID, @SURVEYID, @HTMLNOTE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);                        
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;