/**
* Saves the given field trip to the database.
*
* @param trip the field trip
*/
public static void save(FieldTrip trip) {
EntityManager em = HomeschoolTracker.getFactory().createEntityManager();
em.getTransaction().begin();
em.merge(trip);
em.getTransaction().commit();
em.close();
}
/**
* Retrieves field trip details for a given {@link Day}.
*
* @param selectedDay the day
* @return the field trip
*/
public static FieldTrip get(Date selectedDay) {
EntityManager em = HomeschoolTracker.getFactory().createEntityManager();
Query q = em.createQuery("SELECT t FROM FieldTrip t JOIN t._when w WHERE w._date = :when");
q.setParameter("when", selectedDay);
FieldTrip result = null;
if (q.getResultList().size() > 0) {
result = (FieldTrip) q.getSingleResult();
}
em.close();
return result;
}
