package com.service;

import java.util.*;
import com.ORM.*;
import com.base.*;
import org.hibernate.*;

public class OrderServiceImpl extends BaseLog implements OrderService {

	/** 新增訂單 */
	public boolean addOrder(Orders order) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		boolean status = false;
		try{
			tx = session.beginTransaction();
			session.save(order);
			tx.commit();
			status=true;
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行OrderServiceImpl類中的addOrder方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return status;
	}

	/** 瀏覽某會員的所有訂單 */
	public List browseOrder(Member member) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		List list = null;
		try{
			Query query = session.createQuery("from Orders as a where a.member=:member");
			tx = session.beginTransaction();
			query.setEntity("member", member);
			list = query.list();
			if (!Hibernate.isInitialized(list))Hibernate.initialize(list);
			tx.commit();			
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行OrderServiceImpl類中的browseOrder方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return list;
	}

	/** 瀏覽所有訂單 */
	public List browseOrder() throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		List list = null;
		try{
			Query query = session.createQuery("from Orders as a order by a.id desc");
			tx = session.beginTransaction();
			list = query.list();
			if (!Hibernate.isInitialized(list))Hibernate.initialize(list);
			tx.commit();			
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行OrderServiceImpl類中的browseOrder方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return list;
	}

	/** 瀏覽某訂單的所有商品記錄 */
	public List browseOrderMer(Cart cart) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		List result = null;
		try{
			//瀏覽購物車中的所有選購記錄
			String hql ="from Cartselectedmer as a where a.cart=:cartid";
			Query query = session.createQuery(hql);
			query.setInteger("cartid", cart.getId().intValue());
			tx = session.beginTransaction();
			result = query.list();
			if(!Hibernate.isInitialized(result)){
				Hibernate.initialize(result);
			}
			tx.commit();
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行OrderServiceImpl類中的browseOrderMer方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return result;
	}	

	/** 刪除訂單 */	
	public boolean delOrder(Integer id) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		boolean status = false;
		try{
			tx = session.beginTransaction();
			Orders order = (Orders)session.load(Orders.class, id);
			session.delete(order);
			tx.commit();
			status = true;
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行OrderServiceImpl類中的delOrder方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return status;
	}

	/** 裝載訂單 */
	public Orders loadOrder(Integer id) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		Orders order = null;
		try{
			tx = session.beginTransaction();
			order = (Orders)session.get(Orders.class, id);
			tx.commit();
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行OrderServiceImpl類中的loadOrder方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return order;
	}

	/** 修改訂單 */
	public boolean updateOrder(Orders order) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		boolean status = false;
		try{
			tx = session.beginTransaction();
			session.update(order);
			tx.commit();
			status=true;
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行OrderServiceImpl類中的updateOrder方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return status;
	}
}