public void AddBook(Book newBook) { try { BookDataContext bookData = new BookDataContext(); bookData.Books.InsertOnSubmit(newBook); bookData.SubmitChanges(); } catch (Exception ex) { throw new Exception("Error:" + ex.Message); } }
public void DeleteBook(Book deletebook) { try { BookDataContext bookData = new BookDataContext(); Book book = bookData.Books.SingleOrDefault(b => b.BookID.Equals(deletebook.BookID)); bookData.Books.DeleteOnSubmit(book); bookData.SubmitChanges(); } catch (Exception ex) { throw new Exception("Error: " + ex.Message); } }
public void Update(Book updateBook) { try { BookDataContext bookData = new BookDataContext(); Book book = bookData.Books.SingleOrDefault(b => b.BookID.Equals(updateBook.BookID)); book.BookPrice = updateBook.BookPrice; book.BookTitle = updateBook.BookTitle; bookData.SubmitChanges(); } catch (Exception ex) { throw new Exception("Error " + ex.Message); } }