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