USP_DATAFORMTEMPLATE_ADD_FAF_COMMENTS

The save procedure used by the add dataform template "FAF Comments 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.
@EVENTID	uniqueidentifier	IN	Event
@TEAMFUNDRAISINGTEAMID	uniqueidentifier	IN	Teamfundraisingteam
@REGISTRANTID	uniqueidentifier	IN	Registrant
@CLIENTUSERSID	int	IN	Clientusers
@AUTHORNAME	nvarchar(255)	IN	Authorname
@COMMENTTEXT	nvarchar(1000)	IN	Commenttext
@LIKECOUNT	int	IN	Likecount
@DISLIKECOUNT	int	IN	Dislikecount
@ROOTCOMMENTID	uniqueidentifier	IN	Rootcomment

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAF_COMMENTS
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier,
    @TEAMFUNDRAISINGTEAMID uniqueidentifier = null,
    @REGISTRANTID uniqueidentifier = null,
    @CLIENTUSERSID int = null,
    @AUTHORNAME nvarchar(255) = '',
    @COMMENTTEXT nvarchar(1000),
    @LIKECOUNT int = 0,
    @DISLIKECOUNT int = 0,
    @ROOTCOMMENTID uniqueidentifier = null
)
as

set nocount on;

DECLARE @PARENTCOMMENTID uniqueidentifier

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

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

  if @ROOTCOMMENTID is null
      set @ROOTCOMMENTID = @ID

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try
    -- handle inserting the data
    insert into dbo.FAFCOMMENTS
        (ID,EVENTID, TEAMFUNDRAISINGTEAMID, REGISTRANTID, CLIENTUSERSID, AUTHORNAME, COMMENTTEXT, LIKECOUNT, DISLIKECOUNT, ROOTCOMMENTID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (@ID,@EVENTID, @TEAMFUNDRAISINGTEAMID, @REGISTRANTID, @CLIENTUSERSID, @AUTHORNAME, @COMMENTTEXT, @LIKECOUNT, @DISLIKECOUNT, @ROOTCOMMENTID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

 --select top 1 @ID = ID FROM dbo.FAFCOMMENTS with (NOLOCK)
        --where EVENTID = @EVENTID        
        --AND ISNULL(REGISTRANTID,'00000000-0000-0000-0000-000000000000') = ISNULL(ISNULL(@REGISTRANTID,REGISTRANTID),'00000000-0000-0000-0000-000000000000')
        --AND ISNULL(TEAMFUNDRAISINGTEAMID,'00000000-0000-0000-0000-000000000000') = ISNULL(ISNULL(@TEAMFUNDRAISINGTEAMID,TEAMFUNDRAISINGTEAMID),'00000000-0000-0000-0000-000000000000')
        --ORDER BY DATEADDED DESC

    --if @ROOTCOMMENTID is null
    --begin

        --UPDATE FAFCOMMENTS
        --SET ROOTCOMMENTID = @ID
        --WHERE ID = @ID
    --end

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0