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];
}
