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. --- PollutometerWebApi.Tests/AqiCalculatorTests.cs | 51 ---- PollutometerWebApi.Tests/EmailSenderTests.cs | 21 -- .../PollutometerWebApi.Tests.csproj | 125 --------- .../Properties/AssemblyInfo.cs | 36 --- .../ReadingsControllerTests.cs | 116 --------- PollutometerWebApi.Tests/SqlOperatorTests.cs | 68 ----- PollutometerWebApi.Tests/app.config | 11 - PollutometerWebApi.Tests/packages.config | 10 - PollutometerWebApi.sln | 30 --- PollutometerWebApi.userprefs | 21 -- PollutometerWebApi/.gitignore | 288 --------------------- PollutometerWebApi/App_Start/RouteConfig.cs | 19 -- PollutometerWebApi/App_Start/WebApiConfig.cs | 24 -- PollutometerWebApi/AqiCalculator.cs | 102 -------- PollutometerWebApi/Controllers/HomeController.cs | 19 -- .../Controllers/ReadingsController.cs | 85 ------ PollutometerWebApi/EmailSender.cs | 34 --- PollutometerWebApi/Global.asax | 1 - PollutometerWebApi/Global.asax.cs | 17 -- PollutometerWebApi/Models/Aqi.cs | 34 --- PollutometerWebApi/Models/Reading.cs | 11 - PollutometerWebApi/PollutometerWebApi.csproj | 151 ----------- PollutometerWebApi/SqlOperator.cs | 83 ------ PollutometerWebApi/Views/Home/Index.cshtml | 1 - PollutometerWebApi/Views/Shared/Error.cshtml | 5 - PollutometerWebApi/Views/Shared/_Layout.cshtml | 9 - PollutometerWebApi/Views/Web.config | 30 --- PollutometerWebApi/Views/_ViewStart.cshtml | 3 - PollutometerWebApi/Web.config | 25 -- PollutometerWebApi/packages.config | 12 - README.md | 2 +- .../PollutometerWebApi.Tests/AqiCalculatorTests.cs | 51 ++++ .../PollutometerWebApi.Tests/EmailSenderTests.cs | 21 ++ .../PollutometerWebApi.Tests.csproj | 125 +++++++++ .../Properties/AssemblyInfo.cs | 36 +++ .../ReadingsControllerTests.cs | 116 +++++++++ .../PollutometerWebApi.Tests/SqlOperatorTests.cs | 68 +++++ .../PollutometerWebApi.Tests/app.config | 11 + .../PollutometerWebApi.Tests/packages.config | 10 + pollutometer-api/PollutometerWebApi.sln | 30 +++ pollutometer-api/PollutometerWebApi.userprefs | 21 ++ pollutometer-api/PollutometerWebApi/.gitignore | 288 +++++++++++++++++++++ .../PollutometerWebApi/App_Start/RouteConfig.cs | 19 ++ .../PollutometerWebApi/App_Start/WebApiConfig.cs | 24 ++ .../PollutometerWebApi/AqiCalculator.cs | 102 ++++++++ .../Controllers/HomeController.cs | 19 ++ .../Controllers/ReadingsController.cs | 85 ++++++ pollutometer-api/PollutometerWebApi/EmailSender.cs | 34 +++ pollutometer-api/PollutometerWebApi/Global.asax | 1 + pollutometer-api/PollutometerWebApi/Global.asax.cs | 17 ++ pollutometer-api/PollutometerWebApi/Models/Aqi.cs | 34 +++ .../PollutometerWebApi/Models/Reading.cs | 11 + .../PollutometerWebApi/PollutometerWebApi.csproj | 151 +++++++++++ pollutometer-api/PollutometerWebApi/SqlOperator.cs | 83 ++++++ .../PollutometerWebApi/Views/Home/Index.cshtml | 1 + .../PollutometerWebApi/Views/Shared/Error.cshtml | 5 + .../PollutometerWebApi/Views/Shared/_Layout.cshtml | 9 + .../PollutometerWebApi/Views/Web.config | 30 +++ .../PollutometerWebApi/Views/_ViewStart.cshtml | 3 + pollutometer-api/PollutometerWebApi/Web.config | 25 ++ .../PollutometerWebApi/packages.config | 12 + 61 files changed, 1443 insertions(+), 1443 deletions(-) delete mode 100644 PollutometerWebApi.Tests/AqiCalculatorTests.cs delete mode 100644 PollutometerWebApi.Tests/EmailSenderTests.cs delete mode 100644 PollutometerWebApi.Tests/PollutometerWebApi.Tests.csproj delete mode 100644 PollutometerWebApi.Tests/Properties/AssemblyInfo.cs delete mode 100644 PollutometerWebApi.Tests/ReadingsControllerTests.cs delete mode 100644 PollutometerWebApi.Tests/SqlOperatorTests.cs delete mode 100644 PollutometerWebApi.Tests/app.config delete mode 100644 PollutometerWebApi.Tests/packages.config delete mode 100644 PollutometerWebApi.sln delete mode 100644 PollutometerWebApi.userprefs delete mode 100644 PollutometerWebApi/.gitignore delete mode 100644 PollutometerWebApi/App_Start/RouteConfig.cs delete mode 100644 PollutometerWebApi/App_Start/WebApiConfig.cs delete mode 100644 PollutometerWebApi/AqiCalculator.cs delete mode 100644 PollutometerWebApi/Controllers/HomeController.cs delete mode 100644 PollutometerWebApi/Controllers/ReadingsController.cs delete mode 100644 PollutometerWebApi/EmailSender.cs delete mode 100644 PollutometerWebApi/Global.asax delete mode 100644 PollutometerWebApi/Global.asax.cs delete mode 100644 PollutometerWebApi/Models/Aqi.cs delete mode 100644 PollutometerWebApi/Models/Reading.cs delete mode 100644 PollutometerWebApi/PollutometerWebApi.csproj delete mode 100644 PollutometerWebApi/SqlOperator.cs delete mode 100644 PollutometerWebApi/Views/Home/Index.cshtml delete mode 100644 PollutometerWebApi/Views/Shared/Error.cshtml delete mode 100644 PollutometerWebApi/Views/Shared/_Layout.cshtml delete mode 100644 PollutometerWebApi/Views/Web.config delete mode 100644 PollutometerWebApi/Views/_ViewStart.cshtml delete mode 100644 PollutometerWebApi/Web.config delete mode 100644 PollutometerWebApi/packages.config create mode 100644 pollutometer-api/PollutometerWebApi.Tests/AqiCalculatorTests.cs create mode 100644 pollutometer-api/PollutometerWebApi.Tests/EmailSenderTests.cs create mode 100644 pollutometer-api/PollutometerWebApi.Tests/PollutometerWebApi.Tests.csproj create mode 100644 pollutometer-api/PollutometerWebApi.Tests/Properties/AssemblyInfo.cs create mode 100644 pollutometer-api/PollutometerWebApi.Tests/ReadingsControllerTests.cs create mode 100644 pollutometer-api/PollutometerWebApi.Tests/SqlOperatorTests.cs create mode 100644 pollutometer-api/PollutometerWebApi.Tests/app.config create mode 100644 pollutometer-api/PollutometerWebApi.Tests/packages.config create mode 100644 pollutometer-api/PollutometerWebApi.sln create mode 100644 pollutometer-api/PollutometerWebApi.userprefs create mode 100644 pollutometer-api/PollutometerWebApi/.gitignore create mode 100644 pollutometer-api/PollutometerWebApi/App_Start/RouteConfig.cs create mode 100644 pollutometer-api/PollutometerWebApi/App_Start/WebApiConfig.cs create mode 100644 pollutometer-api/PollutometerWebApi/AqiCalculator.cs create mode 100644 pollutometer-api/PollutometerWebApi/Controllers/HomeController.cs create mode 100644 pollutometer-api/PollutometerWebApi/Controllers/ReadingsController.cs create mode 100644 pollutometer-api/PollutometerWebApi/EmailSender.cs create mode 100644 pollutometer-api/PollutometerWebApi/Global.asax create mode 100644 pollutometer-api/PollutometerWebApi/Global.asax.cs create mode 100644 pollutometer-api/PollutometerWebApi/Models/Aqi.cs create mode 100644 pollutometer-api/PollutometerWebApi/Models/Reading.cs create mode 100644 pollutometer-api/PollutometerWebApi/PollutometerWebApi.csproj create mode 100644 pollutometer-api/PollutometerWebApi/SqlOperator.cs create mode 100644 pollutometer-api/PollutometerWebApi/Views/Home/Index.cshtml create mode 100644 pollutometer-api/PollutometerWebApi/Views/Shared/Error.cshtml create mode 100644 pollutometer-api/PollutometerWebApi/Views/Shared/_Layout.cshtml create mode 100644 pollutometer-api/PollutometerWebApi/Views/Web.config create mode 100644 pollutometer-api/PollutometerWebApi/Views/_ViewStart.cshtml create mode 100644 pollutometer-api/PollutometerWebApi/Web.config create mode 100644 pollutometer-api/PollutometerWebApi/packages.config diff --git a/PollutometerWebApi.Tests/AqiCalculatorTests.cs b/PollutometerWebApi.Tests/AqiCalculatorTests.cs deleted file mode 100644 index e84b687..0000000 --- a/PollutometerWebApi.Tests/AqiCalculatorTests.cs +++ /dev/null @@ -1,51 +0,0 @@ -using Microsoft.VisualStudio.TestTools.UnitTesting; -using PollutometerWebApi.Models; - -namespace PollutometerWebApi.Tests -{ - [TestClass()] - public class AqiCalculatorTests - { - [TestMethod()] - public void CalculateAqiPerfectTest() - { - var reading = new Reading - { - Co = 2.2, - No = 0.1, - So = 0.8 - }; - - var result = AqiCalculator.CalculateAqi(reading); - Assert.AreEqual(398.0100502512563, result.Value); - } - - [TestMethod()] - public void CalculateAqiBigNumbersTest() - { - var reading = new Reading - { - Co = 100.2, - No = 100.1, - So = 100.8 - }; - - var result = AqiCalculator.CalculateAqi(reading); - Assert.AreEqual(0, result.Value); - } - - [TestMethod()] - public void CalculateAqiZerosTest() - { - var reading = new Reading - { - Co = 0, - No = 0, - So = 0 - }; - - var result = AqiCalculator.CalculateAqi(reading); - Assert.AreEqual(0, result.Value); - } - } -} \ No newline at end of file diff --git a/PollutometerWebApi.Tests/EmailSenderTests.cs b/PollutometerWebApi.Tests/EmailSenderTests.cs deleted file mode 100644 index 427ec92..0000000 --- a/PollutometerWebApi.Tests/EmailSenderTests.cs +++ /dev/null @@ -1,21 +0,0 @@ -using Microsoft.VisualStudio.TestTools.UnitTesting; -using PollutometerWebApi.Models; - -namespace PollutometerWebApi.Tests -{ - [TestClass()] - public class EmailSenderTests - { - [TestMethod()] - public void SendEmailTest() - { - var aqi = new Aqi - { - GasName = "SO", - Value = 69, - Level = "Moderate" - }; - EmailSender.SendEmail(aqi); - } - } -} \ No newline at end of file diff --git a/PollutometerWebApi.Tests/PollutometerWebApi.Tests.csproj b/PollutometerWebApi.Tests/PollutometerWebApi.Tests.csproj deleted file mode 100644 index 6ff37aa..0000000 --- a/PollutometerWebApi.Tests/PollutometerWebApi.Tests.csproj +++ /dev/null @@ -1,125 +0,0 @@ - - - - - Debug - AnyCPU - {94A21C38-920E-42EF-8D48-B133D635EAFA} - Library - Properties - PollutometerWebApi.Tests - PollutometerWebApi.Tests - v4.6.2 - 512 - {3AC096D0-A1C2-E12C-1390-A8335801FDAB};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC} - 10.0 - $(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion) - $(ProgramFiles)\Common Files\microsoft shared\VSTT\$(VisualStudioVersion)\UITestExtensionPackages - False - UnitTest - - - - - - true - full - false - bin\Debug\ - DEBUG;TRACE - prompt - 4 - - - pdbonly - true - bin\Release\ - TRACE - prompt - 4 - - - - ..\packages\MSTest.TestFramework.1.1.18\lib\net45\Microsoft.VisualStudio.TestPlatform.TestFramework.dll - - - ..\packages\MSTest.TestFramework.1.1.18\lib\net45\Microsoft.VisualStudio.TestPlatform.TestFramework.Extensions.dll - - - ..\packages\Newtonsoft.Json.6.0.4\lib\net45\Newtonsoft.Json.dll - True - - - - - ..\packages\Microsoft.AspNet.WebApi.Client.5.2.0\lib\net45\System.Net.Http.Formatting.dll - - - - ..\packages\Microsoft.AspNet.WebApi.Core.5.2.0\lib\net45\System.Web.Http.dll - - - ..\packages\Microsoft.AspNet.WebApi.WebHost.5.2.0\lib\net45\System.Web.Http.WebHost.dll - - - - - - - - - - - - - - - - - - - - - - - - {22C32F4C-0DEB-40EA-9D56-48942CBB2A07} - PollutometerWebApi - - - - - - - False - - - False - - - False - - - False - - - - - - - - - This project references NuGet package(s) that are missing on this computer. Use NuGet Package Restore to download them. For more information, see http://go.microsoft.com/fwlink/?LinkID=322105. The missing file is {0}. - - - - - - - \ No newline at end of file diff --git a/PollutometerWebApi.Tests/Properties/AssemblyInfo.cs b/PollutometerWebApi.Tests/Properties/AssemblyInfo.cs deleted file mode 100644 index d6c3cc7..0000000 --- a/PollutometerWebApi.Tests/Properties/AssemblyInfo.cs +++ /dev/null @@ -1,36 +0,0 @@ -using System.Reflection; -using System.Runtime.CompilerServices; -using System.Runtime.InteropServices; - -// General Information about an assembly is controlled through the following -// set of attributes. Change these attribute values to modify the information -// associated with an assembly. -[assembly: AssemblyTitle("PollutometerWebApi.Tests")] -[assembly: AssemblyDescription("")] -[assembly: AssemblyConfiguration("")] -[assembly: AssemblyCompany("")] -[assembly: AssemblyProduct("PollutometerWebApi.Tests")] -[assembly: AssemblyCopyright("Copyright © 2017")] -[assembly: AssemblyTrademark("")] -[assembly: AssemblyCulture("")] - -// Setting ComVisible to false makes the types in this assembly not visible -// to COM components. If you need to access a type in this assembly from -// COM, set the ComVisible attribute to true on that type. -[assembly: ComVisible(false)] - -// The following GUID is for the ID of the typelib if this project is exposed to COM -[assembly: Guid("94a21c38-920e-42ef-8d48-b133d635eafa")] - -// Version information for an assembly consists of the following four values: -// -// Major Version -// Minor Version -// Build Number -// Revision -// -// You can specify all the values or you can default the Build and Revision Numbers -// by using the '*' as shown below: -// [assembly: AssemblyVersion("1.0.*")] -[assembly: AssemblyVersion("1.0.0.0")] -[assembly: AssemblyFileVersion("1.0.0.0")] diff --git a/PollutometerWebApi.Tests/ReadingsControllerTests.cs b/PollutometerWebApi.Tests/ReadingsControllerTests.cs deleted file mode 100644 index 647649d..0000000 --- a/PollutometerWebApi.Tests/ReadingsControllerTests.cs +++ /dev/null @@ -1,116 +0,0 @@ -using Microsoft.VisualStudio.TestTools.UnitTesting; -using PollutometerWebApi.Models; -using System; -using System.Collections.Generic; -using System.Web.Http.Results; - -namespace PollutometerWebApi.Controllers.Tests -{ - [TestClass()] - public class ReadingsControllerTests - { - ReadingsController controller = new ReadingsController(); - - [TestMethod()] - public void GetAllReadingsTest() - { - var actionResult = controller.GetAllReadings(); - var content = ((OkNegotiatedContentResult>)actionResult).Content; - Assert.IsTrue(content.Count >= 1); - } - - - [TestMethod()] - public void GetReadingTest() - { - var actionResult = controller.GetReading(0); - Assert.IsInstanceOfType(actionResult, typeof(OkNegotiatedContentResult)); - } - - [TestMethod()] - public void GetLatestReadingTest() - { - var actionResult = controller.GetLatestReading(); - var content = ((OkNegotiatedContentResult)actionResult).Content; - Assert.IsNotNull(content); - } - - [TestMethod()] - public void GetReadingsFromLastWeekTest() - { - var actionResult = controller.GetReadingsFromLastWeek(); - var content = ((OkNegotiatedContentResult>)actionResult).Content; - foreach(var reading in content) - { - var now = DateTimeOffset.Now.ToUnixTimeSeconds(); - Assert.IsTrue(reading.TimeStamp < now && reading.TimeStamp > now - 7*24*3600); - } - } - - [TestMethod()] - public void PostReadingPassTest() - { - var newReading = new Reading - { - TimeStamp = (int)DateTimeOffset.Now.ToUnixTimeSeconds(), - Co = 1.0, - No = 1.0, - So = 1.0 - }; - var actionResult = controller.PostReading(newReading); - var reading = controller.GetLatestReading(); - var content = ((OkNegotiatedContentResult)reading).Content; - Assert.AreEqual(newReading.TimeStamp, content.TimeStamp); - } - - [TestMethod()] - public void PostReadingFailTest() - { - var actionResult = controller.PostReading(null); - Assert.IsInstanceOfType(actionResult, typeof(BadRequestResult)); - } - - [TestMethod()] - public void PutReadingPassTest() - { - var latest = controller.GetLatestReading(); - var content = ((OkNegotiatedContentResult)latest).Content; - var actionResult = controller.PutReading(content.Id, - new Reading - { - TimeStamp = (int)DateTimeOffset.Now.ToUnixTimeSeconds(), - Co = 2.0, - No = 2.0, - So = 2.0 - } - ); - Assert.AreEqual(typeof(OkResult), actionResult.GetType()); - } - - [TestMethod()] - public void PutReadingFailTest() - { - var latest = controller.GetLatestReading(); - var content = ((OkNegotiatedContentResult)latest).Content; - var actionResult = controller.PutReading(content.Id, null); - Assert.AreEqual(typeof(BadRequestResult), actionResult.GetType()); - } - - [TestMethod()] - public void DeleteReadingPassTest() - { - var latest = controller.GetLatestReading(); - var content = ((OkNegotiatedContentResult)latest).Content; - var actionResult = controller.DeleteReading(content.Id); - var reading = controller.GetReading(content.Id); - Assert.IsInstanceOfType(reading, typeof(NotFoundResult)); - } - - [TestMethod()] - public void DeleteReadingFailTest() - { - var actionResult = controller.DeleteReading(1337); - Assert.IsInstanceOfType(actionResult, typeof(NotFoundResult)); - } - } -} \ No newline at end of file diff --git a/PollutometerWebApi.Tests/SqlOperatorTests.cs b/PollutometerWebApi.Tests/SqlOperatorTests.cs deleted file mode 100644 index 2930679..0000000 --- a/PollutometerWebApi.Tests/SqlOperatorTests.cs +++ /dev/null @@ -1,68 +0,0 @@ -using Microsoft.VisualStudio.TestTools.UnitTesting; -using PollutometerWebApi.Models; -using System; - -namespace PollutometerWebApi.Tests -{ - [TestClass()] - public class SqlOperatorTests - { - [TestMethod()] - public void GetReadingsTest() - { - var readings = SqlOperator.GetReadings("SELECT * FROM Readings"); - Assert.IsTrue(readings.Count >= 1); - } - - [TestMethod()] - 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); - } - - [TestMethod()] - 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); - } - - [TestMethod()] - public void DeleteReadingTest() - { - var command = "SELECT * FROM Readings " + - "WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)"; - var latestReading = SqlOperator.GetReadings(command)[0]; - SqlOperator.DeleteReading(latestReading.Id); - var command2 = $"SELECT * FROM Readings WHERE Id={latestReading.Id}"; - var readings = SqlOperator.GetReadings(command2); - Assert.IsTrue(readings.Count == 0); - } - } -} \ No newline at end of file diff --git a/PollutometerWebApi.Tests/app.config b/PollutometerWebApi.Tests/app.config deleted file mode 100644 index 4429813..0000000 --- a/PollutometerWebApi.Tests/app.config +++ /dev/null @@ -1,11 +0,0 @@ - - - - - - - - - - - \ No newline at end of file diff --git a/PollutometerWebApi.Tests/packages.config b/PollutometerWebApi.Tests/packages.config deleted file mode 100644 index 7472064..0000000 --- a/PollutometerWebApi.Tests/packages.config +++ /dev/null @@ -1,10 +0,0 @@ - - - - - - - - - - \ No newline at end of file diff --git a/PollutometerWebApi.sln b/PollutometerWebApi.sln deleted file mode 100644 index b4180e0..0000000 --- a/PollutometerWebApi.sln +++ /dev/null @@ -1,30 +0,0 @@ -Microsoft Visual Studio Solution File, Format Version 12.00 -# Visual Studio 15 -VisualStudioVersion = 15.0.27004.2009 -MinimumVisualStudioVersion = 10.0.40219.1 -Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "PollutometerWebApi", "PollutometerWebApi\PollutometerWebApi.csproj", "{22C32F4C-0DEB-40EA-9D56-48942CBB2A07}" -EndProject -Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "PollutometerWebApi.Tests", "PollutometerWebApi.Tests\PollutometerWebApi.Tests.csproj", "{94A21C38-920E-42EF-8D48-B133D635EAFA}" -EndProject -Global - GlobalSection(SolutionConfigurationPlatforms) = preSolution - Debug|Any CPU = Debug|Any CPU - Release|Any CPU = Release|Any CPU - EndGlobalSection - GlobalSection(ProjectConfigurationPlatforms) = postSolution - {22C32F4C-0DEB-40EA-9D56-48942CBB2A07}.Debug|Any CPU.ActiveCfg = Debug|Any CPU - {22C32F4C-0DEB-40EA-9D56-48942CBB2A07}.Debug|Any CPU.Build.0 = Debug|Any CPU - {22C32F4C-0DEB-40EA-9D56-48942CBB2A07}.Release|Any CPU.ActiveCfg = Release|Any CPU - {22C32F4C-0DEB-40EA-9D56-48942CBB2A07}.Release|Any CPU.Build.0 = Release|Any CPU - {94A21C38-920E-42EF-8D48-B133D635EAFA}.Debug|Any CPU.ActiveCfg = Debug|Any CPU - {94A21C38-920E-42EF-8D48-B133D635EAFA}.Debug|Any CPU.Build.0 = Debug|Any CPU - {94A21C38-920E-42EF-8D48-B133D635EAFA}.Release|Any CPU.ActiveCfg = Release|Any CPU - {94A21C38-920E-42EF-8D48-B133D635EAFA}.Release|Any CPU.Build.0 = Release|Any CPU - EndGlobalSection - GlobalSection(SolutionProperties) = preSolution - HideSolutionNode = FALSE - EndGlobalSection - GlobalSection(ExtensibilityGlobals) = postSolution - SolutionGuid = {0EB49A9B-6175-4CB9-8202-5918BA7D2525} - EndGlobalSection -EndGlobal diff --git a/PollutometerWebApi.userprefs b/PollutometerWebApi.userprefs deleted file mode 100644 index 822fb73..0000000 --- a/PollutometerWebApi.userprefs +++ /dev/null @@ -1,21 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - \ No newline at end of file diff --git a/PollutometerWebApi/.gitignore b/PollutometerWebApi/.gitignore deleted file mode 100644 index 940794e..0000000 --- a/PollutometerWebApi/.gitignore +++ /dev/null @@ -1,288 +0,0 @@ -## Ignore Visual Studio temporary files, build results, and -## files generated by popular Visual Studio add-ons. -## -## Get latest from https://github.com/github/gitignore/blob/master/VisualStudio.gitignore - -# User-specific files -*.suo -*.user -*.userosscache -*.sln.docstates - -# User-specific files (MonoDevelop/Xamarin Studio) -*.userprefs - -# Build results -[Dd]ebug/ -[Dd]ebugPublic/ -[Rr]elease/ -[Rr]eleases/ -x64/ -x86/ -bld/ -[Bb]in/ -[Oo]bj/ -[Ll]og/ - -# Visual Studio 2015 cache/options directory -.vs/ -# Uncomment if you have tasks that create the project's static files in wwwroot -#wwwroot/ - -# MSTest test Results -[Tt]est[Rr]esult*/ -[Bb]uild[Ll]og.* - -# NUNIT -*.VisualState.xml -TestResult.xml - -# Build Results of an ATL Project -[Dd]ebugPS/ -[Rr]eleasePS/ -dlldata.c - -# .NET Core -project.lock.json -project.fragment.lock.json -artifacts/ -**/Properties/launchSettings.json - -*_i.c -*_p.c -*_i.h -*.ilk -*.meta -*.obj -*.pch -*.pdb -*.pgc -*.pgd -*.rsp -*.sbr -*.tlb -*.tli -*.tlh -*.tmp -*.tmp_proj -*.log -*.vspscc -*.vssscc -.builds -*.pidb -*.svclog -*.scc - -# Chutzpah Test files -_Chutzpah* - -# Visual C++ cache files -ipch/ -*.aps -*.ncb -*.opendb -*.opensdf -*.sdf -*.cachefile -*.VC.db -*.VC.VC.opendb - -# Visual Studio profiler -*.psess -*.vsp -*.vspx -*.sap - -# TFS 2012 Local Workspace -$tf/ - -# Guidance Automation Toolkit -*.gpState - -# ReSharper is a .NET coding add-in -_ReSharper*/ -*.[Rr]e[Ss]harper -*.DotSettings.user - -# JustCode is a .NET coding add-in -.JustCode - -# TeamCity is a build add-in -_TeamCity* - -# DotCover is a Code Coverage Tool -*.dotCover - -# Visual Studio code coverage results -*.coverage -*.coveragexml - -# NCrunch -_NCrunch_* -.*crunch*.local.xml -nCrunchTemp_* - -# MightyMoose -*.mm.* -AutoTest.Net/ - -# Web workbench (sass) -.sass-cache/ - -# Installshield output folder -[Ee]xpress/ - -# DocProject is a documentation generator add-in -DocProject/buildhelp/ -DocProject/Help/*.HxT -DocProject/Help/*.HxC -DocProject/Help/*.hhc -DocProject/Help/*.hhk -DocProject/Help/*.hhp -DocProject/Help/Html2 -DocProject/Help/html - -# Click-Once directory -publish/ - -# Publish Web Output -*.[Pp]ublish.xml -*.azurePubxml -# TODO: Comment the next line if you want to checkin your web deploy settings -# but database connection strings (with potential passwords) will be unencrypted -*.pubxml -*.publishproj - -# Microsoft Azure Web App publish settings. Comment the next line if you want to -# checkin your Azure Web App publish settings, but sensitive information contained -# in these scripts will be unencrypted -PublishScripts/ - -# NuGet Packages -*.nupkg -# The packages folder can be ignored because of Package Restore -**/packages/* -# except build/, which is used as an MSBuild target. -!**/packages/build/ -# Uncomment if necessary however generally it will be regenerated when needed -#!**/packages/repositories.config -# NuGet v3's project.json files produces more ignorable files -*.nuget.props -*.nuget.targets - -# Microsoft Azure Build Output -csx/ -*.build.csdef - -# Microsoft Azure Emulator -ecf/ -rcf/ - -# Windows Store app package directories and files -AppPackages/ -BundleArtifacts/ -Package.StoreAssociation.xml -_pkginfo.txt - -# Visual Studio cache files -# files ending in .cache can be ignored -*.[Cc]ache -# but keep track of directories ending in .cache -!*.[Cc]ache/ - -# Others -ClientBin/ -~$* -*~ -*.dbmdl -*.dbproj.schemaview -*.jfm -*.pfx -*.publishsettings -orleans.codegen.cs - -# Since there are multiple workflows, uncomment next line to ignore bower_components -# (https://github.com/github/gitignore/pull/1529#issuecomment-104372622) -#bower_components/ - -# RIA/Silverlight projects -Generated_Code/ - -# Backup & report files from converting an old project file -# to a newer Visual Studio version. Backup files are not needed, -# because we have git ;-) -_UpgradeReport_Files/ -Backup*/ -UpgradeLog*.XML -UpgradeLog*.htm - -# SQL Server files -*.mdf -*.ldf -*.ndf - -# Business Intelligence projects -*.rdl.data -*.bim.layout -*.bim_*.settings - -# Microsoft Fakes -FakesAssemblies/ - -# GhostDoc plugin setting file -*.GhostDoc.xml - -# Node.js Tools for Visual Studio -.ntvs_analysis.dat -node_modules/ - -# Typescript v1 declaration files -typings/ - -# Visual Studio 6 build log -*.plg - -# Visual Studio 6 workspace options file -*.opt - -# Visual Studio 6 auto-generated workspace file (contains which files were open etc.) -*.vbw - -# Visual Studio LightSwitch build output -**/*.HTMLClient/GeneratedArtifacts -**/*.DesktopClient/GeneratedArtifacts -**/*.DesktopClient/ModelManifest.xml -**/*.Server/GeneratedArtifacts -**/*.Server/ModelManifest.xml -_Pvt_Extensions - -# Paket dependency manager -.paket/paket.exe -paket-files/ - -# FAKE - F# Make -.fake/ - -# JetBrains Rider -.idea/ -*.sln.iml - -# CodeRush -.cr/ - -# Python Tools for Visual Studio (PTVS) -__pycache__/ -*.pyc - -# Cake - Uncomment if you are using it -# tools/** -# !tools/packages.config - -# Telerik's JustMock configuration file -*.jmconfig - -# BizTalk build output -*.btp.cs -*.btm.cs -*.odx.cs -*.xsd.cs diff --git a/PollutometerWebApi/App_Start/RouteConfig.cs b/PollutometerWebApi/App_Start/RouteConfig.cs deleted file mode 100644 index 7455a55..0000000 --- a/PollutometerWebApi/App_Start/RouteConfig.cs +++ /dev/null @@ -1,19 +0,0 @@ -using System.Web.Mvc; -using System.Web.Routing; - -namespace PollutometerWebApi -{ - public class RouteConfig - { - public static void RegisterRoutes(RouteCollection routes) - { - routes.IgnoreRoute("{resource}.axd/{*pathInfo}"); - - routes.MapRoute( - name: "Default", - url: "{controller}/{action}/{id}", - defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional } - ); - } - } -} diff --git a/PollutometerWebApi/App_Start/WebApiConfig.cs b/PollutometerWebApi/App_Start/WebApiConfig.cs deleted file mode 100644 index d3b2dca..0000000 --- a/PollutometerWebApi/App_Start/WebApiConfig.cs +++ /dev/null @@ -1,24 +0,0 @@ -using System.Net.Http.Formatting; -using System.Web.Http; - -namespace PollutometerWebApi -{ - public static class WebApiConfig - { - public static void Register(HttpConfiguration config) - { - // Web API configuration and services - config.Formatters.Clear(); - config.Formatters.Add(new JsonMediaTypeFormatter()); - - // Web API routes - config.MapHttpAttributeRoutes(); - - config.Routes.MapHttpRoute( - name: "DefaultApi", - routeTemplate: "api/{controller}/{id}", - defaults: new { id = RouteParameter.Optional } - ); - } - } -} diff --git a/PollutometerWebApi/AqiCalculator.cs b/PollutometerWebApi/AqiCalculator.cs deleted file mode 100644 index 58f6194..0000000 --- a/PollutometerWebApi/AqiCalculator.cs +++ /dev/null @@ -1,102 +0,0 @@ -using PollutometerWebApi.Models; - -namespace PollutometerWebApi -{ - public static class AqiCalculator - { - public static Aqi CalculateAqi(Reading reading) - { - double[,,] breakpoints = - { - { - {0, 4.4}, - {4.5, 9.4}, - {9.5, 12.4}, - {12.5, 15.4}, - {15.5, 30.4}, - {30.5, 40.4}, - {40.5, 50.4} - }, - { - {0.000, 0.034}, - {0.035, 0.144}, - {0.145, 0.224}, - {0.225, 0.304}, - {0.305, 0.604}, - {0.605, 0.804}, - {0.805, 1.004} - }, - { - {0, 0.05}, - {0.08, 0.10}, - {0.15, 0.20}, - {0.25, 0.31}, - {0.65, 1.24}, - {1.25, 1.64}, - {1.65, 2.04} - }, - { - {0, 50}, - {51, 100}, - {101, 150}, - {151, 200}, - {201, 300}, - {301, 400}, - {401, 500} - } - }; - - double i, c = 0, cLow = 0, cHigh = 0, iLow = 0, iHigh = 0; - Aqi aqi = new Aqi(); - - for (int x = 0; x < 4; x++) - { - switch (x) - { - case 0: - c = reading.Co; - break; - case 1: - c = reading.So; - break; - case 2: - c = reading.No; - break; - } - - for (int y = 0; y < 7; y++) - { - if (c >= breakpoints[x, y, 0] && c <= breakpoints[x, y, 1]) - { - cLow = breakpoints[x, y, 0]; - cHigh = breakpoints[x, y, 1]; - iLow = breakpoints[3, y, 0]; - iHigh = breakpoints[3, y, 1]; - break; - } - } - - i = (iHigh - iLow) / (cHigh - cLow) * (c - cLow) + iLow; - - if (i > aqi.Value) - { - aqi.Value = i; - switch (x) - { - case 0: - aqi.GasName = "CO"; - break; - case 1: - aqi.GasName = "SO"; - break; - case 2: - aqi.GasName = "NO"; - break; - } - } - } - - return aqi; - } - } -} diff --git a/PollutometerWebApi/Controllers/HomeController.cs b/PollutometerWebApi/Controllers/HomeController.cs deleted file mode 100644 index 69e4846..0000000 --- a/PollutometerWebApi/Controllers/HomeController.cs +++ /dev/null @@ -1,19 +0,0 @@ -using System; -using System.Web.Mvc; - -namespace PollutometerWebApi.Controllers -{ - public class HomeController : Controller - { - public ActionResult Index() - { - var mvcName = typeof(Controller).Assembly.GetName(); - var isMono = Type.GetType("Mono.Runtime") != null; - - ViewData["Version"] = mvcName.Version.Major + "." + mvcName.Version.Minor; - ViewData["Runtime"] = isMono ? "Mono" : ".NET"; - - return View(); - } - } -} 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 diff --git a/PollutometerWebApi/EmailSender.cs b/PollutometerWebApi/EmailSender.cs deleted file mode 100644 index 6cc60fc..0000000 --- a/PollutometerWebApi/EmailSender.cs +++ /dev/null @@ -1,34 +0,0 @@ -using System; -using System.Net.Mail; -using PollutometerWebApi.Models; - -namespace PollutometerWebApi -{ - public static class EmailSender - { - public static void SendEmail(Aqi aqi) - { - MailMessage mail = new MailMessage("***REMOVED***", "alek2026@edu.easj.dk"); - SmtpClient client = new SmtpClient() - { - Host = "mail.cock.li", - Port = 587, - EnableSsl = true, - Timeout = 100, - DeliveryMethod = SmtpDeliveryMethod.Network, - UseDefaultCredentials = false, - Credentials = new System.Net.NetworkCredential("***REMOVED***", "***REMOVED***") - }; - mail.Subject = $"Pollutometer warning - {DateTime.Now}"; - mail.IsBodyHtml = true; - mail.Body = "

WARNING!

\n" + - "\n" + - "\n" + - "\n" + - $"

The warning was triggered by {aqi.GasName}.

\n" + - $"

Air quality index: {aqi.Value}

" + - $"

The AQI level is {aqi.Level}!"; - client.Send(mail); - } - } -} \ No newline at end of file diff --git a/PollutometerWebApi/Global.asax b/PollutometerWebApi/Global.asax deleted file mode 100644 index ee57536..0000000 --- a/PollutometerWebApi/Global.asax +++ /dev/null @@ -1 +0,0 @@ -<%@ Application Inherits="PollutometerWebApi.Global" %> diff --git a/PollutometerWebApi/Global.asax.cs b/PollutometerWebApi/Global.asax.cs deleted file mode 100644 index 3a03cf6..0000000 --- a/PollutometerWebApi/Global.asax.cs +++ /dev/null @@ -1,17 +0,0 @@ -using System.Web; -using System.Web.Mvc; -using System.Web.Routing; -using System.Web.Http; - -namespace PollutometerWebApi -{ - public class Global : HttpApplication - { - protected void Application_Start() - { - AreaRegistration.RegisterAllAreas(); - GlobalConfiguration.Configure(WebApiConfig.Register); - RouteConfig.RegisterRoutes(RouteTable.Routes); - } - } -} diff --git a/PollutometerWebApi/Models/Aqi.cs b/PollutometerWebApi/Models/Aqi.cs deleted file mode 100644 index b13ddb0..0000000 --- a/PollutometerWebApi/Models/Aqi.cs +++ /dev/null @@ -1,34 +0,0 @@ -namespace PollutometerWebApi.Models -{ - public class Aqi - { - double _value; - - public string GasName { get; set; } - public double Value - { - get - { - return _value; - } - set - { - _value = value; - - if (_value >= 0 && _value <= 50) - Level = "Good"; - else if (_value >= 51 && _value <= 100) - Level = "Moderate"; - else if (_value >= 101 && _value <= 150) - Level = "Unhealthy for Sensitive Groups"; - else if (_value >= 151 && _value <= 200) - Level = "Unhealthy"; - else if (_value >= 201 && _value <= 300) - Level = "Very Unhealthy"; - else if (_value >= 301 && _value <= 500) - Level = "Hazardous"; - } - } - public string Level { get; set; } - } -} diff --git a/PollutometerWebApi/Models/Reading.cs b/PollutometerWebApi/Models/Reading.cs deleted file mode 100644 index 18b2326..0000000 --- a/PollutometerWebApi/Models/Reading.cs +++ /dev/null @@ -1,11 +0,0 @@ -namespace PollutometerWebApi.Models -{ - public class Reading - { - public int Id { get; set; } - public int TimeStamp { get; set; } - public double Co { get; set; } - public double No { get; set; } - public double So { get; set; } - } -} diff --git a/PollutometerWebApi/PollutometerWebApi.csproj b/PollutometerWebApi/PollutometerWebApi.csproj deleted file mode 100644 index 6e5eb45..0000000 --- a/PollutometerWebApi/PollutometerWebApi.csproj +++ /dev/null @@ -1,151 +0,0 @@ - - - - - Debug - AnyCPU - {22C32F4C-0DEB-40EA-9D56-48942CBB2A07} - {349C5851-65DF-11DA-9384-00065B846F21};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC} - Library - PollutometerWebApi - PollutometerWebApi - v4.6.2 - - - - - 4.0 - true - - - - - - - - - true - full - false - bin - DEBUG; - prompt - 4 - - - true - bin - prompt - 4 - - - - - - - - - - - - - - - - ..\packages\Microsoft.AspNet.Razor.3.2.3\lib\net45\System.Web.Razor.dll - - - ..\packages\Microsoft.Web.Infrastructure.1.0.0.0\lib\net40\Microsoft.Web.Infrastructure.dll - - - ..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.Helpers.dll - - - ..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.WebPages.Deployment.dll - - - ..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.WebPages.dll - - - ..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.WebPages.Razor.dll - - - ..\packages\Microsoft.AspNet.Mvc.5.2.3\lib\net45\System.Web.Mvc.dll - - - - - ..\packages\Microsoft.AspNet.WebApi.Client.5.2.0\lib\net45\System.Net.Http.Formatting.dll - - - ..\packages\Microsoft.AspNet.WebApi.Core.5.2.0\lib\net45\System.Web.Http.dll - - - ..\packages\Microsoft.AspNet.WebApi.WebHost.5.2.0\lib\net45\System.Web.Http.WebHost.dll - - - ..\packages\Newtonsoft.Json.6.0.4\lib\net45\Newtonsoft.Json.dll - - - - - - - - - - Global.asax - - - - - - - - - - - - - Designer - - - - - - - - - - - 10.0 - $(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion) - - - - - - - - - - - - - - - True - True - 0 - / - http://localhost:50114/ - False - False - - - False - - - - - \ No newline at end of file diff --git a/PollutometerWebApi/SqlOperator.cs b/PollutometerWebApi/SqlOperator.cs deleted file mode 100644 index 1e296a1..0000000 --- a/PollutometerWebApi/SqlOperator.cs +++ /dev/null @@ -1,83 +0,0 @@ -using System.Collections.Generic; -using System.Data.SqlClient; -using PollutometerWebApi.Models; - -namespace PollutometerWebApi -{ - public static class SqlOperator - { - const string ConnectionString = - "Server=tcp:forschool.database.windows.net,1433;" + - "Initial Catalog=schooldb;" + - "Persist Security Info=False;" + - "User ID=***REMOVED***;" + - "Password=***REMOVED***;" + - "MultipleActiveResultSets=False;" + - "Encrypt=True;" + - "TrustServerCertificate=False;" + - "Connection Timeout=30;"; - - public static List GetReadings(string command) - { - var readings = new List(); - - using (SqlConnection databaseConnection = new SqlConnection(ConnectionString)) - { - databaseConnection.Open(); - SqlCommand selectCommand = new SqlCommand(command, databaseConnection); - var reader = selectCommand.ExecuteReader(); - while (reader.Read()) - { - readings.Add(new Reading - { - Id = reader.GetInt32(0), - TimeStamp = reader.GetInt32(1), - Co = reader.GetDouble(2), - No = reader.GetDouble(3), - So = reader.GetDouble(4) - }); - } - } - - return readings; - } - - public static void PutReading(int id, Reading reading) - { - using (SqlConnection dbCon = new SqlConnection(ConnectionString)) - { - dbCon.Open(); - string query = $"UPDATE Readings SET TimeStamp='{reading.TimeStamp}'," + - $"Co='{reading.Co}', No='{reading.No}', So='{reading.So}' WHERE Id={id};"; - var cmd = new SqlCommand(query, dbCon); - cmd.ExecuteNonQuery(); - dbCon.Close(); - } - } - - public static void PostReading(Reading reading) - { - using (SqlConnection dbCon = new SqlConnection(ConnectionString)) - { - dbCon.Open(); - string query = $"INSERT INTO Readings (TimeStamp,Co,No,So)" + - $"VALUES('{reading.TimeStamp}',{reading.Co},{reading.No},{reading.So});"; - var cmd = new SqlCommand(query, dbCon); - cmd.ExecuteNonQuery(); - dbCon.Close(); - } - } - - public static void DeleteReading(int id) - { - using (SqlConnection dbCon = new SqlConnection(ConnectionString)) - { - dbCon.Open(); - string query = $"DELETE FROM Readings WHERE Id={id};"; - var cmd = new SqlCommand(query, dbCon); - cmd.ExecuteNonQuery(); - dbCon.Close(); - } - } - } -} \ No newline at end of file diff --git a/PollutometerWebApi/Views/Home/Index.cshtml b/PollutometerWebApi/Views/Home/Index.cshtml deleted file mode 100644 index 2501eee..0000000 --- a/PollutometerWebApi/Views/Home/Index.cshtml +++ /dev/null @@ -1 +0,0 @@ -

Welcome to ASP.NET MVC @ViewData["Version"] on @ViewData["Runtime"]!

diff --git a/PollutometerWebApi/Views/Shared/Error.cshtml b/PollutometerWebApi/Views/Shared/Error.cshtml deleted file mode 100644 index 20ec06a..0000000 --- a/PollutometerWebApi/Views/Shared/Error.cshtml +++ /dev/null @@ -1,5 +0,0 @@ -@model System.Web.Mvc.HandleErrorInfo - -
-

An error occurred while processing your request.

-
diff --git a/PollutometerWebApi/Views/Shared/_Layout.cshtml b/PollutometerWebApi/Views/Shared/_Layout.cshtml deleted file mode 100644 index 54f6729..0000000 --- a/PollutometerWebApi/Views/Shared/_Layout.cshtml +++ /dev/null @@ -1,9 +0,0 @@ - - - - @ViewBag.Title - - - @RenderBody() - - diff --git a/PollutometerWebApi/Views/Web.config b/PollutometerWebApi/Views/Web.config deleted file mode 100644 index 35da8d0..0000000 --- a/PollutometerWebApi/Views/Web.config +++ /dev/null @@ -1,30 +0,0 @@ - - - - -
-
- - - - - - - - - - - - - - - - - - - - - - - - diff --git a/PollutometerWebApi/Views/_ViewStart.cshtml b/PollutometerWebApi/Views/_ViewStart.cshtml deleted file mode 100644 index 2de6241..0000000 --- a/PollutometerWebApi/Views/_ViewStart.cshtml +++ /dev/null @@ -1,3 +0,0 @@ -@{ - Layout = "~/Views/Shared/_Layout.cshtml"; -} diff --git a/PollutometerWebApi/Web.config b/PollutometerWebApi/Web.config deleted file mode 100644 index 77dd8b3..0000000 --- a/PollutometerWebApi/Web.config +++ /dev/null @@ -1,25 +0,0 @@ - - - - - - - - - - - - - - - - - - - \ No newline at end of file diff --git a/PollutometerWebApi/packages.config b/PollutometerWebApi/packages.config deleted file mode 100644 index 8631ca7..0000000 --- a/PollutometerWebApi/packages.config +++ /dev/null @@ -1,12 +0,0 @@ - - - - - - - - - - - - \ No newline at end of file diff --git a/README.md b/README.md index 3bd9044..e1eea6d 100644 --- a/README.md +++ b/README.md @@ -1 +1 @@ -# PollutometerWebApi +# Pollutometer diff --git a/pollutometer-api/PollutometerWebApi.Tests/AqiCalculatorTests.cs b/pollutometer-api/PollutometerWebApi.Tests/AqiCalculatorTests.cs new file mode 100644 index 0000000..e84b687 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.Tests/AqiCalculatorTests.cs @@ -0,0 +1,51 @@ +using Microsoft.VisualStudio.TestTools.UnitTesting; +using PollutometerWebApi.Models; + +namespace PollutometerWebApi.Tests +{ + [TestClass()] + public class AqiCalculatorTests + { + [TestMethod()] + public void CalculateAqiPerfectTest() + { + var reading = new Reading + { + Co = 2.2, + No = 0.1, + So = 0.8 + }; + + var result = AqiCalculator.CalculateAqi(reading); + Assert.AreEqual(398.0100502512563, result.Value); + } + + [TestMethod()] + public void CalculateAqiBigNumbersTest() + { + var reading = new Reading + { + Co = 100.2, + No = 100.1, + So = 100.8 + }; + + var result = AqiCalculator.CalculateAqi(reading); + Assert.AreEqual(0, result.Value); + } + + [TestMethod()] + public void CalculateAqiZerosTest() + { + var reading = new Reading + { + Co = 0, + No = 0, + So = 0 + }; + + var result = AqiCalculator.CalculateAqi(reading); + Assert.AreEqual(0, result.Value); + } + } +} \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi.Tests/EmailSenderTests.cs b/pollutometer-api/PollutometerWebApi.Tests/EmailSenderTests.cs new file mode 100644 index 0000000..427ec92 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.Tests/EmailSenderTests.cs @@ -0,0 +1,21 @@ +using Microsoft.VisualStudio.TestTools.UnitTesting; +using PollutometerWebApi.Models; + +namespace PollutometerWebApi.Tests +{ + [TestClass()] + public class EmailSenderTests + { + [TestMethod()] + public void SendEmailTest() + { + var aqi = new Aqi + { + GasName = "SO", + Value = 69, + Level = "Moderate" + }; + EmailSender.SendEmail(aqi); + } + } +} \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi.Tests/PollutometerWebApi.Tests.csproj b/pollutometer-api/PollutometerWebApi.Tests/PollutometerWebApi.Tests.csproj new file mode 100644 index 0000000..6ff37aa --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.Tests/PollutometerWebApi.Tests.csproj @@ -0,0 +1,125 @@ + + + + + Debug + AnyCPU + {94A21C38-920E-42EF-8D48-B133D635EAFA} + Library + Properties + PollutometerWebApi.Tests + PollutometerWebApi.Tests + v4.6.2 + 512 + {3AC096D0-A1C2-E12C-1390-A8335801FDAB};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC} + 10.0 + $(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion) + $(ProgramFiles)\Common Files\microsoft shared\VSTT\$(VisualStudioVersion)\UITestExtensionPackages + False + UnitTest + + + + + + true + full + false + bin\Debug\ + DEBUG;TRACE + prompt + 4 + + + pdbonly + true + bin\Release\ + TRACE + prompt + 4 + + + + ..\packages\MSTest.TestFramework.1.1.18\lib\net45\Microsoft.VisualStudio.TestPlatform.TestFramework.dll + + + ..\packages\MSTest.TestFramework.1.1.18\lib\net45\Microsoft.VisualStudio.TestPlatform.TestFramework.Extensions.dll + + + ..\packages\Newtonsoft.Json.6.0.4\lib\net45\Newtonsoft.Json.dll + True + + + + + ..\packages\Microsoft.AspNet.WebApi.Client.5.2.0\lib\net45\System.Net.Http.Formatting.dll + + + + ..\packages\Microsoft.AspNet.WebApi.Core.5.2.0\lib\net45\System.Web.Http.dll + + + ..\packages\Microsoft.AspNet.WebApi.WebHost.5.2.0\lib\net45\System.Web.Http.WebHost.dll + + + + + + + + + + + + + + + + + + + + + + + + {22C32F4C-0DEB-40EA-9D56-48942CBB2A07} + PollutometerWebApi + + + + + + + False + + + False + + + False + + + False + + + + + + + + + This project references NuGet package(s) that are missing on this computer. Use NuGet Package Restore to download them. For more information, see http://go.microsoft.com/fwlink/?LinkID=322105. The missing file is {0}. + + + + + + + \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi.Tests/Properties/AssemblyInfo.cs b/pollutometer-api/PollutometerWebApi.Tests/Properties/AssemblyInfo.cs new file mode 100644 index 0000000..d6c3cc7 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.Tests/Properties/AssemblyInfo.cs @@ -0,0 +1,36 @@ +using System.Reflection; +using System.Runtime.CompilerServices; +using System.Runtime.InteropServices; + +// General Information about an assembly is controlled through the following +// set of attributes. Change these attribute values to modify the information +// associated with an assembly. +[assembly: AssemblyTitle("PollutometerWebApi.Tests")] +[assembly: AssemblyDescription("")] +[assembly: AssemblyConfiguration("")] +[assembly: AssemblyCompany("")] +[assembly: AssemblyProduct("PollutometerWebApi.Tests")] +[assembly: AssemblyCopyright("Copyright © 2017")] +[assembly: AssemblyTrademark("")] +[assembly: AssemblyCulture("")] + +// Setting ComVisible to false makes the types in this assembly not visible +// to COM components. If you need to access a type in this assembly from +// COM, set the ComVisible attribute to true on that type. +[assembly: ComVisible(false)] + +// The following GUID is for the ID of the typelib if this project is exposed to COM +[assembly: Guid("94a21c38-920e-42ef-8d48-b133d635eafa")] + +// Version information for an assembly consists of the following four values: +// +// Major Version +// Minor Version +// Build Number +// Revision +// +// You can specify all the values or you can default the Build and Revision Numbers +// by using the '*' as shown below: +// [assembly: AssemblyVersion("1.0.*")] +[assembly: AssemblyVersion("1.0.0.0")] +[assembly: AssemblyFileVersion("1.0.0.0")] diff --git a/pollutometer-api/PollutometerWebApi.Tests/ReadingsControllerTests.cs b/pollutometer-api/PollutometerWebApi.Tests/ReadingsControllerTests.cs new file mode 100644 index 0000000..647649d --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.Tests/ReadingsControllerTests.cs @@ -0,0 +1,116 @@ +using Microsoft.VisualStudio.TestTools.UnitTesting; +using PollutometerWebApi.Models; +using System; +using System.Collections.Generic; +using System.Web.Http.Results; + +namespace PollutometerWebApi.Controllers.Tests +{ + [TestClass()] + public class ReadingsControllerTests + { + ReadingsController controller = new ReadingsController(); + + [TestMethod()] + public void GetAllReadingsTest() + { + var actionResult = controller.GetAllReadings(); + var content = ((OkNegotiatedContentResult>)actionResult).Content; + Assert.IsTrue(content.Count >= 1); + } + + + [TestMethod()] + public void GetReadingTest() + { + var actionResult = controller.GetReading(0); + Assert.IsInstanceOfType(actionResult, typeof(OkNegotiatedContentResult)); + } + + [TestMethod()] + public void GetLatestReadingTest() + { + var actionResult = controller.GetLatestReading(); + var content = ((OkNegotiatedContentResult)actionResult).Content; + Assert.IsNotNull(content); + } + + [TestMethod()] + public void GetReadingsFromLastWeekTest() + { + var actionResult = controller.GetReadingsFromLastWeek(); + var content = ((OkNegotiatedContentResult>)actionResult).Content; + foreach(var reading in content) + { + var now = DateTimeOffset.Now.ToUnixTimeSeconds(); + Assert.IsTrue(reading.TimeStamp < now && reading.TimeStamp > now - 7*24*3600); + } + } + + [TestMethod()] + public void PostReadingPassTest() + { + var newReading = new Reading + { + TimeStamp = (int)DateTimeOffset.Now.ToUnixTimeSeconds(), + Co = 1.0, + No = 1.0, + So = 1.0 + }; + var actionResult = controller.PostReading(newReading); + var reading = controller.GetLatestReading(); + var content = ((OkNegotiatedContentResult)reading).Content; + Assert.AreEqual(newReading.TimeStamp, content.TimeStamp); + } + + [TestMethod()] + public void PostReadingFailTest() + { + var actionResult = controller.PostReading(null); + Assert.IsInstanceOfType(actionResult, typeof(BadRequestResult)); + } + + [TestMethod()] + public void PutReadingPassTest() + { + var latest = controller.GetLatestReading(); + var content = ((OkNegotiatedContentResult)latest).Content; + var actionResult = controller.PutReading(content.Id, + new Reading + { + TimeStamp = (int)DateTimeOffset.Now.ToUnixTimeSeconds(), + Co = 2.0, + No = 2.0, + So = 2.0 + } + ); + Assert.AreEqual(typeof(OkResult), actionResult.GetType()); + } + + [TestMethod()] + public void PutReadingFailTest() + { + var latest = controller.GetLatestReading(); + var content = ((OkNegotiatedContentResult)latest).Content; + var actionResult = controller.PutReading(content.Id, null); + Assert.AreEqual(typeof(BadRequestResult), actionResult.GetType()); + } + + [TestMethod()] + public void DeleteReadingPassTest() + { + var latest = controller.GetLatestReading(); + var content = ((OkNegotiatedContentResult)latest).Content; + var actionResult = controller.DeleteReading(content.Id); + var reading = controller.GetReading(content.Id); + Assert.IsInstanceOfType(reading, typeof(NotFoundResult)); + } + + [TestMethod()] + public void DeleteReadingFailTest() + { + var actionResult = controller.DeleteReading(1337); + Assert.IsInstanceOfType(actionResult, typeof(NotFoundResult)); + } + } +} \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi.Tests/SqlOperatorTests.cs b/pollutometer-api/PollutometerWebApi.Tests/SqlOperatorTests.cs new file mode 100644 index 0000000..2930679 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.Tests/SqlOperatorTests.cs @@ -0,0 +1,68 @@ +using Microsoft.VisualStudio.TestTools.UnitTesting; +using PollutometerWebApi.Models; +using System; + +namespace PollutometerWebApi.Tests +{ + [TestClass()] + public class SqlOperatorTests + { + [TestMethod()] + public void GetReadingsTest() + { + var readings = SqlOperator.GetReadings("SELECT * FROM Readings"); + Assert.IsTrue(readings.Count >= 1); + } + + [TestMethod()] + 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); + } + + [TestMethod()] + 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); + } + + [TestMethod()] + public void DeleteReadingTest() + { + var command = "SELECT * FROM Readings " + + "WHERE TimeStamp IN(SELECT MAX(TimeStamp) FROM Readings)"; + var latestReading = SqlOperator.GetReadings(command)[0]; + SqlOperator.DeleteReading(latestReading.Id); + var command2 = $"SELECT * FROM Readings WHERE Id={latestReading.Id}"; + var readings = SqlOperator.GetReadings(command2); + Assert.IsTrue(readings.Count == 0); + } + } +} \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi.Tests/app.config b/pollutometer-api/PollutometerWebApi.Tests/app.config new file mode 100644 index 0000000..4429813 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.Tests/app.config @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi.Tests/packages.config b/pollutometer-api/PollutometerWebApi.Tests/packages.config new file mode 100644 index 0000000..7472064 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.Tests/packages.config @@ -0,0 +1,10 @@ + + + + + + + + + + \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi.sln b/pollutometer-api/PollutometerWebApi.sln new file mode 100644 index 0000000..b4180e0 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.sln @@ -0,0 +1,30 @@ +Microsoft Visual Studio Solution File, Format Version 12.00 +# Visual Studio 15 +VisualStudioVersion = 15.0.27004.2009 +MinimumVisualStudioVersion = 10.0.40219.1 +Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "PollutometerWebApi", "PollutometerWebApi\PollutometerWebApi.csproj", "{22C32F4C-0DEB-40EA-9D56-48942CBB2A07}" +EndProject +Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "PollutometerWebApi.Tests", "PollutometerWebApi.Tests\PollutometerWebApi.Tests.csproj", "{94A21C38-920E-42EF-8D48-B133D635EAFA}" +EndProject +Global + GlobalSection(SolutionConfigurationPlatforms) = preSolution + Debug|Any CPU = Debug|Any CPU + Release|Any CPU = Release|Any CPU + EndGlobalSection + GlobalSection(ProjectConfigurationPlatforms) = postSolution + {22C32F4C-0DEB-40EA-9D56-48942CBB2A07}.Debug|Any CPU.ActiveCfg = Debug|Any CPU + {22C32F4C-0DEB-40EA-9D56-48942CBB2A07}.Debug|Any CPU.Build.0 = Debug|Any CPU + {22C32F4C-0DEB-40EA-9D56-48942CBB2A07}.Release|Any CPU.ActiveCfg = Release|Any CPU + {22C32F4C-0DEB-40EA-9D56-48942CBB2A07}.Release|Any CPU.Build.0 = Release|Any CPU + {94A21C38-920E-42EF-8D48-B133D635EAFA}.Debug|Any CPU.ActiveCfg = Debug|Any CPU + {94A21C38-920E-42EF-8D48-B133D635EAFA}.Debug|Any CPU.Build.0 = Debug|Any CPU + {94A21C38-920E-42EF-8D48-B133D635EAFA}.Release|Any CPU.ActiveCfg = Release|Any CPU + {94A21C38-920E-42EF-8D48-B133D635EAFA}.Release|Any CPU.Build.0 = Release|Any CPU + EndGlobalSection + GlobalSection(SolutionProperties) = preSolution + HideSolutionNode = FALSE + EndGlobalSection + GlobalSection(ExtensibilityGlobals) = postSolution + SolutionGuid = {0EB49A9B-6175-4CB9-8202-5918BA7D2525} + EndGlobalSection +EndGlobal diff --git a/pollutometer-api/PollutometerWebApi.userprefs b/pollutometer-api/PollutometerWebApi.userprefs new file mode 100644 index 0000000..822fb73 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi.userprefs @@ -0,0 +1,21 @@ + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi/.gitignore b/pollutometer-api/PollutometerWebApi/.gitignore new file mode 100644 index 0000000..940794e --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/.gitignore @@ -0,0 +1,288 @@ +## Ignore Visual Studio temporary files, build results, and +## files generated by popular Visual Studio add-ons. +## +## Get latest from https://github.com/github/gitignore/blob/master/VisualStudio.gitignore + +# User-specific files +*.suo +*.user +*.userosscache +*.sln.docstates + +# User-specific files (MonoDevelop/Xamarin Studio) +*.userprefs + +# Build results +[Dd]ebug/ +[Dd]ebugPublic/ +[Rr]elease/ +[Rr]eleases/ +x64/ +x86/ +bld/ +[Bb]in/ +[Oo]bj/ +[Ll]og/ + +# Visual Studio 2015 cache/options directory +.vs/ +# Uncomment if you have tasks that create the project's static files in wwwroot +#wwwroot/ + +# MSTest test Results +[Tt]est[Rr]esult*/ +[Bb]uild[Ll]og.* + +# NUNIT +*.VisualState.xml +TestResult.xml + +# Build Results of an ATL Project +[Dd]ebugPS/ +[Rr]eleasePS/ +dlldata.c + +# .NET Core +project.lock.json +project.fragment.lock.json +artifacts/ +**/Properties/launchSettings.json + +*_i.c +*_p.c +*_i.h +*.ilk +*.meta +*.obj +*.pch +*.pdb +*.pgc +*.pgd +*.rsp +*.sbr +*.tlb +*.tli +*.tlh +*.tmp +*.tmp_proj +*.log +*.vspscc +*.vssscc +.builds +*.pidb +*.svclog +*.scc + +# Chutzpah Test files +_Chutzpah* + +# Visual C++ cache files +ipch/ +*.aps +*.ncb +*.opendb +*.opensdf +*.sdf +*.cachefile +*.VC.db +*.VC.VC.opendb + +# Visual Studio profiler +*.psess +*.vsp +*.vspx +*.sap + +# TFS 2012 Local Workspace +$tf/ + +# Guidance Automation Toolkit +*.gpState + +# ReSharper is a .NET coding add-in +_ReSharper*/ +*.[Rr]e[Ss]harper +*.DotSettings.user + +# JustCode is a .NET coding add-in +.JustCode + +# TeamCity is a build add-in +_TeamCity* + +# DotCover is a Code Coverage Tool +*.dotCover + +# Visual Studio code coverage results +*.coverage +*.coveragexml + +# NCrunch +_NCrunch_* +.*crunch*.local.xml +nCrunchTemp_* + +# MightyMoose +*.mm.* +AutoTest.Net/ + +# Web workbench (sass) +.sass-cache/ + +# Installshield output folder +[Ee]xpress/ + +# DocProject is a documentation generator add-in +DocProject/buildhelp/ +DocProject/Help/*.HxT +DocProject/Help/*.HxC +DocProject/Help/*.hhc +DocProject/Help/*.hhk +DocProject/Help/*.hhp +DocProject/Help/Html2 +DocProject/Help/html + +# Click-Once directory +publish/ + +# Publish Web Output +*.[Pp]ublish.xml +*.azurePubxml +# TODO: Comment the next line if you want to checkin your web deploy settings +# but database connection strings (with potential passwords) will be unencrypted +*.pubxml +*.publishproj + +# Microsoft Azure Web App publish settings. Comment the next line if you want to +# checkin your Azure Web App publish settings, but sensitive information contained +# in these scripts will be unencrypted +PublishScripts/ + +# NuGet Packages +*.nupkg +# The packages folder can be ignored because of Package Restore +**/packages/* +# except build/, which is used as an MSBuild target. +!**/packages/build/ +# Uncomment if necessary however generally it will be regenerated when needed +#!**/packages/repositories.config +# NuGet v3's project.json files produces more ignorable files +*.nuget.props +*.nuget.targets + +# Microsoft Azure Build Output +csx/ +*.build.csdef + +# Microsoft Azure Emulator +ecf/ +rcf/ + +# Windows Store app package directories and files +AppPackages/ +BundleArtifacts/ +Package.StoreAssociation.xml +_pkginfo.txt + +# Visual Studio cache files +# files ending in .cache can be ignored +*.[Cc]ache +# but keep track of directories ending in .cache +!*.[Cc]ache/ + +# Others +ClientBin/ +~$* +*~ +*.dbmdl +*.dbproj.schemaview +*.jfm +*.pfx +*.publishsettings +orleans.codegen.cs + +# Since there are multiple workflows, uncomment next line to ignore bower_components +# (https://github.com/github/gitignore/pull/1529#issuecomment-104372622) +#bower_components/ + +# RIA/Silverlight projects +Generated_Code/ + +# Backup & report files from converting an old project file +# to a newer Visual Studio version. Backup files are not needed, +# because we have git ;-) +_UpgradeReport_Files/ +Backup*/ +UpgradeLog*.XML +UpgradeLog*.htm + +# SQL Server files +*.mdf +*.ldf +*.ndf + +# Business Intelligence projects +*.rdl.data +*.bim.layout +*.bim_*.settings + +# Microsoft Fakes +FakesAssemblies/ + +# GhostDoc plugin setting file +*.GhostDoc.xml + +# Node.js Tools for Visual Studio +.ntvs_analysis.dat +node_modules/ + +# Typescript v1 declaration files +typings/ + +# Visual Studio 6 build log +*.plg + +# Visual Studio 6 workspace options file +*.opt + +# Visual Studio 6 auto-generated workspace file (contains which files were open etc.) +*.vbw + +# Visual Studio LightSwitch build output +**/*.HTMLClient/GeneratedArtifacts +**/*.DesktopClient/GeneratedArtifacts +**/*.DesktopClient/ModelManifest.xml +**/*.Server/GeneratedArtifacts +**/*.Server/ModelManifest.xml +_Pvt_Extensions + +# Paket dependency manager +.paket/paket.exe +paket-files/ + +# FAKE - F# Make +.fake/ + +# JetBrains Rider +.idea/ +*.sln.iml + +# CodeRush +.cr/ + +# Python Tools for Visual Studio (PTVS) +__pycache__/ +*.pyc + +# Cake - Uncomment if you are using it +# tools/** +# !tools/packages.config + +# Telerik's JustMock configuration file +*.jmconfig + +# BizTalk build output +*.btp.cs +*.btm.cs +*.odx.cs +*.xsd.cs diff --git a/pollutometer-api/PollutometerWebApi/App_Start/RouteConfig.cs b/pollutometer-api/PollutometerWebApi/App_Start/RouteConfig.cs new file mode 100644 index 0000000..7455a55 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/App_Start/RouteConfig.cs @@ -0,0 +1,19 @@ +using System.Web.Mvc; +using System.Web.Routing; + +namespace PollutometerWebApi +{ + public class RouteConfig + { + public static void RegisterRoutes(RouteCollection routes) + { + routes.IgnoreRoute("{resource}.axd/{*pathInfo}"); + + routes.MapRoute( + name: "Default", + url: "{controller}/{action}/{id}", + defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional } + ); + } + } +} diff --git a/pollutometer-api/PollutometerWebApi/App_Start/WebApiConfig.cs b/pollutometer-api/PollutometerWebApi/App_Start/WebApiConfig.cs new file mode 100644 index 0000000..d3b2dca --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/App_Start/WebApiConfig.cs @@ -0,0 +1,24 @@ +using System.Net.Http.Formatting; +using System.Web.Http; + +namespace PollutometerWebApi +{ + public static class WebApiConfig + { + public static void Register(HttpConfiguration config) + { + // Web API configuration and services + config.Formatters.Clear(); + config.Formatters.Add(new JsonMediaTypeFormatter()); + + // Web API routes + config.MapHttpAttributeRoutes(); + + config.Routes.MapHttpRoute( + name: "DefaultApi", + routeTemplate: "api/{controller}/{id}", + defaults: new { id = RouteParameter.Optional } + ); + } + } +} diff --git a/pollutometer-api/PollutometerWebApi/AqiCalculator.cs b/pollutometer-api/PollutometerWebApi/AqiCalculator.cs new file mode 100644 index 0000000..58f6194 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/AqiCalculator.cs @@ -0,0 +1,102 @@ +using PollutometerWebApi.Models; + +namespace PollutometerWebApi +{ + public static class AqiCalculator + { + public static Aqi CalculateAqi(Reading reading) + { + double[,,] breakpoints = + { + { + {0, 4.4}, + {4.5, 9.4}, + {9.5, 12.4}, + {12.5, 15.4}, + {15.5, 30.4}, + {30.5, 40.4}, + {40.5, 50.4} + }, + { + {0.000, 0.034}, + {0.035, 0.144}, + {0.145, 0.224}, + {0.225, 0.304}, + {0.305, 0.604}, + {0.605, 0.804}, + {0.805, 1.004} + }, + { + {0, 0.05}, + {0.08, 0.10}, + {0.15, 0.20}, + {0.25, 0.31}, + {0.65, 1.24}, + {1.25, 1.64}, + {1.65, 2.04} + }, + { + {0, 50}, + {51, 100}, + {101, 150}, + {151, 200}, + {201, 300}, + {301, 400}, + {401, 500} + } + }; + + double i, c = 0, cLow = 0, cHigh = 0, iLow = 0, iHigh = 0; + Aqi aqi = new Aqi(); + + for (int x = 0; x < 4; x++) + { + switch (x) + { + case 0: + c = reading.Co; + break; + case 1: + c = reading.So; + break; + case 2: + c = reading.No; + break; + } + + for (int y = 0; y < 7; y++) + { + if (c >= breakpoints[x, y, 0] && c <= breakpoints[x, y, 1]) + { + cLow = breakpoints[x, y, 0]; + cHigh = breakpoints[x, y, 1]; + iLow = breakpoints[3, y, 0]; + iHigh = breakpoints[3, y, 1]; + break; + } + } + + i = (iHigh - iLow) / (cHigh - cLow) * (c - cLow) + iLow; + + if (i > aqi.Value) + { + aqi.Value = i; + switch (x) + { + case 0: + aqi.GasName = "CO"; + break; + case 1: + aqi.GasName = "SO"; + break; + case 2: + aqi.GasName = "NO"; + break; + } + } + } + + return aqi; + } + } +} diff --git a/pollutometer-api/PollutometerWebApi/Controllers/HomeController.cs b/pollutometer-api/PollutometerWebApi/Controllers/HomeController.cs new file mode 100644 index 0000000..69e4846 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Controllers/HomeController.cs @@ -0,0 +1,19 @@ +using System; +using System.Web.Mvc; + +namespace PollutometerWebApi.Controllers +{ + public class HomeController : Controller + { + public ActionResult Index() + { + var mvcName = typeof(Controller).Assembly.GetName(); + var isMono = Type.GetType("Mono.Runtime") != null; + + ViewData["Version"] = mvcName.Version.Major + "." + mvcName.Version.Minor; + ViewData["Runtime"] = isMono ? "Mono" : ".NET"; + + return View(); + } + } +} diff --git a/pollutometer-api/PollutometerWebApi/Controllers/ReadingsController.cs b/pollutometer-api/PollutometerWebApi/Controllers/ReadingsController.cs new file mode 100644 index 0000000..adf4d5d --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Controllers/ReadingsController.cs @@ -0,0 +1,85 @@ +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 diff --git a/pollutometer-api/PollutometerWebApi/EmailSender.cs b/pollutometer-api/PollutometerWebApi/EmailSender.cs new file mode 100644 index 0000000..266f146 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/EmailSender.cs @@ -0,0 +1,34 @@ +using System; +using System.Net.Mail; +using PollutometerWebApi.Models; + +namespace PollutometerWebApi +{ + public static class EmailSender + { + public static void SendEmail(Aqi aqi) + { + MailMessage mail = new MailMessage("***REMOVED***", ""); + SmtpClient client = new SmtpClient() + { + Host = "mail.cock.li", + Port = 587, + EnableSsl = true, + Timeout = 100, + DeliveryMethod = SmtpDeliveryMethod.Network, + UseDefaultCredentials = false, + Credentials = new System.Net.NetworkCredential("***REMOVED***", "***REMOVED***") + }; + mail.Subject = $"Pollutometer warning - {DateTime.Now}"; + mail.IsBodyHtml = true; + mail.Body = "

WARNING!

\n" + + "\n" + + "\n" + + "\n" + + $"

The warning was triggered by {aqi.GasName}.

\n" + + $"

Air quality index: {aqi.Value}

" + + $"

The AQI level is {aqi.Level}!"; + client.Send(mail); + } + } +} diff --git a/pollutometer-api/PollutometerWebApi/Global.asax b/pollutometer-api/PollutometerWebApi/Global.asax new file mode 100644 index 0000000..ee57536 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Global.asax @@ -0,0 +1 @@ +<%@ Application Inherits="PollutometerWebApi.Global" %> diff --git a/pollutometer-api/PollutometerWebApi/Global.asax.cs b/pollutometer-api/PollutometerWebApi/Global.asax.cs new file mode 100644 index 0000000..3a03cf6 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Global.asax.cs @@ -0,0 +1,17 @@ +using System.Web; +using System.Web.Mvc; +using System.Web.Routing; +using System.Web.Http; + +namespace PollutometerWebApi +{ + public class Global : HttpApplication + { + protected void Application_Start() + { + AreaRegistration.RegisterAllAreas(); + GlobalConfiguration.Configure(WebApiConfig.Register); + RouteConfig.RegisterRoutes(RouteTable.Routes); + } + } +} diff --git a/pollutometer-api/PollutometerWebApi/Models/Aqi.cs b/pollutometer-api/PollutometerWebApi/Models/Aqi.cs new file mode 100644 index 0000000..b13ddb0 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Models/Aqi.cs @@ -0,0 +1,34 @@ +namespace PollutometerWebApi.Models +{ + public class Aqi + { + double _value; + + public string GasName { get; set; } + public double Value + { + get + { + return _value; + } + set + { + _value = value; + + if (_value >= 0 && _value <= 50) + Level = "Good"; + else if (_value >= 51 && _value <= 100) + Level = "Moderate"; + else if (_value >= 101 && _value <= 150) + Level = "Unhealthy for Sensitive Groups"; + else if (_value >= 151 && _value <= 200) + Level = "Unhealthy"; + else if (_value >= 201 && _value <= 300) + Level = "Very Unhealthy"; + else if (_value >= 301 && _value <= 500) + Level = "Hazardous"; + } + } + public string Level { get; set; } + } +} diff --git a/pollutometer-api/PollutometerWebApi/Models/Reading.cs b/pollutometer-api/PollutometerWebApi/Models/Reading.cs new file mode 100644 index 0000000..18b2326 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Models/Reading.cs @@ -0,0 +1,11 @@ +namespace PollutometerWebApi.Models +{ + public class Reading + { + public int Id { get; set; } + public int TimeStamp { get; set; } + public double Co { get; set; } + public double No { get; set; } + public double So { get; set; } + } +} diff --git a/pollutometer-api/PollutometerWebApi/PollutometerWebApi.csproj b/pollutometer-api/PollutometerWebApi/PollutometerWebApi.csproj new file mode 100644 index 0000000..6e5eb45 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/PollutometerWebApi.csproj @@ -0,0 +1,151 @@ + + + + + Debug + AnyCPU + {22C32F4C-0DEB-40EA-9D56-48942CBB2A07} + {349C5851-65DF-11DA-9384-00065B846F21};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC} + Library + PollutometerWebApi + PollutometerWebApi + v4.6.2 + + + + + 4.0 + true + + + + + + + + + true + full + false + bin + DEBUG; + prompt + 4 + + + true + bin + prompt + 4 + + + + + + + + + + + + + + + + ..\packages\Microsoft.AspNet.Razor.3.2.3\lib\net45\System.Web.Razor.dll + + + ..\packages\Microsoft.Web.Infrastructure.1.0.0.0\lib\net40\Microsoft.Web.Infrastructure.dll + + + ..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.Helpers.dll + + + ..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.WebPages.Deployment.dll + + + ..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.WebPages.dll + + + ..\packages\Microsoft.AspNet.WebPages.3.2.3\lib\net45\System.Web.WebPages.Razor.dll + + + ..\packages\Microsoft.AspNet.Mvc.5.2.3\lib\net45\System.Web.Mvc.dll + + + + + ..\packages\Microsoft.AspNet.WebApi.Client.5.2.0\lib\net45\System.Net.Http.Formatting.dll + + + ..\packages\Microsoft.AspNet.WebApi.Core.5.2.0\lib\net45\System.Web.Http.dll + + + ..\packages\Microsoft.AspNet.WebApi.WebHost.5.2.0\lib\net45\System.Web.Http.WebHost.dll + + + ..\packages\Newtonsoft.Json.6.0.4\lib\net45\Newtonsoft.Json.dll + + + + + + + + + + Global.asax + + + + + + + + + + + + + Designer + + + + + + + + + + + 10.0 + $(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion) + + + + + + + + + + + + + + + True + True + 0 + / + http://localhost:50114/ + False + False + + + False + + + + + \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi/SqlOperator.cs b/pollutometer-api/PollutometerWebApi/SqlOperator.cs new file mode 100644 index 0000000..1e296a1 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/SqlOperator.cs @@ -0,0 +1,83 @@ +using System.Collections.Generic; +using System.Data.SqlClient; +using PollutometerWebApi.Models; + +namespace PollutometerWebApi +{ + public static class SqlOperator + { + const string ConnectionString = + "Server=tcp:forschool.database.windows.net,1433;" + + "Initial Catalog=schooldb;" + + "Persist Security Info=False;" + + "User ID=***REMOVED***;" + + "Password=***REMOVED***;" + + "MultipleActiveResultSets=False;" + + "Encrypt=True;" + + "TrustServerCertificate=False;" + + "Connection Timeout=30;"; + + public static List GetReadings(string command) + { + var readings = new List(); + + using (SqlConnection databaseConnection = new SqlConnection(ConnectionString)) + { + databaseConnection.Open(); + SqlCommand selectCommand = new SqlCommand(command, databaseConnection); + var reader = selectCommand.ExecuteReader(); + while (reader.Read()) + { + readings.Add(new Reading + { + Id = reader.GetInt32(0), + TimeStamp = reader.GetInt32(1), + Co = reader.GetDouble(2), + No = reader.GetDouble(3), + So = reader.GetDouble(4) + }); + } + } + + return readings; + } + + public static void PutReading(int id, Reading reading) + { + using (SqlConnection dbCon = new SqlConnection(ConnectionString)) + { + dbCon.Open(); + string query = $"UPDATE Readings SET TimeStamp='{reading.TimeStamp}'," + + $"Co='{reading.Co}', No='{reading.No}', So='{reading.So}' WHERE Id={id};"; + var cmd = new SqlCommand(query, dbCon); + cmd.ExecuteNonQuery(); + dbCon.Close(); + } + } + + public static void PostReading(Reading reading) + { + using (SqlConnection dbCon = new SqlConnection(ConnectionString)) + { + dbCon.Open(); + string query = $"INSERT INTO Readings (TimeStamp,Co,No,So)" + + $"VALUES('{reading.TimeStamp}',{reading.Co},{reading.No},{reading.So});"; + var cmd = new SqlCommand(query, dbCon); + cmd.ExecuteNonQuery(); + dbCon.Close(); + } + } + + public static void DeleteReading(int id) + { + using (SqlConnection dbCon = new SqlConnection(ConnectionString)) + { + dbCon.Open(); + string query = $"DELETE FROM Readings WHERE Id={id};"; + var cmd = new SqlCommand(query, dbCon); + cmd.ExecuteNonQuery(); + dbCon.Close(); + } + } + } +} \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi/Views/Home/Index.cshtml b/pollutometer-api/PollutometerWebApi/Views/Home/Index.cshtml new file mode 100644 index 0000000..2501eee --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Views/Home/Index.cshtml @@ -0,0 +1 @@ +

Welcome to ASP.NET MVC @ViewData["Version"] on @ViewData["Runtime"]!

diff --git a/pollutometer-api/PollutometerWebApi/Views/Shared/Error.cshtml b/pollutometer-api/PollutometerWebApi/Views/Shared/Error.cshtml new file mode 100644 index 0000000..20ec06a --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Views/Shared/Error.cshtml @@ -0,0 +1,5 @@ +@model System.Web.Mvc.HandleErrorInfo + +
+

An error occurred while processing your request.

+
diff --git a/pollutometer-api/PollutometerWebApi/Views/Shared/_Layout.cshtml b/pollutometer-api/PollutometerWebApi/Views/Shared/_Layout.cshtml new file mode 100644 index 0000000..54f6729 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Views/Shared/_Layout.cshtml @@ -0,0 +1,9 @@ + + + + @ViewBag.Title + + + @RenderBody() + + diff --git a/pollutometer-api/PollutometerWebApi/Views/Web.config b/pollutometer-api/PollutometerWebApi/Views/Web.config new file mode 100644 index 0000000..35da8d0 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Views/Web.config @@ -0,0 +1,30 @@ + + + + +
+
+ + + + + + + + + + + + + + + + + + + + + + + + diff --git a/pollutometer-api/PollutometerWebApi/Views/_ViewStart.cshtml b/pollutometer-api/PollutometerWebApi/Views/_ViewStart.cshtml new file mode 100644 index 0000000..2de6241 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Views/_ViewStart.cshtml @@ -0,0 +1,3 @@ +@{ + Layout = "~/Views/Shared/_Layout.cshtml"; +} diff --git a/pollutometer-api/PollutometerWebApi/Web.config b/pollutometer-api/PollutometerWebApi/Web.config new file mode 100644 index 0000000..77dd8b3 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/Web.config @@ -0,0 +1,25 @@ + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/pollutometer-api/PollutometerWebApi/packages.config b/pollutometer-api/PollutometerWebApi/packages.config new file mode 100644 index 0000000..8631ca7 --- /dev/null +++ b/pollutometer-api/PollutometerWebApi/packages.config @@ -0,0 +1,12 @@ + + + + + + + + + + + + \ No newline at end of file -- cgit v1.2.3