public MyResults()
{
InitializeComponent();
using (Context db = new Context())
{
var completed = from compl in db.CompletedTest where compl.UserLogin == Class.CurrentUser.user.Login select compl;
List <Class.Completed> completedTests = new List <Class.Completed>();
try
{
foreach (CompletedTest test in completed)
{
var currentTest = db.Tests.Where(t => t.Id == test.TestId).First();
Class.Completed compl = new Class.Completed
{
UserLogin = "",
TestName = currentTest.Header,
TestTheme = currentTest.Topic,
Result = test.Result,
Date = test.Date
};
completedTests.Add(compl);
}
ResultGrid.ItemsSource = completedTests;
}
catch (NullReferenceException)
{
ResultGrid.ItemsSource = null;
MessageBox.Show((string)Application.Current.Resources["havent"]);
}
}
}
public TestResults()
{
InitializeComponent();
using (Context db = new Context())
{
var completed = from compl in db.CompletedTest select compl;
List <Class.Completed> completedTests = new List <Class.Completed>();
foreach (CompletedTest test in completed) // в таблице CompletedTest хранится только Id теста
{
var currentTest = db.Tests.Where(t => t.Id == test.TestId).First(); // поэтому мы берём название и тему из таблицы Tests по Id выполненного теста
Class.Completed compl = new Class.Completed
{
UserLogin = test.UserLogin,
TestName = currentTest.Header,
TestTheme = currentTest.Topic,
Result = test.Result,
Date = test.Date
};
completedTests.Add(compl);
}
ResultGrid.ItemsSource = completedTests;
}
}
