package com.briup.dao.impl;

import java.util.List;
import java.util.Map;
//import java.util.Set;
import java.util.TreeMap;

import org.hibernate.Query;
import org.hibernate.Session;

import com.briup.bean.Book;
import com.briup.bean.Orderform;
//import com.briup.bean.Orderline;
import com.briup.common.HibernateSessionFactory;
import com.briup.dao.IOrderDao;

public class OrderDaoImpl implements IOrderDao {

	@SuppressWarnings("unchecked")
	public void deleteOrder(Long orderid) throws Exception {
		Session session=HibernateSessionFactory.getSession();
		Query query=session.createQuery("from Orderform where id='"+orderid+"'");
		List<Orderform> list=query.list();
		for(Orderform of:list){
			session.delete(of);
		}
	}

	@SuppressWarnings("unchecked")
	public Map<Long,Orderform> findAllOrder(Long customerid) throws Exception {
		Session session=HibernateSessionFactory.getSession();
		Query query=session.createQuery("from Orderform where customerid='"+customerid+"'");
		List<Orderform> list=query.list();
		Map<Long,Orderform> orderforms=new TreeMap<Long,Orderform>();
		for(Orderform of:list){
			orderforms.put(of.getId(), of);
		}
		return orderforms;
	}

	@SuppressWarnings("unchecked")
	public Orderform findOrderById(Long orderid) throws Exception {
		Session session=HibernateSessionFactory.getSession();
		Query query=session.createQuery("from Orderform where id='"+orderid+"'");
		List<Orderform> list=query.list();
		Orderform orderform=null;
		for(Orderform of:list){
			orderform = of;
		}
		return orderform;
	}

	@SuppressWarnings("unchecked")
	public void saveOrder(Orderform order) throws Exception {
		Session session=HibernateSessionFactory.getSession();
		session.save(order);
	}

	@SuppressWarnings("unchecked")
	public Map<Long,Book> findAllBook() throws Exception {
		Session session=HibernateSessionFactory.getSession();
		Query query=session.createQuery("from Book");
		List<Book> list=query.list();
		Map<Long,Book> books=new TreeMap<Long,Book>();
		for(Book book:list){
			books.put(book.getId(), book);
		}
		return books;
	}

}