package ma.services;

import java.lang.reflect.Field;
import java.util.*;


import ma.enim.HibernateSessionFactory;
import ma.library.Dept;


import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Expression;



public class DepService {

	/**
	 * @param args
	 */
	
	public void add(Dept Depp)
	{
		Session session = HibernateSessionFactory.getSession();
		Transaction tr = session.beginTransaction();
		session.save(Depp);
		tr.commit();
	}
	public void update(Dept Depp)
	{
		Session session = HibernateSessionFactory.getSession();
		Transaction tr = session.beginTransaction();
		session.update(Depp);
		tr.commit();
	}
	public void delete(Dept Depp)
	{
		Session session = HibernateSessionFactory.getSession();
		Transaction tr = session.beginTransaction();
		session.delete(Depp);
		tr.commit();
	}
	public Dept get(Integer id)
	{
		Session session = HibernateSessionFactory.getSession();
		Transaction tr = session.beginTransaction();
		Dept rep = (Dept) session.get(Dept.class, id);
		tr.commit();
		
		return rep;
	}
	public List list()
	{
		Session session = HibernateSessionFactory.getSession();
		Transaction tr = session.beginTransaction();
		Criteria cri = session.createCriteria(Dept.class);
		List res = cri.list();
		tr.commit();
		
		return res;
	}
	
	public List listVisible(String modele,String couleur,String variante,String taille,String activite)
	{
		Session session = HibernateSessionFactory.getSession();
		Transaction tr = session.beginTransaction();
		Criteria cri = session.createCriteria(Dept.class);
		cri.add(Expression.eq("couleur",couleur));
		cri.add(Expression.eq("modele",modele));
		cri.add(Expression.eq("taille",taille));
		cri.add(Expression.eq("activite",activite));
		if(variante!=null && variante.length()>0) cri.add(Expression.eq("variante",variante));
		List res = cri.list();
		tr.commit();
		return res;
	}
	public List listVisibleM(String modele,String activite)
	{
		Session session = HibernateSessionFactory.getSession();
		Transaction tr = session.beginTransaction();
		Criteria cri = session.createCriteria(Dept.class);
		
		cri.add(Expression.eq("modele",modele));
		
		List res = cri.list();
		tr.commit();
		
		return res;
	}
	
	

}