public EventNumberOfPassesRequest getEventPassesRequest(User user, Event event) {
Session session = SessionFactoryUtil.getInstance().getCurrentSession();
try {
Transaction transaction = session.beginTransaction();
List result =
session
.createQuery(
"from EventNumberOfPassesRequest as eventNumberOfPassesRequest "
+ "where eventNumberOfPassesRequest.idevent="
+ event.getIdevent()
+ " and eventNumberOfPassesRequest.iduser="
+ user.getIduser())
.list();
transaction.commit();
if (result != null && result.size() > 0) {
return (EventNumberOfPassesRequest) result.get(0);
}
} finally {
if (session.isOpen()) {
session.disconnect();
session.close();
}
}
return null;
}
public ActivityPartnerRequest getPartnerRequest(User user, Activity activity) {
Session session = SessionFactoryUtil.getInstance().getCurrentSession();
try {
Transaction transaction = session.beginTransaction();
List result =
session
.createQuery(
"from ActivityPartnerRequest as partnerrequest "
+ "where partnerrequest.idactivity="
+ activity.getIdactivity()
+ " and partnerrequest.iduser="
+ user.getIduser())
.list();
transaction.commit();
if (result != null && result.size() > 0) {
return (ActivityPartnerRequest) result.get(0);
}
} finally {
if (session.isOpen()) {
session.disconnect();
session.close();
}
}
return null;
}
public User getUserByEmail(String email) {
Session session = SessionFactoryUtil.getInstance().getCurrentSession();
Transaction transaction = session.beginTransaction();
List list = session.createQuery("from User as user where user.mail = '" + email + "'").list();
transaction.commit();
if (list != null && list.size() == 1) {
return (User) list.get(0);
}
return null;
}
private User getUserByEmployeeId(String employeeId) {
Session session = SessionFactoryUtil.getInstance().getCurrentSession();
Transaction transaction = session.beginTransaction();
String queryString = "from User user where user.employeeId ='" + employeeId + "'";
List list = session.createQuery(queryString).list();
transaction.commit();
if (list != null && list.size() == 1) {
return (User) list.get(0);
}
return null;
}
public User getUserByName(String firstName, String lastName) {
Session session = SessionFactoryUtil.getInstance().getCurrentSession();
Transaction transaction = session.beginTransaction();
String queryString =
"from User user where user.firstname ='"
+ firstName
+ "' and user.lastname ='"
+ lastName
+ "'";
// System.out.println("queryString = " + queryString);
List list = session.createQuery(queryString).list();
transaction.commit();
if (list != null && list.size() == 1) {
return (User) list.get(0);
}
return null;
}