package com.mpss.dao.impl;

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

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.mpss.dao.MobileDetailsDao;
import com.mpss.entity.MobileDetails;
import com.mpss.entity.MobileDetailsPage;

public class MobileDetailsDaoImpl extends BasicDaoImpl<MobileDetails> implements
		MobileDetailsDao {

	public MobileDetailsDaoImpl() {
		super(MobileDetails.class);
		// TODO Auto-generated constructor stub
	}

	public List<MobileDetails> getList(final MobileDetailsPage page) {
		return (List<MobileDetails>) this.getHibernateTemplate().executeFind(
				new HibernateCallback() {
					public List<MobileDetails> doInHibernate(Session session)
							throws HibernateException, SQLException {
						String hql = "from MobileDetails";
						Query query = session.createQuery(hql);
						int first = (page.getCurrorpage() - 1)
								* page.getPagecount();
						query.setFirstResult(first);
						query.setMaxResults(page.getPagecount());
						return query.list();
					}
				});
	}

	public int getMaxCount() {
		return (Integer) this.getHibernateTemplate().execute(new HibernateCallback(){

			public Integer doInHibernate(Session session)
					throws HibernateException, SQLException {
				String hql = "select count(t) from MobileDetails t";
				Query query = session.createQuery(hql);
				return (Integer) query.uniqueResult();
			}
			
		});
	}

	public void add(MobileDetails t) {

	}

	public void update(MobileDetails t) {

	}

}