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