private static RoutineCheck buildRoutineCheck(MySqlCommand cmd)
{
var routineCheck = new RoutineCheck();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
int nurseIDOrdinal = reader.GetOrdinal("nurseID");
int fnameOrdinal = reader.GetOrdinal("fname");
int lnameOrdinal = reader.GetOrdinal("lname");
int bloodPressureSystolicOrdinal = reader.GetOrdinal("bloodPressureSystolic");
int bloodPressureDiastolicOrdinal = reader.GetOrdinal("bloodPressureDiastolic");
int bodyTempOrdinal = reader.GetOrdinal("bodyTemp");
int pulseOrdinal = reader.GetOrdinal("pulse");
int weightOrdinal = reader.GetOrdinal("weight");
int symptomsOrdinal = reader.GetOrdinal("symptoms");
while (reader.Read())
{
routineCheck.Nurse.ID = DbDefault.GetInt(reader, nurseIDOrdinal);
routineCheck.Nurse.Bio.FirstName = DbDefault.GetString(reader, fnameOrdinal);
routineCheck.Nurse.Bio.LastName = DbDefault.GetString(reader, lnameOrdinal);
routineCheck.BloodPressureSystolic = DbDefault.GetInt(reader, bloodPressureSystolicOrdinal);
routineCheck.BloodPressureDiastolic = DbDefault.GetInt(reader, bloodPressureDiastolicOrdinal);
routineCheck.BodyTemp = DbDefault.GetDouble(reader, bodyTempOrdinal);
routineCheck.Pulse = DbDefault.GetInt(reader, pulseOrdinal);
routineCheck.Weight = DbDefault.GetDouble(reader, weightOrdinal);
routineCheck.Symptoms = DbDefault.GetString(reader, symptomsOrdinal);
}
return(routineCheck);
}
}