OffersDAO.java

package com.caveofprogramming.spring.web.dao;

import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.classic.Session;
import org.hibernate.criterion.Restrictions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

@Repository
@Transactional
@Component("offersDao")
public class OffersDAO 
{
	@Autowired
	private SessionFactory  sessionFactory;
	
	public Session session()
	{
		return sessionFactory.getCurrentSession();
	}

	public void saveOrUpdate(Offer offer) 
	{
		session().saveOrUpdate(offer);	
	}

	public boolean delete(int id) 
	{
		Query query = session().createQuery("delete from Offer where id=:id"); // This is not SQL, it's HQL
		query.setLong("id", id);
		return query.executeUpdate() == 1; 
	}
	
	@SuppressWarnings("unchecked")
	public List<Offer> getOffers() 
	{
		Criteria crit = session().createCriteria(Offer.class);
		crit.createAlias("user", "u").add(Restrictions.eq("u.enabled", true)); // Checking if user.enabled = true
		return crit.list();
	}
	
	@SuppressWarnings("unchecked")
	public List<Offer> getOffers(String username) 
	{
		Criteria crit = session().createCriteria(Offer.class);
		crit.createAlias("user", "u");
		
		crit.add(Restrictions.eq("u.enabled", true)); 
		crit.add(Restrictions.eq("u.username", username));
		
		return crit.list();
	}
	
	public Offer getOffer(int id) 
	{
		Criteria crit = session().createCriteria(Offer.class);
		crit.createAlias("user", "u");
		
		crit.add(Restrictions.eq("u.enabled", true)); 
		crit.add(Restrictions.idEq(id));
		
		return (Offer)crit.uniqueResult();
	}
}