public ActionResult DiemSo(long id)
{
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var de = db.De_Thi.Find(id);
de.TrangThai = true;
db.SaveChanges();
var SV = db.DS_SVThi.SingleOrDefault(x => x.MaDeThi == de.MaDeThi);
try
{
if (SV != null)
{
SV.TrangThai = "Đã Nộp";
db.SaveChanges();
}
}
catch { }
ViewBag.MaPhong = SV.MaPhong;
var Ketqua = (List <DanhGia>)Session["KetQua"];
var mark = Ketqua.Where(x => x.ketQuaThi.Ma_DeThi == id).ToList().First();
return(View(mark));
}
public JsonResult XoaSVPhongThi(string Maphong, string Masv)
{
try
{
var phong = new QuanLyThiDAO().ExamitionRoom(Maphong);
if (phong.TrangThai.Equals("Chưa Thi"))
{
var db = new TracNghiemOnlineDB();
var sv = db.DS_SVThi.SingleOrDefault(x => x.Ma_SV.Equals(Masv) && x.MaPhong.Equals(Maphong));
db.DS_SVThi.Remove(sv);
db.SaveChanges();
return(Json(new
{
status = true
}));
}
}
catch (Exception e)
{
return(Json(new
{
status = "Không Thể Xóa SV Này"
}));
}
return(Json(new
{
status = "Phòng Đang Thi Không Thể Xóa"
}));
}
public JsonResult ListALLClassRoom()
{
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
var lop = new TracNghiemOnlineDB().LopHocPhans.Where(x => x.TrangThai == 1).ToList();
if (session.ChưcVu == "Cán Bộ")
{
lop = (List <LopHocPhan>) new QuanLyThiDAO().ListClassRom(session.TaiKhoan1).Where(x => x.TrangThai == 1).ToList();
}
var ListGV = (from c in new TracNghiemOnlineDB().GiaoViens.Where(x => x.TrangThai == true)
select new
{
c.MaGV,
c.TenGV,
}).ToList();
var LopHoc = (from c in lop.Where(x => x.TrangThai == 1)
select new
{
id = c.MaLop,
Ten = c.TenLop,
}).ToList();
return(Json(new
{
code = 200,
lop = LopHoc,
ListGV
}, JsonRequestBehavior.AllowGet));
}
internal void CreateTopic(De_Thi bo_De1, long mabai, TaiKhoan tk, LopHocPhan lopHocPhan)
{
bo_De1.CauHoiDeThis = new List <CauHoiDeThi>();
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var danhgia = db.DS_BaiHoc.SingleOrDefault(x => x.Ma_Bai == mabai && x.MaSV.Equals(tk.TaiKhoan1));
string[] ListCH = danhgia.ListCauHoi.Split('/');
if ((ListCH.Length) == 40)
{
danhgia.SoCauDung = 0;
danhgia.SoCauSai = 0;
danhgia.ListCauHoi = "";
ListCH = danhgia.ListCauHoi.Split('/');
db.SaveChanges();
}
else if (danhgia.SoCauSai - danhgia.SoCauDung > 30 && danhgia.SoCauSai + danhgia.SoCauDung > 55)
{
danhgia.SoCauDung = 0;
danhgia.SoCauSai = 0;
danhgia.ListCauHoi = "";
ListCH = danhgia.ListCauHoi.Split('/');
db.SaveChanges();
}
Random(bo_De1, mabai, 2, "Nhận Biết", ListCH, lopHocPhan);
Random(bo_De1, mabai, 2, "Thông Hiểu", ListCH, lopHocPhan);
Random(bo_De1, mabai, 1, "Vận Dụng", ListCH, lopHocPhan);
Random(bo_De1, mabai, 1, "Vận Dụng Cao", ListCH, lopHocPhan);
}
public ActionResult DSDeThi()
{
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
var dsdethi = new TracNghiemOnlineDB().Bo_De.Where(x => x.TrangThai == true && x.NguoiDuyet.Equals(session.TaiKhoan1)).ToList();
return(View(dsdethi));
}
public JsonResult LoadLopHP()
{
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
var LopHoc1 = new TracNghiemOnlineDB().LopHocPhans.Where(x => x.TrangThai == 1).ToList();
bool quyen = true;
if (session.ChưcVu.Equals("Cán Bộ"))
{
LopHoc1 = new QuanLyThiDAO().ListClassRom(session.TaiKhoan1);
quyen = false;
}
var LopHoc = (from c in LopHoc1.Where(x => x.TrangThai == 1)
select(new
{
c.MaLop,
c.TenLop,
c.MaMon,
c.MonHoc.TenMon,
c.MaKi,
c.KiThi.TenKi,
c.GiaoVien.TenGV,
c.MaGV
})
).ToList();
return(Json(new
{
quyen,
lop = LopHoc
}, JsonRequestBehavior.AllowGet));
}
public JsonResult Update(long maDe, bool trangthai)
{
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var Bode = db.Bo_De.Find(maDe);
// Bode.TrangThai = trangthai;
Bode.TrangThai = false;
db.SaveChanges();
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
List <Bo_De> bo_Des = new TracNghiemOnlineDB().Bo_De.Where(x => x.Ma_NguoiTao.Equals(session.TaiKhoan1) && x.Xoa == true && x.TrangThai == false || (x.TrangThai == true && x.NguoiDuyet.Equals(session.TaiKhoan1))).ToList();
if (session.ChưcVu.Equals("Cán Bộ"))
{
bo_Des = new TracNghiemOnlineDB().Bo_De.Where(x => x.Ma_NguoiTao == session.TaiKhoan1 && x.Xoa == true && x.NguoiDuyet == null).ToList();
}
var bode1 = (from n in bo_Des
select new
{
Ten = n.NoiDung,
MaDe = n.Ma_BoDe,
SoCau = n.SoCau,
ThoiGian = n.ThoiGianThi,
TenMon = n.MonHoc.TenMon,
Giaovien = n.GiaoVien.TenGV,
TrangThai = n.TrangThai,
}).ToList();
return(Json(new
{
Bode = bode1
}, JsonRequestBehavior.AllowGet));
}
public void CreateChapterStudy(Bo_De bo_De1)
{
Bo_De bo_De = new Bo_De();
bo_De.NoiDung = bo_De1.NoiDung;
bo_De.ThoiGianThi = bo_De1.ThoiGianThi;
bo_De.Ma_Mon = bo_De1.Ma_Mon;
bo_De.Ma_NguoiTao = bo_De1.Ma_NguoiTao;
bo_De.TrangThai = true;
bo_De.Xoa = true;
foreach (var item in bo_De1.CauHois)
{
item.Kho_CauHoi = null;
bo_De.CauHois.Add(item);
}
bo_De.SoCau = bo_De.CauHois.Count;
try
{
db = new TracNghiemOnlineDB();
db.Bo_De.Add(bo_De);
db.SaveChanges();
}catch (Exception e)
{
}
}
public ActionResult KhoCH(long id)
{
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
var gv = new TracNghiemOnlineDB().GiaoViens.Find(session.TaiKhoan1);
ViewBag.Kho = "KHO GIÁO VIÊN";
List <Kho_CauHoi> kho_CauHois = new TracNghiemOnlineDB().Kho_CauHoi.Where(x => x.NguoiTao.Equals(session.TaiKhoan1) && x.Xoa == true && x.TrangThai == true && x.Ma_Chuong == id).ToList();
string loai = (string)Session["Kho"];
if (loai.Equals("BM"))
{
kho_CauHois = new TracNghiemOnlineDB().Kho_CauHoi.Where(x => x.NguoiTao.Equals(gv.MaBoMon) && x.Xoa == true && x.Ma_Chuong == id).ToList();
ViewBag.Kho = "KHO BỘ MÔN";
}
if (loai.Equals("ON"))
{
kho_CauHois = new TracNghiemOnlineDB().Kho_CauHoi.Where(x => x.NguoiTao.Equals(session.TaiKhoan1) && x.Xoa == true && x.TrangThai == false && x.Ma_Chuong == id).ToList();
ViewBag.Kho = "KHO ÔN TẬP";
}
Session[ComMon.ComMonStants.Cauhoi] = null;
ViewBag.MaChuong = id;
// List<Kho_CauHoi> kho_CauHois = new TracNghiemOnlineDB().Kho_CauHoi.Where(x => x.NguoiTao.Equals(session.TaiKhoan1) && x.Xoa == true && x.Ma_Chuong == id).ToList();
ViewBag.kho = "";
return(View(kho_CauHois));
}
public JsonResult AddSinhVien(string maSV, string tenSV, DateTime ngaySinh, string diaChi, string maLop)
{
try
{
var n = new SinhVien();
n.MaSV = maSV;
n.Ten = tenSV;
n.NgaySinh = ngaySinh;
n.DiaChi = diaChi;
n.Ma_Lop = maLop;
n.DaXoa = 0;
db.SinhViens.Add(n);
db.SaveChanges();
TracNghiemOnlineDB tracNghiem = new TracNghiemOnlineDB();
TaiKhoan taiKhoan = new TaiKhoan();
taiKhoan.MatKhau = "1";
taiKhoan.TaiKhoan1 = "" + n.MaSV;
taiKhoan.TenDangNhap = "" + n.MaSV;
taiKhoan.ChưcVu = "SinhViên";
taiKhoan.TrangThai = true;
tracNghiem.TaiKhoans.Add(taiKhoan);
tracNghiem.SaveChanges();
return(Json(new { code = 200, msg = "Thêm mới thành công" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { code = 500, msg = "Không thành công" + e.Message }, JsonRequestBehavior.AllowGet));
}
}
public void GuiboMon(long id, string tgbd)
{
string[] ngay = tgbd.Split('/');
long id1 = (long)Session["mads"];
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var bode = db.DSGV_ThucHien.Find(id1);
DateTime date = new DateTime(int.Parse(ngay[0]), int.Parse(ngay[1]), int.Parse(ngay[2]), int.Parse(ngay[3]), int.Parse(ngay[4]), int.Parse(ngay[5]));
bode.MaDE = id;
var lich = db.LichNops.Find(bode.MaLich);
try
{
if (date > lich.ThoiGian)
{
bode.trangthai = "Nộp Muộn";
}
else
{
bode.trangthai = "Đang xử lý";
}
}
catch {
bode.trangthai = "Đang xử lý";
}
bode.NgayNop = date;
Session["mads"] = null;
db.SaveChanges();
}
public ActionResult VaoThi(string id)
{
var phong = new QuanLyThiDAO().ExamitionRoom(id);
if (phong.TrangThai.Equals("Chưa Thi"))
{
ViewBag.MaPhong = id;
return(View("PhongCho"));
}
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
var DeThi = new QuanLyThiDAO().SeachForTheExam(phong, session.TaiKhoan1);
if (DeThi == null)
{
var list = new BoDeDao().ChapterStudy(long.Parse(phong.MaBoDe.ToString()));
DeThi = new BoDeDao().MixExemQuestion(list, session.TaiKhoan1);
}
new BoDeDao().UpdateDsThi(phong, DeThi, session.TaiKhoan1, "Đã vào phòng");
Session[ComMon.ComMonStants.ExamQuesTion] = DeThi;
DateTime dateTime = DateTime.Parse(phong.ThoiGianDong.ToString());
CT_Dethi cT_Dethi = new CT_Dethi();
cT_Dethi.MADETHI = DeThi.MaDeThi;
cT_Dethi.LYDO = "Sinh viên đã vào phòng";
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
db.CT_Dethi.Add(cT_Dethi);
db.SaveChanges();
ViewBag.GioThi = dateTime.AddMinutes(5).ToString("yyyy/MM/dd HH:mm:ss");
ViewBag.DeThi = DeThi;
return(View(phong));
}
public JsonResult KiemTraDe(long madethi)
{
var dethi = new TracNghiemOnlineDB().De_Thi.Find(madethi);
try
{
var ds = new TracNghiemOnlineDB().DS_SVThi.SingleOrDefault(x => x.MaDeThi == madethi);
if (ds.TrangThai.Equals("Đã Nộp"))
{
return(Json(new
{
status = false
}));
}
}
catch { }
if (dethi.TrangThai == false)
{
return(Json(new
{
status = false
}));
}
else
{
return(Json(new
{
status = true
}));
}
}
//them lop học phan
internal void CreateClassRoom(string malop, long mamon, string id, long maki)
{
try
{
LopHocPhan lopHocPhan = new LopHocPhan();
while (true)
{
Random random = new Random();
lopHocPhan.MaLop = RandomString(2) + random.Next(8);
if (!db.LopHocPhans.ToList().Exists(x => x.MaLop.Equals(lopHocPhan.MaLop)))
{
break;
}
}
db = new TracNghiemOnlineDB();
lopHocPhan.TenLop = malop;
lopHocPhan.MaMon = mamon;
lopHocPhan.MaGV = id;
lopHocPhan.MaKi = maki;
lopHocPhan.TrangThai = 1;
db.LopHocPhans.Add(lopHocPhan);
db.SaveChanges();
}
catch (Exception e)
{
}
}
public ActionResult DSSVThi(string id)
{
Session["Maphong"] = id;
Phong_Thi phong_Thi = new TracNghiemOnlineDB().Phong_Thi.Where(x => x.MaPhong.Equals(id)).ToList().First();
return(View(phong_Thi));
}
public ActionResult TaoLich(LichNop lichNop)
{
if (ModelState.IsValid)
{
try
{
string[] ds = (string[])Session["dsgv"];
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
if (ds.Length > 1)
{
lichNop.TrangThai = true;
lichNop.xoa = true;
lichNop.MaBoMON = session.TaiKhoan1;
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
db.LichNops.Add(lichNop);
db.SaveChanges();
for (int i = 0; i < ds.Length - 1; i++)
{
DSGV_ThucHien GV = new DSGV_ThucHien();
GV.MaGV = ds[i];
GV.MaLich = new TracNghiemOnlineDB().LichNops.ToList().Last().id;
db.DSGV_ThucHien.Add(GV);
db.SaveChanges();
}
return(RedirectToAction("BoMON"));
}
}
catch {
ModelState.AddModelError("", "Vui lòng chọn giáo viên ");
}
}
return(View(lichNop));
}
public ActionResult Diemthi(long id)
{
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var de = db.De_Thi.Find(id);
var exam = new QuanLyThiDAO().SearDethi(id);
var mark = new QuanLyThiDAO().Mark(exam);
Session[ComMon.ComMonStants.ExamQuesTion] = null;
de.TrangThai = true;
de.DiêmSo = mark.ketQuaThi.DiemSo;
db.SaveChanges();
var SV = db.DS_SVThi.SingleOrDefault(x => x.MaDeThi == de.MaDeThi);
try
{
if (SV != null)
{
DateTime dateTime = (DateTime)Session["Gio"];
if (!SV.TrangThai.Equals("Đã Nộp"))
{
SV.TrangThai = "Đã Nộp";
CT_Dethi cT_Dethi = new CT_Dethi();
cT_Dethi.MADETHI = id;
cT_Dethi.LYDO = "Sinh viên đã nộp bài" + dateTime.ToString();
db.CT_Dethi.Add(cT_Dethi);
db.SaveChanges();
}
}
}
catch { }
return(View(mark));
}
public int HuyDe(long madethi1, string tgbd)
{
var ngay = tgbd.Split('/');
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var dethi = db.De_Thi.Find(madethi1);
if (dethi.dem == null)
{
dethi.dem = 0;
}
dethi.dem++;
db.SaveChanges();
DateTime data = new DateTime(int.Parse(ngay[0]), int.Parse(ngay[1]), int.Parse(ngay[2]), int.Parse(ngay[3]), int.Parse(ngay[4]), int.Parse(ngay[5]));
// dethi.TrangThai = false;
// dethi.CT_Dethi = dethi.CT_Dethi + "D";
CT_Dethi cT = new CT_Dethi();
cT.MADETHI = madethi1;
cT.LYDO = "Sinh viên đã rời khỏi màn hình lúc " + data.ToString();
db.CT_Dethi.Add(cT);
db.SaveChanges();
// TracNghiemOnlineDB = new TracNghiemOnlineDB();
var ds = db.DS_SVThi.SingleOrDefault(x => x.MaDeThi == madethi1);
ds.TrangThai = "Đã chuyển tab";
db.SaveChanges();
return(dethi.dem.Value);
}
public ActionResult Index(string id)
{
LopHocPhan lopHoc = new TracNghiemOnlineDB().LopHocPhans.Find(id);
Session["LopHP"] = lopHoc;
var session = (TaiKhoan)Session[ComMonStants.UserLogin];
foreach (var item in new TracNghiemOnlineDB().Chuong_Hoc.Where(x => x.Ma_Mon == lopHoc.MaMon && x.TrangThai == 1))
{
if (!new TracNghiemOnlineDB().DS_BaiHoc.Select(x => x).ToList().Exists(x => x.Ma_Bai == item.Ma_Chuong && x.MaSV.Equals(session.TaiKhoan1)))
{
TracNghiemOnlineDB tracNghiemDB = new TracNghiemOnlineDB();
tracNghiemDB.DS_BaiHoc.Add(new DS_BaiHoc()
{
SoCauSai = 0,
Ma_Bai = item.Ma_Chuong,
MaSV = session.TaiKhoan1,
SoCauDung = 0,
ListCauHoi = ""
});
tracNghiemDB.SaveChanges();
}
}
return(View(new TracNghiemOnlineDB().Chuong_Hoc.Where(x => x.Ma_Mon == lopHoc.MaMon && x.TrangThai == 1)));
}
//sua phong tho
internal void UpDatePhongThi(Phong_Thi classRoom)
{
// classRoom.ThoiGianDong = classRoom.ThoiGianMo.AddMinutes(double.Parse(classRoom.Bo_De.ThoiGianThi));
var Room = db.Phong_Thi.Find(classRoom.MaPhong);
Room.MaBoDe = classRoom.MaBoDe;
Room.TrangThai = classRoom.TrangThai;
Room.Xoa = classRoom.Xoa;
Room.ThoiGianMo = classRoom.ThoiGianMo;
Room.ThoiGianDong = classRoom.ThoiGianDong;
db.SaveChanges();
db = new TracNghiemOnlineDB();
var ds = db.DS_SVThi.Where(x => x.MaPhong == classRoom.MaPhong).ToList();
foreach (var item in ds)
{
if (item.MaDeThi == null)
{
var list = new BoDeDao().ChapterStudy(long.Parse(classRoom.MaBoDe.ToString()));
var dethi = new BoDeDao().MixExemQuestion(list, item.Ma_SV);
new BoDeDao().UpdateDsThi(classRoom, dethi, item.Ma_SV, "Chưa Làm");
}
}
}
public void DeleteSinhVien(string maSV, string MaLop)
{
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var SV = db.DS_LopHP.SingleOrDefault(x => x.Ma_LOP.Equals(MaLop) && x.MA_SV.Equals(maSV));
db.DS_LopHP.Remove(SV);
db.SaveChanges();
}
public ActionResult Menu()
{
var taikhoan = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
var tendangnhap = new TracNghiemOnlineDB().TaiKhoans.Where(x => x.TenDangNhap == taikhoan.TenDangNhap).FirstOrDefault().TaiKhoan1;
ViewBag.HoTen = new TracNghiemOnlineDB().SinhViens.Where(x => x.MaSV == tendangnhap).FirstOrDefault().Ten;
return(PartialView());
}
public ActionResult DSDEGUI()
{
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
var BoDe = new TracNghiemOnlineDB().Bo_De.Where(x => x.Ma_NguoiTao == session.TaiKhoan1 && x.Xoa == true &&
x.PheDuyet != null).ToList();
return(View(BoDe));
}
public ActionResult LoadQuestion()
{
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
List <Kho_CauHoi> cauHois = (List <Kho_CauHoi>)Session[ComMon.ComMonStants.Cauhoi];
if (session.ChưcVu.Equals("BoMon"))
{
foreach (var item in cauHois)
{
item.Xoa = true;
item.TrangThai = true;
item.NguoiTao = session.TaiKhoan1;
new CauHoiDao().CreatrQuestion(item);
}
Session[ComMon.ComMonStants.Cauhoi] = null;
return(RedirectToAction("Index/" + cauHois[0].Ma_Chuong, "CauHoi"));
}
else
{
string loai = (string)Session["Kho"];
if (loai.Equals("BM"))
{
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var gv = db.GiaoViens.Find(session.TaiKhoan1);
foreach (var item in cauHois)
{
item.Xoa = true;
item.TrangThai = true;
item.NguoiTao = gv.MaBoMon;
new CauHoiDao().CreatrQuestion(item);
}
}
else if (loai.Equals("ON"))
{
foreach (var item in cauHois)
{
item.Xoa = true;
item.TrangThai = false;
item.NguoiTao = session.TaiKhoan1;
new CauHoiDao().CreatrQuestion(item);
}
}
else
{
foreach (var item in cauHois)
{
item.Xoa = true;
item.TrangThai = true;
item.NguoiTao = session.TaiKhoan1;
new CauHoiDao().CreatrQuestion(item);
}
}
}
return(RedirectToAction("KhoCH/" + cauHois[0].Ma_Chuong, "CauHoi"));
//cauHois = new List<Kho_CauHoi>();
}
public JsonResult VaoThi(string id)
{
var classRom = new QuanLyThiDAO().ExamitionRoom(id);
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
Session[ComMon.ComMonStants.ExamRoom] = classRom;
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
bool quyen = true;
var bode = new BoDeDao().ListALLChapterStudy(long.Parse(classRom.LopHocPhan.MaMon.ToString()), session.TaiKhoan1);
if (session.ChưcVu.Equals("Cán Bộ"))
{
bode = new TracNghiemOnlineDB().Bo_De.Where(x => x.Ma_Mon == classRom.LopHocPhan.MaMon && x.Ma_NguoiTao.Equals(session.TaiKhoan1) && x.Xoa == true && x.LoaiDe == false).ToList();
foreach (var item in db.Shares.Where(x => x.MaGV.Equals(session.TaiKhoan1) && x.Loai == 0))
{
try
{
var bode2 = db.Bo_De.Where(x => x.Ma_BoDe == item.MA && x.Xoa == true).ToList();
if (bode2.Count > 0)
{
bode.Add(bode2[0]);
}
}
catch { }
}
}
long made = 0;
string trangthai = classRom.TrangThai;
try
{
made = long.Parse(classRom.MaBoDe.ToString());
}
catch
{
made = 0;
}
var bode1 = (from n in bode
select new
{
Ten = n.NoiDung,
MaDe = n.Ma_BoDe,
SoCau = n.SoCau,
ThoiGian = n.ThoiGianThi,
TenMon = n.MonHoc.TenMon,
NguoiTao = new TracNghiemOnlineDB().GiaoViens.Find(n.Ma_NguoiTao).TenGV
}).ToList();
return(Json(new
{
Bode = bode1,
trangthai,
made,
}, JsonRequestBehavior.AllowGet));;
}
public ActionResult LichSuThi(long id)
{
De_Thi de_Thi = new TracNghiemOnlineDB().De_Thi.Where(x => x.MaDeThi == id).ToList()[0];
// ViewBag.lstLop = new SelectList(ltsLop, "Ma_Lop", "TenLop");
ViewBag.TruDiem = new SelectList(new DiemTru().listAll(), "value", "Ten");
return(View(de_Thi));
}
public string LuuSinhVien(string DSlop)
{
var dS = new JavaScriptSerializer().Deserialize <List <DS_LopHP> >(DSlop);
var db = new TracNghiemOnlineDB();
db.DS_LopHP.AddRange(dS);
db.SaveChanges();
return("");
}
public ActionResult NgânHangCauHoi(string id)
{
Session["Kho"] = id;
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
var canbo = new TracNghiemOnlineDB().GiaoViens.Find(session.TaiKhoan1);
reseach();
return(View(new TracNghiemOnlineDB().MonHocs.Where(x => x.MaBoMon.Equals(canbo.MaBoMon)).ToList()));
}
public ActionResult Save()
{
string maphong = "";
List <DS_SVThi> dssv = ((List <DS_SVThi>)Session["Sinhvien"]);
foreach (var item in dssv)
{
TracNghiemOnlineDB db = new TracNghiemOnlineDB();
var LopHP = db.LopHocPhans.Find(item.MaPhong);
if (LopHP != null)
{
maphong = LopHP.MaLop;
if (!db.DS_LopHP.ToList().Exists(x => x.MA_SV.Equals(item.Ma_SV) && x.TrangThai != false && x.Ma_LOP.Equals(LopHP.MaLop)))
{
DS_LopHP DS = new DS_LopHP();
DS.MA_SV = item.Ma_SV;
DS.Ma_LOP = LopHP.MaLop;
DS.TrangThai = true;
db.DS_LopHP.Add(DS);
db.SaveChanges();
}
}
else
{
try
{
var phong = db.Phong_Thi.Find(item.MaPhong);
if (db.DS_LopHP.ToList().Exists(x => x.MA_SV.Equals(item.Ma_SV) && !x.TrangThai == false && x.Ma_LOP.Equals(phong.MaLopHP)))
{
if (!db.DS_SVThi.ToList().Exists(x => x.Ma_SV.Equals(item.Ma_SV) && x.MaPhong.Equals(item.MaPhong)))
{
db.DS_SVThi.Add(item);
db.SaveChanges();
}
}
}
catch
{
}
}
Session["Sinhvien"] = null;
}
Session["Maphong"] = "";
if (maphong.Length > 0)
{
return(Redirect("/Admin/QuanLyThi/DSSinhVen/" + maphong.Trim()));
}
else
{
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
return(Redirect("/Admin/Home/DSSVThi/" + dssv.ToList()[0].MaPhong));
}
}
// GET: Admin/CauHoi
// static List<Kho_CauHoi> cauHois=new List<Kho_CauHoi>();
public ActionResult Index(long?id)
{
Session[ComMon.ComMonStants.Cauhoi] = null;
var session = (TaiKhoan)Session[ComMon.ComMonStants.UserLogin];
ViewBag.MaChuong = id;
List <Kho_CauHoi> kho_CauHois = new TracNghiemOnlineDB().Kho_CauHoi.Where(x => x.NguoiTao.Equals(session.TaiKhoan1) && x.Xoa == true && x.Ma_Chuong == id).ToList();
return(View(kho_CauHois));
}
