USP_DATAFORMTEMPLATE_VIEW_EVENT_INFORMATION

The load procedure used by the view dataform template "Event Information View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@STARTDATE	datetime	INOUT	Start date
@STARTTIME	UDT_HOURMINUTE	INOUT	Start Time
@ENDDATE	datetime	INOUT	End date
@ENDTIME	UDT_HOURMINUTE	INOUT	End time
@CAPACITY	int	INOUT	Capacity
@LOCATIONCONTACT	nvarchar(124)	INOUT	Contact
@EVENTLOCATIONCONTACTID	uniqueidentifier	INOUT	Contact
@APPEAL	nvarchar(50)	INOUT	Appeal
@LOCATION	nvarchar(100)	INOUT	Location
@EVENTYEAR	UDT_YEAR	INOUT	Event Year
@EVENTGROUPNAME	nvarchar(100)	INOUT	FAF Event Group
@LOCATIONDESCRIPTION	nvarchar(1000)	INOUT	Location Description
@EVENTSTATUS	nvarchar(1)	INOUT	Status
@EVENTYPE	nvarchar(25)	INOUT	Event Type
@EVENTID	uniqueidentifier	INOUT	Event
@EVENTALTID	int	INOUT	Event Alt ID
@EVENTURL	nvarchar(1000)	INOUT	URL
@SUPPORTPHONE	nvarchar(100)	INOUT	Support Phone
@SUPPORTURL	nvarchar(1000)	INOUT	Support URL

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENT_INFORMATION
(
@ID uniqueidentifier,  
@DATALOADED bit = 0 output,

--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,  
@CAPACITY int = null output,  
@LOCATIONCONTACT nvarchar(124) = null output,
@EVENTLOCATIONCONTACTID uniqueidentifier = null output,
@APPEAL nvarchar(50) = null output,  
@LOCATION nvarchar(100) = null output,

--EVENTEXTENSION FIELDS

@EVENTYEAR UDT_YEAR = null output,  
@EVENTGROUPNAME nvarchar(100)  = null output,
@LOCATIONDESCRIPTION nvarchar(1000) = null output,
@EVENTSTATUS nvarchar(1) = null output,
@EVENTYPE nvarchar(25) = null output,
@EVENTID uniqueidentifier = null output,
@EVENTALTID int = null output,
@EVENTURL nvarchar(1000) = null output,
@SUPPORTPHONE nvarchar(100) = null output,
@SUPPORTURL nvarchar(1000) = null output
/*,
--EVENTLOCATION FIELDS
@ADDRESSBLOCK nvarchar(150) = null output,  
@CITY nvarchar(50) = null output,  
@COUNTRYID uniqueidentifier = null output,  
@STATEID uniqueidentifier = null output */
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

    select @DATALOADED = 1,

           @NAME = E.NAME,    
           @DESCRIPTION = E.DESCRIPTION,    
           @STARTDATE = E.STARTDATE,    
           @STARTTIME = E.STARTTIME,    
           @ENDDATE = E.ENDDATE,    
           @ENDTIME = E.ENDTIME,    
           @CAPACITY = E.CAPACITY,  
       @LOCATION = dbo.UFN_EVENTLOCATION_GETINFORMATION([E].EVENTLOCATIONID),
       @LOCATIONCONTACT = dbo.UFN_CONSTITUENT_BUILDNAME([E].EVENTLOCATIONCONTACTID),
           @EVENTLOCATIONCONTACTID = E.EVENTLOCATIONCONTACTID,     
           @APPEAL = dbo.UFN_APPEAL_GETNAME(E.APPEALID),    

           @EVENTYEAR = EV.EVENTYEAR,    
           @EVENTGROUPNAME = EG.NAME,  
           @LOCATIONDESCRIPTION = EV.LOCATIONDESCRIPTION,    
           @EVENTSTATUS = EV.EVENTSTATUS,    
           @EVENTYPE = CASE EV.EVENTTYPEID WHEN 1 THEN 'Friend Asking Friend' ELSE '' END,    
           @EVENTID = EV.EVENTID,   
           @EVENTALTID = EV.EVENTALTID,    
           @EVENTURL = EV.EVENTURL,    
           @SUPPORTPHONE = EV.SUPPORTPHONE,    
           @SUPPORTURL = EV.SUPPORTURL

      /* ,    

           @ADDRESSBLOCK = EL.ADDRESSBLOCK,    
           @CITY = EL.CITY,    
           @COUNTRYID = EL.COUNTRYID,    
           @STATEID = EL.STATEID */

    FROM dbo.EVENT E (NOLOCK)
    LEFT JOIN dbo.EVENTEXTENSION EV (NOLOCK)ON E.ID= EV.EVENTID
  LEFT JOIN dbo.EVENTGROUPFAF EG (NOLOCK) ON EG.ID = EV.EVENTGROUPFAFID
    LEFT JOIN dbo.EVENTLOCATION  EL (NOLOCK)ON E.EVENTLOCATIONID= EL.ID
    WHERE E.ID = @ID

    return 0;