USP_DATAFORMTEMPLATE_VIEW_ITINERARYDETAIL

The load procedure used by the view dataform template "Itinerary Detail 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(154)	INOUT	Name
@TRACKNAME	nvarchar(100)	INOUT	Track
@LEADERNAME	nvarchar(154)	INOUT	Leader
@ATTENDEES	xml	INOUT	Group
@ITEMS	xml	INOUT	Items
@STARTDATE	datetime	INOUT	Start date
@STARTTIME	UDT_HOURMINUTE	INOUT	Start time
@ENDDATE	datetime	INOUT	End date
@ENDTIME	UDT_HOURMINUTE	INOUT	End time
@RESOURCES	xml	INOUT	Resources
@ARRIVALDATE	datetime	INOUT	Arrival date
@STAFFRESOURCES	xml	INOUT	Staff resources

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ITINERARYDETAIL
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(154) = null output,
                @TRACKNAME nvarchar(100) = null output,
                @LEADERNAME nvarchar(154) = null output,
                @ATTENDEES xml = null output,
                @ITEMS xml = null output,
                @STARTDATE datetime = null output,
                @STARTTIME UDT_HOURMINUTE = null output,
                @ENDDATE datetime = null output,
                @ENDTIME UDT_HOURMINUTE = null output,
                @RESOURCES xml = null output,
                @ARRIVALDATE datetime = null output,
                @STAFFRESOURCES xml = null output
            )
            as
                set nocount on;

                declare @LEADERID uniqueidentifier

                set @DATALOADED = 0;

                select 
                    @DATALOADED = 1,
                    @NAME = ITINERARY.NAME,
                    @LEADERID = LEADERID,
                    @TRACKNAME = isnull(TRACK.NAME,''),
                    @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(ITINERARY.STARTDATETIME),
                    @ENDDATE = dbo.UFN_DATE_GETEARLIESTTIME(ITINERARY.ENDDATETIME),
                    @STARTTIME = dbo.UFN_HOURMINUTE_GETFROMDATE(ITINERARY.STARTDATETIME),
                    @ENDTIME = dbo.UFN_HOURMINUTE_GETFROMDATE(ITINERARY.ENDDATETIME),
                    @RESOURCES = dbo.UFN_ITINERARYRESOURCE_GETRESOURCES_TOITEMLISTXML(@ID),
                    @STAFFRESOURCES = dbo.UFN_ITINERARY_GETSTAFFRESOURCES_TOITEMLISTXML(@ID),
                    @ARRIVALDATE = RESERVATION.ARRIVALDATE
                from dbo.ITINERARY
                    left join dbo.TRACK on
                        TRACK.ID = ITINERARY.TRACKID
                    inner join dbo.RESERVATION
                        on ITINERARY.RESERVATIONID = RESERVATION.ID
                where ITINERARY.ID = @ID

                set @LEADERNAME = dbo.UFN_CONSTITUENT_BUILDNAME(@LEADERID);

                set @ATTENDEES = dbo.UFN_ITINERARY_GETATTENDEES_TOITEMLISTXML(@ID);

                set @ITEMS = dbo.UFN_ITINERARY_GETITINERARYITEMSINFO_TOITEMLISTXML(@ID);

                return 0;