public static Room GetById(int id)
{
Database db = new Database();
DataTable dt = db.Read("Select * from " + TableName + " WHERE id=" + id);
Room room = new HotelManagement.Room();
var data = dt.Rows[0];
room.Id = id;
room.Price_Per_Day = Convert.ToInt32(data["price_per_day"]);
room.Room_Capacity = Convert.ToInt32(data["room_capacity"]);
room.Room_Type = RoomType.GetById(Convert.ToInt32(data["room_type_id"]));
room.isEmpty = Convert.ToBoolean(data["is_empty"]);
return(room);
}
public static DataTable Search(int room_type, int number_of_people, DateTime entryDate, DateTime departureDate)
{
MessageBox.Show("search");
Database db = new Database();
DataTable dt = db.Read("Select * from " + TableName + " WHERE room_capacity>=" + number_of_people + " AND room_type_id=" + room_type);
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
Room room = new HotelManagement.Room(Convert.ToInt32(dt.Rows[i]["id"]));
bool check = room.CheckForAvialibity(entryDate, departureDate);
if (!check)
{
dt.Rows[i].Delete();
MessageBox.Show(i.ToString());
}
}
return(dt);
}
