public static void InsertMeasurement(MeasurementDTO measurement) { using (ConnectionString connectionString = new ConnectionString()) { connectionString.sqlConnection.Open(); SqlCommand insert = new SqlCommand("sp_PatientMeasurements_InsertValue", connectionString.sqlConnection); insert.CommandType = CommandType.StoredProcedure; insert.Parameters.AddWithValue("@Date", measurement.measurementDate); insert.Parameters.AddWithValue("@MeasurementSucceeded", measurement.measurementSucceeded); insert.Parameters.AddWithValue("@Measurement", measurement.measurementValue); insert.ExecuteNonQuery(); } }
public static MeasurementDTO GetMostRecentDate(List <MeasurementDTO> measurementDtos) { DateTime mostRecentDateTime = DateTime.MinValue; MeasurementDTO mostRecentMeasurement = new MeasurementDTO(); foreach (MeasurementDTO measurement in measurementDtos) { if (measurement.measurementDate.Date > mostRecentDateTime) { mostRecentDateTime = measurement.measurementDate; mostRecentMeasurement = measurement; } } if (mostRecentMeasurement.measurementSucceeded) { return(mostRecentMeasurement); } measurementDtos.Remove(mostRecentMeasurement); var mostRecent = GetMostRecentDate(measurementDtos); return(mostRecent); }