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