public IHttpActionResult PostReading(Reading reading) { if (reading != null) { SqlOperator.PostReading(reading); var aqi = AqiCalculator.CalculateAqi(reading); if (aqi.Value >= 151) { EmailSender.SendEmail(aqi); } return(Ok(reading)); } else { return(BadRequest()); } }
public void PostReadingTest() { var newReading = new Reading { TimeStamp = (int)DateTimeOffset.Now.ToUnixTimeSeconds(), Co = 0.0, No = 0.0, So = 0.0 }; SqlOperator.PostReading(newReading); var command = "SELECT * FROM Readings " + "WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)"; var latestReading = SqlOperator.GetReadings(command)[0]; var command2 = $"SELECT * FROM Readings WHERE Id={latestReading.Id}"; var reading = SqlOperator.GetReadings(command2)[0]; Assert.AreEqual(newReading.TimeStamp, reading.TimeStamp); }