public static void Do() { var countries = CountryRecord.Retrieve(); using (var context = new ClimateContext()) { context.Countries.RemoveRange(context.Countries.ToList()); foreach (var country in countries.OrderByDescending(x => x.population)) { var dbCountry = new Domain.Country { Name = country.name, Population = country.population }; context.Countries.Add(dbCountry); var capital = new Domain.City { IsCapital = true, Country = dbCountry, Name = country.capital }; context.Cities.Add(capital); Console.WriteLine("{0} - done", country.name); } context.SaveChanges(); } }
public static void Do() { var converter = new ModelsConverter(); using (var context = new ClimateContext()) { var cities = context.Cities.Include(x => x.Country).ToList().Select(converter.ToDto).ToArray(); var path = "../../../../shared/data.json"; File.WriteAllText(path, JsonConvert.SerializeObject(cities)); } }
public static void Do() { using (var context = new ClimateContext()) { var capitals = context.Cities.OrderByDescending(x => x.Country.Population).ToList(); var index = 0; foreach (var capital in capitals) { var itsClimate = capital.Climates.ToList(); if (!itsClimate.Any() && !string.IsNullOrEmpty(capital.Name)) { var capitalClimate = data.Retrieve(capital.Name); try { var records = capitalClimate.ClimateAverages[0].month.Select(m => new CityClimateRecord { AbsMax = m.absMaxTemp, AbsMaxFahr = m.absMaxTemp_F, AvgMin = m.avgMinTemp, AvgMinFahr = m.avgMinTemp_F, Month = m.name, MonthIndex = m.index }).ToList(); var climate = new CityClimate { TargetCity = capital, Records = new List <CityClimateRecord>(records) }; context.CityClimates.Add(climate); context.CityClimateRecords.AddRange(records); context.SaveChanges(); Console.WriteLine("{0} - processed, {1}/{2} to do", capital.Name, capitals.Count - ++index, capitals.Count); } catch (Exception) { Console.WriteLine("{0} - failed, {1}/{2} to do", capital.Name, capitals.Count - ++index, capitals.Count); } Thread.Sleep(2000); } else { Console.WriteLine("{0} - skipped, {1}/{2} to do", capital.Name, capitals.Count - ++index, capitals.Count); } } } Console.ReadLine(); }
public static void Do() { var countries = CountryRecord.Retrieve(); using (var context = new ClimateContext()) { var dbCountries = context.Countries.Include(x => x.Cities).ToList(); var joined = countries.Join(dbCountries, x => x.name, x => x.Name, (dto, db) => new { dto, db }); foreach (var pair in joined) { if (pair.dto.latlng != null && pair.dto.latlng.Length == 2) { foreach (var city in pair.db.Cities) { city.Lat = pair.dto.latlng[0]; city.Lon = pair.dto.latlng[1]; } } } context.SaveChanges(); } }
public ClimatesController(ClimateContext context) { _context = context; }
public RepositoryBase() { Context = new ClimateContext(); }
/// <summary> /// Climate controller constructor /// </summary> /// <param name="climateContext">Climate context</param> public ClimateController(ClimateContext climateContext) { _climateContext = climateContext; }