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