USP_DATAFORMTEMPLATE_ADD_WIDGET_EXTENSION

The save procedure used by the add dataform template "Widget Extension Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PARTICIPANTWIDGETID	uniqueidentifier	IN	Participant Widget ID
@EVENTWIDGETID	uniqueidentifier	IN	Event Widget ID
@TEAMWIDGETID	uniqueidentifier	IN	Team Widget ID
@ALLOWOTHERAMOUNT	bit	IN	Allow other amount
@SUGGESTAMOUNT	money	IN	Suggest amount
@GIVINGLEVELDATA	nvarchar(4000)	IN	Giving Level Data
@ALLOWDONOROTHERAMOUNT	bit	IN	Allow donor other amount
@DISPLAYMINIMUMFUNDRAISINGGOAL	bit	IN	Display minimum fundraising goal
@DISPLAYTARGETFUNDRAISINGGOAL	bit	IN	Display target fundraising goal
@ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL	bit	IN	allow participant to change join team label
@ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL	bit	IN	allow participant to change join company label
@ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL	bit	IN	allow participant to change join event label
@JOINMYTEAMLABEL	nvarchar(250)	IN	join my team label
@JOINMYCOMPANYLABEL	nvarchar(250)	IN	join my company label
@JOINMYEVENTLABEL	nvarchar(250)	IN	join my company label

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_WIDGET_EXTENSION
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @PARTICIPANTWIDGETID uniqueidentifier = null,
  @EVENTWIDGETID uniqueidentifier = null,
  @TEAMWIDGETID uniqueidentifier = null,
  @ALLOWOTHERAMOUNT bit = 1,
  @SUGGESTAMOUNT money= 0,
  @GIVINGLEVELDATA nvarchar(4000) = '',
  @ALLOWDONOROTHERAMOUNT bit = 0,
  @DISPLAYMINIMUMFUNDRAISINGGOAL bit = 0,
  @DISPLAYTARGETFUNDRAISINGGOAL bit = 0,
    @ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL bit = 1,
    @ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL bit = 1,
    @ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL bit = 1,
    @JOINMYTEAMLABEL nvarchar(250) = '',
    @JOINMYCOMPANYLABEL nvarchar(250) = '',
    @JOINMYEVENTLABEL nvarchar(250) = ''   
)
as

set nocount on;

if @ID is null
    set @ID = newid()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

BEGIN TRY
    -- handle inserting the data
    INSERT INTO dbo.WIDGETEXTENSION
        (ID, PARTICIPANTWIDGETID, EVENTWIDGETID, TEAMWIDGETID, ALLOWOTHERAMOUNT, SUGGESTAMOUNT, GIVINGLEVELDATA,  
        ALLOWDONOROTHERAMOUNT, DISPLAYMINIMUMFUNDRAISINGGOAL, DISPLAYTARGETFUNDRAISINGGOAL, 
        ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL, ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL, ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL,
        JOINMYTEAMLABEL, JOINMYCOMPANYLABEL, JOINMYEVENTLABEL,
        ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    VALUES
        (@ID, @PARTICIPANTWIDGETID, @EVENTWIDGETID, @TEAMWIDGETID, @ALLOWOTHERAMOUNT, @SUGGESTAMOUNT, @GIVINGLEVELDATA, 
        @ALLOWDONOROTHERAMOUNT, @DISPLAYMINIMUMFUNDRAISINGGOAL, @DISPLAYTARGETFUNDRAISINGGOAL,
        @ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL, @ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL, @ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL,
        @JOINMYTEAMLABEL, @JOINMYCOMPANYLABEL, @JOINMYEVENTLABEL,
        @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
END TRY

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0