USP_DATAFORMTEMPLATE_EDIT_WIDGET_EXTENSION

The save procedure used by the edit dataform template "Widget Extension Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@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	Supporting text
@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_EDIT_WIDGET_EXTENSION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
  @PARTICIPANTWIDGETID uniqueidentifier,
  @EVENTWIDGETID uniqueidentifier,
  @TEAMWIDGETID uniqueidentifier,
  @ALLOWOTHERAMOUNT bit,
  @SUGGESTAMOUNT money,
  @GIVINGLEVELDATA nvarchar(4000),
  @ALLOWDONOROTHERAMOUNT bit,
  @DISPLAYMINIMUMFUNDRAISINGGOAL bit,
  @DISPLAYTARGETFUNDRAISINGGOAL bit,
    @ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL bit,
    @ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL bit,
    @ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL bit,
    @JOINMYTEAMLABEL nvarchar(250),
    @JOINMYCOMPANYLABEL nvarchar(250),
    @JOINMYEVENTLABEL nvarchar(250)  
)
as

    set nocount on;

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

    begin try
        -- handle updating the data
        update dbo.WIDGETEXTENSION set
            ALLOWOTHERAMOUNT = ISNULL(@ALLOWOTHERAMOUNT, ALLOWOTHERAMOUNT),
            SUGGESTAMOUNT = ISNULL(@SUGGESTAMOUNT, SUGGESTAMOUNT),
            GIVINGLEVELDATA = ISNULL(@GIVINGLEVELDATA,GIVINGLEVELDATA),
            ALLOWDONOROTHERAMOUNT = ISNULL(@ALLOWDONOROTHERAMOUNT, ALLOWDONOROTHERAMOUNT),
            DISPLAYMINIMUMFUNDRAISINGGOAL = ISNULL(@DISPLAYMINIMUMFUNDRAISINGGOAL, DISPLAYMINIMUMFUNDRAISINGGOAL),
            DISPLAYTARGETFUNDRAISINGGOAL = ISNULL(@DISPLAYTARGETFUNDRAISINGGOAL, DISPLAYTARGETFUNDRAISINGGOAL),
            ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL = ISNULL(@ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL, ALLOWPARTICIPANTTOCHANGEJOINTEAMLABEL),
            ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL = ISNULL(@ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL, ALLOWPARTICIPANTTOCHANGEJOINCOMPANYLABEL),
            ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL = ISNULL(@ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL, ALLOWPARTICIPANTTOCHANGEJOINEVENTLABEL),
            JOINMYTEAMLABEL = ISNULL(@JOINMYTEAMLABEL, JOINMYTEAMLABEL),
            JOINMYCOMPANYLABEL = ISNULL(@JOINMYCOMPANYLABEL, JOINMYCOMPANYLABEL),
            JOINMYEVENTLABEL = ISNULL(@JOINMYEVENTLABEL, JOINMYEVENTLABEL),    

            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

  -- Clear front end event level data caching
  declare @EVENTID uniqueidentifier
  select @EVENTID = EW.EVENTID from 
      dbo.WIDGETEXTENSION WE
      inner join dbo.EVENTWIDGET EW on WE.EVENTWIDGETID = EW.id
      where  WE.ID = @ID

  if @EVENTID is not null
     exec dbo.USP_FAFDATACACHE_CLEAR @EVENTID=@EVENTID

return 0;