package com.newvideo.service.imp;

import java.io.Serializable;
import java.util.List;

import javax.annotation.Resource;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate4.HibernateCallback;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.newvideo.dao.FindVideoDao;
import com.newvideo.domain.FindVideo;
import com.newvideo.util.Constant;

@Service
public class FindVideoService {

	@Resource
	private FindVideoDao dao;

	public List<FindVideo> getFindVideoList(long cid, int page) {
		return dao.list(
				"from FindVideo where findClass.id = ? order by orderBy desc",
				(page - 1) * Constant.pageCount, Constant.pageCount,
				new Serializable[] { cid });
	}

	public FindVideo getFindVideo(long id) {
		return dao.find(FindVideo.class, id);
	}

	@Transactional
	public void delete(long id) {
		dao.delete(new FindVideo(id));
	}
	
	@Transactional
	public void update(FindVideo fv) {
		dao.update(fv);
	}
	@Transactional
	public Long save(FindVideo fv) {
		return (Long) dao.save(fv);
	}

	public int getCount(long cid) {
		return (int) dao.getCount("select count(*) from FindVideo where findClass.id=?", new Serializable[]{cid});
	}
	
	@Transactional
	public void deleteByCid(final Long id) {
		dao.excute(new HibernateCallback() {
			@Override
			public Object doInHibernate(Session session)
					throws HibernateException {
				Query query = session.createQuery("delete FindVideo fv where fv.findClass.id = ? ");
				query.setParameter(0, id);
				query.executeUpdate();
				return null;
			}
		});
	}

}