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); }