package ejb;

import java.util.Calendar;
import java.util.Date;
import java.util.List;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import data.Admin;
import data.Course;
import data.Professor;
import data.Student;

@Stateless
public class adminEJB implements adminEJBRemote {

	@PersistenceContext(name = "database")
	EntityManager em;

	public adminEJB() {

	}

	public static Date getDate(int day, int month, int year) {
		Calendar cal = Calendar.getInstance();
		cal.set(Calendar.YEAR, year);
		cal.set(Calendar.MONTH, month - 1);
		cal.set(Calendar.DAY_OF_MONTH, day);

		Date d = cal.getTime();
		return d;
	}

	public void createStudent(String number, String name, String birthDate, String email, String alternativeEmail,
			String address, String phone, String username, String password) {

		Student stud = new Student(number, name, birthDate, email, alternativeEmail, address, phone, username,
				password);

		em.persist(stud);

	}

	public void createProfessor(String number, String name, String birthDate, String email, String alternativeEmail,
			String address, String phone, String username, String password) {

		Professor prof = new Professor(number, name, birthDate, email, alternativeEmail, address, phone, username,
				password);
		/* FALTAM CAMPOS TIPO A CATEGORIA */
		em.persist(prof);
	}

	public void createCourse(String name, List<Student> students, Professor professor) {
		Course course = new Course(name, students, professor);

		em.persist(course);
	}

	public Boolean checkCourse(String courseName) {
		Query q;
		q = em.createQuery("from Course c where c.name = :c");
		q.setParameter("c", courseName);
		if (q.getResultList().isEmpty()) {
			return false;
		} else {
			return true;
		}
	}

	public void createAdmin(String user, String pass) {

		Admin a = new Admin(user, pass);

		em.persist(a);
	}

	public void deleteAdmin(String user) {

		//em.getTransaction().begin();

		Query q = em.createNativeQuery("DELETE FROM Admin WHERE user = '" + user + "'");
	    q.executeUpdate();

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

	public Boolean checkUsername(String user) {
		// TODO Auto-generated method stub
		System.out.println("teste de funçao" + "dfgh-> " + em.toString());
		// Query q;
		Query q1;
		// Query q2;
		// q = em.createQuery("from admin a where a.user = '"+user+"'");
		q1 = em.createQuery("SELECT a FROM Admin a WHERE a.user = '" + user + "'");
		// q1 = em.createQuery("from professor p where p.username = :u");
		// q2 = em.createQuery("from student s where s.username = :u");
		System.out.println("blablabla texto");
		// q.setParameter("u", user);

		if (/* q.getResultList().isEmpty() && */ q1.getResultList()
				.isEmpty() /* && q2.getResultList().isEmpty() */) {
			return false;
		} else {
			return true;
		}
	}

	public void texto(String t) {
		System.out.println("texto->" + t);
	}

	public Boolean login(String user, String pass) {

		Query q;

		q = em.createQuery("SELECT a FROM Admin a WHERE a.user = '" + user + "' AND a.pass = '" + pass + "'");

		/*
		 * if (user.equals("admin1") && pass.equals("1234")) { return true; }
		 * else { return false; }
		 */
		if (!q.getResultList().isEmpty()) {
			return true;
		} else {
			return false;
		}
	}

	public void changeInfo(String category, String nameNumber, String field, String newInfo) {
		Query q = null;
		if (category.equalsIgnoreCase("Professor")) {
			q = em.createQuery("from professor p where p.name = :n or p.internalNumber = :n ");

		} else if (category.equalsIgnoreCase("Student")) {
			q = em.createQuery("from Student s where s.name = :n or s.number = :n");

		} else if (category.equalsIgnoreCase("Course")) {
			q = em.createQuery("from Course c where c.name = :n");
		}
		if (q != null) {
			q.setParameter("n", nameNumber);
		} else {
			// NAO ENCONTROU FAZER CENAS ALEATORIAS
		}
		// System.out.println("In the EJB. Height = " + threshold);

		// q.setParameter("t", threshold);
		// @SuppressWarnings("unchecked")
		// List<Player> result = q.getResultList();
		// return result;
	}

	public void main() {
		System.out.println("ola");
	}

	@Override
	public void createStudent(int number, int year, String name, String birthDate, String email,
			String alternativeEmail, String address, String phone) {
		// TODO Auto-generated method stub

	}

	@Override
	public void createProfessor(String name, String birthDate, String email, String alternativeEmail, String address,
			String office, String category, int internalNumber, int phone, int internalPhone, int salary) {
		// TODO Auto-generated method stub

	}

}