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