From 8f083ddb74fb74d6c2b5d347472aa26f18a4b15c Mon Sep 17 00:00:00 2001
From: marcinzelent <zelent.marcin@gmail.com>
Date: Thu, 23 Nov 2017 11:19:37 +0100
Subject: Rewrote almost everything, got rid of singleton.

---
 AirPollutionWebApi/Singletons/Singleton.cs | 99 ------------------------------
 1 file changed, 99 deletions(-)
 delete mode 100644 AirPollutionWebApi/Singletons/Singleton.cs

(limited to 'AirPollutionWebApi/Singletons')

diff --git a/AirPollutionWebApi/Singletons/Singleton.cs b/AirPollutionWebApi/Singletons/Singleton.cs
deleted file mode 100644
index 00269ad..0000000
--- a/AirPollutionWebApi/Singletons/Singleton.cs
+++ /dev/null
@@ -1,99 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Data.SqlClient;
-using AirPollutionWebApi.Models;
-
-namespace AirPollutionWebApi.Singletons
-{
-	public class Singleton
-	{
-		static Singleton instance;
-		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 List<Reading> Readings = new List<Reading>();
-
-		Singleton() {}
-
-		public static Singleton Instance
-		{
-			get
-			{
-				if (instance == null)
-				{
-					instance = new Singleton();
-				}
-				return instance;
-			}
-		}
-
-		public void GetData()
-		{
-			Readings = new List<Reading>();
-			using (SqlConnection databaseConnection = new SqlConnection(ConnectionString))
-			{
-				string command = "SELECT * FROM Readings";
-				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.GetInt32(2),
-						No = reader.GetInt32(3),
-						So = reader.GetInt32(4)
-					});
-				}
-			}
-		}
-
-		//public void PutData(int id, Reading reading)
-		//{
-		//	using (SqlConnection dbCon = new SqlConnection(ConnectionString))
-		//	{
-		//		dbCon.Open();
-		//		string query = $"UPDATE Readings SET FirstName='{reading.FirstName}', LastName='{reading.LastName}', Year='{reading.Year}' WHERE Id={id};";
-		//		var cmd = new SqlCommand(query, dbCon);
-		//		cmd.ExecuteNonQuery();
-		//		dbCon.Close();
-		//	}
-		//	GetData();
-		//}
-
-		public void PostData(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();
-			}
-			GetData();
-		}
-
-		public void DeleteData(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();
-			}
-			GetData();
-		}
-	}
-}
\ No newline at end of file
-- 
cgit v1.2.3