public IHttpActionResult Get(string city_name) { MCity mCity = new MCity(); MTemperature mTemperature = new MTemperature(); List <MTemperature> mTemperatures = new List <MTemperature>(); using (DBEntities database = new DBEntities()) { var vCity = database.City.FirstOrDefault(c => c.city == city_name); if (vCity == null) { return(NotFound()); } mCity.Id = vCity.Id; mCity.city = vCity.city; foreach (var vTemperature in database.Temperature.Where(t => t.City_id == vCity.Id)) { mTemperature.Id = vTemperature.Id; mTemperature.date = "" + vTemperature.date;//gambiarra mTemperature.temperature = vTemperature.temperature; mTemperature.City_id = vTemperature.City_id; mTemperatures.Add(mTemperature); mTemperature = new MTemperature(); } mCity.temperatures = mTemperatures; } return(Ok(mCity)); }
public IHttpActionResult Get() { List <MCity> mCities = new List <MCity>(); List <MTemperature> mTemperatures = new List <MTemperature>(); MCity mCity = new MCity(); MTemperature mTemperature; using (DBEntities database = new DBEntities()) { foreach (var vCity in database.City.ToList()) { mTemperature = new MTemperature();//ex mCity.Id = vCity.Id; mCity.city = vCity.city; var vTemperature = (database.Temperature.Where(t => t.City_id == vCity.Id)).ToList().Last(); mTemperature.Id = vTemperature.Id; mTemperature.date = "" + vTemperature.date;//gambiarra mTemperature.temperature = vTemperature.temperature; mTemperature.City_id = vTemperature.City_id; mTemperatures.Add(mTemperature); mCity.temperatures = mTemperatures; mCities.Add(mCity); mCity = new MCity(); mTemperatures = new List <MTemperature>(); } } return(Ok(mCities)); }
public void AddTemperatureTest() { // Arrange Service1 svc1 = new Service1(); // Act9 var temp = new MTemperature(9000, "TESTING", "TESTING"); var mTemperatures = svc1.AddTemperature(temp); // Assert Assert.AreEqual(true, mTemperatures); }
public bool DeleteTemperature(MTemperature temp) { using (var connection = new SqlConnection(_connectionString)) { string sqlQuery = $"DELETE FROM Temperature WHERE id=@id"; using (SqlCommand command = new SqlCommand(sqlQuery, connection)) { command.Parameters.AddWithValue("@id", temp.ID); connection.Open(); int result = command.ExecuteNonQuery(); if (result < 0) { Console.WriteLine("Error deleting data from the database."); } return(true); } } }
public bool AddTemperature(MTemperature temp) { using (SqlConnection connection = new SqlConnection(_connectionString)) { string sqlQuery = "INSERT INTO Temperature (Temperature, Time, Place) VALUES (@Temperature, @Time, @Place)"; using (SqlCommand command = new SqlCommand(sqlQuery, connection)) { command.Parameters.AddWithValue("@Temperature", temp.Temperature); command.Parameters.AddWithValue("@Time", temp.Time); command.Parameters.AddWithValue("@Place", temp.Place); connection.Open(); int result = command.ExecuteNonQuery(); if (result < 0) { Console.WriteLine("Error inserting data into the database."); } } return(true); } }
public MTemperature UpdateTemperature(MTemperature temp) { using (var connection = new SqlConnection(_connectionString)) { string sqlQuery = $"UPDATE Temperature SET place=@Place WHERE id=@id"; using (SqlCommand command = new SqlCommand(sqlQuery, connection)) { command.Parameters.AddWithValue("@place", temp.Place); command.Parameters.AddWithValue("@id", temp.ID); connection.Open(); int result = command.ExecuteNonQuery(); if (result < 0) { Console.WriteLine("Error updating data inside the database."); } return(temp); } } }