USP_DATAFORMTEMPLATE_PRELOAD_ADD_ITINERARYSTAFFRESOURCE

The load procedure used by the edit dataform template "Itinerary Staff Resource Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ITINERARYID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@IGNORECONFLICTS	bit	INOUT	Ignore conflicts when saving
@STARTDATE	datetime	INOUT	Start date
@STARTTIME	UDT_HOURMINUTE	INOUT	Start time
@ENDDATE	datetime	INOUT	End date
@ENDTIME	UDT_HOURMINUTE	INOUT	End time
@ITINERARYNAME	nvarchar(154)	INOUT	Itinerary name
@ITINERARYCAPACITY	int	INOUT	Itinerary capacity
@ITINERARYITEMSEXIST	int	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_ITINERARYSTAFFRESOURCE
                    (
                        @ITINERARYID uniqueidentifier,
                        @IGNORECONFLICTS bit = null output,
                        @STARTDATE datetime = null output,
                        @STARTTIME UDT_HOURMINUTE = null output,
                        @ENDDATE datetime = null output,
                        @ENDTIME UDT_HOURMINUTE = null output,
                        @ITINERARYNAME nvarchar(154) = null output,
                        @ITINERARYCAPACITY int = null output,
                        @ITINERARYITEMSEXIST int = null output
                    )
                    as
                        set nocount on;

                        select
                            @IGNORECONFLICTS = 0,
                            @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),
                            @ITINERARYNAME = ITINERARY.NAME,
                            @ITINERARYCAPACITY = sum(ITINERARYATTENDEE.QUANTITY),
                            @ITINERARYITEMSEXIST = case when ITINERARY.STARTDATETIME is null then 0 else 1 end
                        from dbo.ITINERARY
                            inner join dbo.ITINERARYATTENDEE
                                on ITINERARY.ID = ITINERARYATTENDEE.ITINERARYID
                        where ITINERARY.ID = @ITINERARYID
                        group by ITINERARY.STARTDATETIME, ITINERARY.ENDDATETIME, ITINERARY.NAME

                        return 0;