/* (non-Javadoc)
   * @see assn2.daos.RecordDAO#getAllByUser(int)
   */
  @Override
  public List<RecordBean> getAllByHotel(int id) throws DataAccessException {
    Connection conn = null;
    List<RecordBean> list = new ArrayList<RecordBean>();
    try {
      conn = services.createConnection();
      PreparedStatement stmt = conn.prepareStatement("select * from Record where hotelid = ? ");
      stmt.setInt(1, id);

      ResultSet rs = stmt.executeQuery();
      if (rs == null) // remember to catch the exceptions
      throw new DataAccessException("cannot find entity of that userid");
      while (rs.next()) {
        RecordBean r = createRecordBean(rs);
        list.add(r);
      }
    } catch (ServiceLocatorException e) {
      e.printStackTrace(); // no connection
    } catch (SQLException e) {
      e.printStackTrace(); // not execution of statement
    } finally {
      if (conn != null) {
        try {
          conn.close(); // and close the connections etc
        } catch (SQLException e1) { // if not close properly
          e1.printStackTrace();
        }
      }
    }
    return list;
  }
  public int getUserid(int recordid) {
    Connection conn = null;
    int r = -1;
    try {
      conn = services.createConnection();
      PreparedStatement stmt =
          conn.prepareStatement(
              "select * from Record as r, Booking as b where r.bookingid = b.bookingid AND r.recordid = (?) ");
      stmt.setInt(1, recordid);

      ResultSet rs = stmt.executeQuery();
      if (rs == null) // remember to catch the exceptions
      throw new DataAccessException("cannot find entity of that recordid");
      rs.next();
      r = rs.getInt("userid");
      return r;
    } catch (ServiceLocatorException e) {
      e.printStackTrace(); // no connection
    } catch (SQLException e) {
      e.printStackTrace(); // not execution of statement
    } finally {
      if (conn != null) {
        try {
          conn.close(); // and close the connections etc
        } catch (SQLException e1) { // if not close properly
          e1.printStackTrace();
        }
      }
    }
    return r;
  }
  /* (non-Javadoc)
   * @see assn2.daos.RecordDAO#getRecord(int)
   */
  @Override
  public RecordBean getRecord(int id) throws DataAccessException {
    Connection conn = null;
    try {
      conn = services.createConnection();
      PreparedStatement stmt = conn.prepareStatement("select * from Record where recordid = ? ");
      stmt.setInt(1, id);

      ResultSet rs = stmt.executeQuery();
      if (rs == null) // remember to catch the exceptions
      throw new DataAccessException("cannot find entity of that recordid");
      if (rs.next()) {
        RecordBean r = createRecordBean(rs);
        stmt.close(); // close it
        return r;
      }
    } catch (ServiceLocatorException e) {
      e.printStackTrace(); // no connection
    } catch (SQLException e) {
      e.printStackTrace(); // not execution of statement
    } finally {
      if (conn != null) {
        try {
          conn.close(); // and close the connections etc
        } catch (SQLException e1) { // if not close properly
          e1.printStackTrace();
        }
      }
    }
    return null; // not found
  }
 /* (non-Javadoc)
  * @see assn2.daos.RecordDAO#deleteAllByBooking(int)
  */
 @Override
 public void deleteAllByBooking(int id) throws DataAccessException {
   Connection con = null;
   try {
     // get the connection
     con = services.createConnection();
     PreparedStatement stmt = con.prepareStatement("delete from Record where bookingid=(?)");
     stmt.setInt(1, id);
     int status = stmt.executeUpdate();
     //			 if (status == 0)//remember to catch the exceptions
     //			 	  throw new DataAccessException("cannot delete any record owned by that id");
     //
   } catch (ServiceLocatorException e) {
     throw new DataAccessException("Unable to retrieve connection; " + e.getMessage(), e);
   } catch (SQLException e) {
     throw new DataAccessException("Unable to execute query; " + e.getMessage(), e);
   } finally {
     if (con != null) {
       try {
         con.close(); // and close the connections etc
       } catch (SQLException e1) { // if not close properly
         e1.printStackTrace();
       }
     }
   }
 }
  public void insert(
      int bookingid,
      int hotelid,
      int roomtypeid,
      int extrabed,
      double price,
      Timestamp checkindate,
      Timestamp checkoutdate)
      throws DataAccessException {
    Connection con = null;
    try {
      // get the connection
      con = services.createConnection();
      PreparedStatement stmt =
          con.prepareStatement(
              "Insert Into Record (bookingid, hotelid, roomtypeid, extrabed, "
                  + "price, checkindate, checkoutdate) "
                  + "values (?, ?, ?, ?, ?, ?,?)");
      stmt.setInt(1, bookingid);
      stmt.setInt(2, hotelid);
      stmt.setInt(3, roomtypeid);
      stmt.setInt(4, extrabed);
      //		     stmt.setInt(5, requestamount);
      stmt.setDouble(5, price);
      stmt.setTimestamp(6, checkindate);
      stmt.setTimestamp(7, checkoutdate);

      // execute the update
      int n = stmt.executeUpdate();
      if (n != 1) // remember to catch the exceptions
      throw new DataAccessException("Did not insert one row into database");
    } catch (ServiceLocatorException e) {
      throw new DataAccessException("Unable to retrieve connection; " + e.getMessage(), e);
    } catch (SQLException e) {
      throw new DataAccessException("Unable to execute query; " + e.getMessage(), e);
    } finally {
      if (con != null) {
        try {
          con.close(); // and close the connections etc
        } catch (SQLException e1) { // if not close properly
          e1.printStackTrace();
        }
      }
    }
  }