USP_DATAFORMTEMPLATE_VIEW_MATCHFINDERCONTACT

The load procedure used by the view dataform template "MatchFinder Contact Data View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(160)	INOUT	Name
@EMAIL	nvarchar(100)	INOUT	Email

Definition

Copy



                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MATCHFINDERCONTACT
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(160) = null output,
                    @EMAIL nvarchar(100) = null output
                )
                as
                set nocount on;

                begin try
                    declare @CONTACTEMAILADDRESSTYPECODEID uniqueidentifier;

                    select top 1
                        @CONTACTEMAILADDRESSTYPECODEID = CONTACTEMAILADDRESSTYPECODEID 
                    from dbo.MATCHFINDERCONFIGURATION;

                    if @CONTACTEMAILADDRESSTYPECODEID is null
                        raiserror('ERR_MFCONFIG_NOCONTACTRECIPROCALRELATIONSHIPTYPECODE', 16, 1);

                    select
                        @DATALOADED = 1,
                        @NAME = CONSTITUENT.NAME
                    from dbo.CONSTITUENT 
                    where CONSTITUENT.ID = @ID;

                    select top 1
                        @EMAIL = EMAILADDRESS.EMAILADDRESS
                    from dbo.EMAILADDRESS
                    where EMAILADDRESS.CONSTITUENTID = @ID and EMAILADDRESS.EMAILADDRESSTYPECODEID = @CONTACTEMAILADDRESSTYPECODEID
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;