package com.david.dao;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.type.Type;
import org.springframework.dao.DataAccessException;
import org.springframework.dao.DataAccessResourceFailureException;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.david.bo.Category;
import com.david.bo.Userinfo;
import com.david.util.IPageBeanSH;

public class CategoryDao extends HibernateDaoSupport implements ICategoryDao {

	private IPageBeanSH pageBeanSH;
	
	public boolean addCategory(Category category) {
		// TODO Auto-generated method stub
		try{
			this.getHibernateTemplate().save(category);
			return true;
		}catch(DataAccessException e){
			e.printStackTrace();
			return false;
		}
	}

	public boolean deleteCategory(Category category) {
		// TODO Auto-generated method stub
		try{
			this.getHibernateTemplate().delete(category);
			return true;
		}catch(DataAccessException e){
			e.printStackTrace();
			return false;
		}
	}

	public List<Category> getCategories(int start, Userinfo userinfo) {
		// TODO Auto-generated method stub
		
		String hql="from Category as category where category.userinfo=? Order by category.id desc";// as c where c.userinfo=?";
		pageBeanSH.setHql(hql);
		pageBeanSH.setStart(start);
		Userinfo[] arrValues={userinfo};
		pageBeanSH.setArrValues(arrValues);
		try {
			return (List<Category>) pageBeanSH.doInHibernate(this.getSession());
		} catch (DataAccessResourceFailureException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		} catch (IllegalStateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
	}
	
	public boolean updateCategory(Category category) {
		// TODO Auto-generated method stub
		try{
			this.getHibernateTemplate().saveOrUpdate(category);
			return true;
		}catch(DataAccessException e){
			e.printStackTrace();	
			return false;
		}
	}

	public void setPageBeanSH(IPageBeanSH pageBeanSH) {
		// TODO Auto-generated method stub
		this.pageBeanSH=pageBeanSH;
	}

	public int getCategoriesNum(Userinfo userinfo) {
		// TODO Auto-generated method stub
		return this.getHibernateTemplate().find("from Category as category where category.userinfo=? Order by category.id desc", userinfo).size();
	}

	public Category getCategoryById(int id) {
		// TODO Auto-generated method stub
		try{
			List<Category> list=this.getHibernateTemplate().find("from Category as category where category.id=? Order by category.id desc", id);
			if(list.size()!=1){
				return null;
			}else{
				return list.get(0);
			}
			//return (Category)this.getHibernateTemplate().load(Category.class, id);
		}catch(DataAccessException e){
			//e.printStackTrace();
			//System.out.print(e.toString());
			return null;
		}
	}

	public List<Category> getCategories(Userinfo userinfo) {
		// TODO Auto-generated method stub
		return this.getHibernateTemplate().find("from Category as category where category.userinfo=? Order by category.id desc", userinfo);
	}

}