/// <summary>
/// Convenience method to insert a new <see cref="List{MedicalNotes}"/> objects into the database, linked to a <see cref="Patient"/>.
/// </summary>
/// <param name="o">The <see cref="Patient"/> to link the notes to.</param>
/// <param name="notes">A <see cref="List{string}"/> that are the notes needing to be added. </param>
public void InsertPatientNote(Patient o, List <string> notes)
{
List <MedicalNotes> getID = GetMedicalNotes(o.ID);
MedicalNotes newEntry;
QueryBuilder qb = new QueryBuilder();
foreach (string s in notes)
{
newEntry = new MedicalNotes();
newEntry.Notes = s;
newEntry.PatientID = o.ID;
newEntry.WrittenDate = DateTime.Now;
qb.Insert(Tables.MEDICALNOTES_TABLE).Values
(null,
newEntry.PatientID,
newEntry.WrittenDate.ToString("yyyy-MM-dd"),
newEntry.Notes);
MySqlCommand cmd = new MySqlCommand(qb.ToString(), dbCon.GetConnection());
cmd.ExecuteNonQuery();
}
}
/// <summary>
/// Gets all <see cref="MedicalNotes"/> objects that match the given SQL query criteria contained in the <see cref="QueryBuilder"/>.
/// </summary>
/// <param name="b"><see cref="QueryBuilder"/> containing the SQL query.</param>
/// <returns>A <see cref="List{MedicalNotes}"/>.</returns>
public List <MedicalNotes> GetMedicalNotes(QueryBuilder b)
{
List <MedicalNotes> result = new List <MedicalNotes>();
MySqlCommand query = new MySqlCommand(b.ToString(), dbCon.GetConnection());
MySqlDataReader reader = query.ExecuteReader();
while (reader.Read())
{
MedicalNotes a = new MedicalNotes();
MedicalNotesTable pt = Tables.MEDICALNOTES_TABLE;
a.ID = GetInt(reader[pt.ID.Name]);
a.PatientID = GetInt(reader[pt.PatientID.Name]);
a.WrittenDate = GetDateTime(reader[pt.WrittenDate.Name]);
a.Notes = GetString(reader[pt.Notes.Name]);
result.Add(a);
}
reader.Close();
reader.Dispose();
return(result);
}