// GET: All books public JsonResult GetAllBooks() { using (BookDBContext contextObj = new BookDBContext()) { var bookList = contextObj.book.ToList(); return Json(bookList, JsonRequestBehavior.AllowGet); } }
//GET: Book by Id public JsonResult GetBookById(string id) { using (BookDBContext contextObj = new BookDBContext()) { var bookId = Convert.ToInt32(id); var getBookById = contextObj.book.Find(bookId); return Json(getBookById, JsonRequestBehavior.AllowGet); } }
// Add book public string AddBook(Book book) { if (book != null) { using (BookDBContext contextObj = new BookDBContext()) { contextObj.book.Add(book); contextObj.SaveChanges(); return "Book record added successfully"; } } else { return "Invalid book record"; } }
//Update Book public string UpdateBook(Book book) { if (book != null) { using (BookDBContext contextObj = new BookDBContext()) { int bookId = Convert.ToInt32(book.Id); Book _book = contextObj.book.Where(b => b.Id == bookId).FirstOrDefault(); _book.Title = book.Title; _book.Author = book.Author; _book.Publisher = book.Publisher; _book.Isbn = book.Isbn; contextObj.SaveChanges(); return "Book record updated successfully"; } } else { return "Invalid book record"; } }
// Delete book public string DeleteBook(string bookId) { if (!String.IsNullOrEmpty(bookId)) { try { int _bookId = Int32.Parse(bookId); using (BookDBContext contextObj = new BookDBContext()) { var _book = contextObj.book.Find(_bookId); contextObj.book.Remove(_book); contextObj.SaveChanges(); return "Selected book record deleted sucessfully"; } } catch (Exception) { return "Book details not found"; } } else { return "Invalid operation"; } }