package com.service;

import java.util.List;

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

/** 系統用戶管理接口實現 */
public class AdminServiceImpl extends BaseLog implements AdminService {

	/** 系統管理員登錄 */
	public Admin adminLogin(String loginName, String loginPwd) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		Admin admin = null;
		try{
			String hql = "select a from Admin as a where a.loginName=:loginName and a.loginPwd=:loginPwd";
			Query query = session.createQuery(hql);
			query.setString("loginName", loginName);
			query.setString("loginPwd", loginPwd);
			query.setMaxResults(1);
			tx = session.beginTransaction();
			admin = (Admin)query.uniqueResult();
			tx.commit();
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行AdminServiceImpl類中的adminLogin方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return admin;
	}

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

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

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

	/** 裝載指定的管理員 */
	public Admin loadAdmin(Integer id) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		Admin admin = null;
		try{
			tx = session.beginTransaction();
			admin = (Admin)session.get(Admin.class, id);
			tx.commit();
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行AdminServiceImpl類中的loadAdmin方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return admin;
	}

	/** 更新管理員 */	
	public boolean updateAdmin(Admin admin) throws Exception {
		Session session = MySessionFactory.getSession();
		Transaction tx = null;
		boolean status = false;
		try{
			tx = session.beginTransaction();
			session.update(admin);
			tx.commit();
			status = true;
		}catch(Exception ex){
			if(tx!=null)tx.rollback();
			logger.info("在執行AdminServiceImpl類中的updateAdmin方法時出錯：\n");
			ex.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}	
		return status;
	}
}