public static void CalcStats(this Statistics statistics, IXmlSocDB xmlSocDb, string startRound, string endRound)
{
statistics.SetMatches(xmlSocDb.LeagueMatches.ToList());
statistics.SetRoundsRange(startRound, endRound);
statistics.CalculateBasicStats();
statistics.CalculateGoalsInIntervals();
statistics.CalculateMatchGoals();
}
private static void SaveChangesInDatabase(IXmlSocDB dbContext)
{
bool saveFailed;
do
{
saveFailed = false;
try
{
dbContext.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
saveFailed = true;
ex.Entries.Single().Reload();
}
}while (saveFailed);
}
public static void UpdateMatchesData(string leagueName, int seasonYear, IXmlSR xmlSocReq, IXmlSocDB xmlSocDb)
{
MatchesDataUpdated = true;
LastUpdateTime = DateTime.UtcNow;
MatchesLastUpdateTime = LastUpdateTime;
var xmlLeagueMatches = xmlSocReq.GetHistoricMatchesByLeagueAndSeason(leagueName, seasonYear);
ClearDbSet(xmlSocDb.LeagueMatches);
xmlSocDb.LeagueMatches.AddRange(xmlLeagueMatches.ConvertToMatchList());
SaveChangesInDatabase(xmlSocDb);
}
public static void UpdateTeamsData(string league, int seasonYear, IXmlSR xmlSocReq, IXmlSocDB xmlSocDb)
{
LastUpdateTime = DateTime.UtcNow;
TeamsLastUpdateTime = LastUpdateTime;
var xmlTeams = xmlSocReq.GetAllTeamsByLeagueAndSeason(league, seasonYear);
ClearDbSet(xmlSocDb.FootballTeams);
xmlSocDb.FootballTeams.AddRange(xmlTeams.ConvertToTeamList());
SaveChangesInDatabase(xmlSocDb);
}
public static void UpdateTableData(string league, int seasonYear, IXmlSR xmlSocReq, IXmlSocDB xmlSocDb)
{
LastUpdateTime = DateTime.UtcNow;
TableLastUpdateTime = LastUpdateTime;
var xmlLeagueStandings = xmlSocReq.GetLeagueStandingsBySeason(league, seasonYear);
ClearDbSet(xmlSocDb.LeagueTable);
xmlSocDb.LeagueTable.AddRange(xmlLeagueStandings.ConvertToLeagueStandingList());
SaveChangesInDatabase(xmlSocDb);
}
