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