/// <summary>
/// Pobieranie wyniki rozgrywek
/// </summary>
/// <returns>List<Result></returns>
public async static Task <List <Result> > GetResultsAsync()
{
using (var context = new QuizEntityContext())
{
return(await context.Results.AsNoTracking().Include(q => q.Category).OrderByDescending(q => q.CreatedOn).ToListAsync());
}
}
/// <summary>
/// Pobiera pytania z danej kategorii losuje i zwraca 7
/// </summary>
/// <param name="categoryId">Id kategorii</param>
/// <returns>Lista pomieszanych pytań</returns>
public static async Task <List <Question> > GetQuestions(int categoryId)
{
using (var context = new QuizEntityContext())
{
return(await context.Questions.Where(q => q.CategoryId == categoryId && q.QuestionLevel == Level).OrderBy(q => new Guid()).Take(7).ToListAsync());
}
}
public static async Task <List <Category> > GetCategories()
{
using (var context = new QuizEntityContext())
{
List <Category> categories = await context.Categories.ToListAsync();
return(categories);
}
}
/// <summary>
/// Zapisuje wynik quizu
/// </summary>
/// <returns>void</returns>
public async static Task SaveQuizResult()
{
Result result = new Result()
{
CategoryId = CategoryController.ChoosedCategory.Id,
Points = CollectedPoints,
UserName = UserController.Name,
CreatedOn = DateTime.Now
};
using (var context = new QuizEntityContext())
{
context.Results.Add(result);
await context.SaveChangesAsync();
}
}
