USP_DATAFORMTEMPLATE_ADD_STEWARDSHIPPLANSTEPNOTE

The save procedure used by the add dataform template "Stewardship Plan Step Note Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@STEPID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being 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
@HTMLNOTE	nvarchar(max)	IN	Notes

Definition

Copy



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

    begin try

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

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

        declare @CURRENTDATE datetime;
        set @CURRENTDATE = getdate();

        declare @PLANID uniqueidentifier;
        select @PLANID = PLANID from dbo.STEWARDSHIPPLANSTEP where ID = @STEPID;

        insert into dbo.STEWARDSHIPNOTE (
            ID, 
            DATEENTERED, 
            TITLE, 
            AUTHORID, 
            TEXTNOTE, 
            STEWARDSHIPNOTETYPECODEID, 
            PLANID,
            STEPID, 
                            [HTMLNOTE],
            ENTEREDBYAPPUSERID,
            ADDEDBYID, 
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED
        ) values (
            @ID,
            @DATEENTERED,
            @TITLE,
            @AUTHORID,
            @TEXTNOTE,
            @NOTETYPECODEID,
            @PLANID,
            @STEPID,
                            @HTMLNOTE,
            @CURRENTAPPUSERID,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CURRENTDATE,
            @CURRENTDATE
        )

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

return 0;