def btn_click_cancelFlight(
label, btn, comments, user
): #...............................................................
print("Cancel FLIGHT")
if messagebox.askokcancel("Cancel",
"Are you sure you want to cancel this flight?"):
btn.config(state='disabled')
btn.config(text="Flight Cancelled!")
print("CANCEL BUTTON CLICKED")
print(css.global_user)
print(entered_Flight_ID_numb)
global user_name
if user_name == 'search_admin':
print("here1")
messagebox.showerror("ERROR",
"SEARCH ADMIN CANNOT CANCEL A FLIGHT")
elif user_name == 'airline_admin':
print("here2")
db.cancel_flight_admin(entered_Flight_ID_numb)
populate_airline_admin_gui(comments, label, user)
else:
print("here3")
db.cancel_reservation_passenger(css.global_user,
entered_Flight_ID_numb)
populate_customer_reservations_gui(comments, user)
con = db.db_connect()
#"""
#Here, I simply test the functionality of the DB. Give it a shot
db.create_flights('MANEMARS', '3030-30-30', '22:30:30', 'Area51', 'MarsRover', 1, 0, 'ON-TIME')
a = db.get_Flights('To_Airport')
print(a)
#db.queryexec("DELETE FROM Cust_Flight;")
#con.commit()
#print(db.book_a_flight('paul', 1, 'GUI'))
#print(db.book_a_flight('paul', 420, 'SEARCH'))
db.cancel_flight_admin(420)
#Now check reservations
print('\n\n')
print(db.get_full_user_reservation('paul'))
db.cancel_reservation_passenger('paul', 420)
print(db.get_full_user_reservation('paul'))
#"""
#Lets test my new work here
#for i in range(1, 10):
#print(db.get_user_reservation('paul'))
#flight_from_jfk = db.queryexec("SELECT * FROM Flights WHERE From_Airport = 'KJFK-New York' ORDER BY Airline_Name ASC")
#print(flight_from_jfk)
#"""
con.close()
