public List<TeacherDetails> getAllTeachersFromClass(int class_id) {
ArrayList<TeacherDetails> teachers = new ArrayList<TeacherDetails>();
Session session = null;
Transaction transaction = null;
List queryResultList = null;
String queryString = "from Teacher where class_id=:class_id";
try {
session = HibernateUtil.getSessionfactory().openSession();
transaction = session.beginTransaction();
Query query = session.createQuery(queryString);
query.setInteger("class_id", class_id);
queryResultList = query.list();
transaction.commit();
Iterator itr = queryResultList.iterator();
while (itr.hasNext()) {
Teacher entry = (Teacher) itr.next();
TeacherDetails teacherDetails = new TeacherDetails();
teacherDetails.setTeacherId(entry.getUser_id());
teacherDetails.setSubjectIds(entry.getSub_ids());
teacherDetails.setTeacherBean(getTeacherDetailsFromID(entry.getUser_id()));
if (entry.getSuffix() != null) {
teacherDetails.setSuffix(entry.getSuffix());
} else {
teacherDetails.setSuffix("");
}
if (!entry.getSub_ids().equals("")) {
teacherDetails.setSubjects(getAssignedSubjects(entry.getSub_ids().split(",")));
} else {
teacherDetails.setSubjects(new ArrayList<Subject>());
}
teachers.add(teacherDetails);
}
return teachers;
} catch (Exception e) {
e.printStackTrace();
} finally {
if (null != session) {
session.close();
}
}
return null;
}
public Boolean isTeacherExists(String teacherLoginName, int regid) {
Transaction transaction = null;
Session session = null;
List<RegisterBean> list = null;
List<Teacher> list2 = null;
try {
session = HibernateUtil.getSessionfactory().openSession();
transaction = session.beginTransaction();
Query query = session.createQuery("from RegisterBean where loginName=:userid and role=2");
query.setParameter("userid", teacherLoginName);
list = query.list();
if (list.size() > 0) {
RegisterBean bean = list.get(0);
Teacher teacher = new Teacher();
teacher.setClass_id(regid);
teacher.setUser_id(bean.getRegId());
query = session.createQuery("from Teacher where user_id=:userid and class_id=:regid");
query.setParameter("userid", teacher.getUser_id());
query.setParameter("regid", teacher.getClass_id());
list2 = query.list();
if (list2.size() > 0) {
return true;
} else {
return false;
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if (null != session) {
session.close();
}
}
return false;
}
