package ent.user.service.impl;

import java.util.List;

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

import ent.user.bean.Person;
import ent.user.service.PersonService;

@Stateless
@Remote
public class PersonServiceBean implements PersonService {
	@PersistenceContext(unitName = "ejb")
	EntityManager em;

	public void delete(Integer personid) {
		em.remove(em.getReference(Person.class, personid));
	}

	@SuppressWarnings("unchecked")
	public List<Person> getClasses(Integer classes) {
		String c = classes.toString();
		return em.createQuery("select o from Person o where o.classes=" + c)
				.getResultList();
	}

	public Person getPerson(Integer personid) {
		return em.find(Person.class, personid);
	}

	@SuppressWarnings("unchecked")
	public List<Person> getPersons(String username, String password) {
		String UserName = "'" + username + "'";
		String PassWord = "'" + password + "'";
		return em.createQuery(
				"select o from Person o where o.username=" + UserName
						+ "and o.password=" + PassWord).getResultList();
	}

	@SuppressWarnings("unchecked")
	public List<Person> getPurview(Integer purview) {
		String c = purview.toString();
		return em.createQuery("select o from Person o where o.purview=" + c)
				.getResultList();
	}

	@SuppressWarnings("unchecked")
	public List<Person> getUserName(String username) {
		String UserName = "'" + username + "'";
		return em.createQuery(
				"select o from Person o where o.username=" + UserName)
				.getResultList();
	}

	public void save(Person person) {
		em.persist(person);
	}

	public void update(Person person) {
		em.merge(person);
	}

}