USP_DATAFORMTEMPLATE_EDIT_MATCHFINDERCONFIG_2

The save procedure used by the edit dataform template "MatchFinder Configuration Edit Form".
Parameters

Parameter	Parameter Type	Mode	Description
@SITEID	nvarchar(100)	IN	Site ID
@ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@PHONETYPECODEID	uniqueidentifier	IN	Phone type
@FAXTYPECODEID	uniqueidentifier	IN	Fax type
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact type
@CONTACTRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Contact relationship type
@CONTACTRECIPROCALRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Contact reciprocal relationship type
@CONTACTEMAILADDRESSTYPECODEID	uniqueidentifier	IN	Contact email type
@ALIASTYPECODEID	uniqueidentifier	IN	Alias type
@MATCHINGGIFTCONDITIONTYPECODEID	uniqueidentifier	IN	Matching gift condition type
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@INFOSOURCECODEID	uniqueidentifier	IN	Information source
Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MATCHFINDERCONFIG_2
                    (
                        @SITEID nvarchar(100),
                        @ADDRESSTYPECODEID uniqueidentifier,
                        @PHONETYPECODEID uniqueidentifier,
                        @FAXTYPECODEID uniqueidentifier,
                        @CONTACTTYPECODEID uniqueidentifier,
                        @CONTACTRELATIONSHIPTYPECODEID uniqueidentifier,
                        @CONTACTRECIPROCALRELATIONSHIPTYPECODEID uniqueidentifier,
                        @CONTACTEMAILADDRESSTYPECODEID uniqueidentifier,
                        @ALIASTYPECODEID uniqueidentifier,
                        @MATCHINGGIFTCONDITIONTYPECODEID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @INFOSOURCECODEID uniqueidentifier
                    )
                    as
                    set nocount on;

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

                    declare @CHANGEDATE datetime;
                    set @CHANGEDATE = getdate();

                    begin try
                        exec dbo.USP_GET_KEY_ACCESS;

                        if(select count(ID) from dbo.MATCHFINDERCONFIGURATION) = 0
                        begin
                            insert into dbo.MATCHFINDERCONFIGURATION(
                                    SITEID,
                                    ADDRESSTYPECODEID, 
                                    PHONETYPECODEID, 
                                    FAXTYPECODEID,
                                    CONTACTTYPECODEID, 
                                    CONTACTRELATIONSHIPTYPECODEID, 
                                    CONTACTRECIPROCALRELATIONSHIPTYPECODEID,
                                    CONTACTEMAILADDRESSTYPECODEID,
                                    ALIASTYPECODEID,
                                    MATCHINGGIFTCONDITIONTYPECODEID,
                                    INFOSOURCECODEID,
                                    ADDEDBYID, 
                                    CHANGEDBYID, 
                                    DATEADDED, 
                                    DATECHANGED
                                ) values (
                                    EncryptByKey(Key_GUID('sym_BBInfinity'), @SITEID),
                                    @ADDRESSTYPECODEID, 
                                    @PHONETYPECODEID, 
                                    @FAXTYPECODEID,
                                    @CONTACTTYPECODEID,
                                    @CONTACTRELATIONSHIPTYPECODEID,
                                    @CONTACTRECIPROCALRELATIONSHIPTYPECODEID,
                                    @CONTACTEMAILADDRESSTYPECODEID,
                                    @ALIASTYPECODEID,
                                    @MATCHINGGIFTCONDITIONTYPECODEID,
                                    @INFOSOURCECODEID,
                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID,
                                    @CHANGEDATE,
                                    @CHANGEDATE);
                        end
                        else
                        begin
                            declare @ID uniqueidentifier;
                            select top 1 @ID = ID from dbo.MATCHFINDERCONFIGURATION;

                            if not @ID is null
                            begin
                                declare @contextCache varbinary(128);
                                set @contextCache = CONTEXT_INFO();
                                if not @CHANGEAGENTID is null
                                    set CONTEXT_INFO @CHANGEAGENTID;

                                delete from dbo.MATCHFINDERCONFIGURATION where ID <> @ID

                                if not @contextCache is null
                                    set CONTEXT_INFO @contextCache; 

                                update dbo.MATCHFINDERCONFIGURATION
                                    set SITEID = EncryptByKey(Key_GUID('sym_BBInfinity'), @SITEID),
                                        ADDRESSTYPECODEID = @ADDRESSTYPECODEID,
                                        PHONETYPECODEID = @PHONETYPECODEID,
                                        FAXTYPECODEID = @FAXTYPECODEID,
                                        CONTACTTYPECODEID = @CONTACTTYPECODEID,
                                        CONTACTRELATIONSHIPTYPECODEID = @CONTACTRELATIONSHIPTYPECODEID,
                                        CONTACTRECIPROCALRELATIONSHIPTYPECODEID = @CONTACTRECIPROCALRELATIONSHIPTYPECODEID,
                                        CONTACTEMAILADDRESSTYPECODEID = @CONTACTEMAILADDRESSTYPECODEID,
                                        ALIASTYPECODEID = @ALIASTYPECODEID,
                                        MATCHINGGIFTCONDITIONTYPECODEID = @MATCHINGGIFTCONDITIONTYPECODEID,
                                        INFOSOURCECODEID = @INFOSOURCECODEID,
                                        CHANGEDBYID = @CHANGEAGENTID,
                                        DATECHANGED = @CHANGEDATE

                            end
                        end

                        close symmetric key sym_BBInfinity;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;

                        close symmetric key sym_BBInfinity;
                        return 1;
                    end catch

                    return 0;