@Override
public SemesterCourse getByIdWithEverything(Long id) {
SemesterCourse sc = getById(id);
Hibernate.initialize(sc.getSemester());
Hibernate.initialize(sc.getCourse());
Hibernate.initialize(sc.getSemester().getSchoolYear());
return sc;
}
@Override
public boolean delete(SemesterCourse item) {
item = entityManager.getReference(SemesterCourse.class, item.getId());
if (item == null) return false;
item.setActive(false);
update(item);
return true;
}
@Override
public List<SemesterCourse> getAllForCourseList() {
List<SemesterCourse> items = null;
try {
Query q = entityManager.createQuery("select a from SemesterCourse a WHERE a.active = 1");
items = q.getResultList();
for (SemesterCourse sc : items) {
Hibernate.initialize(sc.getSemester());
Hibernate.initialize(sc.getCourse());
}
} catch (Exception e) {
e.printStackTrace();
}
return items;
}
@Override
public List<SemesterCourse> getBySemesterId(Long id) {
List<SemesterCourse> items = null;
try {
Query q =
entityManager.createQuery(
"select a from SemesterCourse a WHERE a.active = 1 AND a.semesterId = :semID");
q.setParameter("semID", id);
items = q.getResultList();
for (SemesterCourse sc : items) {
Hibernate.initialize(sc.getSemester());
Hibernate.initialize(sc.getCourse());
}
} catch (Exception e) {
e.printStackTrace();
}
return items;
}
@Override
public List<SemesterCourse> getAllCoursesForStudent(String username) {
List<SemesterCourse> items = null;
try {
Query q =
entityManager.createQuery(
"select sc from SemesterCourse sc, Authority a WHERE a.active = 1"
+ " AND sc.active = 1 AND a.semesterId = sc.semesterId AND a.courseId = sc.courseId"
+ " AND a.username = :username AND a.authority = :authority");
q.setParameter("username", username);
q.setParameter("authority", Role.ROLE_STUDENT.toString());
items = q.getResultList();
for (SemesterCourse sc : items) {
Hibernate.initialize(sc.getSemester());
Hibernate.initialize(sc.getSemester().getSchoolYear());
Hibernate.initialize(sc.getCourse());
}
} catch (Exception e) {
e.printStackTrace();
}
return items;
}
