/**
 * 
 */
package com.ascent.dao.hibernate;

import java.util.ArrayList;

import java.util.List;

import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import com.ascent.bean.Order;
import com.ascent.dao.IOrderDAO;

public class OrderHibernateDAO extends HibernateDaoSupport implements IOrderDAO {

	private static final Logger LOGGER = LogManager
			.getLogger(OrderHibernateDAO.class);

	private static final String LOAD_ALL = "from Order ord  order by ord.orderId desc ";

	private static final String LOAD_BY_CUST = "from Order ord where ore.CustomerId = ? order by ord.orderId desc";

	/**
	 * 
	 */
	public OrderHibernateDAO() {
		super();
	}

	/**
	 * 
	 * @param Order
	 * @return Order
	 */
	public Order saveNewOrder(Order order) {

		try {
			LOGGER.debug("保存訂單信息到數(shù)據(jù)庫！");
			this.getHibernateTemplate().save(order);
			return order;
		} catch (Exception ex) {
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param id
	 *            Integer
	 * 
	 * @return Order
	 */
	public Order getOrder(Integer id) {
		LOGGER.debug("根據(jù)訂單ID取得訂單對象！");
		return (Order) this.getHibernateTemplate().get(Order.class, id);
	}

	/**
	 * 
	 * @return List
	 */
	public List findOrderAll() {
		try {
			LOGGER.debug("獲取所有訂單信息列表！");
			return this.getHibernateTemplate().find(LOAD_ALL);
		} catch (Exception ex) {
			LOGGER.error("獲取所有訂單信息列表失敗！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param type
	 *            String
	 * 
	 * @return List
	 */
	public List findOrderByCustomer(Integer custId) {
		try {
			LOGGER.debug("根據(jù)用戶ID獲取用戶相應的訂單列表！");
			return this.getHibernateTemplate().find(LOAD_BY_CUST, custId);
		} catch (Exception ex) {
			LOGGER.error("根據(jù)用戶ID獲取用戶訂單列表失敗！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param Order
	 * 
	 */
	public void removeOrder(Order order) {
		LOGGER.debug("從數(shù)據(jù)庫中刪除指定訂單");
		this.getHibernateTemplate().delete(order);
	}

}