USP_DATAFORMTEMPLATE_EDITLOAD_FAFEVENT_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@STARTDATE	datetime	INOUT
@STARTTIME	UDT_HOURMINUTE	INOUT
@ENDDATE	datetime	INOUT
@ENDTIME	UDT_HOURMINUTE	INOUT
@EVENTYEAR	UDT_YEAR	INOUT
@EVENTLOCATIONID	uniqueidentifier	INOUT
@EVENTLOCATIONCONTACTID	uniqueidentifier	INOUT
@PRIORYEAREVENTID	uniqueidentifier	INOUT
@MAINEVENTID	uniqueidentifier	INOUT
@EVENTCATEGORYCODEID	uniqueidentifier	INOUT
@SITES	xml	INOUT
@LOOKUPEVENTID	nvarchar(100)	INOUT
@SUPPORTPHONE	nvarchar(100)	INOUT
@SUPPORTURL	UDT_WEBADDRESS	INOUT
@HASSUPPORTINGEVENTS	bit	INOUT
@EVENTTYPECODE	tinyint	INOUT
@EVENTSUPPORTEMAIL	UDT_EMAILADDRESS	INOUT
@FAFPROGRAMID	uniqueidentifier	INOUT

Definition

Copy


-- ID = EVENTID
create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_FAFEVENT_2(
@ID uniqueidentifier,  
@DATALOADED bit = 0 output,
@TSLONG bigint = 0 output,
@CURRENTAPPUSERID uniqueidentifier,
--EVENT FIELDS
@NAME nvarchar(100) = NULL output,  
@DESCRIPTION nvarchar(255) = null output,  
@STARTDATE datetime = null output,  
@STARTTIME UDT_HOURMINUTE = null output,  
@ENDDATE datetime = null output,  
@ENDTIME UDT_HOURMINUTE = null output,  

@EVENTYEAR UDT_YEAR = null output,

@EVENTLOCATIONID uniqueidentifier = null output,
@EVENTLOCATIONCONTACTID uniqueidentifier = null output,
@PRIORYEAREVENTID uniqueidentifier = null output,
@MAINEVENTID uniqueidentifier = null output,
@EVENTCATEGORYCODEID uniqueidentifier =null output,
@SITES xml = null output,

@LOOKUPEVENTID nvarchar(100) = null output,
@SUPPORTPHONE nvarchar(100) = null output,
@SUPPORTURL UDT_WEBADDRESS = null output,
@HASSUPPORTINGEVENTS bit = null output,
@EVENTTYPECODE tinyint = null output,
@EVENTSUPPORTEMAIL UDT_EMAILADDRESS = null output,
@FAFPROGRAMID uniqueidentifier = null output
)
as
    set nocount on;

    -- be sure to set these, in case the select returns no rows
    set @DATALOADED = 0
    set @TSLONG = 0

  if dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID) = 1
  begin 
    if not exists (select SITEID from dbo.APPUSER where APPUSER.ID = @CURRENTAPPUSERID)
      raiserror('You are not assigned to a default site. To continue, contact your administrator and verify your default site setup.', 13,1);
    else
      if dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID) is null
         raiserror('Your default site is not included in your role?s record access.  To continue, contact your administrator and update your role.', 13,1);
  end

  select
  @DATALOADED = 1,
  @TSLONG = E.TSLONG,

  @NAME = E.NAME,    
  @DESCRIPTION = E.DESCRIPTION,    
  @STARTDATE = E.STARTDATE,    
  @STARTTIME = E.STARTTIME,    
  @ENDDATE = E.ENDDATE,    
  @ENDTIME = E.ENDTIME,    
  @EVENTYEAR = EV.EVENTYEAR,
  @EVENTLOCATIONID = E.EVENTLOCATIONID,        
  @EVENTLOCATIONCONTACTID = E.EVENTLOCATIONCONTACTID,  
  @PRIORYEAREVENTID = EV.PRIORYEAREVENTID,
  @MAINEVENTID = E.MAINEVENTID,
  @EVENTCATEGORYCODEID = EVENTCATEGORYCODEID,    
  --@SITES = dbo.UFN_EVENT_GETSITES_TOITEMLISTXML(E.ID),  
  @LOOKUPEVENTID = EV.LOOKUPEVENTID,    
  @SUPPORTPHONE = EV.SUPPORTPHONE,    
  @SUPPORTURL = EV.SUPPORTURL,
  @HASSUPPORTINGEVENTS = case when (select count(ID) from dbo.EVENT ES where ES.MAINEVENTID = E.ID) > 0 then 1 else 0 end,
  @EVENTTYPECODE = EV.EVENTTYPECODE,
  @EVENTSUPPORTEMAIL = EV.EVENTSUPPORTEMAIL,
  @FAFPROGRAMID = EV.FAFPROGRAMID
    from dbo.EVENT E (nolock)
    join dbo.EVENTEXTENSION EV (nolock)on E.ID= EV.EVENTID
    left join dbo.EVENTLOCATION  EL (nolock)on E.EVENTLOCATIONID= EL.ID
    WHERE E.ID = @ID

  select @SITES = (
      SELECT ES.[ID], ES.[SITEID], S.NAME
     FROM dbo.[UFN_EVENT_GETSITES](@ID) ES
     join dbo.[SITE] S on S.ID = ES.SITEID
     for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64 )

    return 0;