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