public List <Appointment> createListOfAppointments(String query)
{
List <Appointment> appointments = new List <Appointment>();
List <String> columnNames = DatabaseModel.ColumnNames.getAppointmentsColumnNames();
String[,] results = _database.selectQuery(query, columnNames);
DataTable table = CollectionsConverter.convertArrayToDataTable(results, columnNames);
if (table.Rows.Count > 0)
{
appointments = (from p in table.AsEnumerable()
select new Appointment(int.Parse(p.Field <String>("patientID")), int.Parse(p.Field <String>("doctorID")), int.Parse(p.Field <String>("roomNumber")), MySqlDatesParser.parseDate(p.Field <String>("date")), p.Field <String>("reason"), int.Parse(p.Field <String>("caseID")))
{
}
).ToList();
}
return(appointments);
}
public List <Doctor> createListOfDoctors(String query)
{
List <Doctor> doctors = new List <Doctor>();
List <String> columnNames = DatabaseModel.ColumnNames.getDoctorsColumnNames();
String[,] results = _database.selectQuery(query, columnNames);
DataTable table = CollectionsConverter.convertArrayToDataTable(results, columnNames);
if (table.Rows.Count > 0)
{
doctors = (from p in table.AsEnumerable()
select new Doctor(p.Field <String>("name"), p.Field <String>("surname"), p.Field <String>("gender"), MySqlDatesParser.parseDate(p.Field <String>("dateOfBirth")), int.Parse(p.Field <String>("mobileNumber")), p.Field <String>("email"), p.Field <String>("specialty"), int.Parse(p.Field <String>("roomNumber")))
{
doctorID = int.Parse(p.Field <String>("doctorID")),
employeeID = int.Parse(p.Field <String>("employeeID"))
}
).ToList();
}
return(doctors);
}
public List <Sample> createListOfSamples(String query)
{
List <Sample> samples = new List <Sample>();
List <String> columnNames = DatabaseModel.ColumnNames.getSamplesColumnNames();
String[,] results = _database.selectQuery(query, columnNames);
DataTable table = CollectionsConverter.convertArrayToDataTable(results, columnNames);
if (table.Rows.Count > 0)
{
samples = (from p in table.AsEnumerable()
select new Sample(int.Parse(p.Field <String>("patient_id")), int.Parse(p.Field <String>("doctor_id")), MySqlDatesParser.parseDate(p.Field <String>("creation_date")), p.Field <String>("result"))
{
sampleID = int.Parse(p.Field <String>("sample_id")),
tested = Convert.ToBoolean(Convert.ToInt32(p.Field <String>("tested")))
}
).ToList();
}
return(samples);
}
public List <Case> createListOfCasesObjects(String query)
{
List <Case> cases = new List <Case>();
List <String> columnNames = DatabaseModel.ColumnNames.getCasesColumnNames();
String[,] results = _database.selectQuery(query, columnNames);
DataTable table = CollectionsConverter.convertArrayToDataTable(results, columnNames);
if (table.Rows.Count > 0)
{
cases = (from p in table.AsEnumerable()
select new Case(int.Parse(p.Field <String>("patientID")), MySqlDatesParser.parseDate(p.Field <String>("start_date")), p.Field <String>("description"))
{
caseID = int.Parse(p.Field <String>("case_id")),
endDate = MySqlDatesParser.parseNullableDate(p.Field <String>("end_date"))
}
).ToList();
}
return(cases);
}
public List <Patient> createListofPatientObjects()
{
List <Patient> patients = new List <Patient>();
List <String> columnNames = DatabaseModel.ColumnNames.getPatientColumnNames();
String query = "SELECT * FROM Patients";
String[,] results = _database.selectQuery(query, columnNames);
DataTable table = CollectionsConverter.convertArrayToDataTable(results, columnNames);
if (table.Rows.Count > 0)
{
patients = (from p in table.AsEnumerable()
select new Patient(p.Field <String>("name"), p.Field <String>("surname"), p.Field <String>("gender"), MySqlDatesParser.parseDate(p.Field <String>("dateOfBirth")), int.Parse(p.Field <String>("mobileNumber")), p.Field <String>("email"), MySqlDatesParser.parseDate(p.Field <String>("dateOfRegistration")), int.Parse(p.Field <String>("patientID")), int.Parse(p.Field <String>("medicalCardID")), Convert.ToBoolean(int.Parse(p.Field <String>("underTreatment"))))
{
}
).ToList();
}
return(patients);
}