private async Task GetTest()
{
using (var db = new MSGCoreContext())
{
Tests = await db.Test.ToListAsync();
}
}
private async Task GetSection()
{
await using (var db = new MSGCoreContext())
{
Sections = await db.Section.ToListAsync();
Articles = await db.Article.ToListAsync();
PhotosMain = await db.Photo.ToListAsync();
var firstArticleId = Articles.Select(p => p.ArticleId).FirstOrDefault();
Photos = await db.Photo.Where(p => p.ArticleId == firstArticleId).ToListAsync();
}
}
private async Task GetUser()
{
using (var db = new MSGCoreContext())
{
Firstname = await db.Users.Where(p => p.UserId == GetUserId).Select(p => p.Firstname)
.FirstOrDefaultAsync();
Surname = await db.Users.Where(p => p.UserId == GetUserId).Select(p => p.Surname)
.FirstOrDefaultAsync();
Results = db.Test
.Where(p => p.Result.Select(p => p.TestId).First() == p.TestId &&
p.Result.Where(c => c.UserId == GetUserId).Select(p => p.UserId).First() == GetUserId)
.Select(p => p.TestName).ToList();
}
}
