public static void LeagueResult_InsertResultRecords(List <ResultRecord> resultList) { using (ClubWorldDbContext db = new ClubWorldDbContext()) { DbContextTransaction tran = db.Database.BeginTransaction(); foreach (ResultRecord res in resultList) { League_Result resEntity = new League_Result { FixtureRef = res.FixtureRef, ResultType = res.FixtureType, HomeShots = res.HomeShots, AwayShots = res.AwayShots }; db.League_Result.Add(resEntity); db.SaveChanges(); int resID = resEntity.ResultID; League_Fixtures fixEntity = db.League_Fixtures.SingleOrDefault(lf => lf.FixtureId == res.FixtureRef); fixEntity.FixtureTypeRef = res.FixtureType; foreach (Player p in res.HomeRink) { League_ResultPlayers lrp = new League_ResultPlayers { ResultRef = resEntity.ResultID, RegistrationRef = p.RegistrationId }; db.League_ResultPlayers.Add(lrp); } } db.SaveChanges(); tran.Commit(); } }
public void InsertResultRecords(List <ResultModel> resultList) { DbContextTransaction tran = _db.Database.BeginTransaction(); foreach (var res in resultList) { League_Result resEntity = new League_Result { FixtureRef = res.FixtureRef, ResultType = res.FixtureType, HomeShots = res.HomeShots, AwayShots = res.AwayShots }; _db.League_Result.Add(resEntity); _db.SaveChanges(); int resID = resEntity.ResultID; League_Fixtures fixEntity = _db.League_Fixtures.SingleOrDefault(lf => lf.FixtureId == res.FixtureRef); fixEntity.FixtureTypeRef = res.FixtureType; foreach (PlayerModel p in res.HomeRink) { League_ResultPlayers lrp = new League_ResultPlayers { ResultRef = resEntity.ResultID, RegistrationRef = p.RegistrationId }; _db.League_ResultPlayers.Add(lrp); } } _db.SaveChanges(); tran.Commit(); }