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 virtual void AddCity(MCity mCity)
{
uow.Cities.Create(new City
{
NameCity = mCity.NameCity,
NameCountry = mCity.NameCountry
});
uow.Save();
}
public ActionResult Citys_Create([DataSourceRequest] DataSourceRequest request, CityViewModel cityVM)
{
if (cityVM != null && ModelState.IsValid)
{
MCity city = new MCity();
city.SetAssignedIdTo(cityVM.CityID);
ConvertToCity(cityVM, city);
city.CreatedDate = DateTime.Now;
city.CreatedBy = User.Identity.Name;
city.DataStatus = "New";
_cityTasks.Insert(city);
}
return(Json(new[] { cityVM }.ToDataSourceResult(request, ModelState)));
}
// POST: api/City
public void Post([FromBody] MCity value)
{
cityActions.AddCity(value);
}
private static void ConvertToCity(CityViewModel cityVM, MCity city)
{
city.CityName = cityVM.CityName;
city.CityStatus = cityVM.CityStatus;
city.CityDesc = cityVM.CityDesc;
}
