private void ShowData()
{
lblFullName.Text = acc.FullName;
// clear table first show list students
dgvHistoryCreateExam.Rows.Clear();
int viTriDong, dem = 0;
using (var _dbContext = new QuizContextDB())
{
foreach (Exam exam in _dbContext.Exams.Where(p => p.AccountID == acc.AccountID).ToList())
{
if (exam != null)
{
dem++;
viTriDong = dgvHistoryCreateExam.Rows.Add();
dgvHistoryCreateExam.Rows[viTriDong].Cells[0].Value = exam.ExamID;
dgvHistoryCreateExam.Rows[viTriDong].Cells[1].Value = exam.ExamName;
dgvHistoryCreateExam.Rows[viTriDong].Cells[2].Value = exam.Subject.SubjectName;
dgvHistoryCreateExam.Rows[viTriDong].Cells[3].Value = exam.Account.Class1.Faculty.FacultyName;
dgvHistoryCreateExam.Rows[viTriDong].Cells[4].Value = exam.dateCreate;
dgvHistoryCreateExam.Rows[viTriDong].Cells[5].Value = exam.TotalQuiz;
}
}
}
}
private void cmbSubjectSearch_SelectedIndexChanged(object sender, EventArgs e)
{
dgvSearchResult.Rows.Clear();
int viTriDong, dem = 0;
using (var _dbContext = new QuizContextDB())
{
Subject subject = _dbContext.Subjects.FirstOrDefault(p => p.SubjectName == cmbSubjectSearch.Text);
if (subject != null)
{
foreach (Exam exam in _dbContext.Exams.Where(p => p.SubjectID == subject.SubjectID).ToList())
{
dem++;
viTriDong = dgvSearchResult.Rows.Add();
dgvSearchResult.Rows[viTriDong].Cells[0].Value = exam.ExamID;
dgvSearchResult.Rows[viTriDong].Cells[1].Value = exam.ExamName;
dgvSearchResult.Rows[viTriDong].Cells[2].Value = exam.Account.Faculty1.FacultyName;
dgvSearchResult.Rows[viTriDong].Cells[3].Value = exam.Account.Class1.ClassName;
dgvSearchResult.Rows[viTriDong].Cells[4].Value = exam.Account.FullName;
dgvSearchResult.Rows[viTriDong].Cells[5].Value = exam.Subject.SubjectName;
dgvSearchResult.Rows[viTriDong].Cells[6].Value = exam.dateCreate;
}
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtExamID.Text == "")
{
MessageBox.Show("Mã kỳ thi rỗng !!!");
return;
}
if (txtExamName.Text == "" || txtFacultyName.Text == "" || quantityQuiz.Value == 0 || quantityTime.Value == 0)
{
MessageBox.Show("Vui lòng nhập đủ các thông tin !!!");
return;
}
if (txtNameTeacher.Text != acc.FullName)
{
MessageBox.Show("Bạn không có quyền sửa đề thi này!");
return;
}
int idExam = int.Parse(txtExamID.Text.ToString());
using (var _dbContext = new QuizContextDB())
{
Exam exam = _dbContext.Exams.FirstOrDefault(p => p.ExamID == idExam);
if (exam != null)
{
exam.ExamName = txtExamName.Text;
exam.TotalQuiz = int.Parse(quantityQuiz.Value.ToString());
exam.TimeTotal = int.Parse(quantityTime.Value.ToString());
exam.SubjectID = cmbSubject.SelectedValue.ToString();
_dbContext.SaveChanges();
}
MessageBox.Show("Cập nhập thành công");
ShowDgv();
}
}
private void ShowDataCmb()
{
QuizContextDB context = new QuizContextDB();
List <Faculty> listFaculty = context.Faculties.ToList();
cmbFacultyName.DataSource = listFaculty;
cmbFacultyName.DisplayMember = "FacultyName";
cmbFacultyName.ValueMember = "FacultyName";
}
private void ShowCmbSearchSubject(string nameFaculty)
{
QuizContextDB context = new QuizContextDB();
List <Subject> listSubject = context.Subjects.Where(p => p.Faculty.FacultyName == nameFaculty).ToList();
cmbSubjectSearch.DataSource = listSubject;
cmbSubjectSearch.DisplayMember = "SubjectName";
cmbSubjectSearch.ValueMember = "SubjectName";
}
private void btnDone_Click(object sender, EventArgs e)
{
List <GroupBox> listGrBox = new List <GroupBox>();
List <RadioButton> listRdo = new List <RadioButton>();
foreach (GroupBox grBox in panelAllQuiz.Controls.OfType <GroupBox>())
{
foreach (RadioButton rdo in grBox.Controls.OfType <RadioButton>())
{
if (rdo.Checked == true)
{
listRdo.Add(rdo);
listGrBox.Add(grBox);
}
}
}
DialogResult dialogResult = MessageBox.Show("Xác nhận nộp bài ?", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var _dbContext = new QuizContextDB())
{
foreach (GroupBox grBoxComplite in listGrBox)
{
foreach (RadioButton rdoBtn in listRdo)
{
foreach (Answer answer in _dbContext.Answers.ToList()
.Where(p => p.QuizID == int.Parse(grBoxComplite.Name) && p.Correct == 1.ToString() && p.AnswerID == int.Parse(rdoBtn.Name)))
{
this.demCorrect++;
}
}
}
float quantityCorrect = float.Parse(demCorrect.ToString());
float pointPerQuiz = (float)((float)10 / float.Parse(demQuantityQuiz.ToString()));
float pointResult = quantityCorrect * pointPerQuiz;
Result result = new Result();
result.AccountID = acc.AccountID;
result.ExamID = this.examID;
result.DateExam = DateTime.Now;
result.Scores = pointResult;
_dbContext.Results.Add(result);
_dbContext.SaveChanges();
ShowFrmResultExam(result);
this.Close();
}
}
}
private void ShowDataResult()
{
using (var _dbContext = new QuizContextDB())
{
Account acc = _dbContext.Accounts.FirstOrDefault(p => p.AccountID == result.AccountID);
Exam exam = _dbContext.Exams.FirstOrDefault(p => p.ExamID == result.ExamID);
lblNameExam.Text = exam.ExamName;
lblFullName.Text = acc.FullName;
lblScore.Text = result.Scores.ToString();
lblDateExam.Text = result.DateExam.ToString();
}
}
private void ShowListQuiz(Exam examFind)
{
using (var _dbContext = new QuizContextDB())
{
int dem = 0, demAnswer = 1;
int y = 60, x = 55;
int grVertical = 0;
foreach (Quiz quiz in _dbContext.Quizs.ToList().Where(p => p.ExamID == this.examID))
{
dem++;
this.demQuantityQuiz++;
this.nameGr = quiz.QuizID.ToString();
GroupBox nameGr = new GroupBox();
nameGr.SuspendLayout();
nameGr.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
nameGr.Controls.Add(CreateTitleQuiz(quiz.QuizName, dem));
foreach (Answer answer in _dbContext.Answers.ToList().Where(p => p.QuizID == quiz.QuizID))
{
if (demAnswer == 2)
{
x += 45;
}
if (demAnswer >= 3)
{
_ = x == 100 ? x = 55 : x += 45;
y = 550;
}
nameGr.Controls.Add(CreateAwserQuiz(answer.ContentAnswer, demAnswer, x, y, answer.AnswerID));
demAnswer++;
}
nameGr.Location = new System.Drawing.Point(0, grVertical);
nameGr.Name = this.nameGr; //nameGr.ToString()
nameGr.Size = new System.Drawing.Size(1110, 137);
nameGr.TabIndex = 6;
nameGr.TabStop = false;
nameGr.ResumeLayout(false);
nameGr.PerformLayout();
grVertical += 135;
demAnswer = 1;
y = 60;
x = 55;
this.panelAllQuiz.Controls.Add(nameGr);
}
lblTotalDone.Text = dem.ToString();
}
}
private void cmbSearchSubject_SelectedValueChanged(object sender, EventArgs e)
{
dgvAllExam.Rows.Clear();
int viTriDong, dem = 0;
using (var _dbContext = new QuizContextDB())
{
foreach (Exam exam in _dbContext.Exams.Where(p => p.Subject.SubjectName == cmbSearchSubject.Text).ToList())
{
dem++;
viTriDong = dgvAllExam.Rows.Add();
dgvAllExam.Rows[viTriDong].Cells[0].Value = exam.ExamName;
dgvAllExam.Rows[viTriDong].Cells[1].Value = exam.ExamID;
dgvAllExam.Rows[viTriDong].Cells[2].Value = exam.Subject.SubjectName;
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtExamID.Text == "")
{
MessageBox.Show("Mã kỳ thi rỗng !!");
return;
}
using (var _dbContext = new QuizContextDB())
{
DialogResult dialogResult = MessageBox.Show("Bạn có chắc muốn xóa kỳ thi này ?", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int idExam = int.Parse(txtExamID.Text.ToString());
Exam exam = _dbContext.Exams.FirstOrDefault(p => p.ExamID == idExam);
foreach (Result i in _dbContext.Results.Where(p => p.ExamID == idExam).ToList())
{
_dbContext.Results.Remove(i);
}
//foreach (Quiz i in _dbContext.Quizs.Where(p => p.ExamID == idExam).ToList())
//{
// _dbContext.Quizs.Remove(i);
//}
if (exam != null)
{
Quiz quiz = _dbContext.Quizs.FirstOrDefault(p => p.ExamID == idExam);
if (quiz != null)
{
Answer answer = _dbContext.Answers.FirstOrDefault(p => p.QuizID == quiz.QuizID);
if (answer != null)
{
_dbContext.Answers.Remove(answer);
}
}
_dbContext.Exams.Remove(exam);
_dbContext.SaveChanges();
MessageBox.Show("Xóa thành công");
ShowDgv();
RestDataForm();
}
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
}
private void dgvAllExam_CellClick(object sender, DataGridViewCellEventArgs e)
{
int rowSelected = e.RowIndex;
txtExamName.Text = dgvAllExam.Rows[rowSelected].Cells[0].Value.ToString();
txtExamID.Text = dgvAllExam.Rows[rowSelected].Cells[1].Value.ToString();
cmbSubject.Text = dgvAllExam.Rows[rowSelected].Cells[2].Value.ToString();
int idExam = int.Parse(dgvAllExam.Rows[rowSelected].Cells[1].Value.ToString());
using (var _dbContext = new QuizContextDB())
{
Exam exam = _dbContext.Exams.FirstOrDefault(p => p.ExamID == idExam);
txtNameTeacher.Text = exam.Account.FullName;
quantityQuiz.Value = int.Parse(exam.TotalQuiz.ToString());
quantityTime.Value = int.Parse(exam.TimeTotal.ToString());
txtFacultyName.Text = acc.Faculty1.FacultyName;
}
}
private void ShowDgv()
{
// clear table first show list students
dgvAllExam.Rows.Clear();
int viTriDong, dem = 0;
using (var _dbContext = new QuizContextDB())
{
foreach (Exam exam in _dbContext.Exams.Where(p => p.Subject.FacultyID == acc.Faculty).ToList())
{
dem++;
viTriDong = dgvAllExam.Rows.Add();
dgvAllExam.Rows[viTriDong].Cells[0].Value = exam.ExamName;
dgvAllExam.Rows[viTriDong].Cells[1].Value = exam.ExamID;
dgvAllExam.Rows[viTriDong].Cells[2].Value = exam.Subject.SubjectName;
}
}
}
private void RenderData()
{
ShowDgv();
using (var _dbContext = new QuizContextDB())
{
List <Subject> subject = _dbContext.Subjects.Where(p => p.FacultyID == acc.Faculty1.FacultyID).ToList();
this.cmbSubject.DataSource = subject;
this.cmbSubject.DisplayMember = "SubjectName";
this.cmbSubject.ValueMember = "SubjectID";
List <Subject> subjectSearch = _dbContext.Subjects.Where(p => p.FacultyID == acc.Faculty1.FacultyID).ToList();
this.cmbSearchSubject.DataSource = subjectSearch;
this.cmbSearchSubject.DisplayMember = "SubjectName";
this.cmbSearchSubject.ValueMember = "SubjectID";
}
txtNameTeacher.Text = acc.FullName;
txtFacultyName.Text = acc.Faculty1.FacultyName;
ShowDgv();
}
private void ShowDetailExam()
{
using (var _dbContext = new QuizContextDB())
{
Exam examFind = _dbContext.Exams.FirstOrDefault(p => p.ExamID == examID);
if (examFind != null)
{
lblExamName.Text = examFind.ExamName;
lblSubjectName.Text = examFind.Subject.SubjectName;
lblDateStart.Text = DateTime.Now.ToShortDateString();
lblFullName.Text = acc.FullName;
lblStudentID.Text = acc.AccountID;
lblClass.Text = acc.Class1.ClassName;
StartCountDown(int.Parse(examFind.TimeTotal.ToString()));
ShowListQuiz(examFind);
}
}
}
private void SearchForName()
{
dgvSearchResult.Rows.Clear();
int viTriDong, dem = 0;
using (var _dbContext = new QuizContextDB())
{
foreach (Exam exam in _dbContext.Exams.Where(p => p.ExamName.Contains(txtExamName.Text)).ToList())
{
dem++;
viTriDong = dgvSearchResult.Rows.Add();
dgvSearchResult.Rows[viTriDong].Cells[0].Value = exam.ExamID;
dgvSearchResult.Rows[viTriDong].Cells[1].Value = exam.ExamName;
dgvSearchResult.Rows[viTriDong].Cells[2].Value = exam.Account.Faculty1.FacultyName;
dgvSearchResult.Rows[viTriDong].Cells[3].Value = exam.Account.Class1.ClassName;
dgvSearchResult.Rows[viTriDong].Cells[4].Value = exam.Account.FullName;
dgvSearchResult.Rows[viTriDong].Cells[5].Value = exam.Subject.SubjectName;
dgvSearchResult.Rows[viTriDong].Cells[6].Value = exam.dateCreate;
}
}
}
private void ShowAllExam()
{
// clear table first show list students
dgvSearchResult.Rows.Clear();
int viTriDong, dem = 0;
using (var _dbContext = new QuizContextDB())
{
foreach (Exam exam in _dbContext.Exams.ToList())
{
dem++;
viTriDong = dgvSearchResult.Rows.Add();
dgvSearchResult.Rows[viTriDong].Cells[0].Value = exam.ExamID;
dgvSearchResult.Rows[viTriDong].Cells[1].Value = exam.ExamName;
dgvSearchResult.Rows[viTriDong].Cells[2].Value = exam.Account.Faculty1.FacultyName;
dgvSearchResult.Rows[viTriDong].Cells[3].Value = exam.Account.Class1.ClassName;
dgvSearchResult.Rows[viTriDong].Cells[4].Value = exam.Account.FullName;
dgvSearchResult.Rows[viTriDong].Cells[5].Value = exam.Subject.SubjectName;
dgvSearchResult.Rows[viTriDong].Cells[6].Value = exam.dateCreate;
}
}
}
private void ShowData()
{
lblFullName.Text = acc.FullName;
dgvHistoryExam.Rows.Clear();
int viTriDong, dem = 0;
using (var _dbContext = new QuizContextDB())
{
foreach (Result result in _dbContext.Results.Where(p => p.AccountID == acc.AccountID).ToList())
{
if (result != null)
{
dem++;
viTriDong = dgvHistoryExam.Rows.Add();
dgvHistoryExam.Rows[viTriDong].Cells[0].Value = result.Exam.ExamID;
dgvHistoryExam.Rows[viTriDong].Cells[1].Value = result.Exam.ExamName;
dgvHistoryExam.Rows[viTriDong].Cells[2].Value = result.Exam.Subject.SubjectName;
dgvHistoryExam.Rows[viTriDong].Cells[3].Value = result.Scores;
dgvHistoryExam.Rows[viTriDong].Cells[4].Value = result.DateExam;
}
}
}
}
private void txtSearchNameExam_TextChanged(object sender, EventArgs e)
{
if (txtSearchNameExam.Text == "")
{
ShowDgv();
return;
}
// clear table first show list students
dgvAllExam.Rows.Clear();
int viTriDong, dem = 0;
using (var _dbContext = new QuizContextDB())
{
foreach (Exam exam in _dbContext.Exams.Where(p => p.ExamName.Contains(txtSearchNameExam.Text)).ToList())
{
dem++;
viTriDong = dgvAllExam.Rows.Add();
dgvAllExam.Rows[viTriDong].Cells[0].Value = exam.ExamName;
dgvAllExam.Rows[viTriDong].Cells[1].Value = exam.ExamID;
dgvAllExam.Rows[viTriDong].Cells[2].Value = exam.Subject.SubjectName;
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string email = txtEmail.Text.Trim();
string password = txtPassword.Text.Trim();
if (string.IsNullOrEmpty(email) || string.IsNullOrEmpty(password))
{
MessageBox.Show("Wrong username or password", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Hand);
return;
}
using (var _dbContext = new QuizContextDB())
{
Account acc = _dbContext.Accounts.Where(p => p.Email == email).FirstOrDefault();
Account acc1 = _dbContext.Accounts.Where(p => p.Password == password).FirstOrDefault();
if (acc == null && acc1 == null)
{
MessageBox.Show("Đăng nhập thất bại");
}
else if (acc == null && acc1 != null)
{
MessageBox.Show("Không tìm thấy email này");
}
else if (acc != null && acc1 == null)
{
MessageBox.Show("Sai mật khẩu");
}
else
{
if (accountAuthentication != null)
{
accountAuthentication(acc);
}
this.Close();
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtExamName.Text == "" || txtFacultyName.Text == "" || quantityQuiz.Value == 0 || quantityTime.Value == 0)
{
MessageBox.Show("Vui lòng điền đủ thông tin !");
return;
}
if (txtExamID.Text != "")
{
this.examID = int.Parse(txtExamID.Text.ToString());
}
using (var _dbContext = new QuizContextDB())
{
Exam examFind = _dbContext.Exams.FirstOrDefault(p => p.ExamID == this.examID);
if (examFind == null)
{
Exam exam = new Exam()
{
SubjectID = cmbSubject.SelectedValue.ToString(),
ExamName = txtExamName.Text,
AccountID = acc.AccountID,
TimeTotal = int.Parse(quantityTime.Value.ToString()),
TotalQuiz = int.Parse(quantityQuiz.Value.ToString()),
dateCreate = DateTime.Now
};
_dbContext.Exams.Add(exam);
_dbContext.SaveChanges();
ShowDgv();
ShowFrmCreateQuiz(exam);
}
else
{
MessageBox.Show("Mã kỳ thi tồn tại!");
return;
}
}
}
