/* Read all allergens */
public async Task <List <Allergen> > readAllergens(int chartId)
{
try {
string query = $@"
SELECT
allergen.id as allergenId,
allergen.patient_chart as allergenPatientChartId,
medicament.id as medicamentId,
medicament.name as medicamentName
FROM
{DBTables.ALLERGEN} as allergen
INNER JOIN
{DBTables.MEDICAMENT} as medicament
ON
{DBTables.ALLERGEN}.medicament = {DBTables.MEDICAMENT}.id
WHERE
allergen.patient_chart = @chartId";
MySqlConnection connection = new MySqlConnection(DB.connectionString);
connection.Open();
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.Parameters.AddWithValue("@chartId", chartId);
cmd.Prepare();
DbDataReader reader = await cmd.ExecuteReaderAsync();
List <Allergen> allergens = new List <Allergen>();
while (reader.Read())
{
PatientChart chart = new PatientChart(
reader.GetInt32(reader.GetOrdinal("allergenPatientChartId")),
DateTime.Now,
null
);
Medicament medicament = new Medicament(
reader.GetInt32(reader.GetOrdinal("medicamentId")),
reader.GetString(reader.GetOrdinal("medicamentName")),
"",
DateTime.Now,
""
);
Allergen allergen = new Allergen(
reader.GetInt32(reader.GetOrdinal("allergenId")),
chart,
medicament
);
allergens.Add(allergen);
}
return(allergens);
} catch (Exception e) {
throw e;
}
}
public ChartDocument()
{
this.Id = 0;
this.Name = "";
this.Type = "";
this.URL = "";
this.DateCreated = DateTime.Now;
this.PatientChart = null;
}
public Allergen(
int id,
PatientChart patientChart,
Medicament medicament
)
{
this.Id = id;
this.PatientChart = patientChart;
this.Medicament = medicament;
}
/* Read one patient chart by patient id */
public async Task <PatientChart> readPatientChart(int patientId)
{
try {
string query = $@"
SELECT *
FROM
{DBTables.PATIENT_CHART}
WHERE
{DBTables.PATIENT_CHART}.patient = @patientId";
MySqlConnection connection = new MySqlConnection(DB.connectionString);
connection.Open();
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.Parameters.AddWithValue("@patientId", patientId);
cmd.Prepare();
DbDataReader reader = await cmd.ExecuteReaderAsync();
PatientChart patientChart = new PatientChart();
while (reader.Read())
{
Patient currentPatient = new Patient(
reader.GetInt32(reader.GetOrdinal("patient")),
"",
"",
"",
"",
DateTime.Now,
""
);
PatientChart chart = new PatientChart(
reader.GetInt32(reader.GetOrdinal("id")),
reader.GetDateTime(reader.GetOrdinal("date_created")),
currentPatient
);
return(chart);
}
return(null);
} catch (Exception e) {
Console.Write(e);
throw e;
}
}
public ChartDocument(
int id,
string name,
string type,
string url,
DateTime dateCreated,
PatientChart patientChart
)
{
this.Id = id;
this.DateCreated = dateCreated;
this.Name = name;
this.Type = type;
this.URL = url;
this.PatientChart = patientChart;
}
/* Read all chart documents */
public async Task <List <ChartDocument> > readChartDocuments(int chartId)
{
try {
string query = $@"
SELECT *
FROM
{DBTables.CHART_DOCUMENT}
WHERE
patient_chart = @chartId";
MySqlConnection connection = new MySqlConnection(DB.connectionString);
connection.Open();
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.Parameters.AddWithValue("@chartId", chartId);
cmd.Prepare();
DbDataReader reader = await cmd.ExecuteReaderAsync();
List <ChartDocument> docs = new List <ChartDocument>();
while (reader.Read())
{
PatientChart chart = new PatientChart(
reader.GetInt32(reader.GetOrdinal("patient_chart")),
DateTime.Now,
null
);
ChartDocument doc = new ChartDocument(
reader.GetInt32(reader.GetOrdinal("id")),
reader.GetString(reader.GetOrdinal("name")),
reader.GetString(reader.GetOrdinal("type")),
reader.GetString(reader.GetOrdinal("url")),
reader.GetDateTime(reader.GetOrdinal("date_created")),
chart
);
docs.Add(doc);
}
return(docs);
} catch (Exception e) {
throw e;
}
}
