Ejemplo n.º 1
0
 // 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";
     }
 }
Ejemplo n.º 2
0
 // GET: All books
 public JsonResult GetAllBooks()
 {
     using (BookDBContext contextObj = new BookDBContext())
     {
         var bookList = contextObj.book.ToList();
         return Json(bookList, JsonRequestBehavior.AllowGet);
     }
 }
Ejemplo n.º 3
0
 //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);
     }
 }
Ejemplo n.º 4
0
 // 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";
     }
 }
Ejemplo n.º 5
0
 //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";
     }
 }