package com.netshop.domain.dao.hibernate;

import java.util.List;
import java.util.Iterator;

import com.netshop.domain.dao.OrderDao;
import com.netshop.domain.model.Item;
import com.netshop.domain.model.Order;
import com.netshop.util.*;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.dao.DataAccessException;
import net.sf.hibernate.*;

public class OrderDAOImpl implements OrderDao{

	private static Log log = LogFactory.getLog(OrderDAOImpl.class);
	/* (non-Javadoc)
	 * @see org.digitstore.dao.OrderDao#getOrder(int)
	 */
	public Order getOrder(int orderId) throws DataAccessException {
		// TODO Auto-generated method stub
		Session s = HibernateUtil.currentSession();
		try{
			HibernateUtil.beginTransaction();
			return (Order)s.load(Order.class,new Integer(orderId));
		}catch(HibernateException e){
			log.fatal(e);
		}
		return null;
	}
	/* (non-Javadoc)
	 * @see org.digitstore.dao.OrderDao#getOrdersByUsername(java.lang.String)
	 */
	public List getOrdersByUsername(String username) throws DataAccessException {
		// TODO Auto-generated method stub
		try{
			Session s = HibernateUtil.currentSession();
			HibernateUtil.beginTransaction();
			String str = " from Order orders where orders.username= '" + username + "'";
			Query query = s.createQuery(str);
			return query.list() ;
		}catch(HibernateException e){
			log.fatal(e);
			e.printStackTrace();
		}
		return null;
	}
	/* (non-Javadoc)
	 * @see org.digitstore.dao.OrderDao#insertOrder(org.digitstore.domain.Order)
	 */
	public void insertOrder(Order order) throws DataAccessException {
		// TODO Auto-generated method stub
		try{
			Session s = HibernateUtil.currentSession();
		    HibernateUtil.beginTransaction();
			s.save(order);
		}catch(HibernateException e){
			log.fatal(e);
			e.printStackTrace();
		}
	}
}