private IEnumerable<SecondRoundPrediction> GetSecondRoundPrediction(int participantId, int predictionType)
{
HetEKSpelEntities db = new HetEKSpelEntities(connectionString);
var predictions =
db.Predictions.Where(p => p.Participant_Id == participantId && p.PredictionType_Id == predictionType).ToList();
var teams = db.Teams.ToList();
var predictionList = new List<SecondRoundPrediction>();
foreach (var prediction in predictions)
{
var predictionLine = new SecondRoundPrediction
{
TeamId = (int)prediction.Team_Id,
TeamName = teams.SingleOrDefault(t => t.Id == prediction.Team_Id).Team1,
Short = teams.SingleOrDefault(t => t.Id == prediction.Team_Id).Short,
PredictionType = prediction.PredictionType_Id,
Points = prediction.Points.ToString()
};
predictionList.Add(predictionLine);
}
return predictionList;
}
private List<SecondRoundPrediction> GetSecoundroutePrediction(List<Prediction> participantPredictions, int predictionType)
{
var secondRoundPredictions = participantPredictions.Where(p => p.PredictionType_Id == predictionType).ToList();
var secondRoundPredictionList = new List<SecondRoundPrediction>();
var teams = db.Teams.ToList();
foreach (var secondRoundPrediction in secondRoundPredictions)
{
var teamName = teams.Single(t => t.Id == secondRoundPrediction.Team_Id).Team1;
var prediction = new SecondRoundPrediction
{
TeamName = teamName,
Points = secondRoundPrediction.Points.ToString()
};
secondRoundPredictionList.Add(prediction);
}
return secondRoundPredictionList;
}