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