public static void AddMatchDetailsToDb(sakilaEntities4 db, int homeTeamID, int awayTeamID, int homeTeamGoals, int awayTeamGoals, DateTime matchDate, int competitionMatchID)
{
var newMatch = new competitionmatch();
newMatch.HomeTeamID = homeTeamID;
newMatch.AwayTeamID = awayTeamID;
newMatch.HomeGoals = homeTeamGoals;
newMatch.AwayGoals = awayTeamGoals;
newMatch.WinnerTeamID = Helper.GetWinnerTeamID(homeTeamID, homeTeamGoals, awayTeamID,
awayTeamGoals);
newMatch.MatchDate = matchDate;
newMatch.CompetitionID = competitionMatchID;
db.competitionmatch.Add(newMatch);
db.SaveChanges();
}
public static void AddMatchDetailsToDb(DataObjects.MatchDetails match, sakilaEntities4 db, int homeTeamID, int awayTeamID, int competitionID = 10)
{
var newMatch = new competitionmatch();
newMatch.HomeTeamID = homeTeamID;
newMatch.AwayTeamID = awayTeamID;
newMatch.HomeGoals = match.HomeTeam.Goals;
newMatch.AwayGoals = match.AwayTeam.Goals;
newMatch.WinnerTeamID = Helper.GetWinnerTeamID(homeTeamID, match.HomeTeam.Goals, awayTeamID,
match.AwayTeam.Goals);
newMatch.MatchDate = match.Date;
newMatch.CompetitionID = competitionID;
db.competitionmatch.Add(newMatch);
db.SaveChanges();
match.MatchID = newMatch.CompetitionMatchID;
}
public static string GetCompetitionMatchResultLetter(competitionmatch match, int teamId)
{
var latest = "";
if (match.WinnerTeamID == teamId)
{
latest = "W";
}
else if (match.WinnerTeamID == null)
{
latest = "D";
}
else
{
latest = "L";
}
return(latest);
}
public static AttributesMatch GetAttributeMatch(sakilaEntities4 db, competitionmatch match)
{
var attributesDict = SecondaryStatsCalculator.BuildAttributesDictionary(match.CompetitionID, db, 50, match.MatchDate);
var homeTeamAttributes = Helper.GetTeamAttributeFromDict((int)match.HomeTeamID, attributesDict);
var awayTeamAttributes = Helper.GetTeamAttributeFromDict((int)match.AwayTeamID, attributesDict);
List <DataObjects.AttributeType> winnerAttributes = null;
if (match.WinnerTeamID == match.HomeTeamID)
{
winnerAttributes = homeTeamAttributes;
}
else if (match.WinnerTeamID == match.AwayTeamID)
{
winnerAttributes = awayTeamAttributes;
}
return(new AttributesMatch
{
HomeAttributes = homeTeamAttributes,
AwayAttributes = awayTeamAttributes,
WinnerAttributes = winnerAttributes
});
}
public static MatchStrengthDetails GetMatchStrengthDetails(sakilaEntities4 db, competitionmatch match, int competitionId)
{
var homeTeamStrength = CalculateTeamStrength(db, match.HomeTeamID, "Home", competitionId, match.MatchDate);
var awayTeamStrength = CalculateTeamStrength(db, match.AwayTeamID, "Away", competitionId, match.MatchDate);
var winner = "Draw";
if (match.WinnerTeamID == match.HomeTeamID)
{
winner = "Home";
}
if (match.WinnerTeamID == match.AwayTeamID)
{
winner = "Away";
}
return(new MatchStrengthDetails
{
HomeTeamStrength = homeTeamStrength,
AwayTeamStength = awayTeamStrength,
Winner = winner
});
}