public JsonResult GetLopKT()
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
var lstLopKT = db.LopKiemTras.Where(x => x.GVID == session.ID);
List <LopKTModel> LopKTs = new List <LopKTModel>();
foreach (var item in lstLopKT)
{
LopKTModel lopKT = new LopKTModel();
lopKT.ID = item.ID;
lopKT.Name = item.Name;
lopKT.TestDate = item.TestDate.Value.ToString("dd/MM/yyyy");
lopKT.GVID = item.GVID;
lopKT.MonHocID = item.MaMonHoc;
lopKT.ThoiGianThi = (int)item.ThoiGianThi;
//lopKT.MaDeThi = item.MaDeThi;
if (item.MaDeThi == null)
{
lopKT.TenDeThi = "Chưa chọn đề thi";
}
else
{
lopKT.TenDeThi = item.DeThi.TenDeThi;
}
LopKTs.Add(lopKT);
}
return(Json(LopKTs, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetCauHoiKT(LopKTModel lop)
{
using (ELearningDB db = new ELearningDB())
{
var lstCauHoi = db.CauHois.Where(x => x.DeThis.Any(r => r.MaDeThi == lop.MaDeThi)).ToList();
List <CauHoiModel> CauHois = new List <CauHoiModel>();
foreach (var item in lstCauHoi)
{
CauHoiModel ch = new CauHoiModel();
ch.NoiDung = item.NoiDung;
ch.BieuThuc = item.BieuThuc;
ch.CauA = item.CauA;
ch.BieuThucA = item.BieuThucA;
ch.CauB = item.CauB;
ch.BieuThucB = item.BieuThucB;
ch.CauC = item.CauC;
ch.BieuThucC = item.BieuThucC;
ch.CauD = item.CauD;
ch.BieuThucD = item.BieuThucD;
ch.DapAn = (int)item.DapAn;
CauHois.Add(ch);
}
return(Json(CauHois, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Delete(LopKTModel lop)
{
using (ELearningDB db = new ELearningDB())
{
if (lop != null)
{
LopKiemTra lopkt = db.LopKiemTras.Find(lop.ID);
db.LopKiemTras.Remove(lopkt);
db.SaveChanges();
return(Json(new { success = true }));
}
return(Json(new { success = false }));
}
}
public JsonResult UpdateDeThi(LopKTModel lop)
{
using (ELearningDB db = new ELearningDB())
{
if (lop != null)
{
LopKiemTra lopkt = db.LopKiemTras.Find(lop.ID);
DeThi dt = db.DeThis.Find(lop.MaDeThi);
string tendt = dt.TenDeThi;
lopkt.MaDeThi = lop.MaDeThi;
db.SaveChanges();
return(Json(new { success = tendt }));
}
return(Json(new { success = false }));
}
}
public JsonResult Update(LopKTModel lop)
{
using (ELearningDB db = new ELearningDB())
{
if (lop != null)
{
var l = db.LopKiemTras.Find(lop.ID);
if (l == null)
{
return(Json(new { success = false }));
}
l.Name = lop.Name;
l.MaMonHoc = lop.MonHocID;
l.TestDate = lop.NgayKT.AddDays(1);
l.ThoiGianThi = lop.ThoiGianThi;
db.SaveChanges();
return(Json(new { success = true }));
}
return(Json(new { success = false }));
}
}
public JsonResult Create(LopKTModel lop)
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
if (lop != null)
{
LopKiemTra lopkt = new LopKiemTra();
lopkt.Name = lop.Name;
lopkt.TestDate = lop.NgayKT.AddDays(1);
lopkt.MaMonHoc = lop.MonHocID;
lopkt.MaDeThi = null;
lopkt.GVID = session.ID;
lopkt.ThoiGianThi = lop.ThoiGianThi;
db.LopKiemTras.Add(lopkt);
db.SaveChanges();
return(Json(new { success = true }));
}
return(Json(new { success = false }));
}
}
public JsonResult GetLopKT(int id)
{
using (ELearningDB db = new ELearningDB())
{
HocVien hv = db.HocViens.Find(id);
TimeZoneInfo date = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time");
DateTime utc = DateTime.UtcNow;
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(utc, date);
var DaKiemTra = new List <LopKiemTra>();
//var lstLopKT = db.LopKiemTra.Where(x => x.HocVien.Any(r => r.ID == id)).ToList();
//var lstBaiLam = db.BaiLam.Where(x => x.MaHocVien == id).ToList();
var lstbl = (from x in db.BaiLams
where x.MaHocVien == id
select x.MaLopKiemTra).ToList();
foreach (var item in lstbl)
{
var l = db.LopKiemTras.Where(x => x.HocViens.Any(r => r.ID == id) && x.ID == item).FirstOrDefault();
DaKiemTra.Add(l);
}
var lstLopKT = db.LopKiemTras.Where(x => x.HocViens.Any(r => r.ID == id)).ToList().Except(DaKiemTra);
List <LopKTModel> Lops = new List <LopKTModel>();
foreach (var item in lstLopKT)
{
if (item.TestDate.Value.Date == now.Date)
{
LopKTModel l = new LopKTModel();
l.ID = item.ID;
l.Name = item.Name;
l.MaDeThi = item.MaDeThi;
l.SoCauHoi = (int)item.DeThi.SoCauHoi;
l.ThoiGianThi = (int)item.ThoiGianThi;
Lops.Add(l);
}
}
return(Json(Lops, JsonRequestBehavior.AllowGet));
}
}
