USP_MATCHFINDER_LINKCONSTITUENTTOMATCHFINDER

Links a constituent record to a MatchFinder Online record.

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@MATCHFINDERRECORDID	int	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_MATCHFINDER_LINKCONSTITUENTTOMATCHFINDER
            (
                @CONSTITUENTID uniqueidentifier,
                @MATCHFINDERRECORDID int,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as 
            set nocount on;

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

            if @CHANGEDATE is null
                set @CHANGEDATE = getdate();

            begin try
                if(select count(ID) from dbo.MATCHFINDERCONSTITUENT where ID = @CONSTITUENTID) > 0
                    raiserror('ERR_MFCONSTIUTENTLINK_CONSTITUENTALREADYLINKED', 16, 1);

                if(select count(ID) from dbo.MATCHFINDERCONSTITUENT where MATCHFINDERRECORDID = @MATCHFINDERRECORDID) > 0
                    raiserror('ERR_MFCONSTITUENTLINK_MFRECORDALREADYLINKED', 16, 1);

                insert into dbo.MATCHFINDERCONSTITUENT(ID, MATCHFINDERRECORDID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values(@CONSTITUENTID, @MATCHFINDERRECORDID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);                
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;