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