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);
}
}
}
