public ActionResult Delete(long id, City vm) { ModelState.Clear(); City city = this.db.Cities .Where(c => c.Id == vm.Id) .FirstOrDefault(); if (city == null) return HttpNotFound(); if (city.Institutes.Count > 0) { this.FlashError("Você não pode apagar essa cidade pois ela tem institutos cadastrados. Remova todos os insitutos antes de apagar a cidade"); return View(city); } try { db.Cities.Remove(city); db.SaveChanges(); return RedirectToAction("Index"); } catch { this.FlashError("Ocorreu um problema ao apagar a cidade"); } return View(city); }
public ActionResult Create(VMEditCreateCity vm) { if (ModelState.IsValid) { try { City city = new City(); city.Name = vm.Name; city.State = db.States.Where(c => c.Id == vm.StateId).FirstOrDefault(); this.db.Cities.Add(city); this.db.SaveChanges(); this.FlashInfo("Cidade cadastrado com sucesso."); return RedirectToAction("Index"); } catch (DbEntityValidationException ex) { foreach(var entityError in ex.EntityValidationErrors) { foreach(var error in entityError.ValidationErrors) { ModelState.AddModelError(error.PropertyName, error.ErrorMessage); } } }catch(Exception ex) { ModelState.AddModelError("", "Ocorreu um problema ao salvar a cidade"); } } vm.States = db.States.OrderBy(m => m.Name).ToList(); return View(vm); }
public SensorsController() { if(this.db.Sensors.Count() == 0) { City city; State state; Country country; if(db.Countries.Count() == 0) { country = new Country { Name = "Brasil" }; db.Countries.Add(country); db.SaveChanges(); } else { country = db.Countries.Where(c => c.Name == "Brasil").FirstOrDefault(); } if(db.States.Count() == 0) { state = new State { Name = "Santa Catarina", Country = country, Code = "SC" }; db.States.Add(state); db.SaveChanges(); }else { state = db.States.Where(s => s.Name == "Santa Catarina").FirstOrDefault(); } if(db.Cities.Count() == 0) { city = new City { Name = "Joinville", State = state }; db.Cities.Add(city); db.SaveChanges(); }else { city = db.Cities.Where(c => c.Name == "Joinville").FirstOrDefault(); } for(int i = 0; i < 100; i++) { Sensor sensor = new Sensor(); sensor.Address = "Rua XV de Novembro " + i; sensor.City = city; sensor.Latitude = 10.0; sensor.Longitude = 10.0; sensor.Name = "Sensor " + i; sensor.SerialNumber = i.ToString(); db.Sensors.Add(sensor); } db.SaveChanges(); } }