public int Put(int id, [FromBody] EnvironmentClass value) { const string updateString = "update EnvironmentData set oxygen =@oxygen, co2 =@co2, co =@co, [PM2.5] =@pm25, PM10 =@pm10, ozon =@ozon, dustParticles =@dustParticles, nitrogenDioxide =@nitrogenDioxide, sulphurDioxide =@SulphurDioxide, longitude=@longitude, latitude=@latitude, userId =@userId, dateTimeInfo =@dateTimeInfo where id=@id;"; using (SqlConnection databaseConnection = new SqlConnection(connectionString)) { databaseConnection.Open(); using (SqlCommand updateCommand = new SqlCommand(updateString, databaseConnection)) { updateCommand.Parameters.AddWithValue("@id", id); updateCommand.Parameters.AddWithValue("@oxygen", value.Oxygen); updateCommand.Parameters.AddWithValue("@co2", value.Co2); updateCommand.Parameters.AddWithValue("@co", value.Co); updateCommand.Parameters.AddWithValue("@pm25", value.Pm25); updateCommand.Parameters.AddWithValue("@pm10", value.Pm10); updateCommand.Parameters.AddWithValue("@ozon", value.Ozon); updateCommand.Parameters.AddWithValue("@dustParticles", value.DustParticles); updateCommand.Parameters.AddWithValue("@nitrogenDioxide", value.NitrogenDioxide); updateCommand.Parameters.AddWithValue("@sulphurDioxide", value.SulphurDioxide); updateCommand.Parameters.AddWithValue("@longitude", value.Longitude); updateCommand.Parameters.AddWithValue("@latitude", value.Latitude); updateCommand.Parameters.AddWithValue("@userId", value.UserId); updateCommand.Parameters.AddWithValue("@dateTimeInfo", value.DateTimeInfo); int rowsAffected = updateCommand.ExecuteNonQuery(); return(rowsAffected); } } }
public int Post([FromBody] EnvironmentClass value) { string insertString = "insert into EnvironmentData (oxygen, co2, co, [PM2.5], PM10, ozon, dustParticles, nitrogenDioxide, sulphurDioxide, longitude, latitude, userId, dateTimeInfo) values(@oxygen, @co2, @co, @PM25, @PM10, @ozon, @dustParticles, @nitrogenDioxide, @sulphurDioxide, @longitude, @latitude, @userId, @dateTimeInfo)"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(insertString, conn)) { command.Parameters.AddWithValue("@oxygen", value.Oxygen); command.Parameters.AddWithValue("@co2", value.Co2); command.Parameters.AddWithValue("@co", value.Co); command.Parameters.AddWithValue("@PM25", value.Pm25); command.Parameters.AddWithValue("@PM10", value.Pm10); command.Parameters.AddWithValue("@ozon", value.Ozon); command.Parameters.AddWithValue("@dustParticles", value.DustParticles); command.Parameters.AddWithValue("@nitrogenDioxide", value.NitrogenDioxide); command.Parameters.AddWithValue("@sulphurDioxide", value.SulphurDioxide); command.Parameters.AddWithValue("@longitude", value.Longitude); command.Parameters.AddWithValue("@latitude", value.Latitude); command.Parameters.AddWithValue("@userId", value.UserId); command.Parameters.AddWithValue("@dateTimeInfo", value.DateTimeInfo); int rowsAffected = command.ExecuteNonQuery(); return(rowsAffected); } } }
public void TestPostEnvironment() { DateTime tryDate = new DateTime(2018, 01, 01); EnvironmentClass newEnv = new EnvironmentClass { Oxygen = 7, Co2 = 7, Co = 19, Pm25 = 18, Pm10 = 45, Ozon = 22, DustParticles = 11, NitrogenDioxide = 12, SulphurDioxide = 34, Longitude = 67, Latitude = 8, UserId = 2, DateTimeInfo = tryDate }; int EnvCount = _controller.Post(newEnv); Assert.AreEqual(1, EnvCount); IEnumerable <EnvironmentClass> envList = _controller.Get(); Assert.AreEqual(4, envList.Count()); // Passed }
public void InitializeSession(Session session) { this.session = session; Console = new ConsoleClass(session); Environment = new EnvironmentClass(session); Path = new PathClass(session); File = new FileClass(session); Directory = new DirectoryClass(session); Thread = new ThreadClass(session); Process = new ProcessClass(session); }
public IEnumerable <EnvironmentClass> Get() { string selectString = "select * from EnvironmentData;"; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(selectString, conn)) { using (SqlDataReader reader = command.ExecuteReader()) { List <EnvironmentClass> result = new List <EnvironmentClass>(); while (reader.Read()) { EnvironmentClass env = ReadEnvironment(reader); result.Add(env); } return(result); } } } }
public IEnumerable <EnvironmentClass> GetEnvByUserId(int userId) { const string selectString = "select * from EnvironmentData where userid =@userid"; using (SqlConnection databaseConnection = new SqlConnection(connectionString)) { databaseConnection.Open(); using (SqlCommand selectCommand = new SqlCommand(selectString, databaseConnection)) { selectCommand.Parameters.AddWithValue("@userid", userId); using (SqlDataReader reader = selectCommand.ExecuteReader()) { List <EnvironmentClass> envList = new List <EnvironmentClass>(); while (reader.Read()) { EnvironmentClass env = EnvironmentController.ReadEnvironment(reader); envList.Add(env); } return(envList); } } } }
public void TestPutEnvironment() { DateTime tryDate = new DateTime(2019, 02, 02); EnvironmentClass newEnv = new EnvironmentClass { Oxygen = 18, Co2 = 7, Co = 19, Pm25 = 18, Pm10 = 45, Ozon = 22, DustParticles = 11, NitrogenDioxide = 12, SulphurDioxide = 34, Longitude = 67, Latitude = 8, UserId = 2, DateTimeInfo = tryDate }; int EnvCount = _controller.Put(7, newEnv); Assert.AreEqual(18, newEnv.Oxygen); // Passed }
internal static EnvironmentClass ReadEnvironment(SqlDataReader reader) { int id = reader.GetInt32(0); decimal oxygen = reader.IsDBNull(1) ? 0 : reader.GetDecimal(1); decimal co2 = reader.IsDBNull(2) ? 0 : reader.GetDecimal(2); decimal co = reader.IsDBNull(3) ? 0 : reader.GetDecimal(3); decimal pm25 = reader.IsDBNull(4) ? 0 : reader.GetDecimal(4); decimal pm10 = reader.IsDBNull(5) ? 0 : reader.GetDecimal(5); decimal ozon = reader.IsDBNull(6) ? 0 : reader.GetDecimal(6); decimal dustParticles = reader.IsDBNull(7) ? 0 : reader.GetDecimal(7); decimal nitrogenDioxide = reader.IsDBNull(8) ? 0 : reader.GetDecimal(8); decimal sulphurDioxide = reader.IsDBNull(9) ? 0 : reader.GetDecimal(9); decimal longitude = reader.GetDecimal(10); decimal latitude = reader.GetDecimal(11); int userId = reader.GetInt32(12); DateTime dateTimeInfo = reader.GetDateTime(13); EnvironmentClass env = new EnvironmentClass() { Id = id, Oxygen = oxygen, Co2 = co2, Co = co, Pm25 = pm25, Pm10 = pm10, Ozon = ozon, DustParticles = dustParticles, NitrogenDioxide = nitrogenDioxide, SulphurDioxide = sulphurDioxide, Longitude = longitude, Latitude = latitude, UserId = userId, DateTimeInfo = dateTimeInfo }; return(env); }