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