public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.PRESCRIPTION_MEDICATIONS);
query.Add(Database.Tables.PrescriptionMedications.PrescriptionId);
query.Add(Database.Tables.PrescriptionMedications.MedicationId);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
Prescription = PatientsManager.GetPrescription(reader.GetInt32(0));
Base = PatientsManager.GetMedication(reader.GetInt32(1));
Code = Base.Code;
Name = Base.Name;
PatientsManager.Add(this);
}
reader.Close();
}