USP_DATAFORMTEMPLATE_ADD_EVENT_EXTENSION

Used for adding Event Extension

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.
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@EVENTYEAR	UDT_YEAR	IN	Event year
@SUPPORTPHONE	nvarchar(100)	IN	Support phone
@SUPPORTURL	UDT_WEBADDRESS	IN	Support url
@EVENTURL	UDT_WEBADDRESS	IN	Event url
@EVENTTYPECODE	tinyint	IN
@LOCATIONDESCRIPTION	nvarchar(1000)	IN	Location description
@LOOKUPEVENTID	nvarchar(100)	IN
@PRIORYEAREVENTID	uniqueidentifier	IN
@EVENTSUPPORTEMAIL	UDT_EMAILADDRESS	IN
@CLIENTSITESID	int	IN
@SITEID	uniqueidentifier	IN
@FAFPROGRAMID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EVENT_EXTENSION
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier,
 @EVENTYEAR UDT_YEAR= '',    
 @SUPPORTPHONE nvarchar(100) = '',  
 @SUPPORTURL UDT_WEBADDRESS = '',  
 @EVENTURL UDT_WEBADDRESS = '',  
 @EVENTTYPECODE tinyint = 1,  
 --@EVENTSTATUS nvarchar(1) = '',  

 @LOCATIONDESCRIPTION nvarchar(1000) = '',  
 @LOOKUPEVENTID nvarchar(100) = '',  
 @PRIORYEAREVENTID uniqueidentifier = null,  
 @EVENTSUPPORTEMAIL UDT_EMAILADDRESS = '',
 @CLIENTSITESID int = 0,
 @SITEID uniqueidentifier = null, -- default site to use upon constituent creation from front end registration

 @FAFPROGRAMID uniqueidentifier = null
)
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

    insert into dbo.EVENTEXTENSION
        (ID, EVENTID, EVENTYEAR, SUPPORTPHONE, SUPPORTURL, EVENTURL, EVENTTYPECODE,  LOCATIONDESCRIPTION,         
        LOOKUPEVENTID, PRIORYEAREVENTID, EVENTSUPPORTEMAIL,CLIENTSITESID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, SITEID, FAFPROGRAMID)
    VALUES
        (@ID, @EVENTID, @EVENTYEAR, @SUPPORTPHONE, @SUPPORTURL, @EVENTURL, @EVENTTYPECODE, @LOCATIONDESCRIPTION,         
        @LOOKUPEVENTID, @PRIORYEAREVENTID, @EVENTSUPPORTEMAIL, @CLIENTSITESID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, @SITEID, @FAFPROGRAMID)

  exec dbo.USP_DATAFORMTEMPLATE_ADD_EVENTGOAL @EVENTID = @EVENTID;    

  declare @CONFIGID uniqueidentifier  
  set @CONFIGID = newid();

  insert into dbo.EVENTFAFCONFIG
    (ID, EVENTID,  ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  VALUES
    (@CONFIGID, @EVENTID,  @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

  --AJ 12/14/2009...Added new fields for EVENTTEAMFAFCONFIG  

  insert into dbo.EVENTTEAMFAFCONFIG
    (    ID, EVENTID,  ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  VALUES
    (    @CONFIGID, @EVENTID,  @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

  --TPhan 12/01/2009: If default label for plural do not exist, then add them

  IF NOT EXISTS (SELECT * FROM dbo.FAFSYSTEMDEFAULTLABEL (NOLOCK) WHERE FAFSYSTEMDEFAULTNAME = 'Fundraising Coaches')  
    exec dbo.USP_DATAFORMTEMPLATE_ADD_FAF_SYSTEM_DEFAULT_LABEL

  --AJ 09/29/2009...copy default VALUES of FAFSYSTEMDEFAULTLABEL into EVENTLABEL

  insert into dbo.EVENTLABEL 
    (ID, EVENTID, LABELNAME, LABELVALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  SELECT newid(), @EVENTID, FAFSYSTEMDEFAULTNAME, FAFSYSTEMDEFAULTVALUE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE    
  FROM FAFSYSTEMDEFAULTLABEL

    --AJ 11/19/2009...add value for EVENTATTRIBUTES  

    --soumya 12/11/2009... add ALLOWPARTICIPANTSWAIVEBENEFITS field 

  insert into dbo.EVENTATTRIBUTES 
     (ID, EVENTID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  VALUES
    (newid(), @EVENTID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

    -- handle inserting the data

    insert into dbo.REGISTRATIONWAIVER
        (ID, EVENTID, WAIVERTEXT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    VALUES
        (newid(), @EVENTID, 'Enter your organization?s waiver statement.', @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

    --AJ 03/11/2010...add default values for FAFEVENTDONATIONOPTIONSCONFIG  

    insert into dbo.FAFEVENTDONATIONOPTIONSCONFIG
        (ID, EVENTID,  ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    VALUES
        (newid(), @EVENTID,  @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

  -- default PARTICIPANT page meta data for participant: rolecode = 0; team: rolecode = 1; company: rolecode = 2; household: rolecode = 3;

  insert into dbo.EVENTWIDGET
    (ID,WIDGETID,EVENTID,DISPLAYTEXT,ROLECODE,ISACTIVE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
  select NEWID(),WIDGETID,@EVENTID,DEFAULTTEXT,0,1,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE
    FROM dbo.WIDGETGALLERY WHERE ISACTIVE = 1

  insert into dbo.EVENTWIDGET
    (ID,WIDGETID,EVENTID,DISPLAYTEXT,ROLECODE,ISACTIVE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
  select NEWID(),WIDGETID,@EVENTID,DEFAULTTEXT,1,1,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE
    from dbo.WIDGETGALLERY WHERE ISACTIVE = 1

  insert into dbo.EVENTWIDGET
    (ID,WIDGETID,EVENTID,DISPLAYTEXT,ROLECODE,ISACTIVE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
  select NEWID(),WIDGETID,@EVENTID,DEFAULTTEXT,2,1,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE
    from dbo.WIDGETGALLERY WHERE ISACTIVE = 1

  insert into dbo.EVENTWIDGET
    (ID,WIDGETID,EVENTID,DISPLAYTEXT,ROLECODE,ISACTIVE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
  select NEWID(),WIDGETID,@EVENTID,DEFAULTTEXT,3,1,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE
    from dbo.WIDGETGALLERY WHERE ISACTIVE = 1

  insert into dbo.WIDGETEXTENSION
    (ID, EVENTWIDGETID,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)  
  select NEWID(), ID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
  from dbo.EVENTWIDGET  
  where EVENTID = @EVENTID and WIDGETID in (11,13,14)

  -- end


end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0