package restaurant;

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

public class RestaurantMenu22{
	
    private DBCon con;
	private Read read;
	private Write write;
	private Exit exit;
	private Common common;
	ResultSet rs=null;
    
	public boolean addRoom(Vector roomMessage,String operator){
		 
		  common=new Common();
		  operator=common.toChinese(operator);
		
          String sql="select * from room where id='"+common.toChinese((String)roomMessage.get(0))+"'";
          con = new DBCon();
	      read = new Read(con.getConnection());    
          rs=read.executeQuery(sql); 
     
          try{
            if(rs.next()){
              exit = new Exit(con.getConnection());
              exit.Close();
              return false;
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }
		  
	            sql="insert into room values(";
		        sql+="'"+common.toChinese((String)roomMessage.get(0))+"',";
		        sql+="'"+common.toChinese((String)roomMessage.get(1))+"',";
    	        sql+="'"+common.toChinese((String)roomMessage.get(2))+"',";
    	        sql+=Integer.parseInt(common.toChinese((String)roomMessage.get(3)))+",";
    	        sql+=Integer.parseInt(common.toChinese((String)roomMessage.get(4)))+",";
    	        sql+="'"+common.toChinese((String)roomMessage.get(5))+"',";
    	        sql+="'empty')";
    	    con = new DBCon();
	        write = new Write(con.getConnection());    
            write.executeUpdate(sql); 

            common=new Common();
            common.WriteSystemLog("酒店經理:"+operator+"添加房間."+common.toChinese((String)roomMessage.get(0))+"."+common.getNowTime());
            exit = new Exit(con.getConnection());
            exit.Close();
            return true;
		
	}    

    public boolean modifyRoom(Vector roomMessage,String operator){
    	  
    	  common=new Common();
    	  operator=common.toChinese(operator);
    	
          String sql="select * from room where id='"+common.toChinese((String)roomMessage.get(0))+"'";
          con = new DBCon();
	      read = new Read(con.getConnection());    
          rs=read.executeQuery(sql); 
     
          try{
            if(rs.next()){
              exit = new Exit(con.getConnection());
              exit.Close();
            }
            else
              return false;
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }
		  
                   sql="update  room set ";
  	               sql+="deptName='"+ common.toChinese((String)roomMessage.get(1)) +"',";
    	           sql+="type='"+ common.toChinese((String)roomMessage.get(2)) +"',";
    	           sql+="capacity="+Integer.parseInt(common.toChinese((String)roomMessage.get(3))) +",";
    	           sql+="price="+Integer.parseInt(common.toChinese((String)roomMessage.get(4))) +",";
    	           sql+="remark='"+ common.toChinese((String)roomMessage.get(5)) +"',";
    	           sql+="flag='empty'";
    	           sql+="  where id='"+common.toChinese((String)roomMessage.get(0))+"'";	
	
    	    con = new DBCon();
	        write = new Write(con.getConnection());    
            write.executeUpdate(sql); 
            
            common=new Common();
            common.WriteSystemLog("酒店經理:"+operator+"修改房間."+common.toChinese((String)roomMessage.get(0))+"."+common.getNowTime());
            exit = new Exit(con.getConnection());
            exit.Close();
            return true;          
    }

	public String searchRoom(String roomID){
		    Vector vec = new Vector();
		    
		    common = new Common();
		    roomID=common.toChinese(roomID);
    	    
    	    String sql="select * from room where id='"+roomID+"'";
            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("deptName"));
            	vec.addElement(rs.getString("type"));
            	vec.addElement(rs.getString("capacity"));
            	vec.addElement(rs.getString("price"));
            	vec.addElement(rs.getString("remark"));
            	vec.addElement(rs.getString("flag"));
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
          
          String  str="";

          if(vec.size()==7)
          {
                  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>";
          }
          
          if(vec.size()==0)
              str="不存在此房間!";
          
          return str;
	}	

}