/// <summary>
/// Update a Room in the database
/// </summary>
/// <param name="room">The updated Room</param>
private void updateRoom(Room room)
{
string sql;
sql = "UPDATE Room";
sql += "Number='" + room.getRoomNumber() + "', ";
sql += "Capacity=" + room.getCapacity() + ", ";
sql += "RoomType='" + room.getRoomType() + "', ";
sql += "SlotsOff='" + room.getSlotsOff() + "', ";
sql += "WHERE ID LIKE " + room.getID();
excuteNonQuery(sql);
}
/// <summary>
/// Insert Room to the database
/// </summary>
/// <param name="room">The Room to be inserted</param>
private void insertRoom(Room room)
{
string sql;
sql = "INSERT INTO Room (Number, Capacity, RoomType, SlotsOff, Deleted) VALUES(";
sql += "'"+room.getRoomNumber()+"', ";
sql += room.getCapacity() + ", ";
sql += "'" + room.getRoomType() + "', ";
sql += "'" + room.getSlotsOff() + "', false ";
excuteNonQuery(sql);
}
