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 CbSubtractCom_SelectedValueChanged(object sender, EventArgs e)
{
string idmh2 = cbSubtractCom.SelectedValue.ToString();
var rs5 = TracNghiem.LayDanhSachDeThi().Where(s => s.subtractID == idmh2).ToList();
cbDe.DataSource = rs5;
cbDe.DisplayMember = "id";
cbDe.ValueMember = "id";
}
private void CbMH_SelectedValueChanged(object sender, EventArgs e)
{
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;
}
private void CbSubDemo_SelectedIndexChanged(object sender, EventArgs e)
{
//lấy value
string t = cbSubDemo.SelectedValue.ToString();
var rs5 = TracNghiem.LayDanhSachDeThi().Where(s => s.subtractID.Trim() == t.Trim()).Select(s => s).ToList();
if (rs5 != null)
{
dgvShowDemo.DataSource = rs5;
cbDe.DataSource = rs5;
cbDe.DisplayMember = "id";
cbDe.ValueMember = "subtractID";
}
}
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";
}
