public int DangKyThi(int mand)
{
try
{
DangKi a = new DangKi();
string ngay = DateTime.Today.Day.ToString();
string thang = DateTime.Today.Month.ToString();
string nam = DateTime.Today.Year.ToString();
string ngaydk = thang + "/" + ngay + "/" + nam;
DateTime dtime = new DateTime(2018, 12, 27);
//string formattedStrings = dti
a.NgayDangKy = DateTime.Today;
a.TinhTrang = false;
a.MaNguoiDung = mand;
var prolist = thi.BoDes.ToList(); // lấy tất cả sản phẩm
int count = prolist.Count();
int index = new Random().Next(count); // lấy random từ 0 => count nhằm mục đính lấy random trong danh sách Product
BoDe pro = prolist.Skip(index).FirstOrDefault();
// dùng Skip để lấy Product thứ index
a.MaBoDe = pro.MaBoDe;
thi.DangKis.InsertOnSubmit(a);
thi.SubmitChanges();
return(0);
}
catch
{
return(1);
}
}
private void BoDeSelection(object sender, SelectionChangedEventArgs e)
{
BoDe userSelection = (BoDe)Bodelv.SelectedItem;
LopThongTin.BoDeObject = userSelection;
Frame.Navigate(typeof(LamBoDePage));
}
private void FormDangKyBoDe_Load(object sender, EventArgs e)
{
bODETableAdapter.Fill(this.dtsTTN.BODE);
dtsTTN.EnforceConstraints = false;
lOPTableAdapter.Fill(dtsTTN.LOP);
dANGKIBODETableAdapter.Fill(dtsTTN.DANGKIBODE);
mONHOCTableAdapter.Fill(dtsTTN.MONHOC);
txtMaBD.Text = BoDe.TaoMaBD().ToString();
txtMaGV.Text = Program.username;
txtNgayDangKy.Text = DateTime.UtcNow.ToString("dd/MM/yyyy");
cbbCoSo.SelectedIndex = 1;
cbbCoSo.SelectedIndex = 0;
List <TietBatDau> lstTBD = new List <TietBatDau>();
for (int i = 0; i < KeyConst.TIETBD.Length; i++)
{
TietBatDau tbd = new TietBatDau("Tiết " + (i + 1).ToString(), i + 1);
lstTBD.Add(tbd);
}
cbbTietBD.DataSource = lstTBD;
cbbTietBD.DisplayMember = "Ten";
cbbTietBD.ValueMember = "TietBD";
cbbMaLop.SelectedIndex = 1;
cbbCoSo.SelectedIndex = 0;
cbbTietBD.SelectedIndex = 1;
cbbTietBD.SelectedIndex = 0;
cbbMonHoc.SelectedIndex = 1;
cbbMonHoc.SelectedIndex = 0;
}
private void btnTest_Click(object sender, EventArgs e)
{
List <BODE> listBD = new List <BODE>();
if (!CheckData())
{
return;
}
int demCauHoi = CauHoi.CountCauHoiByMonHoc(MaMH, MaTD);
if (demCauHoi < txtSoCauThi.Value)
{
MessageBox.Show("Số câu hỏi không đủ để tạo đề thi, môn học này chỉ có " + demCauHoi + " câu hỏi!", "Thông báo", MessageBoxButtons.OK);
return;
}
lstMaCH = BoDe.LayCauHoiTaoBD(MaMH, MaKhoa, MaTD, (int)txtSoCauThi.Value);
if (lstMaCH.Count == 0)
{
MessageBox.Show("Đã xảy ra lỗi khi tạo bộ đề thi, vui lòng thử lại sau!", "Thông báo", MessageBoxButtons.OK);
return;
}
FormXemTruocBoDe frmXemTruocBD = new FormXemTruocBoDe(MaKhoa, MaTD, cbbMonHoc.Text, lstMaCH, (int)txtThoiGianThi.Value);
frmXemTruocBD.Show();
}
private void summarylistview_SelectedIndexChanged(object sender, EventArgs e)
{
rdoA.Checked = false;
rdoB.Checked = false;
rdoC.Checked = false;
rdoD.Checked = false;
int i = 0;
try
{
i = index;
index = summarylistview.FocusedItem.Index;
}
catch (Exception)
{
index = i;
}
if (index <= 0)
{
btnCAUTRUOC.Enabled = false;
btnCAUSAU.Enabled = true;
index = 0;
numericUpDownCAUINDEX.Value = index + 1;
}
else if (index >= soCauThi - 1)
{
btnCAUSAU.Enabled = false;
btnCAUTRUOC.Enabled = true;
index = soCauThi - 1;
numericUpDownCAUINDEX.Value = index + 1;
}
else
{
btnCAUTRUOC.Enabled = true;
btnCAUSAU.Enabled = true;
}
BoDe b = (BoDe)boDe[index];
lblNOIDUNG.Text = "Câu " + (index + 1) + ": " + b.NoiDung;
rdoA.Text = b.DapAnA;
rdoB.Text = b.DapAnB;
rdoC.Text = b.DapAnC;
rdoD.Text = b.DapAnD;
if (index == 0)
{
btnCAUTRUOC.Enabled = false;
}
this.checkDapAnDaChon();
}
//Lấy bộ đề lưu vào List
private List <BoDe> convertToListBD(DataTable ds)
{
List <BoDe> list = new List <BoDe>();
foreach (DataRow row in ds.Rows)
{
BoDe bd = new BoDe(
row["MACH"].ToString(),
row["NOIDUNG"].ToString(),
row["LOAICH"].ToString(),
row["DAPAN"].ToString(),
row["MAMH"].ToString(),
row["MATD"].ToString(),
row["MAGV"].ToString()
);
list.Add(bd);
}
return(list);
}
public List <BoDe> GetBoDe()
{
List <BoDe> datalist = new List <BoDe>();
DataTable dt = getData("select *from BODE");
if (dt.Rows.Count == 0)
{
datalist = null;
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
BoDe temp = new BoDe();
temp.Title = dt.Rows[i][0].ToString();
temp.TenBoDe = dt.Rows[i][1].ToString();
datalist.Add(temp);
}
}
return(datalist);
}
private List <BoDe> convertToListBD(DataTable ds)
{
List <BoDe> list = new List <BoDe>();
foreach (DataRow row in ds.Rows)
{
BoDe bd = new BoDe(
Convert.ToInt32(row["CAUHOI"].ToString()),
row["MAMH"].ToString(),
row["TRINHDO"].ToString(),
row["NOIDUNG"].ToString(),
row["A"].ToString(),
row["B"].ToString(),
row["C"].ToString(),
row["D"].ToString(),
row["DAP_AN"].ToString(),
row["MAGV"].ToString()
);
list.Add(bd);
}
return(list);
}
private void numericUpDownCAUINDEX_ValueChanged(object sender, EventArgs e)
{
rdoA.Checked = false;
rdoB.Checked = false;
rdoC.Checked = false;
rdoD.Checked = false;
index = (int)numericUpDownCAUINDEX.Value - 1;
if (index <= 0)
{
btnCAUTRUOC.Enabled = false;
btnCAUSAU.Enabled = true;
index = 0;
numericUpDownCAUINDEX.Value = index + 1;
}
else if (index >= soCauThi - 1)
{
btnCAUSAU.Enabled = false;
btnCAUTRUOC.Enabled = true;
index = soCauThi - 1;
numericUpDownCAUINDEX.Value = index + 1;
}
else
{
btnCAUTRUOC.Enabled = true;
btnCAUSAU.Enabled = true;
}
BoDe b = (BoDe)boDe[index];
lblNOIDUNG.Text = "Câu " + (index + 1) + ": " + b.NoiDung;
rdoA.Text = b.DapAnA;
rdoB.Text = b.DapAnB;
rdoC.Text = b.DapAnC;
rdoD.Text = b.DapAnD;
if (index == 0)
{
btnCAUTRUOC.Enabled = false;
}
this.checkDapAnDaChon();
}
private void btnCAUSAU_Click(object sender, EventArgs e)
{
rdoA.Checked = false;
rdoB.Checked = false;
rdoC.Checked = false;
rdoD.Checked = false;
index++;
numericUpDownCAUINDEX.Value = index + 1;
btnCAUTRUOC.Enabled = true;
BoDe b = (BoDe)boDe[index];
lblNOIDUNG.Text = "Câu " + (index + 1) + ": " + b.NoiDung;
rdoA.Text = b.DapAnA;
rdoB.Text = b.DapAnB;
rdoC.Text = b.DapAnC;
rdoD.Text = b.DapAnD;
if (index == soCauThi - 1)
{
btnCAUSAU.Enabled = false;
}
this.checkDapAnDaChon();
}
private void frmTracNghiem_Load(object sender, EventArgs e)
{
soCauThi = boDe.Count;
this.cT_BAITHITableAdapter.Connection.ConnectionString = Program.connstr;
// TODO: This line of code loads data into the 'dS.CT_BAITHI' table. You can move, or remove it, as needed.
//this.cT_BAITHITableAdapter.Fill(this.dS.CHITIETBAITHI);
// TODO: This line of code loads data into the 'dSQLTN.CT_BAITHI' table. You can move, or remove it, as needed.
toolStripStatusHOTEN.Text = "Họ và tên: " + Program.mHoTen;
toolStripStatusMAGV.Text = "Mã SV:" + Program.mUserId;
toolStripStatusNHOM.Text = "nhóm: SINHVIEN";
toolStripStatusMALOP.Text = "mã lớp: ";
toolStripStatusTENLOP.Text = "tên lớp: ";
BoDe b = (BoDe)boDe[index];
lblNOIDUNG.Text = "Câu " + index + 1 + ": " + b.NoiDung;
rdoA.Text = b.DapAnA;
rdoB.Text = b.DapAnB;
rdoC.Text = b.DapAnC;
rdoD.Text = b.DapAnD;
soCauThi = g.SoCauThi;
String lenh = "EXEC SP_TIMKIEMMH '" + g.MaMH + "'";
Program.myReader = Program.ExecSqlDataReader(lenh);
Program.myReader.Read();
String tenMH = Program.myReader.GetString(1);
Program.myReader.Close();
lblLOP.Text = "Lớp: " + "";
lblMONHOC.Text = "Môn học: " + tenMH;
lblNGAYTHI.Text = "Ngày thi: " + g.NgayThi.ToString("dd/MM/yyyy");
lblTRINHDO.Text = "Trình độ: " + g.TrinhDo;
btnCAUTRUOC.Enabled = false;
mm = g.ThoiGian;
t.Interval = 1000;
t.Tick += new EventHandler(this.t_Tick);
t.Start();
//Copy dữ liệu từ bộ đề sang chi tiết bài thi
int i = 1;
foreach (BoDe b2 in boDe)
{
int cauHoi = b2.CauHoi;
String maMH = b2.MaMH;
String trinhDo = b2.TrinhDo;
String noiDung = b2.NoiDung;
String A = b2.DapAnA;
String B = b2.DapAnB;
String C = b2.DapAnC;
String D = b2.DapAnD;
String dapAn = b2.DapAnDung;
String maGV = b2.MaGV;
String dapAnDaChon = "";
CT_BaiThi ct = new CT_BaiThi(cauHoi, i, noiDung, A, B, C, D, dapAn, dapAnDaChon);
CT_BaiThi.thithu.Add(ct);
i++;
}
/*cập nhật thông báo đáp án đã chọn*/
// capNhatThongBaoDapAnDaChon();
numericUpDownCAUINDEX.Maximum = 100;
numericUpDownCAUINDEX.Minimum = 1;
summarylistview.View = View.Details;
summarylistview.GridLines = true;
summarylistview.FullRowSelect = true;
foreach (CT_BaiThi ct in CT_BaiThi.thithu)
{
String[] arr = new string[2];
arr[0] = ct.getThuTu().ToString();
arr[1] = ct.getDapAnDaChon().ToString();
ListViewItem baiThi = new ListViewItem(arr);
this.summarylistview.Items.Add(baiThi);
}
}
private void FormThi_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dtsTTN.CT_BAITHI' table. You can move, or remove it, as needed.
this.cT_BAITHITableAdapter.Fill(this.dtsTTN.CT_BAITHI);
bANGDIEMTableAdapter.Fill(this.dtsTTN.BANGDIEM);
MyTimer.Interval = (1000); // 1 mins
MyTimer.Tick += new EventHandler(t_Tick);
MyTimer.Start();
if (MaBD != -1)
{
BDThiTam = BoDe.LayBDThi(MaBD);
if (BDThi == null)
{
return;
}
CAUHOITHI = new List <HoTroLayCauHoiThi>();
HoTroLayCauHoiThi htCHThi = null;
Panel pnCauHoi = null;
int i = BDThiTam.Count;
while (BDThiTam.Count != 0)
{
htCHThi = new HoTroLayCauHoiThi();
int r = rnd.Next(BDThiTam.Count);
HoTroLayBDThi ht = BDThiTam[r];
BDThi.Add(ht);
CAUHOI cauHoi = CauHoi.GetCauHoiByMaCH(ht.MaCauHoi);
List <LUACHON> luachon = CauHoi.GetLuaChonByMaCH(ht.MaCauHoi);
pnCauHoi = new Panel();
pnCauHoi.AutoSize = true;
pnCauHoi.Dock = DockStyle.Top;
Label lb = new Label();
lb.AutoSize = true;
FontStyle newFontStyle = (FontStyle)(FontStyle.Bold);
lb.Font = new Font("Times New Rowman", 25, newFontStyle);
lb.Text = "Câu " + i + " : " + cauHoi.NOIDUNG;
RadioButton rGLuaChon = null;
foreach (LUACHON lc in luachon)
{
rGLuaChon = new RadioButton();
rGLuaChon.AutoSize = true;
rGLuaChon.Name = lc.MALC.Trim() + "-" + cauHoi.MACH.ToString().Trim();
rGLuaChon.Font = new Font("Times New Rowman", 25, newFontStyle);
// update dap an neu thay doi lua chon
rGLuaChon.CheckedChanged += new EventHandler(LuaChon_Click);
//rGLuaChon.Add(new RadioGroupItem(lc.MALC.ToString(), "Câu " + lc.MALC.ToString() + " : " + lc.NOIDUNG));
rGLuaChon.Text = "Câu " + lc.MALC.ToString() + " : " + lc.NOIDUNG;
rGLuaChon.Dock = DockStyle.Bottom;
rGLuaChon.Focus();
pnCauHoi.Controls.Add(rGLuaChon);
}
lb.Dock = DockStyle.Top;
pnCauHoi.Controls.Add(lb);
pnThi.Controls.Add(pnCauHoi);
htCHThi.MaCH = cauHoi.MACH;
htCHThi.STT = ht.SoTT;
htCHThi.DapAn = cauHoi.DAPAN;
htCHThi.STTKhiThi = i - 1;
CAUHOITHI.Add(htCHThi);
BDThiTam.RemoveAt(r);
i--;
}
}
pnThi.AllowDrop = true;
pnThi.AutoScroll = true;
}
private void ThiThu_Load(object sender, EventArgs e)
{
boDe = BoDe.boDe;
soCauThi = boDe.Count;
dS.EnforceConstraints = false;
this.cTBAITHITableAdapter.Connection.ConnectionString = Program.connstr;
BoDe b = (BoDe)boDe[index];
lblNOIDUNG.Text = "Câu " + index + 1 + ": " + b.NoiDung;
rdoA.Text = b.DapAnA;
rdoB.Text = b.DapAnB;
rdoC.Text = b.DapAnC;
rdoD.Text = b.DapAnD;
Dangky g = Dangky.dangky;
soCauThi = g.SoCauThi;
lblMONHOC.Text = "Môn: " + Program.maMH;
lblLOP.Text = "Lớp: " + Program.mMalop;
lblNGAYTHI.Text = "Ngày thi: " + g.NgayThi.ToString("dd/MM/yyyy");
lblTRINHDO.Text = "Trình độ: " + g.TrinhDo;
btnCAUTRUOC.Enabled = false;
mm = g.ThoiGian;
t.Interval = 1000;// bộ tính là 1s
t.Tick += new EventHandler(this.t_Tick);
t.Start();
//Copy dữ liệu từ bộ đề sang chi tiết bài thi
int i = 1;
foreach (BoDe b2 in BoDe.boDe)
{
String maCH = b2.MaCH;
String noiDung = b2.NoiDung;
String loaiCH = b2.LoaiCH;
String dapAn = b2.DapAn;
String maMH = b2.MaMH;
String maTD = b2.MaTD;
String maGV = b2.MaGV;
DataTable lc = Program.ExecSqlDataTable("EXEC SP_GET_LUA_CHON '" + maCH + "'");
List <LuaChon> listLC = convertToListLC(lc);
LuaChon.lc = listLC;
LuaChon[] arrluachon = listLC.ToArray();
String A = arrluachon[0].TenLC;
String B = arrluachon[1].TenLC;
String C = arrluachon[2].TenLC;
String D = arrluachon[3].TenLC;
String dapAnDaChon = "";
CT_BaiThi ct = new CT_BaiThi(maCH, i, noiDung, A, B, C, D, dapAn, dapAnDaChon);
CT_BaiThi.ct_baiThi.Add(ct);
i++;
}
/*cập nhật thông báo đáp án đã chọn*/
// capNhatThongBaoDapAnDaChon();
numericUpDownCAUINDEX.Maximum = 100;
numericUpDownCAUINDEX.Minimum = 1;
summarylistview.View = View.Details;
summarylistview.GridLines = true;
summarylistview.FullRowSelect = true;
foreach (CT_BaiThi ct in CT_BaiThi.ct_baiThi)
{
String[] arr = new string[2];
arr[0] = ct.getThuTu().ToString();
arr[1] = ct.getDapAnDaChon().ToString();
ListViewItem baiThi = new ListViewItem(arr);
this.summarylistview.Items.Add(baiThi);
}
}
