public int saveGuest(Person p, Guest g) throws SQLException { conn = DBTool.getInstance(); System.out.println("Saving guest..."); if (conn.isValid(10000)) { Statement s = conn.createStatement(); int idPerson = p.getId(); String guestFirstname = g.getFirstname(); String guestMiddlename = g.getMiddlename(); String guestLastname = g.getLastname(); String guestBirthday = ADate.formatADate(g.getBirthday(), ""); String guestCreationdate = ADate.formatADate(g.getCreationDate(), ""); s.execute( "INSERT INTO guest (firstname, middlename, lastname, creationdate, birthday, idperson) VALUES('" + guestFirstname + "', '" + guestMiddlename + "', '" + guestLastname + "', '" + guestCreationdate + "', '" + guestBirthday + "', '" + idPerson + "');"); ResultSet rs = s.executeQuery("SELECT LAST_INSERT_ID();"); rs.next(); int returnId = rs.getInt(1); System.out.println("Save complete!"); rs.close(); s.close(); conn.close(); return returnId; } else { System.out.println("Connection not valid"); conn.close(); return -1; } }
/** * *@purpose : To create a new guest *@param : Guest guestobject, Strig cineplexname *@return : * void */ @SuppressWarnings("unchecked") public void createNewGuest(Guest guest, String cineplexName) { JSONArray jsonGuests = (JSONArray) jsonObject.get("guests"); boolean exists = false; for (int i = 0; i < this.guests.size(); i++) { if (this.guests.get(i).getEmail().equalsIgnoreCase(guest.getEmail()) && this.guests.get(i).getMobileNo() == guest.getMobileNo() && this.guests.get(i).getCineplexName().equals(cineplexName)) { // System.out.println("Account already exists"); exists = true; break; } } if (!exists) { JSONObject jsonGuest = new JSONObject(); jsonGuest.put("id", guest.getId().toLowerCase()); jsonGuest.put("name", guest.getName()); jsonGuest.put("mobileno", guest.getMobileNo()); jsonGuest.put("email", guest.getEmail().toLowerCase()); jsonGuest.put("cineplexname", cineplexName); jsonGuests.add(jsonGuest); } updateFile(JSONDAO.guestPath, this.jsonObject); }
private void parseJSON(JSONObject jsonObject, boolean INCLUDE_BOOKINGS) { if (this.jsonObject != null) { JSONArray jsonGuests = (JSONArray) jsonObject.get("guests"); JSONObject jsonGuest; Guest guest; for (int i = 0; i < jsonGuests.size(); i++) { jsonGuest = (JSONObject) jsonGuests.get(i); if (this.guests == null) this.guests = new ArrayList<Guest>(); guest = new Guest(); guest.setId(jsonGuest.get("id").toString()); guest.setName(jsonGuest.get("name").toString()); guest.setEmail(jsonGuest.get("email").toString()); guest.setCineplexName(jsonGuest.get("cineplexname").toString()); guest.setMobileNo(Integer.parseInt(jsonGuest.get("mobileno").toString())); if (INCLUDE_BOOKINGS) guest.setBookings(new BookingDAO().getBookingsByGuest(guest)); this.guests.add(guest); } } }
public ArrayList<Person> getAllPersons() throws SQLException { conn = DBTool.getInstance(); System.out.println("Getting all persons..."); if (conn.isValid(10000)) { Statement s = conn.createStatement(); ArrayList<Person> persons = new ArrayList<>(); ResultSet rs = s.executeQuery("SELECT * FROM person"); while (rs.next()) { int idperson = rs.getInt("idperson"); String firstname = rs.getString("firstname"); String middlename = rs.getString("middlename"); String lastname = rs.getString("lastname"); String address = rs.getString("address"); ADate birthday = new ADate(rs.getString("birthday")); ADate expirationDate = new ADate(rs.getString("expirationdate")); File picturePath = new File(rs.getString("picturepath")); ADate quarantineExpirationDate = null; if (!rs.getString("quarantineexpirationdate").isEmpty()) { quarantineExpirationDate = new ADate(rs.getString("quarantineexpirationdate")); } ADate creationDate = new ADate(rs.getString("creationdate")); boolean oneOne = false; if (rs.getInt("oneone") == 1) { oneOne = true; } boolean quarantine = false; if (rs.getInt("quarantine") == 1) { quarantine = true; } boolean enrolled = false; if (rs.getInt("enrolled") == 1) { enrolled = true; } boolean hone = false; if (rs.getInt("hone") == 1) { hone = true; } Statement s2 = conn.createStatement(); ArrayList<Guest> guests = new ArrayList<>(); ResultSet rsGuest = s2.executeQuery("SELECT * FROM guest WHERE idperson = " + idperson + ";"); while (rsGuest.next()) { Guest g = new Guest( rsGuest.getString("firstname"), rsGuest.getString("middlename"), rsGuest.getString("lastname"), new ADate(rsGuest.getString("birthday")), new ADate(rsGuest.getString("creationdate"))); g.setId(rsGuest.getInt("idguest")); guests.add(g); } Person p = new Person( firstname, middlename, lastname, address, birthday, expirationDate, picturePath, creationDate, oneOne); p.setId(idperson); p.setQuarantine(quarantine); p.setQuarantineExpirationDate(quarantineExpirationDate); p.setEnrolled(enrolled); p.setHone(hone); p.setGuests(guests); persons.add(p); rsGuest.close(); s2.close(); } System.out.println("Get complete!"); rs.close(); s.close(); conn.close(); return persons; } else { System.out.println("Connection invalid"); conn.close(); return null; } }