public async Task <IActionResult> PutZoneCity([FromRoute] int id, [FromBody] ZoneCity zoneCity) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != zoneCity.CityId) { return(BadRequest()); } _context.Entry(zoneCity).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ZoneCityExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PostZoneCity([FromBody] ZoneCity zoneCity) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.ZoneCities.Add(zoneCity); await _context.SaveChangesAsync(); return(CreatedAtAction("GetZoneCity", new { id = zoneCity.CityId }, zoneCity)); }
public async Task InitializeDataAsync(IServiceProvider serviceProvider) { _context = serviceProvider.GetRequiredService <ApplicationDbContext>(); // Add the code for inintializing at here if (_context.ApplicationOptions.Count() == 0) { _context.ApplicationOptions.Add(new ApplicationOption() { OptionsDate = DateTime.Now, EndUserLicenseAgreementSource = "https://www.lipsum.com/", PrivacyPolicySource = "https://www.lipsum.com/", TermsConditionsSource = "https://www.lipsum.com/", DataTimeWindow = TimeSpan.FromHours(12), Version = 1, VersionMajor = 0, VersionMinor = 1 }); await _context.SaveChangesAsync(); } // Zone Data if (_context.ZoneRegions.Count() == 0) { if (_context.ZoneStates.Count() == 0) { _context.ZoneStates.Add(new ZoneState() { //StateId=1, Description = "Texas", ShortDescription = "TX" }); } await _context.SaveChangesAsync(); var texas = _context.ZoneStates.FirstOrDefault(s => s.Description.Equals("Texas", StringComparison.OrdinalIgnoreCase)); if (_context.ZoneCities.Count() == 0) { _context.ZoneCities.Add(new ZoneCity() { //CityId=1, Description = "Austin", State = texas }); await _context.SaveChangesAsync(); } ZoneCity zoneCityAustin = _context.ZoneCities.FirstOrDefault(c => c.Description.Equals("austin", StringComparison.OrdinalIgnoreCase)); if (zoneCityAustin == null) { return; } var northAustin = new ZoneRegion() { City = zoneCityAustin, Description = "North", Type = (int)RegionType.Neighborhood, ARGBFill = "80FDCAC9", ARGBStroke = "00000000", StrokeWidth = 1.0f }; _context.ZoneRegions.Add(northAustin); int i = 0; _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.468183, Longitude = -97.796568, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.481202, Longitude = -97.744093, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.475876, Longitude = -97.702605, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.479723, Longitude = -97.673583, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.454274, Longitude = -97.66677, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.407798, Longitude = -97.674034, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.381145, Longitude = -97.674087, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.33819, Longitude = -97.69989, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.347079, Longitude = -97.712304, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.368705, Longitude = -97.71888, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.379072, Longitude = -97.73816, RegionId = northAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = northAustin, Order = ++i, Latitude = 30.447467, Longitude = -97.790109, RegionId = northAustin.RegionId }); //northAustin.BoundLatitudeMin = _context.ZoneRegionPolygons.Where(r => r.RegionId.Equals(northAustin.RegionId)).Min(r => r.Latitude); //northAustin.BoundLatitudeMax = _context.ZoneRegionPolygons.Where(r => r.RegionId.Equals(northAustin.RegionId)).Max(r => r.Latitude); //northAustin.BoundLongitudeMin = _context.ZoneRegionPolygons.Where(r => r.RegionId.Equals(northAustin.RegionId)).Min(r => r.Longitude); //northAustin.BoundLongitudeMax = _context.ZoneRegionPolygons.Where(r => r.RegionId.Equals(northAustin.RegionId)).Max(r => r.Longitude); var pflugervilleAustin = new ZoneRegion() { City = zoneCityAustin, Description = "Pflugerville", Type = (int)RegionType.Neighborhood, ARGBFill = "8099FAD7", ARGBStroke = "00000000", StrokeWidth = 1.0f }; i = 0; _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.479723, Longitude = -97.673583, RegionId = pflugervilleAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.488303, Longitude = -97.633951, RegionId = pflugervilleAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.472029, Longitude = -97.592119, RegionId = pflugervilleAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.388846, Longitude = -97.57844, RegionId = pflugervilleAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.351819, Longitude = -97.592098, RegionId = pflugervilleAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.366039, Longitude = -97.605541, RegionId = pflugervilleAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.388549, Longitude = -97.651256, RegionId = pflugervilleAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.400987, Longitude = -97.655484, RegionId = pflugervilleAustin.RegionId }); //shared with north austin _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.407798, Longitude = -97.674034, RegionId = pflugervilleAustin.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = pflugervilleAustin, Order = ++i, Latitude = 30.454274, Longitude = -97.66677, RegionId = pflugervilleAustin.RegionId }); //pflugervilleAustin.BoundLatitudeMin = _context.ZoneRegionPolygons.Where(r => r.RegionId.Equals(pflugervilleAustin.RegionId)).Min(r => r.Latitude); //pflugervilleAustin.BoundLatitudeMax = _context.ZoneRegionPolygons.Where(r => r.RegionId.Equals(pflugervilleAustin.RegionId)).Max(r => r.Latitude); //pflugervilleAustin.BoundLongitudeMin = _context.ZoneRegionPolygons.Where(r => r.RegionId.Equals(pflugervilleAustin.RegionId)).Min(r => r.Longitude); //pflugervilleAustin.BoundLongitudeMax = _context.ZoneRegionPolygons.Where(r => r.RegionId.Equals(pflugervilleAustin.RegionId)).Max(r => r.Longitude); var westSixth = new ZoneRegion() { City = zoneCityAustin, Description = "West 6th", Type = (int)RegionType.SocialDistrict, ARGBFill = "8095C6E4", //blue-grey ARGBStroke = "00000000", StrokeWidth = 1.0f }; i = 0; _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = westSixth, Order = ++i, Latitude = 30.273021, Longitude = -97.749524, RegionId = westSixth.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = westSixth, Order = ++i, Latitude = 30.271798, Longitude = -97.745204, RegionId = westSixth.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = westSixth, Order = ++i, Latitude = 30.268091, Longitude = -97.746655, RegionId = westSixth.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = westSixth, Order = ++i, Latitude = 30.269296, Longitude = -97.750918, RegionId = westSixth.RegionId }); var warehouseDistrict = new ZoneRegion() { City = zoneCityAustin, Description = "Warehouse District", Type = (int)RegionType.SocialDistrict, ARGBFill = "80D2B7D8", //purple-ish ARGBStroke = "00000000", StrokeWidth = 1.0f }; i = 0; _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = warehouseDistrict, Order = ++i, Latitude = 30.269036, Longitude = -97.74634, RegionId = warehouseDistrict.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = warehouseDistrict, Order = ++i, Latitude = 30.268019, Longitude = -97.742779, RegionId = warehouseDistrict.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = warehouseDistrict, Order = ++i, Latitude = 30.26522, Longitude = -97.743823, RegionId = warehouseDistrict.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = warehouseDistrict, Order = ++i, Latitude = 30.266814, Longitude = -97.749481, RegionId = warehouseDistrict.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = warehouseDistrict, Order = ++i, Latitude = 30.269279, Longitude = -97.750911, RegionId = warehouseDistrict.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = warehouseDistrict, Order = ++i, Latitude = 30.268091, Longitude = -97.746655, RegionId = warehouseDistrict.RegionId }); var secondStreet = new ZoneRegion() { City = zoneCityAustin, Description = "2nd Street", Type = (int)RegionType.SocialDistrict, ARGBFill = "806F7FBD", //purple-ish ARGBStroke = "00000000", StrokeWidth = 1.0f }; i = 0; _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = secondStreet, Order = ++i, Latitude = 30.266517, Longitude = -97.748421, RegionId = secondStreet.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = secondStreet, Order = ++i, Latitude = 30.26522, Longitude = -97.743823, RegionId = secondStreet.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = secondStreet, Order = ++i, Latitude = 30.263367, Longitude = -97.744544, RegionId = secondStreet.RegionId }); _context.ZoneRegionPolygons.Add(new ZoneRegionPolygon() { Region = secondStreet, Order = ++i, Latitude = 30.264683, Longitude = -97.749128, RegionId = secondStreet.RegionId }); await _context.SaveChangesAsync(); } }