public async Task <IActionResult> Edit(int id, [Bind("Id,Ad,Nufus")] Ulke ulke)
{
if (id != ulke.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(ulke);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UlkeExists(ulke.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(ulke));
}
public async Task <IActionResult> Duzenle(KoronaBilgi koronaBilgi)
{
if (ModelState.IsValid)
{
//_db.Entry(koronaBilgi).State = EntityState.Modified;
_db.Update(koronaBilgi);
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
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"));
}
