USP_DATAFORMTEMPLATE_EDIT_FAFEVENT

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FAFEVENT
(

@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

)
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

  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

    /* -- 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
    */

    --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;