private void Form_Thi_Load(object sender, EventArgs e)
{
Id_Made = SinhVien_KyThiDAO.GetMaDe(MSVKT);
listBTDoc = BTDocDAO.LoadDSCauHoi_TheoMaDe(Id_Made);
listBTNguPhap = BTNguPhapDAO.LoadDSCauHoi_TheoMaDe(Id_Made);
foreach (BTDoc item in listBTDoc)
{
List <CauHoiDoc> rb = CauHoiDocDAO.LoadDSCauHoiDoc(item.Id_Doc);
ListCauHoiDoc.Add(rb);
}
SinhVien sv = ThanhVienDAO.GetThongTinSV(MSVKT);
lb_name.Text = sv.HoVaTen;
lb_MSV.Text = sv.MaSV;
TTKT tk = TTKTDAO.GetTTKT(MSVKT);
lb_NamKT.Text = tk.TenKyThi;
timer1.Interval = 1000;
timer1.Start();
sl = listBTNguPhap.Count;
foreach (List <CauHoiDoc> item in ListCauHoiDoc)
{
sl = sl + item.Count;
}
for (int i = 0; i < sl; i++)
{
TaoListBTT(5, 50 * i, i);
}
ThemCode(0);
btn_TC.Hide();
}
private void cb_KyThi_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
TTKT item = (TTKT)cb_KyThi.SelectedItem;
i = item.MaTTKT;
Load_Form(item.MaTTKT);
}
catch
{ }
}
private void btn_XemDanhSach_Click(object sender, EventArgs e)
{
if (txb_TenKyThi != null && txb_TenKyThi.Text != "")
{
Form_DSSV_KyThi f = new Form_DSSV_KyThi();
TTKT KT = new TTKT();
KT.MaTTKT = int.Parse(dtgv_ThongTinKyThi.CurrentRow.Cells["MaTTKT"].Value.ToString());
KT.TenKyThi = dtgv_ThongTinKyThi.CurrentRow.Cells["TenKyThi"].Value.ToString();
KT.NgayThi = dtgv_ThongTinKyThi.CurrentRow.Cells["NgayThi"].Value.ToString();
KT.DiaDiemTHi = dtgv_ThongTinKyThi.CurrentRow.Cells["Diadiemthi"].Value.ToString();
KT.CoQuanToChuc = dtgv_ThongTinKyThi.CurrentRow.Cells["CoQuanToChuc"].Value.ToString();
f.KyThi1 = KT;
f.Show();
}
else
{
MessageBox.Show("Bạn chưa chọn kỳ thi!", "Thông báo");
}
}
public static string GetMK(int MaTTKT)
{
string MatKhau = null;
String querry = "select * from ThongTinKyThi where MaTTKT= " + MaTTKT;
DataTable DT = new DataTable();
DT = DataProvider.instanse.Executequerry(querry);
if (DT.Rows.Count == 0)
{
return(null);
}
else
{
foreach (DataRow item in DT.Rows)
{
TTKT AC = new TTKT(item);
MatKhau = AC.MatKhau;
}
return(MatKhau);
}
}
public static TTKT GetTTKT(int MSVKT)
{
List <TTKT> list = new List <TTKT>();
String querry = "exec GetTTKT_ThanhVienDAO '" + MSVKT + "'";
DataTable DT = new DataTable();
DT = DataProvider.instanse.Executequerry(querry);
if (DT.Rows.Count == 0)
{
return(null);
}
else
{
foreach (DataRow item in DT.Rows)
{
TTKT AC = new TTKT(item);
list.Add(AC);
}
return(list[0]);
}
}
public static List <TTKT> LoadDSThongTinKyThi()
{
List <TTKT> list = new List <TTKT>();
String querry = "Select * From ThongTinKyThi";
DataTable DT = new DataTable();
DT = DataProvider.instanse.Executequerry(querry);
if (DT.Rows.Count == 0)
{
return(null);
}
else
{
foreach (DataRow item in DT.Rows)
{
TTKT AC = new TTKT(item);
list.Add(AC);
}
return(list);
}
}
