public void Inserir(TbCoronaVirus tbCoronaVirus) { DbApiContext ctx = new DbApiContext(); ctx.tbCoronaVirus.Add(tbCoronaVirus); ctx.SaveChanges(); }
public TbCoronaVirus Consultar(int id) { DbApiContext ctx = new DbApiContext(); TbCoronaVirus coronaVirus = ctx.tbCoronaVirus.Find(id); return(coronaVirus); }
public void Excluir(int id) { DbApiContext ctx = new DbApiContext(); TbCoronaVirus coronaVirus = ctx.tbCoronaVirus.Find(id); ctx.Entry(coronaVirus).State = EntityState.Deleted; ctx.SaveChanges(); }
public void Alterar(TbCoronaVirus tbCoronaVirus) { DbApiContext ctx = new DbApiContext(); ctx.Entry(tbCoronaVirus).State = EntityState.Modified; ctx.tbCoronaVirus.Update(tbCoronaVirus); ctx.SaveChanges(); }
public static void ImprimeDados(List <TbCoronaVirus> lstDados) { //Console.Clear(); var vetor = lstDados.Select(s => s.CountryRegion).Distinct().OrderBy(o => o).ToArray(); var data = lstDados.Select(s => new { s.CountryRegion, s.Updated }).GroupBy(g => g.CountryRegion).ToList(); Dictionary <string, DateTime> dict = new Dictionary <string, DateTime>(); for (int i = 0; i < data.Count; i++) { dict.Add( data[i].Select(s => s.CountryRegion).FirstOrDefault(), data[i].Select(s => s.Updated).Max(m => m) ); } //string data = lstDados.Select(s => s.Updated).Where(w => w.Equals(item)).Max().ToString();//.Where(w => w.CountryRegion.Equals(item)).Max(); List <TbCoronaVirus> dados = new List <TbCoronaVirus>(); TbCoronaVirus coronaVirus = new TbCoronaVirus(); foreach (var item in dict) { coronaVirus = lstDados.Where(w => w.CountryRegion.Contains(item.Key)).Where(w => w.Updated.Equals(item.Value)).OrderBy(O => O.Confirmed).FirstOrDefault(); dados.Add(coronaVirus); } // Console.Clear(); Console.WriteLine("CountryRegion".PadRight(40, ' ') + " | " + "Deaths".PadLeft(20, ' ').Replace(",", ".") + " | " + "Confirmed".PadLeft(20, ' ').Replace(",", ".") + " | " + "Recovered".PadLeft(20, ' ').Replace(",", ".") + " | " + "Updated".PadRight(20, ' ')); Console.WriteLine(string.Concat(Enumerable.Repeat("-", 120))); Console.WriteLine(""); int perc = 0; foreach (var item in dados.OrderByDescending(o => o.Confirmed)) { perc++; //ConsoleUtility.WriteProgressBar(dados.Count / perc, true); CultureInfo cultureinfo = new CultureInfo("PT-BR"); int pad = 20; Console.WriteLine( item.CountryRegion.PadRight(pad + pad, ' ') + " | " + item.Deaths.ToString("#,###").PadLeft(pad, ' ').Replace(",", ".") + " | " + item.Confirmed.ToString("#,###").PadLeft(pad, ' ').Replace(",", ".") + " | " + item.Recovered.ToString("#,###").PadLeft(pad, ' ').Replace(",", ".") + " | " + item.Updated.ToString("dd/MM/yyyy").PadRight(pad, ' ') ); } Console.WriteLine(""); Console.WriteLine(string.Concat(Enumerable.Repeat("-", 120))); Console.WriteLine(""); }
public static List <TbCoronaVirus> listar(StreamReader reader) { // Console.Clear(); CultureInfo cultureinfo = new CultureInfo("en-us"); List <TbCoronaVirus> lst = new List <TbCoronaVirus>(); int index = 1; while (!reader.EndOfStream) { string[] linha = reader.ReadLine().Replace("'", "`").Split(','); if (linha.Length == 15 && Char.IsNumber(linha[0][0])) { TbCoronaVirus dados = new TbCoronaVirus(); long inumber; decimal fnumber; dados.IdIndex = index; dados.Id = long.Parse(linha[0]?.Trim()); dados.Updated = DateTime.Parse(linha[1]?.Trim(), cultureinfo); dados.Confirmed = long.Parse(linha[2]?.Trim()); dados.ConfirmedChange = long.TryParse(linha[3]?.Trim(), out inumber) ? inumber : 0; dados.Deaths = long.TryParse(linha[4]?.Trim(), out inumber) ? inumber : 0; dados.DeathsChange = long.TryParse(linha[5]?.Trim(), out inumber) ? inumber : 0; dados.Recovered = long.TryParse(linha[6]?.Trim(), out inumber) ? inumber : 0; dados.RecoveredChange = long.TryParse(linha[7]?.Trim(), out inumber) ? inumber : 0; dados.Latitude = decimal.TryParse(linha[8]?.Trim().Replace(".", ","), out fnumber) ? fnumber : 0; dados.Longitude = decimal.TryParse(linha[9]?.Trim().Replace(".", ","), out fnumber) ? fnumber : 0; dados.Iso2 = linha[10]?.Trim(); dados.Iso3 = linha[11]?.Trim(); dados.CountryRegion = linha[12]?.Trim(); dados.AdminRegion1 = linha[13]?.Trim(); dados.AdminRegion2 = linha[14]?.Trim(); lst.Add(dados); index++; } } Console.WriteLine($@"Foram localizados {string.Format(lst.Count.ToString(), "C")} Registros no arquivo"); return(lst); }