USP_BBNC_COMMITDONATION_ADDACKNOWLEDGEETOTRIBUTE

Adds a constituent as an acknowledgee on a tribute.

Parameters

Parameter	Parameter Type	Mode
@TRIBUTEID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_BBNC_COMMITDONATION_ADDACKNOWLEDGEETOTRIBUTE
            (
                @TRIBUTEID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as
            set nocount on;

            if not @TRIBUTEID is null and not @CONSTITUENTID is null
            begin
                if (select count(ID) from dbo.TRIBUTEACKNOWLEDGEE where TRIBUTEID = @TRIBUTEID and CONSTITUENTID = @CONSTITUENTID) = 0 
                begin
                    declare @SEQUENCE int;
                    select @SEQUENCE = coalesce(max(SEQUENCE), 0) + 1 from dbo.TRIBUTEACKNOWLEDGEE where TRIBUTEID = @TRIBUTEID;

                    insert into dbo.TRIBUTEACKNOWLEDGEE(ID, TRIBUTEID, CONSTITUENTID, SEQUENCE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        values(newid(), @TRIBUTEID, @CONSTITUENTID, @SEQUENCE, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
                end
            end