USP_DATAFORMTEMPLATE_EDITLOAD_WIDGET_EXTENSION

The load procedure used by the edit dataform template "Widget Extension Edit 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.
@PARTICIPANTWIDGETID	uniqueidentifier	INOUT	Participant Widget ID
@EVENTWIDGETID	uniqueidentifier	INOUT	Event Widget ID
@TEAMWIDGETID	uniqueidentifier	INOUT	Team Widget ID
@ALLOWOTHERAMOUNT	bit	INOUT	Allow other amount
@SUGGESTAMOUNT	money	INOUT	Suggest amount
@GIVINGLEVELDATA	nvarchar(4000)	INOUT	Supporting text
@ALLOWDONOROTHERAMOUNT	bit	INOUT	Allow donor other amount
@DISPLAYMINIMUMFUNDRAISINGGOAL	bit	INOUT	Display minimum fundraising goal
@DISPLAYTARGETFUNDRAISINGGOAL	bit	INOUT	Display target fundraising goal
@ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL	bit	INOUT	allow participant to change join team label
@ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL	bit	INOUT	allow participant to change join company label
@ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL	bit	INOUT	allow participant to change join event label
@JOINMYTEAMLABEL	nvarchar(250)	INOUT	join my team label
@JOINMYCOMPANYLABEL	nvarchar(250)	INOUT	join my company label
@JOINMYEVENTLABEL	nvarchar(250)	INOUT	join my company label

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WIDGET_EXTENSION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @PARTICIPANTWIDGETID uniqueidentifier = null output,
    @EVENTWIDGETID uniqueidentifier = null output,
    @TEAMWIDGETID uniqueidentifier = null output,
      @ALLOWOTHERAMOUNT bit = null output,
    @SUGGESTAMOUNT money = null output,
    @GIVINGLEVELDATA nvarchar(4000) = null output,
      @ALLOWDONOROTHERAMOUNT bit= null output,
      @DISPLAYMINIMUMFUNDRAISINGGOAL bit = null output,
      @DISPLAYTARGETFUNDRAISINGGOAL bit = null output,
    @ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL bit = null output,
    @ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL bit = null output,
    @ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL bit = null output,
    @JOINMYTEAMLABEL nvarchar(250) = null output,
    @JOINMYCOMPANYLABEL nvarchar(250) = null output,
    @JOINMYEVENTLABEL nvarchar(250) = 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,
    @PARTICIPANTWIDGETID = PARTICIPANTWIDGETID, 
    @EVENTWIDGETID = EVENTWIDGETID, 
    @TEAMWIDGETID = TEAMWIDGETID, 
    @ALLOWOTHERAMOUNT = ALLOWOTHERAMOUNT, 
    @SUGGESTAMOUNT = SUGGESTAMOUNT, 
    @GIVINGLEVELDATA = GIVINGLEVELDATA,
    @ALLOWDONOROTHERAMOUNT = ALLOWDONOROTHERAMOUNT, 
    @DISPLAYMINIMUMFUNDRAISINGGOAL = DISPLAYMINIMUMFUNDRAISINGGOAL,
    @DISPLAYTARGETFUNDRAISINGGOAL = DISPLAYTARGETFUNDRAISINGGOAL,
    @ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL = ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL,
    @ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL = ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL,
    @ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL = ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL,
    @JOINMYTEAMLABEL = JOINMYTEAMLABEL,
    @JOINMYCOMPANYLABEL = JOINMYCOMPANYLABEL,
    @JOINMYEVENTLABEL = JOINMYEVENTLABEL    
    from dbo.WIDGETEXTENSION
    where ID = @ID

    return 0;