USP_EXCHANGECONTACTSYNC_ADDCONTACTLINK

Records the link between a constituent and app user.

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@APPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_EXCHANGECONTACTSYNC_ADDCONTACTLINK
            (
                @CONSTITUENTID uniqueidentifier, 
                @APPUSERID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as
                set nocount on;

                declare @CURRENTDATE datetime

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

                set @CURRENTDATE = getdate();

                if not exists(select ID from dbo.EXCHANGECONTACT where EXCHANGECONTACT.CONSTITUENTID = @CONSTITUENTID and EXCHANGECONTACT.APPUSERID = @APPUSERID) begin
                    insert into dbo.EXCHANGECONTACT
                        (CONSTITUENTID, APPUSERID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED) 
                    values 
                        (@CONSTITUENTID, @APPUSERID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
                end;