private EventRequestBean getFromResultSet(ResultSet resultSet) throws SQLException {
EventRequestBean eventRequest;
String id = resultSet.getString(1);
eventRequest = new EventRequestBean(id);
String name = resultSet.getString(2);
eventRequest.setName(name);
int clientId = resultSet.getInt(3);
eventRequest.setClientId(clientId);
String type = resultSet.getString(4);
eventRequest.setType(type);
Date from = resultSet.getDate(5);
eventRequest.setFrom(from);
Date to = resultSet.getDate(6);
eventRequest.setTo(to);
String budget = resultSet.getString(7);
eventRequest.setBudget(budget);
String status = resultSet.getString(8);
eventRequest.setStatus(status);
Map<String, String> preferences = eventRequest.getPreferences();
preferences.put("details_photo_video", resultSet.getNString(9));
preferences.put("details_music", resultSet.getNString(10));
preferences.put("details_poster", resultSet.getNString(11));
preferences.put("details_decoration", resultSet.getNString(12));
preferences.put("details_network", resultSet.getNString(13));
preferences.put("details_food_beverages", resultSet.getNString(14));
preferences.put("details_waiter", resultSet.getNString(15));
preferences.put("feedback_budget", resultSet.getNString(16));
return eventRequest;
}
