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.Customerorder;
import com.ascent.dao.ICustomerOrderDAO;

public class CustomerOrderHibernateDAO extends HibernateDaoSupport implements
		ICustomerOrderDAO {
	private static final Logger LOGGER = LogManager
			.getLogger(CustomerOrderHibernateDAO.class);

	private static final String LOAD_ALL = "from Customerorder custord order by custord.custorderId desc";

	private static final String LOAD_BY_NAME = "from Customerorder custord where custord.custorderName = ? order by custord.custorderId desc";

	private static final String LOAD_BY_ORDERID = "from Customerorder custord where custord.orderId = ? order by custord.custorderId desc";

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

	/**
	 * 
	 * @param Customerorder
	 * @return Customerorder
	 */
	public Customerorder saveCustomerOrder(Customerorder customerorder) {
		try {
			this.getHibernateTemplate().save(customerorder);
			LOGGER.debug("保存用戶發送信息到數據庫成功！");
			return customerorder;
		} catch (Exception ex) {
			LOGGER.error("保存用戶發送信息到數據庫失敗!");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param id
	 *            Integer
	 * 
	 * @return Customerorder
	 */
	public Customerorder getCustomerOrder(Integer id) {
		LOGGER.debug("根據用戶ID得到用戶信息！");
		return (Customerorder) this.getHibernateTemplate().get(
				Customerorder.class, id);
	}

	/**
	 * 
	 * @return List
	 */
	public List findCustomerOrderAll() {
		try {
			LOGGER.debug("得到所有發送用戶列表！");
			return this.getHibernateTemplate().find(LOAD_ALL);
		} catch (Exception ex) {
			LOGGER.error("獲取所有發送用戶列表失敗！");
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param type
	 *            String
	 * 
	 * @return List
	 */
	public List findCustomerOrderByName(String name) {
		try {
			LOGGER.debug("根據用戶姓名得到發送用戶信息！");
			return this.getHibernateTemplate().find(LOAD_BY_NAME, name);
		} catch (Exception ex) {
			LOGGER.error("根據用戶姓名獲取發送用戶信息失敗！");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param type
	 *            String
	 * 
	 * @return List
	 */
	public List findCustomerOrderByOrderId(int id) {
		try {
			LOGGER.debug("根據訂單id得到發送用戶信息！");
			return this.getHibernateTemplate().find(LOAD_BY_ORDERID, id);
		} catch (Exception ex) {
			LOGGER.error("根據訂單id獲取發送用戶信息失敗！");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param Customer
	 * 
	 */
	public void removeCustomerOrder(Customerorder customerorder) {
		LOGGER.debug("從數據庫中刪除指定用戶信息！");
		this.getHibernateTemplate().delete(customerorder);
	}
}