UFN_ITINERARYITEM_VALIDDATE

Checks to see if an itinerary item is not added before reservation date.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_ITINERARYITEM_VALIDDATE
            (
                @ID uniqueidentifier
            )
            returns bit as
            begin
                declare @ITINERARYDATETIME datetime;
                declare @ARRIVALDATETIME datetime;

                select @ARRIVALDATETIME = dbo.UFN_DATE_ADDHOURMINUTE(dbo.UFN_DATE_GETEARLIESTTIME(ARRIVALDATE), ARRIVALTIME),
                    @ITINERARYDATETIME = dbo.UFN_DATE_ADDHOURMINUTE(dbo.UFN_DATE_GETEARLIESTTIME(STARTDATE), STARTTIME)
                from dbo.ITINERARYITEM
                inner join dbo.ITINERARY on ITINERARYITEM.ITINERARYID = ITINERARY.ID
                inner join dbo.RESERVATION on ITINERARY.RESERVATIONID = RESERVATION.ID
                where ITINERARYITEM.ID = @ID

                if @ARRIVALDATETIME > @ITINERARYDATETIME
                    return 0;

                return 1;
            end