public Prediction GetPrediction(int matchId)
{
using (var context = new FootballContext())
{
return(context.Predictions.FirstOrDefault(c => c.MatchId == matchId));
}
}
public void SavePrediction(string username, int matchId, int homeGoals, int awayGoals)
{
using (var context = new FootballContext())
{
var prediction = context.Predictions.FirstOrDefault(p => p.MatchId == matchId && p.Username == username);
if (prediction == null)
{
prediction = new Prediction
{
Username = username,
MatchId = matchId,
AwayGoals = awayGoals,
HomeGoals = homeGoals
};
context.Predictions.Add(prediction);
}
else
{
prediction.HomeGoals = homeGoals;
prediction.AwayGoals = awayGoals;
}
context.SaveChanges();
}
}
public IList <FootballMatch> GetMatches(int competitionId)
{
using (var context = new FootballContext())
{
return(context.Matches.Where(c => c.CompetitionId == competitionId).ToList());
}
}
public FootballMatch GetMatch(int id)
{
using (var context = new FootballContext())
{
return(context.Matches.FirstOrDefault(c => c.Id == id));
}
}
public IList <Competition> GetCompetitions()
{
using (var context = new FootballContext())
{
return(context.Competitions.ToList());
}
}
public Competition GetCompetition(int id)
{
using (var context = new FootballContext())
{
return(context.Competitions.FirstOrDefault(c => c.Id == id));
}
}
public void AddCompetition(Competition competition)
{
using (var context = new FootballContext())
{
context.Competitions.Add(competition);
context.SaveChanges();
}
}
public IList <Prediction> GetPredictions(string username, int competitionId)
{
using (var context = new FootballContext())
{
return(context.Predictions.Where(p => p.Match.CompetitionId == competitionId &&
p.Username == username).ToList());
}
}