EventSettingDao.java

package nl.topicus.konijn.data.dao.hibernate;

import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Path;
import javax.persistence.criteria.Root;

import nl.topicus.konijn.data.dao.interfaces.IEventSettingDao;
import nl.topicus.konijn.data.entity.Event;
import nl.topicus.konijn.data.entity.EventSetting;

/**
 * EventSetting Data access helper
 * 
 * @author Joost Limburg
 * 
 */
public class EventSettingDao extends BaseDao<EventSetting> implements
		IEventSettingDao {
	public EventSetting getEventSetting(String name, Event event) {
		CriteriaBuilder cb = emp.get().getCriteriaBuilder();
		CriteriaQuery<EventSetting> c = cb.createQuery(EventSetting.class);
		Root<EventSetting> eve = c.from(EventSetting.class);
		Path<String> eveQ = eve.get("event");
		Path<String> typeQ = eve.get("name");
		c.where(cb.and(cb.equal(eveQ, event), cb.equal(typeQ, name)));

		EventSetting eventS = null;
		try {
			eventS = emp.get().createQuery(c).getSingleResult();
		} catch (javax.persistence.NoResultException ex) {
		}

		return eventS;
	}
}