public ActionResult Edit(tblTheLoaiSach model, FormCollection collection) { db = new TRUONGHOCDbContext(); var item = db.tblTheLoaiSaches.Find(model.ID); item.TEN_THELOAI = model.TEN_THELOAI; item.MA_THELOAI = model.MA_THELOAI; var itemtl = db.tblTheLoaiSaches.Where(x => x.TRANG_THAI == 1 && x.ID != model.ID).ToList(); foreach (var itemNXB in itemtl) { if (item.MA_THELOAI == itemNXB.MA_THELOAI) { ModelState.AddModelError("", "Mã đã tồn tại"); break; } } if (ModelState.IsValid) { db.SaveChanges(); return(RedirectToAction("Index", "TheLoaiSach")); } else { return(View(model)); } }
public ActionResult Create(tblTheLoaiSach model, FormCollection collection) { db = new TRUONGHOCDbContext(); model.TRANG_THAI = 1; var item = db.tblTheLoaiSaches.Where(x => x.TRANG_THAI == 1).ToList(); foreach (var itemNXB in item) { if (model.MA_THELOAI == itemNXB.MA_THELOAI) { ModelState.AddModelError("", "Mã đã tồn tại"); break; } } if (ModelState.IsValid) { db.tblTheLoaiSaches.Add(model); db.SaveChanges(); return(RedirectToAction("Index", "TheLoaiSach")); } else { return(View()); } }