public async Task <IActionResult> Yeni(KoronaBilgi koronaBilgi)
{
if (ModelState.IsValid)
{
_db.KoronaBilgileri.Add(koronaBilgi);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Ulkeler = new SelectList(await _db.Ulkeler.ToListAsync(), "Id", "Ad");
return(View(koronaBilgi));
}
public async Task <IActionResult> Yeni(KoronaBilgi koronaBilgi)
{
if (ModelState.IsValid)
{
_db.KoronaBilgileri.Add(koronaBilgi);
_db.SaveChanges();
}
return(RedirectToAction("Index"));
//https://docs.microsoft.com/en-us/aspnet/core/mvc/views/working-with-forms?view=aspnetcore-5.0#the-select-tag-helperer
ViewBag.Ulkeler = new SelectList(await _db.Ulkeler.ToListAsync(), "Id", "Ad");
return(View(koronaBilgi));
}
public IActionResult Doldur()
{
HtmlWeb web = new HtmlWeb();
HtmlDocument doc = web.Load(url);
HtmlNodeCollection ulkeAdlar = doc.DocumentNode.SelectNodes("//tr/td[2]//*");
HtmlNodeCollection ulkeVakalar = doc.DocumentNode.SelectNodes("//tr/td[3]");
HtmlNodeCollection ulkeOlumler = doc.DocumentNode.SelectNodes("//tr/td[5]");
HtmlNodeCollection ulkeNufus = doc.DocumentNode.SelectNodes("//tr/td[15]");
List <string> adlar = new List <string>();
List <string> vakalar = new List <string>();
List <string> olumler = new List <string>();
List <string> nufuslar = new List <string>();
for (int i = 7; i < 227; i++)
{
adlar.Add(ulkeAdlar[i].InnerHtml);
}
for (int i = 8; i < 228; i++)
{
vakalar.Add(ulkeVakalar[i].InnerHtml == " " ? "0" : ulkeVakalar[i].InnerHtml.Trim().Replace(",", ""));
olumler.Add(ulkeOlumler[i].InnerHtml == " " ? "0" : ulkeOlumler[i].InnerHtml.Trim().Replace(",", ""));
nufuslar.Add(ulkeNufus[i].InnerText == " " ? "0" : ulkeNufus[i].InnerText.Trim().Replace(",", ""));
}
for (int i = 0; i < adlar.Count; i++)
{
if (!_db.Ulkeler.Select(x => x.Ad).Contains(adlar[i]))
{
Ulke ulke = new Ulke()
{
Ad = adlar[i],
Nufus = Convert.ToInt64(nufuslar[i]),
KoronaBilgi = new KoronaBilgi()
{
OlumSayisi = Convert.ToInt32(olumler[i] == " " || string.IsNullOrEmpty(olumler[i]) ? "0" : olumler[i]),
VakaSayisi = Convert.ToInt32(vakalar[i])
}
};
_db.Ulkeler.Add(ulke);
_db.SaveChanges();
}
else
{
Ulke ulke = _db.Ulkeler.Include(x => x.KoronaBilgi).FirstOrDefault(x => x.Ad == adlar[i]);
ulke.Nufus = Convert.ToInt64(nufuslar[i]);
ulke.KoronaBilgi.OlumSayisi = Convert.ToInt32(olumler[i]);
ulke.KoronaBilgi.VakaSayisi = Convert.ToInt32(vakalar[i]);
_db.Update(ulke);
}
}
return(RedirectToAction("Index"));
}
