public void AddCityData(CityDailyCaseData cd)
{
var TestCityDatasIfExist = (from e in _db.CityDailyCaseDatas where e.Date == cd.Date && e.Name == cd.Name select e).Count();
if (TestCityDatasIfExist < 1)
{
_db.CityDailyCaseDatas.Add(cd);
}
else
{
Console.WriteLine("Data already exist for Date {0}", cd.Date.ToShortDateString());
}
_db.SaveChanges();
}
public IActionResult Upload(IFormFile file, DateTime dateTime)
{
using var reader = new StreamReader(file.OpenReadStream());
var lines = new List <string>();
string line;
while ((line = reader.ReadLine()) != null)
{
lines.Add(line);
}
String dt = dateTime.ToShortDateString();
foreach (var l in lines)
{
if (l.StartsWith("\"\""))
{
continue;
}
string[] words = l.Split(',');
CityData TempCityData = new CityData
{
Name = words[1].Substring(1, words[1].Length - 2),
Pop = int.Parse(words[11])
};
_cityService.AddCity(TempCityData);
CityDailyCaseData TempCityDailyCaseData = new CityDailyCaseData
{
Name = words[1].Substring(1, words[1].Length - 2),
Cases = int.Parse(words[2]),
Death = int.Parse(words[5]),
Test = int.Parse(words[8]),
Date = dateTime
};
_cityService.AddCityData(TempCityDailyCaseData);
}
ViewBag.dateTime = dt;
return(View("Display", lines));
}
