public int cancel(int bookingid) { Airline2DataSet1TableAdapters.bookingTableAdapter adp5 = new Airline2DataSet1TableAdapters.bookingTableAdapter(); if (adp5.checkBooking(bookingid) != null ) { string seat_type = adp5.getSeatType(bookingid); int route_id = (int)adp5.getRouteID(bookingid); int book_seat = (int)adp5.getNoOfSeat(bookingid); Airline2DataSet1TableAdapters.flightTableAdapter adp6 = new Airline2DataSet1TableAdapters.flightTableAdapter(); if (seat_type == "A") { int seat = (int)adp6.getAvailableSeatA(route_id); adp6.UpdateSeatA((seat + book_seat), route_id); adp5.DeleteBooking(bookingid); return 1; } else if (seat_type == "B") { int seat = (int)adp6.getAvailableSeatB(route_id); adp6.UpdateSeatB((seat + book_seat), route_id); adp5.DeleteBooking(bookingid); return 1; } else if (seat_type == "C") { int seat = (int)adp6.getAvailableSeatC(route_id); adp6.UpdateSeatC((seat + book_seat), route_id); adp5.DeleteBooking(bookingid); return 1; } else { return 0; } } else { return 0; } }