package dk.thoerup.hibertest1;

import java.util.List;

import org.hibernate.Transaction;

import org.hibernate.Criteria;
import org.hibernate.classic.Session;
import org.hibernate.criterion.Restrictions;

public class DepartmentDAO {

	@SuppressWarnings("unchecked")
	public static List<Department> getDepartments() {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction tx = session.beginTransaction();		
		Criteria c = session.createCriteria(Department.class);
		
		return c.list();
	}
	
	public static Department getDepartmentById(int id) {
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		Transaction tx = session.beginTransaction();		
		Criteria c = session.createCriteria(Department.class);
		c.add( Restrictions.eq("id", id));
		return (Department) c.uniqueResult();
		
	}
}