private void FillGrid()
{
using (var context = new LearningToolDBEntities())
{
var x = from tr in context.TestingResults
where tr.UserId == _userId
select new
{
Chapter = tr.Chapter,
Result = tr.Mark,
Date = tr.Date
};
TestResultGridView.DataSource = x.ToList();
TestResultGridView.Columns[0].HeaderText = @"Глава";
TestResultGridView.Columns[1].HeaderText = @"Оценка";
TestResultGridView.Columns[2].HeaderText = @"Дата прохождения";
foreach (var column in TestResultGridView.Columns)
{
column.TextAlignment = ContentAlignment.MiddleCenter;
}
}
}
private bool IsUnique()
{
using (var context = new LearningToolDBEntities())
{
var users = from user in context.Users
where user.Login == LoginTextBox.Text
select user;
return(!users.Any());
}
}
private static bool Аuthorization(string login, string password)
{
using (var context = new LearningToolDBEntities())
{
var user = context.Users.FirstOrDefault(u => u.Login == login);
if (user == null || user.Password != password)
{
return(false);
}
RememberUser(user);
return(true);
}
}
private void SaveResult()
{
using (var context = new LearningToolDBEntities())
{
try
{
context.TestingResults.Add(new TestingResult
{
Date = DateTime.Now,
Mark = correctAnswersCount,
UserId = UserProfile.Id,
Chapter = ChapterNameLabel.Text
});
context.SaveChanges();
}
catch (Exception e)
{
MessageBox.Show(@"Результат не сохранён. Авторизируйтесь!");
}
}
}
private void FillData(int chapterId)
{
using (var context = new LearningToolDBEntities())
{
var questions = from ch in context.Chapters
where ch.Id == chapterId
select ch.Questions;
foreach (var q in questions)
{
questionList = new List <Question>(q);
}
answersList = new List <List <Answer> >();
foreach (var question in questionList)
{
answersList.Add(new List <Answer>(question.Answers));
}
ChapterNameLabel.Text = context.Chapters.Find(chapterId)?.Name;
}
}
private void AddUser()
{
using (var context = new LearningToolDBEntities())
{
var user = new User
{
Login = LoginTextBox.Text,
Password = PasswordTextBox.Text,
};
context.Users.Add(user);
context.SaveChanges();
var userInfo = new UserInformation
{
Name = NameTextBox.Text,
SecondName = SecondNameTextBox.Text,
//Groupe = groupe,
Id = user.Id
};
context.UserInformations.Add(userInfo);
context.SaveChanges();
}
}
