protected IEnumerable <DecimalQuizResult> GetDecimalQuizResultsFromDb(UserStatsSearch search)
{
IEnumerable <DecimalQuizResult> results = new List <DecimalQuizResult>();
using (var entitiesContext = new MathsQuizEntities())
{
results = entitiesContext.DecimalQuizResults
.Where(r => r.QuizUser.Equals(search.User))
.Where(r => r.QuizDate > search.FromDate)
.Where(r => r.QuizDate <= search.ToDate)
.OrderBy(r => r.QuizDate);
results = results.ToList();
}
return(results);
}
public IEnumerable <UserResultsSummary> GetUserResultsSummary(UserStatsSearch search)
{
var results = new List <UserResultsSummary>();
using (var entitiesContext = new MathsQuizEntities())
{
var stats = entitiesContext.GetSummaryStats(search.User, search.FromDate, search.ToDate).ToList();
stats.ForEach(s =>
results.Add(
new UserResultsSummary {
QuizType = s.QuizType,
AverageCorrectPerQuiz = s.AvgCorrectPerQuiz ?? 0,
AverageQuestionsPerQuiz = s.AvgCorrectPerQuiz ?? 0,
QuizzesTaken = s.QuizzesTaken ?? 0,
QuizzesWithOverMinCorrectAnswers = s.QuizzesOverMinAnswers ?? 0,
TotalCorrect = s.TotalCorrect ?? 0,
TotalQuestions = s.TotalQuestionsAnswered ?? 0
}));
}
return(results);
}
public IEnumerable <DecimalQuizResult> GetDecimalQuizResults(UserStatsSearch search)
{
return(GetDecimalQuizResultsFromDb(search));
}
public IEnumerable <MultiplicationQuizResult> GetMultiplicationQuizResults(UserStatsSearch search)
{
return(GetMultiplicationQuizResultsFromDb(search));
}
