USP_DATAFORMTEMPLATE_VIEW_AVAILABLE_FUNDRAISINGGROUPS

The load procedure used by the view dataform template "Event Team Hierarchy Config View Form 2"

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.
@INDIVIDUALSENABLED	bit	INOUT	Individual participants can fundraise
@HOUSEHOLDSENABLED	bit	INOUT	Households can fundraise
@TEAMSENABLED	bit	INOUT	Teams can fundraise
@COMPANIESENABLED	bit	INOUT	Companies can fundraise
@FUNDRAISINGCOACHENABLED	bit	INOUT	Fundraising coach
@SPONSORENABLED	bit	INOUT	Sponsor
@PREVIOUSYEAREVENTID	uniqueidentifier	INOUT	Previous year eventid

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_AVAILABLE_FUNDRAISINGGROUPS
(
    @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
    @INDIVIDUALSENABLED bit = null output,  
    @HOUSEHOLDSENABLED bit = null output,  
    @TEAMSENABLED bit = null output,  
    @COMPANIESENABLED bit = null output,
    @FUNDRAISINGCOACHENABLED bit = null output,
    @SPONSORENABLED bit = null output,
    @PREVIOUSYEAREVENTID uniqueidentifier= null output

)
as
    set nocount on;

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

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

    select @DATALOADED = 1,
           @INDIVIDUALSENABLED = INDIVIDUALSFUNDRAISE,
           @HOUSEHOLDSENABLED = HOUSEHOLDSFUNDRAISE,
           @TEAMSENABLED = TEAMSFUNDRAISE,
           @COMPANIESENABLED = COMPANIESFUNDRAISE,
           @PREVIOUSYEAREVENTID= PRIORYEAREVENTID 
           --from dbo.EVENTTEAMFAFCONFIG

           --where EVENTID = @ID    

      FROM dbo.EVENTEXTENSION E(NOLOCK) INNER JOIN 
      dbo.EVENTTEAMFAFCONFIG EC (NOLOCK)
      ON E.EVENTID= EC.EVENTID AND E.EVENTID= @ID

  if @INDIVIDUALSENABLED = 1 or @HOUSEHOLDSENABLED = 1 or @TEAMSENABLED = 1 or @COMPANIESENABLED = 1
    set @FUNDRAISINGCOACHENABLED = 1
  else
    set @FUNDRAISINGCOACHENABLED = 0

  if exists(select top 1 ID from EVENTSPONSORSHIPTYPE where EVENTID = @ID)
        set @SPONSORENABLED = 1
    ELSE
        set @SPONSORENABLED = 0

    return 0;