public int cancel(int bookingid)
{
Hotel1DataSet1TableAdapters.bookingTableAdapter hb4 = new Hotel1DataSet1TableAdapters.bookingTableAdapter();
if (hb4.getNoOfRoom(bookingid) != null)
{
string room_type =hb4.getRoomType(bookingid);
int room_id = (int)hb4.getRoomID(bookingid);
int book_room = (int)hb4.getNoOfRoom(bookingid);
Hotel1DataSet1TableAdapters.roomTableAdapter hb5 = new Hotel1DataSet1TableAdapters.roomTableAdapter();
if (room_type == "BB")
{
int room = (int)hb5.getAvailableRoomBB(room_id);
hb5.UpdateRoomBB((room + book_room), room_id);
hb4.DeleteBooking(bookingid);
return 1;
}
else if (room_type == "HB")
{
int room = (int)hb5.getAvailableRoomHB(room_id);
hb5.UpdateRoomHB((room + book_room), room_id);
hb4.DeleteBooking(bookingid);
return 1;
}
else if (room_type == "FB")
{
int room = (int)hb5.getAvailableRoomFB(room_id);
hb5.UpdateRoomFB((room + book_room), room_id);
hb4.DeleteBooking(bookingid);
return 1;
}
else
{
return 0;
}
}
else
{
return 0;
}
}
