private void btnXemBaiThi_Click(object sender, EventArgs e)
{
int viTri = bANGDIEMBindingSource.Position;
if (viTri == -1)
{
MessageBox.Show("Chọn 1 bảng điểm để xem nhé :)");
return;
}
int id_bangdiem = int.Parse(((DataRowView)bANGDIEMBindingSource[viTri])["MA_BAI_THI"].ToString());
rpXemBaiThi rp = new rpXemBaiThi(id_bangdiem);
if (Program.mNhom == "SINHVIEN")
{
rp.lbHoTen.Text = "HỌ TÊN: " + Program.mHoTen;
rp.lbLop.Text = "LỚP: " + Program.tenlop;
} else
{
String maSV = ((DataRowView)bANGDIEMBindingSource[viTri])["MASV"].ToString();
Program.myReader = Program.ExecSqlDataReader("EXEC SP_TIM_SV '" + maSV + "'");
Program.myReader.Read();
String name = Program.myReader.GetString(1)+" "+ Program.myReader.GetString(2);
String maLop = Program.myReader.GetString(5);
Program.myReader.Close();
Program.myReader = Program.ExecSqlDataReader("EXEC SP_TIMKIEM_LOP '" + maLop + "'");
Program.myReader.Read();
String lop = Program.myReader.GetString(1);
Program.myReader.Close();
rp.lbHoTen.Text = "HỌ TÊN: " + name;
rp.lbLop.Text = "LỚP: " + lop;
}
String maMonThi = ((DataRowView)bANGDIEMBindingSource[viTri])["MAMH"].ToString();
Program.myReader = Program.ExecSqlDataReader("EXEC SP_TIMKIEMMH '" + maMonThi + "'");
Program.myReader.Read();
String tenMonThi = Program.myReader.GetString(1);
Program.myReader.Close();
rp.lbMonHoc.Text = "MÔN THI: " + tenMonThi;
String ngayThi = ((DataRowView)bANGDIEMBindingSource[viTri])["NGAYTHI"].ToString();
rp.lbNgayThi.Text = "NGÀY THI: " + ngayThi.Substring(0, 10);
String lan = ((DataRowView)bANGDIEMBindingSource[viTri])["LAN"].ToString();
rp.lbLanThi.Text = "LẦN: " + lan;
ReportPrintTool print = new ReportPrintTool(rp);
print.ShowPreviewDialog();
}
private void ghiBangDiemVaBaiThi()
{
GiaoVienDK g = GiaoVienDK.gv_dk;
BangDiem bd = new BangDiem(Program.mUserId, g.MaMH, g.Lan, g.NgayThi.ToString(), tongDiem);
bd.ghiDiem();
String strlenh = "EXEC SP_TIMBANGDIEM_THI '" + Program.mUserId + "', '" + g.MaMH + "', " + g.Lan;
Program.myReader.Close();
Program.myReader = Program.ExecSqlDataReader(strlenh);
Program.myReader.Read();
int idBangDiem = Program.myReader.GetInt32(5);
Program.myReader.Close();
foreach (CT_BaiThi ct in CT_BaiThi.ct_baiThi)
{
bdsCT_BAITHI.AddNew();
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["THUTU"] = ct.getThuTu();
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["NOIDUNG"] = ct.getNoiDung();
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["A"] = ct.getA().Trim();
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["B"] = ct.getB().Trim();
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["C"] = ct.getC().Trim();
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["D"] = ct.getD().Trim();
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["DAPANDUNG"] = ct.getDapAnDung().Trim().ElementAt(0);
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["DAPANDACHON"] = ct.getDapAnDaChon().Length == 0 ? ' ': ct.getDapAnDaChon().ElementAt(0);
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["MA_BAI_THI"] = idBangDiem;
((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["CAU_HOI"] = ct.getCauHoi();
bdsCT_BAITHI.EndEdit();
}
try
{
cT_BAITHITableAdapter.Update(this.dS.CHITIETBAITHI);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
DialogResult dialogResult = MessageBox.Show("Số câu đúng: " + soCauDung + "/" + soCauThi + "\nTổng điểm: " + tongDiem + "\nBạn có muốn xem lại bài thi?", "KẾT QUẢ", MessageBoxButtons.YesNoCancel);
if (dialogResult == DialogResult.Yes)
{
rpXemBaiThi rp = new rpXemBaiThi(idBangDiem);
rp.lbHoTen.Text = "HỌ TÊN: " + Program.mHoTen;
rp.lbLop.Text = "LỚP: " + Program.tenlop;
rp.lbMonHoc.Text = "MÔN THI" + this.lblMONHOC.Text;
rp.lbNgayThi.Text = "NGÀY THI: " + lblNGAYTHI.Text;
rp.lbLanThi.Text = "LẦN: " + g.Lan;
ReportPrintTool print = new ReportPrintTool(rp);
print.ShowPreviewDialog();
}
else if (dialogResult == DialogResult.No)
{
}
else if (dialogResult == DialogResult.Cancel)
{
}
GiaoVienDK.gv_dk = null;
CT_BaiThi.ct_baiThi.Clear();
BoDe.boDe.Clear();
}
