public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.PRESCRIPTIONS);
query.Add(Database.Tables.Prescriptions.PrescriberId);
query.Add(Database.Tables.Prescriptions.PatientId);
query.Add(Database.Tables.Prescriptions.Name);
query.Add(Database.Tables.Prescriptions.Remark);
query.Add(Database.Tables.Prescriptions.StartDate);
query.Add(Database.Tables.Prescriptions.EndDate);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
Prescriber = StaffsManager.GetMedicalStaff(reader.GetInt32(0));
Patient = PatientsManager.GetPatient(reader.GetInt32(1));
Name = reader.GetString(2);
Remark = reader.GetString(3);
StartDate = reader.GetDateTime(4);
EndDate = reader.GetDateTime(5);
PatientsManager.Add(this);
}
reader.Close();
// TODO: Implement fetching prescription's medications.
}
public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.TEST_RESULTS);
query.Add(Database.Tables.TestResults.PatientId);
query.Add(Database.Tables.TestResults.MedicalLicenseNo);
query.Add(Database.Tables.TestResults.Name);
query.Add(Database.Tables.TestResults.Description);
query.Add(Database.Tables.TestResults.Result);
query.Add(Database.Tables.TestResults.Remark);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
Patient = PatientsManager.GetPatient(reader.GetInt32(0));
MedicalLicenseNo = reader.GetString(1);
Name = reader.GetString(2);
Description = reader.GetString(3);
Result = reader.GetString(4);
Remark = reader.GetString(5);
PatientsManager.Add(this);
}
reader.Close();
}
public async Task <IHttpActionResult> GetPatients([FromUri] string patientId)
{
try
{
if (patientId != null)
{
return(Json(await _manager.GetPatient(patientId)));
}
PatientPage patientPage = await _manager.GetPatients(new FindPatientModel { PatientId = patientId });
return(patientPage.Patients.Count() > 0 ? Json(patientPage) : (IHttpActionResult)BadRequest("no patients found!"));
}
catch (Exception ex) { return(InternalServerError(ex)); }
}
public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.APPOINTMENTS);
query.Add(Database.Tables.Appointments.MedicalStaffId);
query.Add(Database.Tables.Appointments.PatientId);
query.Add(Database.Tables.Appointments.Cancelled);
query.Add(Database.Tables.Appointments.DateAppointed);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
MedicalStaff = StaffsManager.GetMedicalStaff(reader.GetInt32(0));
Patient = PatientsManager.GetPatient(reader.GetInt32(1));
Cancelled = reader.GetByte(2) > 0 ? true : false;
DateAppointed = reader.GetDateTime(3);
PatientsManager.Add(this);
}
reader.Close();
}