private void EditUserForm_Load(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { foreach (User user in ExamDB.Users) { if (user.Login == userLogin) { currentUser = user; } } } LoginTextBox.Text = currentUser.Login; PasswordTextBox.Text = currentUser.Password; LNameTextBox.Text = currentUser.LName; FnameTextBox.Text = currentUser.FName; PhoneTextBox.Text = currentUser.Phone; if (currentUser.ID_roles == 1) { RoleComboBox.SelectedItem = RoleComboBox.Items[2]; } else if (currentUser.ID_roles == 2) { RoleComboBox.SelectedItem = RoleComboBox.Items[1]; } else if (currentUser.ID_roles == 3) { RoleComboBox.SelectedItem = RoleComboBox.Items[0]; } }
private void SaveExamButton_Click(object sender, EventArgs e) { if (textBox1.Text.Length == 0) { MessageBox.Show("Enter exam name!"); } else { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { Exam exam = new Exam() { ID_subjects = int.Parse(textBox2.Text), Name = textBox1.Text, Exam_date = DateTime.Now }; List <RelationExamsQuestion> relationExamsQuestions = new List <RelationExamsQuestion>(); foreach (int item in questionIdList) { relationExamsQuestions.Add(new RelationExamsQuestion() { ID_exam = exam.ID, ID_Question = item }); } ExamDB.Exams.Add(exam); ExamDB.RelationExamsQuestions.AddRange(relationExamsQuestions); ExamDB.SaveChanges(); } MessageBox.Show("Exam added!"); this.Owner.Show(); this.Close(); } }
private void DeleteSubjectButton_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox .Show("Are you sure?", "Deleting group", MessageBoxButtons.OKCancel); if (dialogResult == DialogResult.OK) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { Subject subject = new Subject(); foreach (Subject subject1 in ExamDB.Subjects) { if (subject1.ID == int.Parse(dataGridView1.CurrentRow.Cells["ID"] .Value.ToString())) { subject = subject1; } } ExamDB.RelationSubjectsGroups.RemoveRange(ExamDB.RelationSubjectsGroups .Where(r => r.ID_subject == subject.ID)); ExamDB.RelationTeacherSubjects.RemoveRange(ExamDB.RelationTeacherSubjects .Where(r => r.ID_Subject == subject.ID)); ExamDB.Subjects.Remove(subject); ExamDB.SaveChanges(); } MessageBox.Show("Subject deleted successfully!"); } }
private void button1_Click(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { Question question = new Question() { Name = textBox1.Text, }; Answer answer1 = new Answer() { ID_question = question.ID, QuestionText = FirstAnswerTextBox.Text, CorrectAnswer = checkBox1.Checked }; Answer answer2 = new Answer() { ID_question = question.ID, QuestionText = SecondAnswerTextBox.Text, CorrectAnswer = checkBox2.Checked }; ExamDB.Questions.Add(question); ExamDB.Answers.Add(answer1); ExamDB.Answers.Add(answer2); ExamDB.SaveChanges(); } MessageBox.Show("Question Added!"); }
private void CreateExamsForm_Load(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var query = from q in ExamDB.Questions select new { q.Name, q.ID }; dataGridView1.DataSource = query.ToList(); } }
private void button2_Click(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var query = from g in ExamDB.Groups select new { g.Name, g.ID }; dataGridView1.DataSource = query.ToList(); } }
private void ActionsWithSubjectsForm_Load(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var query = from su in ExamDB.Subjects select new { su.Name, su.ID }; dataGridView1.DataSource = query.ToList(); } }
private void ShowGroupsButton_Click(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var query = from su in ExamDB.Subjects select new { su.Name, su.ID }; dataGridView1.DataSource = query.ToList(); } ShowTeachersButton.Enabled = true; }
private void button1_Click(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { RelationTeacherSubject relationTeacherSubject = new RelationTeacherSubject() { ID_teacher = user.ID, ID_Subject = int.Parse(dataGridView1.CurrentRow.Cells["ID"].Value.ToString()) }; ExamDB.RelationTeacherSubjects.Add(relationTeacherSubject); ExamDB.SaveChanges(); } MessageBox.Show("Teacher assigned!"); this.Close(); }
private void ObserveSubjectsForm_Load(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var query = from s in ExamDB.Subjects from r in ExamDB.RelationTeacherSubjects from t in ExamDB.Users where r.ID_Subject == s.ID && r.ID_teacher == t.ID && t.ID == teacher.ID select new { s.Name }; dataGridView1.DataSource = query.ToList(); } }
private void ShowTeachersButton_Click(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { int groupId = int.Parse(dataGridView1.CurrentRow.Cells["ID"].Value.ToString()); var query = from s in ExamDB.Users from g in ExamDB.Groups where groupId == s.ID_group select new { Group_name = g.Name, Student = s.LName + " " + s.FName }; dataGridView1.DataSource = query.ToList(); } ShowTeachersButton.Enabled = false; }
private void RegisterUserButton_Click(object sender, EventArgs e) { foreach (TextBox item in groupBox1.Controls) { if (item.Text.Length == 0) { MessageBox.Show("All fields must be filled!"); return; } } using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { foreach (User user in ExamDB.Users) { if (user.ID == currentUser.ID) { user.Login = LoginTextBox.Text; user.Password = PasswordTextBox.Text; switch (RoleComboBox.SelectedItem) { case "Student": user.ID_roles = 3; break; case "Teacher": user.ID_roles = 2; break; case "Admin": user.ID_roles = 1; break; default: user.ID_roles = 3; break; } user.LName = LNameTextBox.Text; user.FName = FnameTextBox.Text; user.Arrival_date = DateTime.Now; user.Phone = PhoneTextBox.Text; if (dataGridView1.CurrentRow != null) { user.ID_group = Int32.Parse(dataGridView1.CurrentRow.Cells["ID"].Value.ToString()); } } } ExamDB.SaveChanges(); } MessageBox.Show("User edited successfully!"); this.Owner.Show(); this.Close(); }
private void ShowUsers(int roleId) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var query = from u in ExamDB.Users from g in ExamDB.Groups where u.ID_roles == roleId //&& u.ID_group == g.ID select new { u.Login, u.FName, u.LName, u.Phone, u.Arrival_date, u.ID_roles }; dataGridView1.DataSource = query.ToList(); } }
private void ShowTeachersButton_Click(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { int subjectId = int.Parse(dataGridView1.CurrentRow.Cells["ID"].Value.ToString()); var query = from t in ExamDB.Users from s in ExamDB.Subjects from r in ExamDB.RelationTeacherSubjects where t.ID == r.ID_teacher && r.ID_Subject == subjectId && r.ID_Subject == s.ID select new { Subject_name = s.Name, Teacher_name = t.LName + " " + t.FName }; dataGridView1.DataSource = query.ToList(); } ShowTeachersButton.Enabled = false; }
private void AssignTeachersForm_Load(object sender, EventArgs e) { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { var query = from s in ExamDB.Subjects select new { s.Name, s.ID }; dataGridView1.DataSource = query.ToList(); foreach (User user in ExamDB.Users) { if (user.Login == login) { this.user = user; } } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Length == 0) { MessageBox.Show("Enter group name!"); } else { using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { Group subject = new Group() { Name = textBox1.Text }; ExamDB.Groups.Add(subject); ExamDB.SaveChanges(); MessageBox.Show("Group added successfully!"); } this.Close(); } }
private void button5_Click(object sender, EventArgs e) { if (dataGridView1.DataSource == null) { MessageBox.Show("Select user to edit!"); } using (ExamTestSystemEntities ExamDB = new ExamTestSystemEntities()) { foreach (User user in ExamDB.Users) { if (user.Login == dataGridView1.CurrentRow.Cells["Login"].Value.ToString()) { ExamDB.Users.Remove(user); } } DialogResult dialogResult = MessageBox.Show("Are you sure?", "Deleting user", MessageBoxButtons.OKCancel); if (dialogResult == DialogResult.OK) { ExamDB.SaveChanges(); MessageBox.Show("User deleted!"); } } }