package org.dao.impl;

import java.util.ArrayList;
import java.util.List;

import org.dao.IOrderDao;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.model.Order;
import org.model.Userinfo;

public class OrderDaoImpl extends BaseDaoImpl implements IOrderDao{
	
	public List<Order> getByUser(Userinfo user){
		Session session = getSession();
		List<Order> list = new ArrayList<Order>();
		try {
			 list = session.createQuery("from Order as o inner join fetch o.bookinfo where o.userinfo=:userinfo order by o.id desc")
			               .setParameter("userinfo", user)
			               .list();
			session.close();
		} catch (HibernateException ex) {
			ex.printStackTrace();
			throw ex;
		}
		return list;
	}
	
	public void save(Order order){
		super.saveObject(order);
	}
	
	public Order getByID(Integer id){
		Session session = getSession();
		List<Order> list = new ArrayList<Order>();
		try {
			 list = session.createQuery("from Order as o inner join fetch o.bookinfo where o.id=:orderid") 
			 				.setParameter("orderid", id)
			               .list();
			session.close();
		} catch (HibernateException ex) {
			ex.printStackTrace();
			throw ex;
		}
	
		Order order = new Order();
		if (list.size()>0)
			order = list.get(0);
		return order;
	}

}