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(); }