public ActionResult Index() { var sensors = db.Sensors.OrderBy(m => m.Id).Include(m => m.City).ToList(); List<SensorViewModel> vm = new List<SensorViewModel>(); foreach(var s in sensors) { SensorViewModel sensorVM = new SensorViewModel(); sensorVM.Address = s.Address; if(s.City != null) sensorVM.City = new CityViewModel { Id = s.City.Id, Name = s.City.Name }; sensorVM.Id = s.Id; sensorVM.Latitude = s.Latitude; sensorVM.Longitude = s.Longitude; vm.Add(sensorVM); } return Json(vm, JsonRequestBehavior.AllowGet); }
public ActionResult Detail(int id) { var sensor = db.Sensors.Where(s => s.Id == id).FirstOrDefault(); if (sensor == null) return Json(@"{ ""error"": ""Sensor not found"" }"); SensorViewModel vm = new SensorViewModel(); vm.Id = sensor.Id; vm.Address = sensor.Address; if(sensor.City != null) vm.City = new CityViewModel { Id = sensor.City.Id, Name = sensor.City.Name }; vm.Latitude = sensor.Latitude; vm.Longitude = sensor.Longitude; return Json(vm, JsonRequestBehavior.AllowGet); }