USP_FAFEVENTCOPY_WRAPPER

Perform FAF event configuration copy
Parameters

Parameter	Parameter Type	Mode
@SOURCEID	uniqueidentifier	IN
@TARGETEVENTID	uniqueidentifier	IN
@COPYBATCHGUID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@EVENTYEAR	UDT_YEAR	IN
@SUPPORTPHONE	nvarchar(100)	IN
@SUPPORTURL	UDT_WEBADDRESS	IN
@EVENTTYPECODE	tinyint	IN
@LOCATIONDESCRIPTION	nvarchar(1000)	IN
@LOOKUPEVENTID	nvarchar(100)	IN
@PRIORYEAREVENTID	uniqueidentifier	IN
@EVENTSUPPORTEMAIL	UDT_EMAILADDRESS	IN
@CLIENTSITESID	int	IN
@USERID	int	IN
@SITEID	uniqueidentifier	IN
@FAFPROGRAMID	uniqueidentifier	IN
Definition

Copy


CREATE procedure dbo.USP_FAFEVENTCOPY_WRAPPER
(
  @SOURCEID uniqueidentifier,
  @TARGETEVENTID uniqueidentifier,
  @COPYBATCHGUID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @EVENTYEAR UDT_YEAR= '',    
  @SUPPORTPHONE nvarchar(100) = '',  
  @SUPPORTURL UDT_WEBADDRESS = '',  
  @EVENTTYPECODE tinyint = 1,  
  @LOCATIONDESCRIPTION nvarchar(1000) = '',  
  @LOOKUPEVENTID nvarchar(100) = '',  
  @PRIORYEAREVENTID uniqueidentifier = null,
  @EVENTSUPPORTEMAIL UDT_EMAILADDRESS = '',
  @CLIENTSITESID int = 0,
  @USERID int,
  @SITEID uniqueidentifier = null, --default site id to use upon constituent creation from front end forms

  @FAFPROGRAMID uniqueidentifier = null
)
as
begin
  declare @CURRENTDATE datetime
  set @CURRENTDATE = getdate()

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

  insert into dbo.EVENTEXTENSION
        (ID, EVENTID, EVENTYEAR, SUPPORTPHONE, SUPPORTURL, EVENTTYPECODE, LOCATIONDESCRIPTION, 
          LOOKUPEVENTID, PRIORYEAREVENTID, EVENTSUPPORTEMAIL, CLIENTSITESID, COPYSOURCEID, COPYBATCHGUID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, SITEID, FAFPROGRAMID)
  values
        (newid(), @TARGETEVENTID, @EVENTYEAR, @SUPPORTPHONE, @SUPPORTURL, @EVENTTYPECODE, @LOCATIONDESCRIPTION, 
        @LOOKUPEVENTID, @PRIORYEAREVENTID, @EVENTSUPPORTEMAIL, @CLIENTSITESID, @SOURCEID, @COPYBATCHGUID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE,@SITEID,@FAFPROGRAMID)

  insert into dbo.EVENTFAFCONFIG
    (ID, EVENTID, GOALISSET, SOCIALNETWORKISSET, LABELISSET, TEAMHIERARCHYISSET, MERCHANTACCOUNTSET, SPONSORSHIPOPTIONISSET, 
    REGISTRATIONOPTIONISSET, INCENTIVEOPTIONISSET, INCENTIVELEVELISSET, DONATIONOPTIONSISSET, REVENUERULESISSET, FUNDRAISINGCOACHISSET,  
    COPYSOURCEID, COPYBATCHGUID,
    ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
  select newid(), @TARGETEVENTID, GOALISSET, SOCIALNETWORKISSET, LABELISSET, TEAMHIERARCHYISSET, MERCHANTACCOUNTSET, SPONSORSHIPOPTIONISSET, 
    REGISTRATIONOPTIONISSET, INCENTIVEOPTIONISSET, INCENTIVELEVELISSET, DONATIONOPTIONSISSET, REVENUERULESISSET, FUNDRAISINGCOACHISSET, 
    @SOURCEID, @COPYBATCHGUID,
    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
    from dbo.EVENTFAFCONFIG 
    where EVENTID = @SOURCEID

  update dbo.EVENTEXTENSION
    set TWITTERID = source.TWITTERID,       
     TWITTERPASSWORD = source.TWITTERPASSWORD,
       TWITTERURL = source.TWITTERURL, 
       FACEBOOKID = source.FACEBOOKID,
       FACEBOOKPASSWORD = source.FACEBOOKPASSWORD,
       FACEBOOKURL = source.FACEBOOKURL, 
       YOUTUBEID = source.YOUTUBEID,
       YOUTUBEPASSWORD = source.YOUTUBEPASSWORD,
       YOUTUBEURL = source.YOUTUBEURL,
       MYSPACEID = source.MYSPACEID,
       MYSPACEPASSWORD = source.MYSPACEPASSWORD,
       MYSPACEURL = source.MYSPACEURL,
     MERCHANTACCOUNTID = source.MERCHANTACCOUNTID,
     ISNEWSOCIALNETWORK = source.ISNEWSOCIALNETWORK,
     CHANGEDBYID = @CHANGEAGENTID,
     DATECHANGED = @CURRENTDATE
  from (select TWITTERID,TWITTERPASSWORD,TWITTERURL, 
               FACEBOOKID,FACEBOOKPASSWORD,FACEBOOKURL, 
               YOUTUBEID,YOUTUBEPASSWORD,YOUTUBEURL,
               MYSPACEID,MYSPACEPASSWORD,MYSPACEURL,MERCHANTACCOUNTID, ISNEWSOCIALNETWORK
        from dbo.EVENTEXTENSION
        where EVENTID = @SOURCEID
  ) source
  where EVENTID = @TARGETEVENTID

  exec dbo.USP_FAFEVENTGOAL_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTLABEL_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTTEAMFAFCONFIG_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTATTRIBUTES_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTREGISTRATIONWAIVER_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTREGISTRATIONTOPION_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTSPONSORSHIPOPTION_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTINCENTIVEOPTION_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTREVENUEOPTION_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID, @COPYBATCHGUID=@COPYBATCHGUID;
  exec dbo.USP_FAFEVENTEMAILTEMPLATE_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID, @COPYBATCHGUID=@COPYBATCHGUID,@CHANGEAGENTID=@CHANGEAGENTID,@USERID=@USERID,@CLIENTSITESID=@CLIENTSITESID
  exec dbo.USP_EVENTATTRIBUTE_COPY @SOURCEID=@SOURCEID, @DESTINATIONID=@TARGETEVENTID, @CHANGEAGENTID=@CHANGEAGENTID
  exec dbo.USP_FAFEVENTSOCIALNETWORK_COPY @SOURCEID=@SOURCEID, @TARGETEVENTID=@TARGETEVENTID,@CHANGEAGENTID=@CHANGEAGENTID

end