package com.supinfo.rmt.services;

import com.supinfo.rmt.entity.Employee;
import com.supinfo.rmt.entity.Manager;
import com.supinfo.rmt.entity.User;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.NoResultException;
import javax.persistence.Persistence;
import javax.persistence.Query;

public class UserService {

	private EntityManagerFactory emf;

	public UserService() {
		emf = Persistence.createEntityManagerFactory("PU");

		initialiseDatabase();
	}

	public void initialiseDatabase() {
		EntityManager em = emf.createEntityManager();

		Manager m = new Manager();
		m.setFirstname("Barack");
		m.setLastname("Obama");
		m.setUsername("barack");
		m.setPassword("expotus");

		Employee e = new Employee();
		e.setFirstname("John");
		e.setLastname("Rambo");
		e.setUsername("rambo");
		e.setPassword("greenberet");

		em.getTransaction().begin();

		Query query = em.createQuery("DELETE FROM User");
		query.executeUpdate();

		em.persist(m);
		em.persist(e);

		em.getTransaction().commit();
		em.close();
	}

	public User login(String username, String password) {
		try {
			EntityManager em = emf.createEntityManager();

			Query query = em
					.createQuery("SELECT u FROM User u " + "WHERE u.username=:username AND u.password=:password");

			query.setParameter("username", username);
			query.setParameter("password", password);

			return (User) query.getSingleResult();
		}

		catch (NoResultException nre) {
			// the user does not exist
			return null;
		}
	}
}