USP_DATAFORMTEMPLATE_VIEW_PARTICIPANT_TITLE

The load procedure used by the view dataform template "Participant List View"

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.
@TYPECODE	tinyint	INOUT	Type
@TEAMNAME	nvarchar(100)	INOUT	Team Name
@FULLNAME	nvarchar(100)	INOUT	Full Name

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PARTICIPANT_TITLE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TYPECODE tinyint = NULL output,
    @TEAMNAME nvarchar(100) = null output,
    @FULLNAME nvarchar(100) = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    IF EXISTS (SELECT TOP 1 R.ID FROM REGISTRANT R LEFT JOIN TEAMFUNDRAISINGTEAMCAPTAIN TFTC ON TFTC.CONSTITUENTID = R.CONSTITUENTID WHERE TFTC.TEAMFUNDRAISINGTEAMID=@ID)    
    BEGIN    
        SET @ID=(SELECT TOP 1 R.ID FROM REGISTRANT R LEFT JOIN TEAMFUNDRAISINGTEAMCAPTAIN TFTC ON TFTC.CONSTITUENTID = R.CONSTITUENTID WHERE TFTC.TEAMFUNDRAISINGTEAMID=@ID)
    END    

    --SELECT        R.ID AS REGISTRANTID, TE.TYPECODE AS ROLE, TFT.NAME AS TEAMNAME, dbo.UFN_REGISTRANT_GETNAME(R.ID) as FULLNAME

    SELECT        @DATALOADED = 1,
                @TYPECODE = TE.TYPECODE,
                @TEAMNAME = TFT.NAME, 
                @FULLNAME= dbo.UFN_REGISTRANT_GETNAME(R.ID)            
    FROM        REGISTRANT R 
    LEFT JOIN    TEAMFUNDRAISER TFR ON R.CONSTITUENTID = TFR.CONSTITUENTID
    LEFT JOIN    TEAMFUNDRAISINGTEAMMEMBER TFTM ON TFR.ID = TFTM.TEAMFUNDRAISERID
    LEFT JOIN    TEAMFUNDRAISINGTEAM TFT ON TFTM.TEAMFUNDRAISINGTEAMID = TFT.ID
    LEFT JOIN    TEAMEXTENSION TE ON TFTM.TEAMFUNDRAISINGTEAMID = TE.TEAMFUNDRAISINGTEAMID
    WHERE        R.ID= @ID    

    return 0;