package dk.thoerup.pictureposterservice;

import java.util.List;

import org.hibernate.*;
import org.hibernate.criterion.*;



public class PostingDAO {
	
	@SuppressWarnings("unchecked")
	static public List<Posting> getAll() {
		Session session = HibernateUtil.getSessionFactory().openSession(); 
		//no need to open transaction for a readonly session		
 	
		Criteria c = session.createCriteria(Posting.class);
		java.util.List<Posting> list = c.list();
		
		session.close();
 	
		return list;
	}
	
	static public void savePosting(Posting post) {
		Session session = HibernateUtil.getSessionFactory().openSession();
		
		Transaction tx = session.beginTransaction();
		session.persist(post);
		tx.commit();

		session.close();
	}
	
	static public Posting getPostingById(int id) {
		 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
 	
		 Criteria c = session.createCriteria(Posting.class);
		 c.add( Restrictions.eq("id", id));
		 Posting post = (Posting) c.uniqueResult();
		 
		 return post;
	} 
	
}