PointsCategoryExposed.java

package persistency.exposed;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityTransaction;
import javax.persistence.NoResultException;
import javax.persistence.Query;

import persistency.entities.LoggedUser;
import persistency.entities.gamification.PointsCategory;
import persistency.entities.gamification.PointsInstance;
import utils.DBUtils;

@SuppressWarnings("unchecked")
public class PointsCategoryExposed extends AbstractExposed<PointsCategory> {

	public static final String JTA_PU_NAME = "statCreateTablesJTA";

	public List<PointsCategory> allCodes() {
		Query namedQuery = entityManager.createNamedQuery("allCategories");
		List<PointsCategory> codeList = namedQuery.getResultList();
		return codeList;
	}


//	public PointsCategory findCategoryByName(String operationName) {
//		Query namedQuery = entityManager.createNamedQuery("getCategoryByName");
//		namedQuery.setParameter("name", operationName);
//		PointsCategory result = null;
//		try {
//			result = (PointsCategory) namedQuery.getSingleResult();
//		} catch (NoResultException e) {
//			result = null;
//		}
//		return result;
//
//	}

	public PointsCategory findCategoryByShortName(String sname) {
		Query namedQuery = entityManager.createNamedQuery("getCategoryByShortName");
		namedQuery.setParameter("sname", sname);
		PointsCategory result = null;
		try {
			result = (PointsCategory) namedQuery.getSingleResult();
		} catch (NoResultException e) {
			result = null;
		}
		return result;
	}
}