public Available_Items findByAvailable_ItemsByID(int bookID) { Available_Items availableItem = null; try { using (var db = new LibraryDB()) { availableItem = db.Available_Items.Find(bookID); } } catch (Exception ex) { Console.WriteLine("find book by id " + ex.InnerException); } return(availableItem); }
public Boolean addAvailableItem(Available_Items item) { Boolean status = false; try { using (var db = new LibraryDB()) { db.Available_Items.Add(item); db.SaveChanges(); status = true; } } catch (Exception ex) { Console.WriteLine(ex.InnerException); } return(status); }
public Boolean updateItem(Available_Items item) { Boolean status = false; try { using (var db = new LibraryDB()) { Console.WriteLine("Book detail updated"); db.Available_Items.AddOrUpdate(item); db.SaveChanges(); status = true; } } catch (Exception ex) { Console.WriteLine("Update book problem " + ex.InnerException); } return(status); }