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!");
}
}
}
