public IHttpActionResult PutReading(int id, Reading reading) { if (reading != null) { SqlOperator.PutReading(id, reading); return(Ok()); } else { return(BadRequest()); } }
public void PutReadingTest() { var newReading = new Reading { TimeStamp = (int)DateTimeOffset.Now.ToUnixTimeSeconds(), Co = 0.5, No = 0.5, So = 0.5 }; var command = "SELECT * FROM Readings " + "WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)"; var latestReading = SqlOperator.GetReadings(command)[0]; SqlOperator.PutReading(latestReading.Id, newReading); var command2 = $"SELECT * FROM Readings WHERE Id={latestReading.Id}"; var reading = SqlOperator.GetReadings(command2)[0]; Assert.AreEqual(newReading.TimeStamp, reading.TimeStamp); }