package com.eco.dao.impl;

import java.util.ArrayList;
import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import com.eco.dao.classes.User;
import com.eco.dao.ServiceUser;

public class ServiceDaoUserImpl implements ServiceUser {
	EntityManagerFactory emf = Persistence
			.createEntityManagerFactory("eshoperemf");
	@PersistenceContext
	EntityManager enm = emf.createEntityManager();

	@Override
	public List<User> FindAllUser() {
		Query query = enm.createQuery("select * from User");
		User user=new User(1, "test@mail.com", "karim", "123", "karim", "Hamza", "0606060606", "0505050505", "casablanca", 20320, "bk123", "test Remarque");
		List<User> Users = new ArrayList<>();
		Users.add(user);
		return Users;
	}

	@Override
	public User FindUser(int id) {
		Query query = enm
				.createQuery("select * from user where iduser=id");
		User user = (User) query.getSingleResult();
		return (user);
	}

	public Boolean FindCurrentUser(User c) {
		Boolean l;
		try {
			Query query = enm.createQuery("select *  From User Where Login="
					+ c.getLogin() + "and Password=" + c.getPassword());
			User currentuser = (User) query.getSingleResult();
			l=true;
		} catch (Exception e) {
			System.out.println(e.getMessage());
			l=false;
		}
		return l;
	}

	@Override
	public void deleteUser(int id) {
		User oldetat = FindUser(id);
		enm.remove(oldetat);
	}

	@Override
	public void updateUser(int id) {
		User modifyetat = FindUser(id);
		enm.flush();
	}

	@Override
	public void insertUser(User e) {
		User newuser = new User();
		newuser.setAdresse(e.getAdresse());
		newuser.setCIN(e.getCIN());
		newuser.setCodePostal(e.getCodePostal());
		newuser.setEmail(e.getEmail());
		newuser.setFax(e.getFax());
		newuser.setFirstName(e.getFirstName());
		newuser.setLastName(e.getLastName());
		newuser.setLogin(e.getLogin());
		newuser.setPhone(e.getPhone());
		newuser.setRemarque(e.getRemarque());
		enm.persist(newuser);
	}
}