public static void DeleteBooks(int BookId)
{
using (Bookshop entities = new Bookshop())
{
Book book = entities.Books.Where(p => p.BookID == BookId).First <Book>();
entities.Books.Remove(book);
entities.SaveChanges();
}
}
public static void UpdateBooks(int BookId,
string Title, int CategoryID, string Author, string ISBN, int Stock, decimal Price)
{
using (Bookshop entities = new Bookshop())
{
Book book = entities.Books.Where(p => p.BookID == BookId).First <Book>();
book.Title = Title;
book.CategoryID = CategoryID;
book.Author = Author;
book.ISBN = ISBN;
book.Stock = Stock;
book.Price = Price;
entities.SaveChanges();
}
}