public async Task <ActionResult <COVID19> > PostCOVID19(COVID19 cOVID19)
{
_context.COVID19.Add(cOVID19);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCOVID19", new { id = cOVID19.Id }, cOVID19));
}
public async Task <IActionResult> PutCOVID19(int id, COVID19 cOVID19)
{
if (id != cOVID19.Id)
{
return(BadRequest());
}
_context.Entry(cOVID19).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!COVID19Exists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public static List <COVID19> GetData(string csvfilename)
{
var sr = new StreamReader(csvfilename);
sr.ReadLine();
var rtn = new List <COVID19>();
while (!sr.EndOfStream)
{
var split = sr.ReadLine().Split(",");
var r = new COVID19();
var Month = split[0].Substring(0, 1);
var Day = split[0].Substring(2).TrimEnd("日".ToCharArray());
r.PublishDate = new DateTime(2020, int.Parse(Month), int.Parse(Day));
switch (split[1])
{
case "国家级":
r.Kbn = 0;
break;
case "省级":
r.Kbn = 1;
break;
case "地区级":
r.Kbn = 2;
break;
default:
r.Kbn = -1;
break;
}
r.Province = split[2];
r.City = split[3];
r.Confirmed_New = string.IsNullOrEmpty(split[4])?0:int.Parse(split[4]);
r.Recoved_New = string.IsNullOrEmpty(split[5])?0:int.Parse(split[5]);
r.Death_New = string.IsNullOrEmpty(split[6])?0:int.Parse(split[6]);
r.Confirmed_asymptomatic_New = string.IsNullOrEmpty(split[7])?0:int.Parse(split[7]);
r.Recoved_asymptomatic_New = string.IsNullOrEmpty(split[8])?0:int.Parse(split[8]);
r.Death_asymptomatic_New = string.IsNullOrEmpty(split[9])?0:int.Parse(split[9]);
r.SubAfterCheck = string.IsNullOrEmpty(split[10])?0:int.Parse(split[10]);
r.SubAfterCheck_Recoved = string.IsNullOrEmpty(split[11])?0:int.Parse(split[11]);
r.SubAfterCheck_Death = string.IsNullOrEmpty(split[12])?0:int.Parse(split[12]);
r.Confirmed_Total = string.IsNullOrEmpty(split[13])?0:int.Parse(split[13]);
r.Recoved_Total = string.IsNullOrEmpty(split[14])?0:int.Parse(split[14]);
r.Death_Total = string.IsNullOrEmpty(split[15])?0:int.Parse(split[15]);
r.Confirmed_asymptomatic_Total = string.IsNullOrEmpty(split[16])?0:int.Parse(split[16]);
r.Recoved_asymptomatic_Total = string.IsNullOrEmpty(split[17])?0:int.Parse(split[17]);
r.Death_asymptomatic_Total = string.IsNullOrEmpty(split[18])?0:int.Parse(split[18]);
rtn.Add(r);
}
return(rtn);
}
static void Main(string[] args)
{
var ds = COVID19.GetData(@"F:\VisLab\CreateJSON\csv\dataset.csv");
Console.WriteLine("Import csv records count:" + ds.Count);
//提取所有国家级的记录
var Country_Dairy = ds.Where(x => x.Kbn == 0);
string json = JsonConvert.SerializeObject(Country_Dairy, Formatting.Indented);
using (var sw = new StreamWriter(JsonFolder_Visualization_AngularAssets + "Country_Dairy.json", false))
{
sw.Write(json);
sw.Close();
}
var Province_Dairy = ds.Where(x => x.Kbn == 1 && x.PublishDate.Month == 3);
json = JsonConvert.SerializeObject(Province_Dairy, Formatting.Indented);
using (var sw = new StreamWriter(JsonFolder_Visualization_AngularAssets + "Province_Dairy.json", false))
{
sw.Write(json);
sw.Close();
}
}
