USP_DATAFORMTEMPLATE_EDITLOAD_FAFTOPFUNDRAISERDISPLAYOPTION

The load procedure used by the edit dataform template "FAF Top Fundraiser Display Option Edit Data 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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@EVENTID	uniqueidentifier	INOUT	Event
@NUMBERCOMPANIESTODISPLAY	smallint	INOUT	Number companies to display
@DISPLAYCOMPANYNAME	bit	INOUT	Display companyname
@DISPLAYCOMPANYPICTURE	bit	INOUT	Display company picture
@DISPLAYCOMPANYSTORY	bit	INOUT	Display company story
@DISPLAYCOMPANYTOTALRAISED	bit	INOUT	Display company total raised
@DISPLAYCOMPANYFUNDRAISINGGOAL	bit	INOUT	Display company fundraising goal
@NUMBERTEAMSTODISPLAY	smallint	INOUT	Number teams to display
@DISPLAYTEAMNAME	bit	INOUT	Display team name
@DISPLAYTEAMPICTURE	bit	INOUT	Display team picture
@DISPLAYTEAMSTORY	bit	INOUT	Display team story
@DISPLAYTEAMTOTALRAISED	bit	INOUT	Display team total raised
@DISPLAYTEAMFUNDRAISINGGOAL	bit	INOUT	Display team fundraising goal
@NUMBERHOUSEHOLDSTODISPLAY	smallint	INOUT	Number households to display
@DISPLAYHOUSEHOLDNAME	bit	INOUT	Display household name
@DISPLAYHOUSEHOLDPICTURE	bit	INOUT	Display household picture
@DISPLAYHOUSEHOLDSTORY	bit	INOUT	Display household story
@DISPLAYHOUSEHOLDTOTALRAISED	bit	INOUT	Display household total raised
@DISPLAYHOUSEHOLDFUNDRAISINGGOAL	bit	INOUT	Display household fundraising goal
@NUMBERPARTICIPANTSTODISPLAY	smallint	INOUT	Number participants to display
@DISPLAYPARTICIPANTNAME	bit	INOUT	Display participant name
@DISPLAYPARTICIPANTPICTURE	bit	INOUT	Display participant picture
@DISPLAYPARTICIPANTSTORY	bit	INOUT	Display participant story
@DISPLAYPARTICIPANTTOTALRAISED	bit	INOUT	Display participant total raised
@DISPLAYPARTICIPANTFUNDRAISINGGOAL	bit	INOUT	Display participant fundraising goal
@PLAYEROPTIONSTITLE	nvarchar(200)	INOUT	Player options title
@WIDTH	smallint	INOUT	Width
@HEIGHT	smallint	INOUT	Height
@SCROLLINGDIRECTIONCODE	tinyint	INOUT	Scrolling direction
@SPEED	smallint	INOUT	Speed
@DISPLAYPLAYPAUSEOPTIONS	bit	INOUT	Display play pause options
@DISPLAYCOMPANIES	bit	INOUT	Display companies
@DISPLAYTEAMS	bit	INOUT	Display teams
@DISPLAYHOUSEHOLDS	bit	INOUT	Display households
@DISPLAYPARTICIPANTS	bit	INOUT	Display participants
@DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME	bit	INOUT	Display team name in addition to fundraiser name
@DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME	bit	INOUT	Display company name in addition to fundraiser name

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_FAFTOPFUNDRAISERDISPLAYOPTION (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @EVENTID uniqueidentifier = null output,
    @NUMBERCOMPANIESTODISPLAY smallint = null output,
    @DISPLAYCOMPANYNAME bit = null output,
    @DISPLAYCOMPANYPICTURE bit = null output,
    @DISPLAYCOMPANYSTORY bit = null output,
    @DISPLAYCOMPANYTOTALRAISED bit = null output,
    @DISPLAYCOMPANYFUNDRAISINGGOAL bit = null output,
    @NUMBERTEAMSTODISPLAY smallint = null output,
    @DISPLAYTEAMNAME bit = null output,
    @DISPLAYTEAMPICTURE bit = null output,
    @DISPLAYTEAMSTORY bit = null output,
    @DISPLAYTEAMTOTALRAISED bit = null output,
    @DISPLAYTEAMFUNDRAISINGGOAL bit = null output,
    @NUMBERHOUSEHOLDSTODISPLAY smallint = null output,
    @DISPLAYHOUSEHOLDNAME bit = null output,
    @DISPLAYHOUSEHOLDPICTURE bit = null output,
    @DISPLAYHOUSEHOLDSTORY bit = null output,
    @DISPLAYHOUSEHOLDTOTALRAISED bit = null output,
    @DISPLAYHOUSEHOLDFUNDRAISINGGOAL bit = null output,
    @NUMBERPARTICIPANTSTODISPLAY smallint = null output,
    @DISPLAYPARTICIPANTNAME bit = null output,
    @DISPLAYPARTICIPANTPICTURE bit = null output,
    @DISPLAYPARTICIPANTSTORY bit = null output,
    @DISPLAYPARTICIPANTTOTALRAISED bit = null output,
    @DISPLAYPARTICIPANTFUNDRAISINGGOAL bit = null output,
    @PLAYEROPTIONSTITLE nvarchar(200) = null output,
    @WIDTH smallint = null output,
    @HEIGHT smallint = null output,
    @SCROLLINGDIRECTIONCODE tinyint = null output,
    @SPEED smallint = null output,
    @DISPLAYPLAYPAUSEOPTIONS bit = null output,

    @DISPLAYCOMPANIES bit = null output,
    @DISPLAYTEAMS bit = null output,
    @DISPLAYHOUSEHOLDS bit = null output,
    @DISPLAYPARTICIPANTS bit = null output,

    @DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME bit = null output,
    @DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME bit = null output  
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows
    set @DATALOADED = 0
    set @TSLONG = 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.  Also note that we fetch the TSLONG so that concurrency
    -- can be considered.
    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @EVENTID = EVENTID, 
        @NUMBERCOMPANIESTODISPLAY = NUMBERCOMPANIESTODISPLAY, 
        @DISPLAYCOMPANYNAME = DISPLAYCOMPANYNAME, 
        @DISPLAYCOMPANYPICTURE = DISPLAYCOMPANYPICTURE, 
        @DISPLAYCOMPANYSTORY = DISPLAYCOMPANYSTORY, 
        @DISPLAYCOMPANYTOTALRAISED = DISPLAYCOMPANYTOTALRAISED, 
        @DISPLAYCOMPANYFUNDRAISINGGOAL = DISPLAYCOMPANYFUNDRAISINGGOAL, 
        @NUMBERTEAMSTODISPLAY = NUMBERTEAMSTODISPLAY, 
        @DISPLAYTEAMNAME = DISPLAYTEAMNAME, 
        @DISPLAYTEAMPICTURE = DISPLAYTEAMPICTURE, 
        @DISPLAYTEAMSTORY = DISPLAYTEAMSTORY, 
        @DISPLAYTEAMTOTALRAISED = DISPLAYTEAMTOTALRAISED, 
        @DISPLAYTEAMFUNDRAISINGGOAL = DISPLAYTEAMFUNDRAISINGGOAL, 
        @NUMBERHOUSEHOLDSTODISPLAY = NUMBERHOUSEHOLDSTODISPLAY, 
        @DISPLAYHOUSEHOLDNAME = DISPLAYHOUSEHOLDNAME, 
        @DISPLAYHOUSEHOLDPICTURE = DISPLAYHOUSEHOLDPICTURE, 
        @DISPLAYHOUSEHOLDSTORY = DISPLAYHOUSEHOLDSTORY, 
        @DISPLAYHOUSEHOLDTOTALRAISED = DISPLAYHOUSEHOLDTOTALRAISED, 
        @DISPLAYHOUSEHOLDFUNDRAISINGGOAL = DISPLAYHOUSEHOLDFUNDRAISINGGOAL, 
        @NUMBERPARTICIPANTSTODISPLAY = NUMBERPARTICIPANTSTODISPLAY, 
        @DISPLAYPARTICIPANTNAME = DISPLAYPARTICIPANTNAME, 
        @DISPLAYPARTICIPANTPICTURE = DISPLAYPARTICIPANTPICTURE, 
        @DISPLAYPARTICIPANTSTORY = DISPLAYPARTICIPANTSTORY, 
        @DISPLAYPARTICIPANTTOTALRAISED = DISPLAYPARTICIPANTTOTALRAISED, 
        @DISPLAYPARTICIPANTFUNDRAISINGGOAL = DISPLAYPARTICIPANTFUNDRAISINGGOAL, 
        @PLAYEROPTIONSTITLE = PLAYEROPTIONSTITLE, 
        @WIDTH = WIDTH, 
        @HEIGHT = HEIGHT, 
        @SCROLLINGDIRECTIONCODE = SCROLLINGDIRECTIONCODE, 
        @SPEED = SPEED, 
        @DISPLAYPLAYPAUSEOPTIONS = DISPLAYPLAYPAUSEOPTIONS,

        @DISPLAYCOMPANIES = DISPLAYCOMPANIES, 
        @DISPLAYTEAMS = DISPLAYTEAMS, 
        @DISPLAYHOUSEHOLDS = DISPLAYHOUSEHOLDS,
        @DISPLAYPARTICIPANTS = DISPLAYPARTICIPANTS,

        @DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME= DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME,
        @DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME= DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME

    from dbo.FAFTOPFUNDRAISERDISPLAYOPTION
    where ID = @ID

    return 0;