public int booking(int room_id, int no_of_room, string room_type, double room_price, double total_price, string date)
{
Hotel1DataSet1TableAdapters.bookingTableAdapter hb1 = new Hotel1DataSet1TableAdapters.bookingTableAdapter();
Hotel1DataSet1TableAdapters.roompriceTableAdapter hb2 = new Hotel1DataSet1TableAdapters.roompriceTableAdapter();
Hotel1DataSet1TableAdapters.roomTableAdapter hb3 = new Hotel1DataSet1TableAdapters.roomTableAdapter();
if (room_type == "BB")
{
int noA = (int)hb3.getAvailableRoomBB(room_id);
if (noA >= no_of_room)
{
if (room_price >= (double)hb2.getCostPrice("BB") && room_price <= (double)hb2.getMaxPrice("BB"))
{
hb1.Insert(room_id, no_of_room, room_type, room_price, total_price, date);
hb3.UpdateRoomBB(noA - no_of_room, room_id);
return 1;
}
else
{
return 0;
}
}
else
{
return 0;
}
}
else if (room_type == "HB")
{
int noB = (int)hb3.getAvailableRoomHB(room_id);
if (noB >= no_of_room)
{
if (room_price >= (double)hb2.getCostPrice("HB") && room_price <= (double)hb2.getMaxPrice("HB"))
{
hb1.Insert(room_id, no_of_room, room_type, room_price, total_price, date);
hb3.UpdateRoomHB(noB - no_of_room,room_id);
return 1;
}
else
{
return 0;
}
}
else
{
return 0;
}
}
else if (room_type == "FB")
{
int noC = (int)hb3.getAvailableRoomFB(room_id);
if (noC >= no_of_room)
{
if (room_price >= (double)hb2.getCostPrice("FB") && room_price <= (double)hb2.getMaxPrice("FB"))
{
hb1.Insert(room_id, no_of_room, room_type, room_price, total_price, date);
hb3.UpdateRoomFB(noC - no_of_room,room_id);
return 1;
}
else
{
return 0;
}
}
else
{
return 0;
}
}
else
{
return 0;
}
}
public double getCostPrice(string room_type)
{
Hotel1DataSet1TableAdapters.roompriceTableAdapter hb = new Hotel1DataSet1TableAdapters.roompriceTableAdapter();
return (double)hb.getCostPrice(room_type);
}
