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; } }