USP_DATAFORMTEMPLATE_VIEW_EVENTTEAMHIERARCHY_CONFIG

The load procedure used by the view dataform template "EventTeamHierarchyConfig 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.
@INDIVIDUALSFUNDRAISE	bit	INOUT	Individual participants can fundraise
@HOUSEHOLDSFUNDRAISE	bit	INOUT	Households can fundraise
@HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS	tinyint	INOUT	Number of household co-leaders household leader can appoint
@HOUSEHOLDSJOINTEAMS	bit	INOUT	Households can join teams
@TEAMSFUNDRAISE	bit	INOUT	Teams can fundraise
@TEAMSREQUESTFUNDRAISE	bit	INOUT	Event administrator must approve new teams
@TEAMNAMECHANGEAFTERREG	bit	INOUT	Team name can change after registration
@TEAMLEADERAPPOINTTEAMCOLEADERS	tinyint	INOUT	Number of team co-leaders team leader can appoint
@TEAMLEADERAPPROVETEAMMEMBERS	bit	INOUT	Team leader must approve team members
@TEAMLEADEROPTIONAPPROVETEAMMEMBERS	bit	INOUT	Team leader has option to approve team members
@COMPANIESFUNDRAISE	bit	INOUT	Companies can fundraise
@COMPANYTEAMSAPPROVEBYEVENTADMIN	bit	INOUT	Event administrator must approve new companies
@COMPANYLEADERAPPOINTCOMPANYCOLEADERS	tinyint	INOUT	Number of company co-leaders company leader can appoint
@COMPANYNAMECHANGEAFTERREG	bit	INOUT	Company name can change after registration
@COMPANYLEADERAPPROVETEAMS	bit	INOUT	Company leader must approve teams
@COMPANYLEADEROPTIONAPPROVETEAMS	bit	INOUT	Company leader has option to approve teams
@HOUSEHOLDMEMBERSLIMIT	int	INOUT	Household members limit
@TEAMMEMBERSLIMIT	int	INOUT	Team members limit
@COMPANYTEAMSLIMIT	int	INOUT	Company teams limit
@COMPANYTEAMMEMBERSLIMIT	int	INOUT	Company team members limit
@PARTICIPANTSCANREACTIVATETEAMS	bit	INOUT	Participants can reactivate teams
@FORMERTEAMCANREACTIVATETEAMSCODE	tinyint	INOUT	Choice of team activation level
@FORMERTEAMCANREACTIVATETEAMSCODE_ZERO	varchar(3)	INOUT	Only former team leaders can reactivate teams
@FORMERTEAMCANREACTIVATETEAMSCODE_ONE	varchar(3)	INOUT	Former team leaders and team members can reactivate teams
@FORMERTEAMCANREACTIVATETEAMSCODE_TWO	varchar(3)	INOUT	Anyone can reactivate teams
@PARTICIPANTSCANREACTIVATECOMPANYTEAMS	bit	INOUT	Participants can reactivate companies
@FORMERCOMPANYCANREACTIVATETEAMSCODE	tinyint	INOUT	Choice of company activation level
@FORMERCOMPANYCANREACTIVATETEAMSCODE_ZERO	varchar(3)	INOUT	Only former company leaders can reactivate companies
@FORMERCOMPANYCANREACTIVATETEAMSCODE_ONE	varchar(3)	INOUT	Former company leaders and company team leaders can reactivate companies
@FORMERCOMPANYCANREACTIVATETEAMSCODE_TWO	varchar(3)	INOUT	Any former company team member can reactivate a company
@PARTICIPANTSCANREACTIVATEHOUSEHOLDS	bit	INOUT	Participants can reactivate households
@FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE	tinyint	INOUT	Choice of household activation level
@FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE_ZERO	varchar(3)	INOUT	Only former household leaders can reactivate households
@FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE_ONE	varchar(3)	INOUT	Former household leaders and household members can reactivate households

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTTEAMHIERARCHY_CONFIG
(

  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  --@TSLONG bigint = 0 output,
    @INDIVIDUALSFUNDRAISE bit = null output,

    @HOUSEHOLDSFUNDRAISE bit = null output,
    --@HOUSEHOLDAPPROVEBYEVENTADMIN bit = null output,
    @HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS tinyint = null output,
  @HOUSEHOLDSJOINTEAMS bit = null output,

    @TEAMSFUNDRAISE bit = null output,
    @TEAMSREQUESTFUNDRAISE bit = null output,
  @TEAMNAMECHANGEAFTERREG bit = null output,    
    @TEAMLEADERAPPOINTTEAMCOLEADERS tinyint = null output,
  @TEAMLEADERAPPROVETEAMMEMBERS bit = null output,
  @TEAMLEADEROPTIONAPPROVETEAMMEMBERS bit = null output,

    @COMPANIESFUNDRAISE bit = null output,
  @COMPANYTEAMSAPPROVEBYEVENTADMIN bit = null output,  
    @COMPANYLEADERAPPOINTCOMPANYCOLEADERS tinyint = null output,
  @COMPANYNAMECHANGEAFTERREG bit = null output,
    @COMPANYLEADERAPPROVETEAMS bit = null output,
  @COMPANYLEADEROPTIONAPPROVETEAMS bit = null output,

 @HOUSEHOLDMEMBERSLIMIT int= null output,
 @TEAMMEMBERSLIMIT int= null output,
 @COMPANYTEAMSLIMIT int= null output,
 @COMPANYTEAMMEMBERSLIMIT int= null output,
 @PARTICIPANTSCANREACTIVATETEAMS bit= null output,
 @FORMERTEAMCANREACTIVATETEAMSCODE tinyint= null output, 

 @FORMERTEAMCANREACTIVATETEAMSCODE_ZERO varchar(3) = null output, 
 @FORMERTEAMCANREACTIVATETEAMSCODE_ONE  varchar(3) = null output, 
 @FORMERTEAMCANREACTIVATETEAMSCODE_TWO  varchar(3) = null output, 

 @PARTICIPANTSCANREACTIVATECOMPANYTEAMS bit= null output,
 @FORMERCOMPANYCANREACTIVATETEAMSCODE tinyint= null output,
 @FORMERCOMPANYCANREACTIVATETEAMSCODE_ZERO varchar(3) = null output,
 @FORMERCOMPANYCANREACTIVATETEAMSCODE_ONE  varchar(3) = null output,
 @FORMERCOMPANYCANREACTIVATETEAMSCODE_TWO  varchar(3) = null output,

 @PARTICIPANTSCANREACTIVATEHOUSEHOLDS bit= null output,
 @FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE tinyint= null output,
 @FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE_ZERO varchar(3) = null output,
 @FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE_ONE  varchar(3) = 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,
        --@TSLONG = EC.TSLONG,
        @INDIVIDUALSFUNDRAISE = EC.INDIVIDUALSFUNDRAISE,
        @HOUSEHOLDSFUNDRAISE = EC.HOUSEHOLDSFUNDRAISE,
        --@HOUSEHOLDAPPROVEBYEVENTADMIN = EC.HOUSEHOLDAPPROVEBYEVENTADMIN,
        @HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS = EC.HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS,
        @HOUSEHOLDSJOINTEAMS = EC.HOUSEHOLDSJOINTEAMS,
        @TEAMSFUNDRAISE = EC.TEAMSFUNDRAISE,
        @TEAMSREQUESTFUNDRAISE = EC.TEAMSREQUESTFUNDRAISE,
        @TEAMNAMECHANGEAFTERREG = EC.TEAMNAMECHANGEAFTERREG,        
        @TEAMLEADERAPPOINTTEAMCOLEADERS = EC.TEAMLEADERAPPOINTTEAMCOLEADERS,
        @TEAMLEADERAPPROVETEAMMEMBERS = EC.TEAMLEADERAPPROVETEAMMEMBERS,
        @TEAMLEADEROPTIONAPPROVETEAMMEMBERS = EC.TEAMLEADEROPTIONAPPROVETEAMMEMBERS,
        @COMPANIESFUNDRAISE = EC.COMPANIESFUNDRAISE,
        @COMPANYTEAMSAPPROVEBYEVENTADMIN = EC.COMPANYTEAMSAPPROVEBYEVENTADMIN,
        @COMPANYLEADERAPPOINTCOMPANYCOLEADERS = EC.COMPANYLEADERAPPOINTCOMPANYCOLEADERS,
    @COMPANYNAMECHANGEAFTERREG = EC.COMPANYNAMECHANGEAFTERREG,
        @COMPANYLEADERAPPROVETEAMS = EC.COMPANYLEADERAPPROVETEAMS,
        @COMPANYLEADEROPTIONAPPROVETEAMS = EC.COMPANYLEADEROPTIONAPPROVETEAMS,

        @HOUSEHOLDMEMBERSLIMIT= HOUSEHOLDMEMBERSLIMIT,
        @TEAMMEMBERSLIMIT= TEAMMEMBERSLIMIT,
        @COMPANYTEAMSLIMIT= COMPANYTEAMSLIMIT,
        @COMPANYTEAMMEMBERSLIMIT= COMPANYTEAMMEMBERSLIMIT,
        @PARTICIPANTSCANREACTIVATETEAMS= PARTICIPANTSCANREACTIVATETEAMS,
        @FORMERTEAMCANREACTIVATETEAMSCODE= FORMERTEAMCANREACTIVATETEAMSCODE,
    @FORMERTEAMCANREACTIVATETEAMSCODE_ZERO = case when FORMERTEAMCANREACTIVATETEAMSCODE = 0 then 'Yes' else 'No' end,
    @FORMERTEAMCANREACTIVATETEAMSCODE_ONE  = case when FORMERTEAMCANREACTIVATETEAMSCODE = 1 then 'Yes' else 'No' end,
    @FORMERTEAMCANREACTIVATETEAMSCODE_TWO  = case when FORMERTEAMCANREACTIVATETEAMSCODE = 2 then 'Yes' else 'No' end,

        @PARTICIPANTSCANREACTIVATECOMPANYTEAMS= PARTICIPANTSCANREACTIVATECOMPANYTEAMS,
        @FORMERCOMPANYCANREACTIVATETEAMSCODE = FORMERCOMPANYCANREACTIVATETEAMSCODE,
    @FORMERCOMPANYCANREACTIVATETEAMSCODE_ZERO = case when FORMERCOMPANYCANREACTIVATETEAMSCODE = 0 then 'Yes' else 'No' end,
    @FORMERCOMPANYCANREACTIVATETEAMSCODE_ONE  = case when FORMERCOMPANYCANREACTIVATETEAMSCODE = 1 then 'Yes' else 'No' end,
    @FORMERCOMPANYCANREACTIVATETEAMSCODE_TWO  = case when FORMERCOMPANYCANREACTIVATETEAMSCODE = 2 then 'Yes' else 'No' end,

    @PARTICIPANTSCANREACTIVATEHOUSEHOLDS= PARTICIPANTSCANREACTIVATEHOUSEHOLDS,
    @FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE = FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE,
    @FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE_ZERO = case when FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE = 0 then 'Yes' else 'No' end,
     @FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE_ONE = case when FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE = 1 then 'Yes' else 'No' end


    from dbo.EVENTTEAMFAFCONFIG EC
    where EVENTID = @ID

    return 0;