private void testDateSingle()
{
using (var db = new EntranceScoresContext())
{
var collegeEntity = db.collegeEntities.DefaultIfEmpty().Single(c => c.code.Equals("ANH"));
var majorEntity = db.majorEntities.DefaultIfEmpty().Single(c => c.code.Equals("714"));
var majorCollege = new MajorCollege();
majorCollege.CollegeEntity = collegeEntity;
majorCollege.MajorEntity = majorEntity;
majorCollege.score = 17.5;
majorCollege.groupCode = "sdsd";
majorCollege.year = 2019;
db.majorColleges.Add(majorCollege);
db.SaveChanges();
}
}
public ActionResult <string> Get(int year)
{
using (var db = new EntranceScoresContext())
{
//Parallel.ForEach(collegeEntities, college => Process(college,year,db));
foreach (var cl in collegeEntities)
{
this.Process(cl, year, db);
}
if (isAddNewMajor == false)
{
//Add majorCollege to database
db.majorColleges.AddRange(majorColleges);
}
else
{
//Add majorCollege to database
//Convert map to list
newMajorEntities = newMajorMap.Select(p => new MajorEntity {
code = p.Key, name = p.Value
}).ToList();
Console.WriteLine("Begin the process of adding industry of the " + year + " to the database");
//Add list to db
db.majorEntities.AddRange(newMajorEntities);
Console.WriteLine("Finish process of add industry!");
}
db.SaveChanges();
return("Crawling data from " + year + " OK");
}
}