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()
from validations.hotel_validation import validate_location
from validations.hotel_validation import validate_room_members
from validations.hotel_validation import validate_member
from exceptions.CustomExceptions import InvalidBookedFlightException
from exceptions.CustomExceptions import InvalidHotelLocationException
from exceptions.CustomExceptions import InvalidNoOfRoomsException
from exceptions.CustomExceptions import InvalidAdultExecutiveRoomsException
'''
positive test cases
'''
drooms = 2
erooms = 4
children = 2
adult = 4
c = validate_room_members(erooms,drooms,children,adult)
if(not c):
print('valid no of rooms')
d = validate_member(erooms,adult)
if not d:
print('Valid adult vs executive rooms')
'''
negative test cases
'''
try:
list_of_flights=validate_booked_flight('000')
except InvalidBookedFlightException as e:
print(e)