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 frmStudent_Load(object sender, EventArgs e) { /*Load thông tin học sinh đăng nhập*/ var rs = TracNghiem.LayDanhSachHocSinh(); var r = rs.Where(s => s.id == temp.id).Select(s => s).SingleOrDefault(); lbstudentID.Text = r.id.ToString(); lbFullnameStudent.Text = r.studentFullname.ToString(); lbBirthdayStudent.Text = string.Format("{0}-{1}-{2}", r.studentBirthday.Value.Day, r.studentBirthday.Value.Month, r.studentBirthday.Value.Year); lbClassStudent.Text = r.studentClass.ToString(); lbEmailStudent.Text = r.studentEmail.ToString(); temp = r; /*load lịch thi cho học sinh này*/ var rs1 = TracNghiem.LayDanhSachKyThi().Where(s => Convert.ToInt32(s.gradeid) == Convert.ToInt32(temp.studentClass)).Select(s => s).ToList(); dgvCompetition.DataSource = rs1; //dgvCompetition.Columns["SUBTRACT"].Visible = false; //dgvCompetition.Columns["clidCompetition"].Visible = false; //load luyện thi var rs2 = TracNghiem.LayDanhSachMonHoc(); cbSubDemo.DataSource = rs2; cbSubDemo.DisplayMember = "name"; cbSubDemo.ValueMember = "id"; string idmh = cbSubDemo.SelectedValue.ToString(); var rs3 = TracNghiem.LayDanhSachDeThi().Where(s => s.subtractID == idmh).ToList(); cbDe.DataSource = rs3; cbDe.DisplayMember = "id"; cbDe.ValueMember = "id"; dgvShowDemo.DataSource = rs3; }
private void frmCreateTest_Load(object sender, EventArgs e) { var rs = TracNghiem.LayDanhSachMonHoc(); cbMonThi.DataSource = rs; cbMonThi.DisplayMember = "name"; cbMonThi.ValueMember = "id"; }
private void DgvQuiz_SelectionChanged(object sender, EventArgs e) { int rowindex = dgvQuiz.CurrentRow.Index; txtQuiz.Text = dgvQuiz[2, rowindex].Value.ToString(); txtA.Text = dgvQuiz[3, rowindex].Value.ToString(); txtB.Text = dgvQuiz[4, rowindex].Value.ToString(); txtC.Text = dgvQuiz[5, rowindex].Value.ToString(); txtD.Text = dgvQuiz[6, rowindex].Value.ToString(); var rs = TracNghiem.LayDanhSachMonHoc(); lbSubtract.Text = rs.Where(s => dgvQuiz[1, rowindex].Value.ToString().Trim() == s.id.Trim()).Select(s => s.name).SingleOrDefault().ToString(); cbRight.SelectedItem = dgvQuiz[7, rowindex].Value.ToString(); }
private void frmAddQuiz_Load(object sender, EventArgs e) { //load cb môn học var rs = TracNghiem.LayDanhSachMonHoc(); cbSubtract.DataSource = rs; cbSubtract.ValueMember = "id"; cbSubtract.DisplayMember = "name"; //load cb đáp án đúng List <string> ans = new List <string>() { "a", "b", "c", "d" }; cbRight.DataSource = ans; //load cb độ khó var rs1 = TracNghiem.LayDanhSachDoKho(); cbRateHard.DataSource = rs1; cbRateHard.DisplayMember = "levelQuizz"; cbRateHard.ValueMember = "id"; }
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"; }