package com.pfe.dao;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

import javax.faces.bean.ApplicationScoped;
import javax.faces.bean.ManagedBean;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;

import com.pfe.dao.HibernateUtil;
import com.pfe.entity.Mission;
import com.pfe.entity.User;



@ManagedBean(name = "userService")
@ApplicationScoped
public class Userdao implements Serializable{





    public boolean usercontrol(String login, String password){


        //System.out.println("---------Access User Control--------");
        //Ouvrir une session Hibernate sur le serveur base de données
        Session session = HibernateUtil.getSessionFactory().openSession();

        //System.out.println("---------Operation debut--------");

        session.beginTransaction();
        String hql = "FROM User u where u.login = :login and u.pass = :password";
        Query query = session.createQuery(hql)
                .setParameter("login", login).setParameter("password", password);
        session.getTransaction().commit();
        User user = new User();
        user=(User) query.uniqueResult();
        session.close();
        if (user !=null) {
            return true;
        }
        else
            return false;
    }

    public List getAllUsers(){
        List user = new ArrayList();
        Session session = HibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();
        user = session.createQuery("FROM User").list();
        session.getTransaction().commit();
        return user;

    }

public List getUserbyLogin(String login){

    Session session = HibernateUtil.getSessionFactory().openSession();
    String sql ="SELECT estAdmin, nomcomplet from user where user.login='"+login+"'";
    System.out.println(sql);
    SQLQuery query = session.createSQLQuery(sql);
    query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
    return query.list();

}

public boolean addUser(User v){
    try {
        Session session = HibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();
        session.save(v);
        session.getTransaction().commit();
        return true;
    } catch (Exception e) {
        return false;
    }
}


public boolean removeUser(int idUser){

    try {
        Session session = HibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();
        User v = (User) session.get(Mission.class,idUser);
        session.delete(v);
        session.getTransaction().commit();
        return true;
    } catch (Exception e) {
        return false;
    }
}

public boolean editUser(User v){
try {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();
    session.merge(v);
    session.getTransaction().commit();
    return true;
} catch (Exception e) {
    return false;
}
}

    }


    /*  User user = new User();
        user.setLogin(login);
        user.setPass(password);

        //Commencer une Transaction
        /*session.beginTransaction();
        session.save(user);
        session.getTransaction().commit();
        System.out.println("---------Operation effectué avec succès--------");
        if (login.equals("Samir") && password.equals("admin")){
            return true;
            }
        else
            return false;
    }*/