package com.netshop.domain.dao.hibernate;

import java.util.List;

import com.netshop.domain.dao.ItemDao;
import com.netshop.domain.model.Category;
import com.netshop.domain.model.Item;
import com.netshop.domain.model.Order;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.dao.DataAccessException;
import net.sf.hibernate.*;
import com.netshop.util.*;

public class ItemDAOImpl implements ItemDao{

	private static Log log = LogFactory.getLog(ItemDAOImpl.class);
	/* (non-Javadoc)
	 * @see org.digitstore.dao.ItemDao#getItem(java.lang.String)
	 */
	public Item getItem(String itemId) throws DataAccessException {
		// TODO Auto-generated method stub
		Session s = HibernateUtil.currentSession();
		try{
			HibernateUtil.beginTransaction();
			return (Item)s.load(Item.class,itemId);
		}catch(HibernateException e){
			log.fatal(e);
		}
		return null;
	}
	/* (non-Javadoc)
	 * @see org.digitstore.dao.ItemDao#getItemListByProduct(java.lang.String)
	 */
	public List getItemListByProduct(String productId)
			throws DataAccessException {
		// TODO Auto-generated method stub
		try{
			Session s = HibernateUtil.currentSession();
			HibernateUtil.beginTransaction();
			String str = " from Item item where item.productId = '" + productId + "'";
			Query query = s.createQuery(str);
			return query.list() ;
		}catch(HibernateException e){
			log.fatal(e);
		}
		return null;
	}
	/* (non-Javadoc)
	 * @see org.digitstore.dao.ItemDao#isItemInStock(java.lang.String)
	 */
	public boolean isItemInStock(String itemId) throws DataAccessException {
		// TODO Auto-generated method stub
		Item item = getItem(itemId);
		if ( item == null)
			return false;
		return true;
	}
	/* (non-Javadoc)
	 * @see org.digitstore.dao.ItemDao#updateQuantity(org.digitstore.domain.Order)
	 */
	
}