package com.xc.hotelmanager.user.control.session;

import javax.ejb.*;
import com.xc.hotelmanager.user.exception.UserManagerException;
import java.util.*;
import com.xc.hotelmanager.user.model.*;
import com.xc.hotelmanager.user.control.entity.*;
import com.xc.hotelmanager.user.control.EjbGetter1;
import java.sql.*;
import com.xc.hotelmanager.user.control.*;


public class SB_usermanagerBean implements SessionBean {
  SessionContext sessionContext;
  public void ejbCreate() throws CreateException {
    /**@todo Complete this method*/
  }
  public void ejbRemove() {
    /**@todo Complete this method*/
  }
  public void ejbActivate() {
    /**@todo Complete this method*/
  }
  public void ejbPassivate() {
    /**@todo Complete this method*/
  }
  public void setSessionContext(SessionContext sessionContext) {
    this.sessionContext = sessionContext;
  }

  public String Login(String uid, String upwd) throws UserManagerException {
    TbHoteluser user=null;
    try{

     user=EjbGetter1.getTbHoteluserHome().findByPrimaryKey(uid);
     String p=user.getPwd();
     String level=user.getUsertype();
     if(user!=null){
       if (upwd.equals(p)) {
            return level;
       }
       else{return "密碼錯(cuò)誤！";}
     }

    }
    catch(Exception ex){
      if (user == null) {
        return "該用戶不存在！";
      }
      else {
        throw new UserManagerException(ex.getMessage());
        //return ex.getMessage();
       }
    }
  return null;
  }
  public Emp addEmp(Emp employee) throws UserManagerException {
    try{
         TbEmployee ejbEmployee=EjbGetter1.getTbEmployeeHome().create(employee.getemid());
         ejbEmployee.setEmp(employee);
         return employee;
     }
     catch(Exception ex){
         throw new UserManagerException(ex.getMessage());
     }

  }

  public Collection getAllEmp() throws UserManagerException {
    try{
       String sql="select * from Employee ";
       return this.loadBySql(sql);
          }
       catch(Exception ex){
           throw new UserManagerException(ex.getMessage());
          }

  }
  public Emp saveEmp(Emp employee) throws UserManagerException {
    try{
         TbEmployee ejbEmployee=EjbGetter1.getTbEmployeeHome().findByPrimaryKey(employee.getemid());
         ejbEmployee.setEmp(employee);
         return employee;

         }
     catch(Exception ex){
          throw new UserManagerException(ex.getMessage());
         }

  }


  public void removeEmp(String emid) throws UserManagerException {
    try{
           TbEmployee ejbEmployee=EjbGetter1.getTbEmployeeHome().findByPrimaryKey(emid) ;
           ejbEmployee.remove();
       }
       catch(Exception ex){
            throw new UserManagerException(ex.getMessage());
       }

  }
  public Emp loadEmp(String emid) throws UserManagerException {
    try{
         TbEmployee ejbEmployee=EjbGetter1.getTbEmployeeHome().findByPrimaryKey(emid) ;
            return ejbEmployee.getEmp() ;

          }
    catch(Exception ex){
            throw new UserManagerException(ex.getMessage());
        }

  }

  private Collection loadBySql(String sql) throws Exception {
          Connection conn=EjbGetter1.getDataSource().getConnection();
          Statement st=conn.createStatement();
          ResultSet rs=st.executeQuery(sql);
          Collection result=new Vector();
          while(rs.next()){
              Emp employee=new Emp();
              employee.setemid(rs.getString("emid"));
              employee.setemname(rs.getString("emname"));
              employee.setemage(rs.getInt("emage") );
              employee.setemsex(rs.getString("emsex"));
              employee.setemposition(rs.getString("emposition"));
              employee.setemstuts(rs.getString("emstuts"));
              result.add(employee);
          }
          rs.close();
          conn.close();
          return result;

  }
  public Hoteluser loadHoteluser(String userid) throws UserManagerException {
    try{
          TbHoteluser ejbHoteluser=EjbGetter1.getTbHoteluserHome().findByPrimaryKey(userid) ;
             return ejbHoteluser.getHoteluser();

           }
     catch(Exception ex){
             throw new UserManagerException(ex.getMessage());
         }

  }
  public Hoteluser saveHoteluser(Hoteluser hoteluser)throws UserManagerException {
    try{
          TbHoteluser ejbHoteluser=EjbGetter1.getTbHoteluserHome().findByPrimaryKey(hoteluser.getUserid());
          ejbHoteluser.setHoteluser(hoteluser);
          return hoteluser;

          }
      catch(Exception ex){
           throw new UserManagerException(ex.getMessage());
          }

  }
  public Hoteluser addHoteluser(Hoteluser hoteluser) throws UserManagerException{
    try{
        TbHoteluser ejbHoteluser=EjbGetter1.getTbHoteluserHome().create(hoteluser.getUserid());
        ejbHoteluser.setHoteluser(hoteluser);
        return hoteluser;
    }
    catch(Exception ex){
        throw new UserManagerException(ex.getMessage());
    }

  }
  public Collection getAllHoteluser() throws UserManagerException {
    try{
       String sql="select * from Hoteluser ";
       return this.loaduserBySql(sql);
          }
       catch(Exception ex){
           throw new UserManagerException(ex.getMessage());
          }

  }
  public void removeHoteluser(String userid) throws UserManagerException {
    try{
       TbHoteluser ejbHoteluser=EjbGetter1.getTbHoteluserHome().findByPrimaryKey(userid) ;
       ejbHoteluser.remove();
   }
   catch(Exception ex){
        throw new UserManagerException(ex.getMessage());
   }

  }

  private Collection loaduserBySql(String sql) throws Exception {
         Connection conn=EjbGetter1.getDataSource().getConnection();
         Statement st=conn.createStatement();
         ResultSet rs=st.executeQuery(sql);
         Collection result=new Vector();
         while(rs.next()){
             Hoteluser hoteluser=new Hoteluser();
             hoteluser.setUserid(rs.getString("userid"));
             hoteluser.setPwd(rs.getString("pwd"));
             hoteluser.setUsertype(rs.getString("usertype") );
             result.add(hoteluser);
         }
         rs.close();
         conn.close();
        return result;
 }

 public String getuserid(String userid) throws UserManagerException{
    TbHoteluser user=null;
    try{

      user = EjbGetter1.getTbHoteluserHome().findByPrimaryKey(userid);
      if (user != null) {
        return "1";
      }
      else{
      return "0";
    }
  }
    catch(Exception ex){
      if(user==null){
         return "0";
      }
        throw new UserManagerException(ex.getMessage());
    }

  }



}