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