From 08e7a82cc7b237e550c0236bebd4f41c3c3f4acf Mon Sep 17 00:00:00 2001 From: marcinzelent Date: Fri, 16 Mar 2018 21:40:28 +0100 Subject: Moved API to separate folder. --- .../Controllers/ReadingsController.cs | 85 ---------------------- 1 file changed, 85 deletions(-) delete mode 100644 PollutometerWebApi/Controllers/ReadingsController.cs (limited to 'PollutometerWebApi/Controllers/ReadingsController.cs') diff --git a/PollutometerWebApi/Controllers/ReadingsController.cs b/PollutometerWebApi/Controllers/ReadingsController.cs deleted file mode 100644 index adf4d5d..0000000 --- a/PollutometerWebApi/Controllers/ReadingsController.cs +++ /dev/null @@ -1,85 +0,0 @@ -using System; -using System.Web.Http; -using PollutometerWebApi.Models; - -namespace PollutometerWebApi.Controllers -{ - public class ReadingsController : ApiController - { - public ReadingsController() {} - - public IHttpActionResult GetAllReadings() - { - var command = "SELECT * FROM Readings"; - var readings = SqlOperator.GetReadings(command); - - if (readings.Count > 0) return Ok(readings); - else return NotFound(); - } - - public IHttpActionResult GetReading(int id) - { - var command = $"SELECT * FROM Readings WHERE Id={id}"; - var readings = SqlOperator.GetReadings(command); - - if (readings.Count == 1) return Ok(readings[0]); - else return NotFound(); - } - - [Route("api/Readings/latest")] - public IHttpActionResult GetLatestReading() - { - var command = "SELECT * FROM Readings " + - "WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)"; - var reading = SqlOperator.GetReadings(command)[0]; - - if (reading != null) return Ok(reading); - else return NotFound(); - } - - [Route("api/Readings/lastweek")] - public IHttpActionResult GetReadingsFromLastWeek() - { - var timeNow = DateTimeOffset.Now.ToUnixTimeSeconds(); - var command = "SELECT * FROM Readings " + - $"WHERE TimeStamp BETWEEN {timeNow-7*24*3600} AND {timeNow}"; - var readings = SqlOperator.GetReadings(command); - - if (readings.Count > 0) return Ok(readings); - else return NotFound(); - } - - public IHttpActionResult PutReading(int id, Reading reading) - { - if (reading != null) - { - SqlOperator.PutReading(id, reading); - return Ok(); - } - else return BadRequest(); - } - - 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 IHttpActionResult DeleteReading(int id) - { - var command = $"SELECT * FROM Readings WHERE Id={id}"; - var readings = SqlOperator.GetReadings(command); - if (readings.Count == 0) return NotFound(); - SqlOperator.DeleteReading(id); - - return Ok(readings[0]); - } - } -} \ No newline at end of file -- cgit v1.2.3