private void btnSubmit_Click(object sender, EventArgs e)
{
var rs = TracNghiem.LayDanhSachCauHoi();
var rs2 = TracNghiem.LayDanhSachMonHoc();
string codeSubstract = rs2.Where(s => s.name == cbSubtract.Text).Select(s => s.id).SingleOrDefault().ToString();
int r = (from i in rs where i.idSubtract.ToString().Trim() == codeSubstract.Trim() select i).Count();
//thứ nhất là khởi tạo 1 câu hỏi
QUIZ qNew = new QUIZ()
{
id = r + 1,
idSubtract = codeSubstract,
quizz = txtQuiz.Text,
a = txtA.Text,
b = txtB.Text,
c = txtC.Text,
d = txtD.Text,
answer = char.Parse(cbRight.SelectedItem.ToString()),
rateHard = int.Parse(cbRateHard.SelectedValue.ToString())
};
if (TracNghiem.ThemCauHoi(qNew))
{
MessageBox.Show("Thêm câu hỏi thành công");
}
else
{
MessageBox.Show("Thêm thất bại");
}
//thêm xong để đó để có thêm tiếp thì bấm tiếp
//đã xong chức năng thêm câu hỏi
}
private void frmThiThat_Load(object sender, EventArgs e)
{
timerTest.Enabled = true;
//load danh sách câu hỏi từ đề thi
var rs = TracNghiem.LayDeThi().Where(s => s.testID == pemp.id).Select(s => s);
var rs2 = TracNghiem.LayDanhSachCauHoi().Where(s => s.idSubtract.Trim() == pemp.subtractID.Trim()).ToList();
rs3 = (from i in rs
join j in rs2 on i.quizID equals j.id
select j).ToList();
lbSubtract.Text = pemp.subtractID;
lbGrade.Text = pemp.gradeid.ToString();
lbDateBegin.Text = pemp.testDateBegin.Value.ToString();
lbTTL.Text = pemp.testTimeToLive.ToString();
lbEnd.Text = pemp.testDateBegin.Value.AddHours(1).ToString();
lbName.Text = temp.studentFullname;
lbBirth.Text = temp.studentBirthday.Value.Date.ToString();
lbShowQuiz.Text = rs3[idxQuizCurrent].quizz;
rdA.Text = "A. " + rs3[idxQuizCurrent].a;
rdB.Text = "B. " + rs3[idxQuizCurrent].b;
rdC.Text = "C. " + rs3[idxQuizCurrent].c;
rdD.Text = "D. " + rs3[idxQuizCurrent].d;
txtCurrentQuiz.Text = (idxQuizCurrent + 1).ToString();
tempQuiz = rs3[idxQuizCurrent];
//var rs4 = (from i in rs
// join j in rs2 on i.quizID equals j.id
// select new {i.stt, i.quizID }).ToList();
//cbQuiz.DataSource = rs4;
//cbQuiz.DisplayMember = "stt";
//cbQuiz.ValueMember = "quizID";
}
private void frmTestDetail_Load(object sender, EventArgs e)
{
var rs = TracNghiem.LayDeThi().Where(s => (s.testID == t && s.subtractID == m));
var rs2 = TracNghiem.LayDanhSachCauHoi();
var rs3 = (from i in rs
join j in rs2 on i.quizID equals j.id
select new { j.quizz, j.a, j.b, j.c, j.d }).ToList();
dgvShowFullTestDetail.DataSource = rs3;
}
private void frmThiThu_Load(object sender, EventArgs e)
{
//load danh sách câu hỏi từ đề thi
var rs = TracNghiem.LayDeThi().Where(s => s.testID == de && s.subtractID == mh);
var rs2 = TracNghiem.LayDanhSachCauHoi().Where(s => s.idSubtract.Trim() == mh.Trim()).ToList();
rs3 = (from i in rs
join j in rs2 on i.quizID equals j.id
select j).ToList();
lbShowQuiz.Text = rs3[idxQuizCurrent].quizz;
rdA.Text = "A. " + rs3[idxQuizCurrent].a;
rdB.Text = "B. " + rs3[idxQuizCurrent].b;
rdC.Text = "C. " + rs3[idxQuizCurrent].c;
rdD.Text = "D. " + rs3[idxQuizCurrent].d;
txtCurrentQuiz.Text = (idxQuizCurrent + 1).ToString();
temp = rs3[idxQuizCurrent];
}
private void btnAddDatabase_Click(object sender, EventArgs e)
{
//thêm dữ liệu vào câu hỏi
int flag = 0;
DataTable dt = (DataTable)(dgvShow.DataSource);
for (int i = 0; i < dt.Rows.Count; i++)
{
var rs = TracNghiem.LayDanhSachCauHoi().Where(s => s.idSubtract.Trim() == dt.Rows[i][1].ToString().Trim());
var t = rs.OrderByDescending(s => s.id).Take(1).Select(s => s).SingleOrDefault();
// tạo 1 cái QUIZ
QUIZ qNew = new QUIZ()
{
id = t.id + 1,
idSubtract = dt.Rows[i][1].ToString(),
quizz = dt.Rows[i][2].ToString(),
a = dt.Rows[i][3].ToString(),
b = dt.Rows[i][4].ToString(),
c = dt.Rows[i][5].ToString(),
d = dt.Rows[i][6].ToString(),
answer = Convert.ToChar(dt.Rows[i][7].ToString().ToLower()),
rateHard = Convert.ToInt32(dt.Rows[i][8])
};
var t1 = rs.Where(s => s.quizz.Trim() == qNew.quizz.Trim()).Take(1).SingleOrDefault();
if (t1 == null)
{
//Thêm vào bảng câu hỏi
TracNghiem.ThemCauHoi(qNew);
flag = 1;
}
}
if (flag == 0)
{
MessageBox.Show("Thêm thất bại");
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
//lấy ra đề thi có id lớn nhất của môn học được chọn
var rs = TracNghiem.LayDanhSachDeThi();
if (rs.Count == 0)
{
TEST ts = new TEST()
{
id = 1, subtractID = cbMonThi.SelectedValue.ToString()
};
TracNghiem.ThemDeThi(ts);
Random rd = new Random();
var rs1 = TracNghiem.LayDanhSachCauHoi().Where(s => s.idSubtract == cbMonThi.SelectedValue.ToString()).ToList();
while (rancauhoi.Count < 60)
{
int i = rd.Next(0, rs1.Count);
if (!rancauhoi.Contains(rs1[i]))
{
rancauhoi.Add(rs1[i]);
}
}
for (int i = 0; i < 60; i++)
{
TEST_DETAIL tNew = new TEST_DETAIL()
{
testID = ts.id,
subtractID = rancauhoi[i].idSubtract,
stt = i + 1,
quizID = rancauhoi[i].id
};
TracNghiem.ThemChiTietDeThi(tNew);
}
}
else
{
var t = rs.OrderByDescending(s => s.id).Where(s => s.subtractID == cbMonThi.SelectedValue.ToString()).Take(1).Select(s => s).SingleOrDefault();
if (t != null)
{
TEST ts = new TEST()
{
id = t.id + 1, subtractID = cbMonThi.SelectedValue.ToString()
};
TracNghiem.ThemDeThi(ts);
Random rd = new Random();
var rs1 = TracNghiem.LayDanhSachCauHoi().Where(s => s.idSubtract == cbMonThi.SelectedValue.ToString()).ToList();
while (rancauhoi.Count < 60)
{
int i = rd.Next(0, rs1.Count);
if (!rancauhoi.Contains(rs1[i]))
{
rancauhoi.Add(rs1[i]);
}
}
for (int i = 0; i < 60; i++)
{
TEST_DETAIL tNew = new TEST_DETAIL()
{
testID = ts.id,
subtractID = rancauhoi[i].idSubtract,
stt = i + 1,
quizID = rancauhoi[i].id
};
TracNghiem.ThemChiTietDeThi(tNew);
}
}
}
MessageBox.Show("Tạo đề thành công");
Close();
}
private void frmTeacher_Load(object sender, EventArgs e)
{
//load thông tin giáo viên
lbCodeTeacher.Text = temp.teacherID;
lbEmailTeacher.Text = temp.teacherEmail;
lbFacultyTeacher.Text = "?????????";
lbNameTeacher.Text = temp.teacherFullname;
lbBirthTeacher.Text = string.Format("{0}-{1}-{2}", temp.teacherBirthday.Value.Day, temp.teacherBirthday.Value.Month, temp.teacherBirthday.Value.Year);
//load tiêu đề form
this.TitleText = string.Format("<b>Phân hệ giáo viên - ID: {0}</b>", temp.teacherID);
/*load tab quản lý câu hỏi*/
//load danh sách câu hỏi
var rs = TracNghiem.LayDanhSachCauHoi();
dgvQuiz.DataSource = rs;
//dgvQuiz.Columns["LEVELQUIZ"].Visible = false;
//dgvQuiz.Columns["SUBTRACT"].Visible = false;
//load combobox
List <string> ans = new List <string>()
{
"a", "b", "c", "d"
};
cbRight.DataSource = ans;
var r = TracNghiem.LayDanhSachDoKho();
cbLevelQuiz.DataSource = r;
cbLevelQuiz.DisplayMember = "levelQuizz";
cbLevelQuiz.ValueMember = "id";
/*load tab quản lí đề thi*/
//load danh sách đề thi thật vào gridview
var rs2 = TracNghiem.LayDanhSachMonHoc();
cbMH.DataSource = rs2;
cbMH.DisplayMember = "name";
cbMH.ValueMember = "id";
string idmh = cbMH.SelectedValue.ToString();
var rs3 = TracNghiem.LayDanhSachDeThi().Where(s => s.subtractID == idmh).ToList();
cbTest.DataSource = rs3;
cbTest.DisplayMember = "id";
cbTest.ValueMember = "id";
dgvTest.DataSource = rs3;
/*load tab quan li kỳ thi thật*/
var rs4 = TracNghiem.LayDanhSachKyThi();
dgvCompetition.DataSource = rs4;
cbSubtractCom.DataSource = rs2;
cbSubtractCom.DisplayMember = "name";
cbSubtractCom.ValueMember = "id";
string idmh2 = cbSubtractCom.SelectedValue.ToString();
var rs5 = TracNghiem.LayDanhSachDeThi().Where(s => s.subtractID == idmh2).ToList();
cbDe.DataSource = rs5;
cbDe.DisplayMember = "id";
cbDe.ValueMember = "id";
var rs6 = TracNghiem.LayDanhSachKhoi();
cbgradeid.DataSource = rs6;
cbgradeid.DisplayMember = "id";
cbgradeid.ValueMember = "id";
//load tab kỳ thi thử
var rs7 = TracNghiem.LayDanhSachKyThiThu();
dgvDemoCompetition.DataSource = rs7;
cbMHDemo.DataSource = rs2;
cbMHDemo.DisplayMember = "name";
cbMHDemo.ValueMember = "id";
string idmh3 = cbMHDemo.SelectedValue.ToString();
var rs8 = TracNghiem.LayDanhSachDeThiThu().Where(s => s.subtractID == idmh3).ToList();
cbDemoDe.DataSource = rs8;
cbDemoDe.DisplayMember = "demoTestID";
cbDemoDe.ValueMember = "demoTestID";
cbDemoKhoi.DataSource = rs6;
cbDemoKhoi.DisplayMember = "id";
cbDemoKhoi.ValueMember = "id";
}
