public ActionResult AddOrEdit(Book bk) { using (CBookEntitiesBooks db = new CBookEntitiesBooks()) { if (bk.BookID == 0) { var isExist = IsBNameExist(bk.BName); if (isExist) { ModelState.AddModelError("BExist", "Book already Exist"); return(View(bk)); } else { db.Books.Add(bk); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } } else { db.Entry(bk).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public bool IsBNameExist(string bookname) { using (CBookEntitiesBooks db = new CBookEntitiesBooks()) { var v = db.Books.Where(a => a.BName == bookname).FirstOrDefault(); return(v != null); } }
public ActionResult GetData() { using (CBookEntitiesBooks db = new CBookEntitiesBooks()) { List <Book> bookList = db.Books.ToList <Book>(); return(Json(new { data = bookList }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (CBookEntitiesBooks db = new CBookEntitiesBooks()) { Book bk = db.Books.Where(x => x.BookID == id).FirstOrDefault <Book>(); db.Books.Remove(bk); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { return(View(new Book())); } else { using (CBookEntitiesBooks db = new CBookEntitiesBooks()) { return(View(db.Books.Where(x => x.BookID == id).FirstOrDefault <Book>())); } } }