public static void Luu_Ket_Qua(KETQUATHI kqua)
{
using (var QLTTN = new QLTTNDataContext())
{
QLTTN.KETQUATHIs.InsertOnSubmit(kqua);
QLTTN.SubmitChanges();
}
}
public static void Cap_Nhat_Ket_Qua(KETQUATHI kqua, double Diem)
{
using (var QLTTN = new QLTTNDataContext())
{
var query = from q in QLTTN.KETQUATHIs
where q.TaiKhoan == kqua.TaiKhoan && q.MaKyThi == kqua.MaKyThi && q.MaDeThi == kqua.MaDeThi
select q;
query.First().Diem = Diem;
QLTTN.SubmitChanges();
}
}
//Nộp Bài
private void btnSubmit_Click(object sender, EventArgs e)
{
Thoi_Gian.Stop();
Luu_Cau_Tra_Loi();
double So_cau_Dung = 0;
double Tong_So_cau = De.De.Count;
double Diem;
for (int i = 0; i < DS_Cau_Tra_Loi.Count; i++)
{
if (DS_Cau_Tra_Loi[i].cau_tra_loi.Replace(" ", "") == DS_Cau_Tra_Loi[i].Dap_An.Replace(" ", ""))
{
So_cau_Dung++;
}
}
Diem = (So_cau_Dung / Tong_So_cau) * 10;
Diem = Math.Round(Diem, 2);
for (int i = 0; i < De.De.Count; i++)
{
if (i > DS_Cau_Tra_Loi.Count - 1)
{
CauTraLoi cauTraLoi = new CauTraLoi();
cauTraLoi.new_Cau_Tra_Loi(i, "", De.De[i].Dap_An);
DS_Cau_Tra_Loi.Add(cauTraLoi);
}
}
frmDap_An.DS_Cau_Tra_Loi = DS_Cau_Tra_Loi;
KETQUATHI kqua = new KETQUATHI();
kqua.MaKyThi = _ma_ky_thi_;
kqua.MaDeThi = _ma_de_thi_;
kqua.TaiKhoan = hs.Tai_Khoan;
kqua.Diem = Diem;
kqua.ThoiGianBatDau = Start_time;
kqua.ThoiGianKetThuc = End_time;
if (BUS_Hoc_Sinh.Luu_Ket_Qua(kqua) == true)
{
MessageBox.Show("Đã Lưu ^_^", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmKetQua.Diem = Diem;
frmKetQua frmKetQua1 = new frmKetQua();
frmKetQua1.ShowDialog();
}
else
{
MessageBox.Show("Đã Có Kết Quả Đề Này ^_^", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
btnSubmit.Enabled = false;
btnNext.Enabled = false;
btnPrev.Enabled = false;
btnStart_Pause.Enabled = false;
}
public static bool Luu_Ket_Qua(KETQUATHI kqua)
{
using (var QLTTN = new QLTTNDataContext())
{
var Querry = (from kq in QLTTN.KETQUATHIs
where kq.MaKyThi == kqua.MaKyThi && kq.MaDeThi == kqua.MaDeThi && kq.TaiKhoan == kqua.TaiKhoan
select kq).Count();
if (Querry == 0)
{
DAO_Hoc_Sinh.Luu_Ket_Qua(kqua);
return(true);
}
else
{
return(false);
}
}
}
public static void DeleteUserWithLinq(string taiKhoan)
{
using (var dataContext = new QLTTNDataContext())
{
var ResultTemp = dataContext.KETQUATHIs.Where(kq => kq.TaiKhoan.Equals(taiKhoan)).Select(kq => kq).ToList();
var listStudentTemp = dataContext.DANHSACHTHISINHs.Where(ds => ds.TaiKhoan.Equals(taiKhoan)).Select(ds => ds).ToList();
NGUOIDUNG Student = dataContext.NGUOIDUNGs.Where(nd => nd.TaiKhoan.Equals(taiKhoan)).Select(nd => nd).Single();
KETQUATHI Result = null;
DANHSACHTHISINH listStudent = null;
if (ResultTemp.Count > 0)
{
Result = dataContext.KETQUATHIs.Where(kq => kq.TaiKhoan.Equals(taiKhoan)).Select(kq => kq).Single();
dataContext.KETQUATHIs.DeleteOnSubmit(Result);
}
if (listStudentTemp.Count > 0)
{
listStudent = dataContext.DANHSACHTHISINHs.Where(ds => ds.TaiKhoan.Equals(taiKhoan)).Select(ds => ds).Single();
dataContext.DANHSACHTHISINHs.DeleteOnSubmit(listStudent);
}
dataContext.NGUOIDUNGs.DeleteOnSubmit(Student);
dataContext.SubmitChanges();
}
}
