示例#1
0
def check_hotel(p_hotelid,eroom,droom,days_of_stay,booking_name,children,adult):
    try:
        totalfare=0
        con=DBConnectivity.create_connection()
        cur=DBConnectivity.create_cursor(con)
        cur.execute("select efare,dfare from hotel where hotelid=:hotel_id",{"hotel_id":p_hotelid})
        flag=0
        check =False
        for row in cur:
            flag=1
            if(row[0]==None):
                raise InvalidHotelIdException();
            else:
                check=hotel_validation.validate_member(eroom,adult)
                if(check):
                    raise InvalidAdultExecutiveRoomsException()
                check=hotel_validation.validate_room_members(eroom,droom,children,adult);
                if(check):
                    raise InvalidNoOfRoomsException()
                check=hotel_validation.validate_days_of_stay(days_of_stay)
                if(check):
                    raise InvalidDaysOfStayException()
                check=hotel_validation.validate_booking_name(booking_name)
                if(check):
                    raise InvalidBookingNameException()
                hotel_validation.validate_no_of_children(children)
                hotel_validation.validate_no_of_adult(adult)
                if(booking_name==""):
                    raise InvalidBookingNameException()
                totalfare=(row[0]*eroom+row[1]*droom)*days_of_stay
                return totalfare
        if(flag==0):
            raise InvalidHotelIdException()
        
        for row in cur:
            totalfare=(row[0]*eroom+row[1]*droom)*days_of_stay
            return totalfare
    finally:
        cur.close()
        con.close()
示例#2
0
def hotel_booking(hotelid=None,flightid=None,children=None,adult=None,eroom=None,droom=None):
    try:
        totalfare=0
        flag=0
        if(hotelid==None):
            ch=input("Do you have a Flight Booking? Enter 'Y' or 'N'")
            if(ch=='Y'):
                flightid=input("Enter flight id:")
                flag=1;
            else:
                children=int(input("Enter number of children"))
                adult=int(input("Enter number of adults"))
                hotel_validation.validate_no_of_children(children);
                hotel_validation.validate_no_of_adult(adult)
            eroom=int(input("Enter number of executive room:"))
            droom=input("Enter number of delux room:")
            droom=int(droom)
            hotelid=input("Enter Hotel id:")
        days_of_stay=int(input("Enter the number of days of stay"))
        booking_name=input("Enter the name under which booking has to be made")
        if(flag==1):
            list_of_members = hotel_validation.validate_booked_flight(flightid)
            children=list_of_members[0]
            adult=list_of_members[1]
        totalfare=hotel_booking_validation.validate_hotel(hotelid,eroom,droom,days_of_stay,booking_name,children,adult)
        print("Total Fare",totalfare)
        count=book_hotelDB.retrieve_count()
        bookingid=count+1
        booking=HotelBooking()
        booking.set_bookingid(bookingid)
        booking.set_flight_id(flightid)
        booking.set_hotel_id(hotelid)
        booking.set_no_of_children(children)
        booking.set_no_of_adults(adult)
        booking.set_primary_passenger(booking_name)
        booking.set_fare(totalfare)
        booking.set_eroom(eroom)
        booking.set_droom(droom)
        booking.set_days_of_stay(days_of_stay)
        book_hotelDB.bookHotel(booking)
        print("Your accomodation is successfully booked with booking id",bookingid)
    except CustomExceptions.InvalidHotelIdException as e:
        print(e)
    except CustomExceptions.InvalidDaysOfStayException as e:
        print(e)
    except CustomExceptions.InvalidBookingNameException as e:
        print(e)
    except CustomExceptions.InvalidBookedFlightException as e:
        print(e)
    except CustomExceptions.InvalidHotelLocationException as e:
        print(e)
    except CustomExceptions.InvalidAdultExecutiveRoomsException as e:
        print(e)
    except CustomExceptions.InvalidNoOfRoomsException as e:
        print(e)
    except CustomExceptions.InvalidFlightIdException as e:
        print(e)
    except CustomExceptions.InvalidAdultsException as e:
        print(e)
    except CustomExceptions.InvalidChildrenException as e:
        print(e)
    except CustomExceptions.InvalidDateException as e:
        print(e)
    finally:
        pass
        if(totalfare==0):
            hotel_booking()