1 package dst.ass1.jpa.dao.impl;
3 import dst.ass1.jpa.dao.ICourseDAO;
4 import dst.ass1.jpa.model.ICourse;
5 import dst.ass1.jpa.model.impl.Course;
6 import dst.ass1.jpa.util.Constants;
8 import javax.persistence.EntityManager;
9 import javax.persistence.NoResultException;
10 import java.util.Collection;
11 import java.util.Date;
13 public class CourseDAO extends GenericDAO<Course, ICourse> implements ICourseDAO {
14 public CourseDAO(EntityManager em) {
15 super(em, Course.class);
19 public Collection<ICourse> findOngoingAndFreeCoursesForPlatform(String platformName) {
21 return em.createNamedQuery(Constants.Q_ONGOING_AND_FREE_PLATFORM_COURSES, ICourse.class)
22 .setParameter("platformName", platformName).getResultList();
23 } catch (NoResultException e) {
29 public Collection<ICourse> findNonCancelledCoursesBetweenStartAndEnd(Date start, Date end) {