/**
* Creates a Patient object from a database query
*
* @param result The ResultSet from the database query
* @return The Patient object
*/
private Patient createFromSearch(ResultSet result) {
Patient p = new Patient();
try {
p.setPatientID(result.getInt("patient_ID"));
p.setFirstName(result.getString("firstname"));
p.setLastName(result.getString("lastname"));
p.setPreferredName(result.getString("preferredname"));
// set gender
String gender = result.getString("gender");
if ("M".equals(gender)) p.setGender("Male");
else if ("F".equals(gender)) p.setGender("Female");
else p.setGender("Other");
// set clinic
String clinicCode = result.getString("clinic");
p.setClinic(clinicCode);
p.setClinicName(Utils.getClinicName(clinicCode));
p.setVolunteer(result.getInt("volunteer"));
p.setNotes(result.getString("notes"));
p.setAvailability(result.getString("availability"));
p.setAlerts(result.getString("alerts"));
String myOscarVerfied = result.getString("myoscar_verified");
p.setMyoscarVerified(myOscarVerfied);
// set myoscar authentication for display in client's detail page
if ("1".equals(myOscarVerfied)) p.setMyOscarAuthentication("Authenticated");
else p.setMyOscarAuthentication("Not Authenticated");
p.setPartner(result.getInt("volunteer2"));
// Set volunteer name and partner name
setVolunteerDisplayName(p, "volunteer1");
setVolunteerDisplayName(p, "volunteer2");
} catch (SQLException e) {
System.out.println("Error: Failed to create Patient object");
e.printStackTrace();
}
return p;
}
