package DAO;

import java.util.List;

import org.hibernate.Session;

import Model.Etudiant;
import Model.VEtudiant;

public class DAOBase 
{	
	public static void addEtudiant(Etudiant e)
	{
		Session session= HibernateUtil.getSessionFactory().openSession();
		session.beginTransaction();
		session.save(e);
		session.getTransaction().commit();
		session.close();
	}
	
	public static void removeFirstEtudiant()
	{
		Session session= HibernateUtil.getSessionFactory().openSession();
		session.beginTransaction();
		session.delete(session.createQuery("from Etudiant").list().get(0));
		session.getTransaction().commit();
		session.close();
	}
	
	@SuppressWarnings("unchecked")
	public static List<Etudiant> getListEtudiant()
	{
		Session session= HibernateUtil.getSessionFactory().openSession();
		session.beginTransaction();
		List<Etudiant> result = session.createQuery("from Etudiant").list();
		session.close();
		return result;
	}
	
	@SuppressWarnings("unchecked")
	public static List<VEtudiant> getListViewItems()
	{
		Session session= HibernateUtil.getSessionFactory().openSession();
		session.beginTransaction();
		List<VEtudiant> result = session.createQuery("from VEtudiant").list();
		session.close();
		return result;
	}
}