private void button3_Click(object sender, EventArgs e) { int correctAnswerCount = 0; foreach (KeyValuePair <MyQuestion, Answer> item in result) { if (item.Value.CorrectAnswer == true) { correctAnswerCount++; } } int markPercents = (correctAnswerCount * 100) / myQuestions.Count; using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { Mark mark = new Mark() { ID_exam = currentExam.ID, ID_student = student.ID, Mark1 = markPercents }; ExamDB.Marks.Add(mark); ExamDB.SaveChanges(); } MessageBox.Show("Exam completed! Your result is " + markPercents + "%."); this.Owner.Owner.Show(); this.Owner.Close(); this.Close(); }
private void ExamProcessForm_Load(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { pageCounter = 0; ExamNameLabel.Text = currentExam.Name; result = new Dictionary <MyQuestion, Answer>(); var questions = from req in ExamDB.RelationExamsQuestions from ex in ExamDB.Exams from q in ExamDB.Questions where ex.ID == req.ID_exam && q.ID == req.ID_Question && ex.ID == currentExam.ID select new MyQuestion //класс-контейнер { QuestionID = q.ID, QuestionText = q.Name }; List <Answer> answers = new List <Answer>(); questions.ToList(); foreach (var question in questions) { answers.AddRange(ExamDB.Answers.Where(a => a.ID_question == question.QuestionID)); } QuestionTextLabel.Text = questions.First().QuestionText; checkBox1.Text = answers[0].QuestionText; checkBox2.Text = answers[1].QuestionText; myQuestions = new List <MyQuestion>(questions); myAnswers = new List <Answer>(answers); } }
private void PassExamButton_Click(object sender, EventArgs e) { Exam currentExam = new Exam(); bool success = false; using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { foreach (var exam in ExamDB.Exams) { if (exam.ID == Int32.Parse(IncompletedExamsGridView.CurrentRow.Cells["ID"].Value.ToString())) { currentExam = exam; success = true; } } } if (success == true) { ExamProcessForm examProcessForm = new ExamProcessForm(student, currentExam); examProcessForm.Show(this); this.Hide(); } else { MessageBox.Show("Something went wrong!"); } }
private void IncompletedExamsForm_Load(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var currentStudentMarks = from marks in ExamDB.Marks //запрос содержит оценки студента where marks.ID_student == student.ID select new { marks.ID, marks.ID_exam, marks.ID_student, marks.Mark1 }; var incompletedExams = from ex in ExamDB.Exams //экзамены текущего студента, where currentStudentMarks.Select(m => m.ID_exam) //по которым нет .Contains(ex.ID) == false //оценок from sub in ExamDB.Subjects where ex.ID_subjects == sub.ID select new { ex.Name, Subject = sub.Name, ex.Exam_date, ex.ID }; IncompletedExamsGridView.DataSource = incompletedExams.ToList(); } }
private void ComletedExamsForm_Load(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var query = from ex in ExamDB.Exams from su in ExamDB.Subjects from mar in ExamDB.Marks where mar.ID_exam == ex.ID && ex.ID_subjects == su.ID && mar.ID_student == student.ID select new { Subject_Name = su.Name, Exam_Name = ex.Name, Mark = mar.Mark1 }; CompletedExamsGridView.DataSource = query.ToList(); } }
private void LoginButton_Click(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { //IQueryable<User> CurrentUser = ExamDB.Users.Where(u => u.Login == LoginTextBox.Text); //if (CurrentUser.FirstOrDefault() == null) //{ // MessageBox.Show("Login is incorrect!"); //} //else if (CurrentUser.FirstOrDefault().Password != PasswordTextBox.Text) //{ // MessageBox.Show("Password is incorrect!"); //} //else if (CurrentUser.FirstOrDefault().ID_roles == 1) //{ // this.Hide(); // AdminMenuForm adminMenuForm = new AdminMenuForm(CurrentUser); // adminMenuForm.Show(); //} //else if (CurrentUser.FirstOrDefault().ID_roles == 3) //{ // this.Hide(); // StudentMenuForm studentMenuForm = new StudentMenuForm(CurrentUser); // studentMenuForm.Show(); //} User CurrentUser = null; foreach (User user in ExamDB.Users) { if (user.Login == LoginTextBox.Text) { CurrentUser = user; } } if (CurrentUser == null) { MessageBox.Show("Login is incorrect!"); } else if (CurrentUser.Password != PasswordTextBox.Text) { MessageBox.Show("Password is incorrect!"); } else if (CurrentUser.ID_roles == 1) { AdminMenuForm adminMenuForm = new AdminMenuForm(CurrentUser); adminMenuForm.Show(this); this.Hide(); } else if (CurrentUser.ID_roles == 3) { StudentMenuForm studentMenuForm = new StudentMenuForm(CurrentUser); studentMenuForm.Show(this); this.Hide(); } else if (CurrentUser.ID_roles == 2) { TeacherMenuForm teacherMenuForm = new TeacherMenuForm(CurrentUser); teacherMenuForm.Show(this); this.Hide(); } } }