package bookingsystem;
import java.util.ArrayList;
import java.util.Date;
import java.sql.Time;
import java.util.Vector;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.*;
import javax.swing.JOptionPane;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class  Reservation extends Booking{
         private int R_ID;
         private Table table;
         private String arrivalDate;
         private String arrivaltime;
         private boolean isarrival;
         private Customer customer;
         private String bookingNo;
         Connection cn = ConnectionDB.getCon();

         public Reservation()
         {
             super();

         }


         public Reservation(int covers,String predate,Table t,Customer c,String arrivaldate,String arrivaltime)
        {
                super(covers,predate,t);
                if(c==null)
                {
                  return;
                }

                customer = c;
                this.arrivalDate = arrivaldate;
                this.arrivaltime = arrivaltime;
                this.isarrival = false;
        }

        public void addBooking()
        {
            int tempCno = customer.getCno();
            String addSql = "INSERT INTO RESERVATION"
                         +"(COVERS,PREDATE,ARRIVALDATE,ARRIVALTIME,TALNO,CNO,ISARRIVAL,ISPAYBILL) VALUES("
                              +this.covers+","+"'"+super.getpreDate()+"','"+this.arrivalDate+"','"+this.arrivaltime+"','"
                              +super.getTalNo()+"'," + tempCno + ","+0+","+0+")";
        try {
            PreparedStatement ps = cn.prepareStatement(addSql);
            ps.executeUpdate();
            JOptionPane.showMessageDialog(null, "添加成功!");
        } catch (SQLException ex) {
        }


        }
        public String getarrivaldate()
        {
            return arrivalDate;
        }
        public String getarrivaltime()
        {
            return arrivaltime;
        }
        public boolean getisarrival()
        {
            return isarrival;
        }
        public Customer getCustomer()
        {
            return customer;
        }
        public String getbookingno()
        {
            return bookingNo;
        }
        public  Vector getfreetables(String date,String time)
       {
           Vector freeTables = new Vector();
           Connection cn = ConnectionDB.getCon();
           Statement st = null;
           ResultSet rs = null;
           try
           {
             String sql = "SELECT * FROM T_TABLE WHERE TALNO NOT IN"
             + " (SELECT TALNO FROM RESERVATION WHERE ARRIVALDATE ='"
             + date +"' AND ARRIVALTIME = '"+ time +"')";
            st = cn.createStatement();
            rs = st.executeQuery(sql);
             while (rs.next()) {
                 String tempFreeTalno = rs.getString("TALNO");
                 Table tempFreeTable = new Table(tempFreeTalno);
                 freeTables.add(tempFreeTable);
             }

           }catch(Exception ex)
           {
               ex.printStackTrace();
           }



           return  freeTables;
       }



        public void setarrivaldate(String arrivaldate)
        {
            this.arrivalDate = arrivaldate;
        }
        public void setarrivaltime(String arrivaltime)
        {
            this.arrivaltime = arrivaltime;
        }
        public void setisarrival(boolean isarrival)
        {
            this.isarrival = isarrival;
        }
        public void setcustomer(Customer customer)
        {
            this.customer = customer;
        }




}