public async Task <ActionResult <IEnumerable <City> > > InsertOrUpdateCity() { List <City> cities = new List <City>(); cities = GisParse.GetCitiesFromURL(); if (cities.Any()) { foreach (var city in cities) { var dataForUpdate = await _context.Cities.FirstOrDefaultAsync(x => x.Reference.Equals(city.Reference)); if (dataForUpdate == null) { _context.Cities.Add( new City { CityName = city.CityName, Reference = city.Reference } ); } await _context.SaveChangesAsync(); } } var citiesFromDB = await _context.Cities.ToListAsync(); return(citiesFromDB); }
public ActionResult <IEnumerable <City> > ParseCities() { var cities = GisParse.GetCitiesFromURL(); return(cities); }