USP_DATAFORMTEMPLATE_EDIT_COMMENTS

The save procedure used by the edit dataform template "Comments Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@COMMENTTEXT	nvarchar(1000)	IN	Commenttext
@AUTHORNAME	nvarchar(100)	IN	Authorname
@AUTHORCONSTITUENTID	uniqueidentifier	IN	Authorconstituentid
@EVENTID	uniqueidentifier	IN	Eventid
@REFERENCEID	uniqueidentifier	IN	Referenceid
@REFERENCETYPECODE	tinyint	IN	Referencetype

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_COMMENTS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @COMMENTTEXT nvarchar(1000),
    @AUTHORNAME nvarchar(100),
    @AUTHORCONSTITUENTID uniqueidentifier,
    @EVENTID uniqueidentifier,
    @REFERENCEID uniqueidentifier,
    @REFERENCETYPECODE tinyint
)
as

    set nocount on;

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

    begin try
        -- handle updating the data
        update dbo.COMMENT_TEXT set
            COMMENTTEXT = @COMMENTTEXT,
            AUTHORNAME = @AUTHORNAME,
            AUTHORCONSTITUENTID = @AUTHORCONSTITUENTID,
            EVENTID = @EVENTID,
            REFERENCEID = @REFERENCEID,
            REFERENCETYPECODE = @REFERENCETYPECODE,

            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;