private static IList <LabTest> buildLabTestList(MySqlCommand cmd)
{
var labTests = new List <LabTest>();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
var apptIdOrdinal = reader.GetOrdinal("apptID");
var testTypeCodeOrdinal = reader.GetOrdinal("testTypeCode");
var resultsOrdinal = reader.GetOrdinal("results");
var abnormalityOrdinal = reader.GetOrdinal("abnormality");
var datetimeOrdinal = reader.GetOrdinal("testDatetime");
var testTypeNameOrdinal = reader.GetOrdinal("name");
while (reader.Read())
{
var labTest = new LabTest();
var testType = new TestType
{
Code = DbDefault.GetInt(reader, testTypeCodeOrdinal),
Name = DbDefault.GetString(reader, testTypeNameOrdinal)
};
labTest.TestType = testType;
labTest.AppointmentID = DbDefault.GetInt(reader, apptIdOrdinal);
labTest.Results = DbDefault.GetString(reader, resultsOrdinal);
labTest.Abnormality = DbDefault.GetString(reader, abnormalityOrdinal);
labTest.Date = DbDefault.GetDatetime(reader, datetimeOrdinal);
labTests.Add(labTest);
}
return(labTests);
}
}
private static IList <Appointment> buildAppointmentList(MySqlCommand cmd)
{
var appointments = new List <Appointment>();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
int apptIDOrdinal = reader.GetOrdinal("apptID");
int datetimeOrdinal = reader.GetOrdinal("datetime");
int reasonsOrdinal = reader.GetOrdinal("reasons");
int doctorIDOrdinal = reader.GetOrdinal("doctorID");
int fnameOrdinal = reader.GetOrdinal("fname");
int lnameOrdinal = reader.GetOrdinal("lname");
int initialOrdinal = reader.GetOrdinal("initialDiagnosis");
int finalOrdinal = reader.GetOrdinal("finalDiagnosis");
while (reader.Read())
{
Appointment appointment = new Appointment();
appointment.ID = DbDefault.GetInt(reader, apptIDOrdinal);
appointment.Date = DbDefault.GetDatetime(reader, datetimeOrdinal);
appointment.Reasons = DbDefault.GetString(reader, reasonsOrdinal);
appointment.Doctor.ID = DbDefault.GetInt(reader, doctorIDOrdinal);
appointment.Doctor.Bio.FirstName = DbDefault.GetString(reader, fnameOrdinal);
appointment.Doctor.Bio.LastName = DbDefault.GetString(reader, lnameOrdinal);
appointment.Diagnosis.InitialDiagnosis = DbDefault.GetString(reader, initialOrdinal);
appointment.Diagnosis.FinalDiagnosis = DbDefault.GetString(reader, finalOrdinal);
appointments.Add(appointment);
}
return(appointments);
}
}
private static IList <DateTime> buildDateList(MySqlCommand cmd)
{
var dates = new List <DateTime>();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
int datetimeOrdinal = reader.GetOrdinal("datetime");
while (reader.Read())
{
dates.Add(DbDefault.GetDatetime(reader, datetimeOrdinal));
}
return(dates);
}
}
private static IList <Patient> buildPatientList(MySqlCommand cmd)
{
IList <Patient> patients = new List <Patient>();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
int patientIDOrdinal = reader.GetOrdinal("patientID");
int bioIDOrdinal = reader.GetOrdinal("ID");
int fnameOrdinal = reader.GetOrdinal("fname");
int lnameOrdinal = reader.GetOrdinal("lname");
int dobOrdinal = reader.GetOrdinal("DOB");
int phoneNumberOrdinal = reader.GetOrdinal("phone#");
int genderOrdinal = reader.GetOrdinal("gender");
int addressIDOrdinal = reader.GetOrdinal("addressID");
int address1Ordinal = reader.GetOrdinal("address1");
int address2Ordinal = reader.GetOrdinal("address2");
int cityOrdinal = reader.GetOrdinal("city");
int stateOrdinal = reader.GetOrdinal("state");
int zipOrdinal = reader.GetOrdinal("zip");
while (reader.Read())
{
Patient patient = new Patient();
patient.ID = DbDefault.GetInt(reader, patientIDOrdinal);
patient.Bio.FirstName = DbDefault.GetString(reader, fnameOrdinal);
patient.Bio.LastName = DbDefault.GetString(reader, lnameOrdinal);
patient.Bio.DOB = DbDefault.GetDatetime(reader, dobOrdinal);
patient.Bio.PhoneNumber = DbDefault.GetString(reader, phoneNumberOrdinal);
patient.Bio.Gender = DbDefault.GetString(reader, genderOrdinal);
patient.Bio.Address.AddressID = DbDefault.GetInt(reader, addressIDOrdinal);
patient.Bio.Address.Address1 = DbDefault.GetString(reader, address1Ordinal);
patient.Bio.Address.Address2 = DbDefault.GetString(reader, address2Ordinal);
patient.Bio.Address.City = DbDefault.GetString(reader, cityOrdinal);
patient.Bio.Address.State = DbDefault.GetString(reader, stateOrdinal);
patient.Bio.Address.Zip = DbDefault.GetInt(reader, zipOrdinal);
patients.Add(patient);
}
return(patients);
}
}
