package com.poson.ejb3.sb.impl;

import java.util.List;

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

import com.poson.ejb3.entity.Posoner;
import com.poson.ejb3.sb.PosonerDao;

@Stateless
public class PosonerDaoImpl implements PosonerDao {

	@PersistenceContext
	protected EntityManager em;

	public boolean addPosoner(Posoner posoner) {
		em.persist(posoner);
		return true;
	}

	public List getAllPosoners() {
		Query query = em.createQuery("from Posoner");
		List posoners = query.getResultList();
		return posoners;
	}

	public Posoner getPosonerById(Long id) {
		return em.find(Posoner.class, id);
	}

	public Posoner getPosonerByName(String name) {
		Query query = em
				.createQuery("from Posoner posoner where posoner.name='" + name
						+ "'");
		List posoners = query.getResultList();
		if (posoners != null&&posoners.size()>0)
			return (Posoner) posoners.get(0);
		return null;
	}

	public boolean updatePosoner(Posoner posoner) {
		em.merge(posoner);
		return true;
	}

	public boolean removePosoner(Long id) {
		Posoner posoner = this.getPosonerById(id);
		em.remove(posoner);
		return true;
	}
}