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