public static async Task <List <CountryCoronaInfo> > GetTodaysCoronaInfoAllCountries() { using (CoronaContext context = new CoronaContext()) { CoronaVirusSummary coronaVirusSummary = await context.CoronaVirusSummaries.FirstOrDefaultAsync(f => f.Date == DateTime.Today, new CancellationToken()); if (coronaVirusSummary != null) { return(await DataHelper.GetCountryInfoListAsync(coronaVirusSummary.VirusInfo)); } } return(null); }
public static CountryCoronaInfo GetTodaysCoronaInfoByCountry(string countryCode) { CountryCoronaInfo countryCoronaInfo = new CountryCoronaInfo(); using (CoronaContext coronaContext = new CoronaContext()) { CoronaVirusSummary coronaVirusSummary = coronaContext.CoronaVirusSummaries.FirstOrDefault(f => f.Date == DateTime.Today); if (coronaVirusSummary != null) { return(((IEnumerable <CountryCoronaInfo>)JsonConvert.DeserializeObject <List <CountryCoronaInfo> >(coronaVirusSummary.VirusInfo)).SingleOrDefault(c => c.CountryInfo.Iso2 == countryCode)); } } return(null); }
public static async Task SaveVirusInfoAsync(string virusInfo) { CoronaContext context = new CoronaContext(); context.Database.EnsureCreated(); CoronaVirusSummary coronaVirusSummary = await context.CoronaVirusSummaries.SingleOrDefaultAsync(x => x.Date == DateTime.Today, new CancellationToken()); if (coronaVirusSummary == null) { context.CoronaVirusSummaries.Add(new CoronaVirusSummary() { Date = DateTime.Today, VirusInfo = virusInfo }); int num = await context.SaveChangesAsync(new CancellationToken()); } else { coronaVirusSummary.VirusInfo = virusInfo; int num = await context.SaveChangesAsync(new CancellationToken()); } }
public static void SaveVirusInfo(string virusInfo) { CoronaContext coronaContext = new CoronaContext(); coronaContext.Database.EnsureCreated(); CoronaVirusSummary coronaVirusSummary = coronaContext.CoronaVirusSummaries.SingleOrDefault(x => x.Date == DateTime.Today); if (coronaVirusSummary == null) { coronaContext.CoronaVirusSummaries.Add(new CoronaVirusSummary() { Date = DateTime.Today, VirusInfo = virusInfo }); coronaContext.SaveChanges(); } else { coronaVirusSummary.VirusInfo = virusInfo; coronaContext.SaveChanges(); } }