package restaurant;

import java.io.*;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;

public class RestaurantMenu11{
    
    private DBCon con;
	private Read read;
	private Write write;
	private Exit exit;
	private Common common;
	ResultSet rs=null;

	public String searchOperator(String userID){
		    Vector vec = new Vector();
		    common = new Common();
		    userID=common.toChinese(userID);
		    
    	    String sql="select * from operator where id='"+userID+"'";
            con = new DBCon();
	        read = new Read(con.getConnection());    
            rs=read.executeQuery(sql); 
            
         try{
            while(rs.next()){
            	vec.addElement(rs.getString("id"));
            	vec.addElement(rs.getString("name"));
            	vec.addElement(rs.getString("type"));
            	vec.addElement("******");
            	vec.addElement(rs.getString("tel"));
            	vec.addElement(rs.getString("address"));
            	vec.addElement(rs.getString("PICNo"));
            	vec.addElement(rs.getString("remark"));
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
          
          String  str="";
          if(vec.size()==0)
             str="不存在該用戶!";
          else
          {
                  str="帳號:"+vec.get(0)+"<br>";
                  str+="姓名:"+vec.get(1)+"<br>";
			      str+="類型:"+vec.get(2)+"<br>";
			      str+="密碼:"+vec.get(3)+"<br>";
			      str+="電話:"+vec.get(4)+"<br>";
			      str+="住址:"+vec.get(5)+"<br>";
			      str+="身份證號:"+vec.get(6)+"<br>";
			      str+="備注:"+vec.get(7)+"<br>";
          }         
          return str;
	}

	public boolean addUser(Vector userMessage,String operator){
		  
		 common=new Common();
		 operator=common.toChinese(operator);
		 
		 if(common.userExist((String)userMessage.get(0))){
		    return false;
		 }
    	
    	 if(!common.isManager(operator)){
            return false; 
    	 }
	     else{
	     	
	     	String sql="insert into operator values(";
		        sql+="'"+common.toChinese((String)userMessage.get(0))+"',";
		        sql+="'"+common.toChinese((String)userMessage.get(1))+"',";
    	        sql+="'"+common.toChinese((String)userMessage.get(2))+"',";
    	        sql+="'"+common.toChinese((String)userMessage.get(3))+"',";
    	        sql+="'"+common.toChinese((String)userMessage.get(4))+"',";
    	        sql+="'"+common.toChinese((String)userMessage.get(5))+"',";
    	        sql+="'"+common.toChinese((String)userMessage.get(6))+"',";
    	        sql+="'"+common.toChinese((String)userMessage.get(7))+"')";
    	    con = new DBCon();
	        write = new Write(con.getConnection());    
            write.executeUpdate(sql); 
            
            common.WriteSystemLog("管理員"+operator+"添加了用戶:"+common.toChinese((String)userMessage.get(0)));
            exit = new Exit(con.getConnection());
            exit.Close();
            return true;
		}
	}
    
    public boolean modifyUser(Vector vec,String operator){

		 common=new Common();
		 operator=common.toChinese(operator);
		 
		 if(!common.userExist(common.toChinese((String)vec.get(0)))){
		    return false;
		 }
    	  
    	 if(!common.isManager(operator)){
            return false; 
    	 }
    	  else{
    	     String sql="update operator set name='"+common.toChinese((String)vec.get(1))+"',";
    	           sql+="type='"+ common.toChinese((String)vec.get(2)) +"',";
    	           sql+="password='"+ common.toChinese((String)vec.get(3)) +"',";
    	           sql+="tel='"+ common.toChinese((String)vec.get(4)) +"',";
    	           sql+="address='"+ common.toChinese((String)vec.get(5)) +"',";
    	           sql+="PICNo='"+ common.toChinese((String)vec.get(6)) +"',";
    	           sql+="remark='"+ common.toChinese((String)vec.get(7)) +"'";
    	           sql+=" where id='"+common.toChinese((String)vec.get(0))+"'";	

	     
    	     con = new DBCon();
	         write = new Write(con.getConnection());    
             write.executeUpdate(sql); 
             exit = new Exit(con.getConnection());
             exit.Close();
             
             common.WriteSystemLog("酒店經理:"+operator+"修改了用戶:"+common.toChinese((String)vec.get(0)));
             return true;
		  }
    }
      
    public boolean deleteUser(String userID,String operator){
    	
		 common=new Common();
		 userID=common.toChinese(userID);
		 
		 if(!common.userExist(userID)){
		    return false;
		 }
    	
    	 if(!common.isManager(operator)){
            return false; 
    	 }
    	 else{
    	   String sql="delete from operator where id='"+userID+"'";
   
           con = new DBCon();
	       write = new Write(con.getConnection());    
           write.executeUpdate(sql); 
           exit = new Exit(con.getConnection());
           exit.Close();
            
           common.WriteSystemLog("酒店經理:"+operator+"刪除了用戶:"+userID);
           return true;
         }
    }

}