USP_DATAFORMTEMPLATE_PRELOAD_ADD_ITINERARY

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

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@LEADERID	uniqueidentifier	INOUT	Leader
@RESERVATIONID	uniqueidentifier	INOUT
@ARRIVALDATE	datetime	INOUT
@CHECKCAPACITY	bit	INOUT	Check capacity

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_ITINERARY
                (
                    @CONTEXTID uniqueidentifier,
                    @LEADERID uniqueidentifier = null output,
                    @RESERVATIONID uniqueidentifier = null output,
                    @ARRIVALDATE datetime = null output,
                    @CHECKCAPACITY bit = null output
                )
                as
                    set nocount on;

                    select @LEADERID = RECIPIENTID 
                    from dbo.SALESORDER where ID = @CONTEXTID

                    select @ARRIVALDATE = RESERVATION.ARRIVALDATE
                    from dbo.RESERVATION
                    where RESERVATION.ID = @CONTEXTID

                    select @CHECKCAPACITY = case when (MAXIMUMCAPACITY > 0) then  1 else 0 end
                    from dbo.GROUPSALESDEFAULT          

                    set @RESERVATIONID = @CONTEXTID

                    return 0;