public void AddKiThi(string nd) { TracNghiemOnlineDB db = new TracNghiemOnlineDB(); KiThi kiThi = new KiThi(); kiThi.TenKi = nd; kiThi.TrangThai = true; db.KiThis.Add(kiThi); db.SaveChanges(); }
public JsonResult DeleteKiThi(long maki) { try { TracNghiemOnlineDB db = new TracNghiemOnlineDB(); KiThi kiThi = db.KiThis.Find(maki); db.KiThis.Remove(kiThi); db.SaveChanges(); } catch (Exception e) { return(Json(new { msg = "Đang Có Lớp Học Được Tạo" }, JsonRequestBehavior.AllowGet)); } return(Json(new { msg = "Xóa Thành Công" }, JsonRequestBehavior.AllowGet)); }
public void Update(long maki, string nd, bool trangthai) { TracNghiemOnlineDB db = new TracNghiemOnlineDB(); KiThi kiThi = db.KiThis.Find(maki); kiThi.TenKi = nd; kiThi.TrangThai = trangthai; db.SaveChanges(); List <LopHocPhan> list = new TracNghiemOnlineDB().LopHocPhans.Where(x => x.MaKi == maki).ToList(); if (trangthai == false) { foreach (var item in list) { db = new TracNghiemOnlineDB(); LopHocPhan lop = db.LopHocPhans.Find(item.MaLop); lop.TrangThai = 0; db.SaveChanges(); } } else { { foreach (var item in db.LopHocPhans.Where(x => x.MaKi == maki)) { db = new TracNghiemOnlineDB(); LopHocPhan lop = db.LopHocPhans.Find(item.MaLop); lop.TrangThai = 1; db.SaveChanges(); } } } }