/**
  * @param Hotel $hotel
  * @throws \Exception
  */
 public function insert(Hotel $hotel)
 {
     $this->connect();
     $id = mysqli_real_escape_string($this->conn, $hotel->getId()->getValue());
     $name = mysqli_real_escape_string($this->conn, $hotel->getName());
     $starts = mysqli_real_escape_string($this->conn, $hotel->getStarts());
     $standardRoomType = mysqli_real_escape_string($this->conn, $hotel->getStandardRoomType());
     $sql = sprintf("INSERT INTO `hotel` (`id`, `name`, `starts`, `standard_room_type`) VALUES ('%s', '%s', %d, '%s')", $id, $name, $starts, $standardRoomType);
     if (!mysqli_query($this->conn, $sql)) {
         throw new \Exception("Error: " . $sql . "SQL Error" . mysqli_error($this->conn));
     }
     $this->closeConnection();
 }
 /**
  * @param Hotel $hotel
  */
 public function delete(Hotel $hotel)
 {
     if (isset($this->hotels[$hotel->getId()->getValue()])) {
         unset($this->hotels[$hotel->getId()->getValue()]);
     }
 }