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