USP_DATAFORMTEMPLATE_EDIT_FAFEVENT_2

create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FAFEVENT_2
(

@ID uniqueidentifier,  
@CHANGEAGENTID uniqueidentifier = null,
@CURRENTAPPUSERID uniqueidentifier,

--EVENT FIELDS
@NAME nvarchar(100),  
@DESCRIPTION nvarchar(255),  
@STARTDATE datetime,  
@STARTTIME UDT_HOURMINUTE,  
@ENDDATE datetime,  
@ENDTIME UDT_HOURMINUTE, 
@EVENTYEAR UDT_YEAR,
@EVENTLOCATIONID uniqueidentifier ,  
@EVENTLOCATIONCONTACTID uniqueidentifier,
@PRIORYEAREVENTID uniqueidentifier,
@MAINEVENTID uniqueidentifier,
@EVENTCATEGORYCODEID uniqueidentifier,
@SITES xml,

@LOOKUPEVENTID nvarchar(100),
@SUPPORTPHONE nvarchar(100),
@SUPPORTURL UDT_WEBADDRESS,
@HASSUPPORTINGEVENTS bit,
@EVENTTYPECODE tinyint,
@EVENTSUPPORTEMAIL UDT_EMAILADDRESS,
@FAFPROGRAMID uniqueidentifier

)
as  

set nocount on  

--EVENT FIELDS 
declare @r int 
declare @CURRENTDATE datetime
--declare @APPEALID uniqueidentifier
--declare @DESIGNATIONLEVELID uniqueidentifier
declare @DESIGNATIONUSERID nvarchar(200),
        @defaultSiteId uniqueidentifier,
        @dSite nvarchar(200),
        @ORIGINALFAFPROGRAMID uniqueidentifier

set @CURRENTDATE = getdate();
begin try

  if dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID) = 1 
  begin 
    if @SITES is null
      raiserror('Site is required.',13,1) 
    else
      begin        
        select @defaultSiteId = SITEID from dbo.UFN_SITE_MYSITE_GET(@CURRENTAPPUSERID) 
        set @dSite = '<SITEID>'+ cast(@defaultSiteId as nvarchar(40)) +'</SITEID>';
        if CAST(@SITES AS NVARCHAR(MAX)) NOT LIKE '%'+@dSite+'%'
          raiserror('You did not assign your default site to the event.  To continue, edit site security and add your default site.', 13,1)
      end
  end

  set @ORIGINALFAFPROGRAMID = (select FAFPROGRAMID from dbo.EVENTEXTENSION where EVENTID=@ID)

  exec dbo.USP_EVENT_GETSITES_UPDATEFROMXML @ID, @SITES, @CHANGEAGENTID, @CURRENTDATE
  set @SITES = dbo.UFN_EVENT_GETSITES_TOITEMLISTXML(@ID)
  ------------------------------------------------------------------------  
  exec @r = dbo.USP_DATAFORMTEMPLATE_EDIT_EVENT_INFO  
    @ID=@ID,  
    @CURRENTAPPUSERID = @CURRENTAPPUSERID,
    @CHANGEAGENTID = @CHANGEAGENTID,
    @NAME = @NAME,  
    @DESCRIPTION = @DESCRIPTION,  
    @STARTDATE = @STARTDATE,  
    @STARTTIME = @STARTTIME,  
    @ENDDATE = @ENDDATE,  
    @ENDTIME = @ENDTIME,   
    @EVENTLOCATIONID = @EVENTLOCATIONID,
    @EVENTLOCATIONCONTACTID = @EVENTLOCATIONCONTACTID,
    @PREVIOUSYEAREVENTID = @PRIORYEAREVENTID, 
    @MAINEVENTID = @MAINEVENTID,
    @SITES = @SITES,
    @EVENTCATEGORYCODEID = @EVENTCATEGORYCODEID,    
    @EVENTYEAR = @EVENTYEAR,  
    @LOOKUPEVENTID = @LOOKUPEVENTID, 
    @SUPPORTPHONE = @SUPPORTPHONE,  
    @SUPPORTURL = @SUPPORTURL,
    @EVENTTYPECODE = @EVENTTYPECODE,
    @EVENTSUPPORTEMAIL = @EVENTSUPPORTEMAIL,
    @FAFPROGRAMID = @FAFPROGRAMID

    /* -- removing this as it was temporary
      --Check to see there is an existing record for this eventid and add default value if no record is found.
      IF NOT EXISTS (SELECT EVENTID FROM FAFEVENTDONATIONOPTIONSCONFIG WHERE EVENTID=@ID)
      BEGIN
          if @CHANGEAGENTID is null  
              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

          insert into dbo.FAFEVENTDONATIONOPTIONSCONFIG
              (ID, EVENTID, ALLOWGIFTTYPEONETIMEDONATION, ALLOWGIFTTYPERECURRING, ALLOWGIFTTYPEPLEDGE, ISENABLEDONATIONS, ISENABLERECURRINGGIFTS, ISENABLEPLEDGES, 
              ISALLOWTEAMDONATIONS, ISALLOWCOMPANYDONATIONS, ISALLOWEVENTDONATIONS, MINIMUMDONATIONAMOUNT, MAXIMUMTRANSACTIONAMOUNT, ISALLOWDONATIONSFROMORGS, 
              ISFREQUENCYAVAILONLINEMONTHLYGIFT, ISFREQUENCYAVAILONLINEANNUALLYGIFT, ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT, ISFREQUENCYAVAILONLINEQUARTERLYGIFT, 
              ISFREQUENCYAVAILONLINEBIMONTHLYGIFT, ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT, ISFREQUENCYAVAILONLINEBIWEEKLYGIFT, ISFREQUENCYAVAILONLINEWEEKLYGIFT, 
              ISALLOWDONORTOSELECTSTARTDATEGIFT, STARTDATEONORBEFOREGIFT, ISSTARTDATESAMEASDAYTOSUBMITGIFT, DONORONORBEFOREDATEGIFT, ISFREQUENCYAVAILONLINEMONTHLYPLEDGE, 
              ISFREQUENCYAVAILONLINEANNUALLYPLEDGE, ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE, ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE, ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE, 
              ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE, ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE, ISFREQUENCYAVAILONLINEWEEKLYPLEDGE, ISALLOWDONORTOSELECTSTARTDATEPLEDGE, 
              STARTDATEONORBEFOREPLEDGE, ISSTARTDATESAMEASDAYTOSUBMITPLEDGE, DONORONORBEFOREDATEPLEDGE, 
              ISFREQUENCYAVAILONLINESINGLEPLEDGE, ISFREQUENCYAVAILONLINESINGLEGIFT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
          values
              (newid(), @ID, 0, 0, 0, 0, 0, 0, 
              0, 0, 0, 0, 0, 0, 
              0, 0, 0, 0, 
              0, 0, 0, 0, 
              0, null, 0, null, 0, 
              0, 0, 0, 0,
              0, 0, 0, 0, 
              null, 0, null, 
              0, 0, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)                
      END
    */

    --If the event was linked to an FAFProgram and now is not linked to one, or is linked to a different one, we need to update the 
    --local groups for this event and unlink them from any NFG(s) they might have been linked to for the old campaign
    IF (@ORIGINALFAFPROGRAMID is not null) AND (ISNULL(@ORIGINALFAFPROGRAMID,'00000000-0000-0000-0000-000000000000') <> ISNULL(@FAFPROGRAMID,'00000000-0000-0000-0000-000000000000'))
    BEGIN
      UPDATE dbo.TEAMEXTENSION
      SET NFGCAMPAIGNLEVELID=null, CHANGEDBYID=@CHANGEAGENTID, DATECHANGED=@CURRENTDATE 
      where EVENTID=@ID
    END

    --select @DESIGNATIONLEVELID = DL.ID, @APPEALID = E.APPEALID from [EVENT] E 
    --join dbo.APPEALDESIGNATION AD on E.APPEALID = AD.APPEALID
    --join DESIGNATION D on AD.DESIGNATIONID = D.ID
    --join DESIGNATIONLEVEL DL on DL.ID = D.DESIGNATIONLEVEL1ID
    --where E.ID = @ID 

    --exec dbo.USP_FAFEVENTDEFAULTDESIGNATION_ADD_EDIT @DESIGNATIONLEVELID=@DESIGNATIONLEVELID, @EVENTID=@ID, @APPEALID=@APPEALID, @NAME=@NAME, @DESCRIPTION=@DESCRIPTION, @CURRENTAPPUSERID=@CURRENTAPPUSERID, @CHANGEAGENTID=@CHANGEAGENTID

end try

begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
end catch

return 0;

------------------------------------------------------------------------