public static List <Book> ListAllBook()
{
using (Mybooks model = new Mybooks())
{
return(model.Books.ToList <Book>());
}
}
public static void DeleteBook(int bookID)
{
using (Mybooks model = new Mybooks())
{
Book ToDelete = model.Books.Where(b => b.BookID == bookID).First();
model.Books.Remove(ToDelete);
model.SaveChanges();
}
}
public static List <Book> Searched(string search)
{
using (Mybooks model = new Mybooks())
{
List <Book> ToSearch = model.Books.Where(c => c.Title.Contains(search) || c.Author.Contains(search)).ToList <Book>();
return(ToSearch);
}
}
public static void UpdateBook(int bookID, int Stock, decimal Price)
{
using (Mybooks model = new Mybooks())
{
Book ToUpdate = model.Books.Where(a => a.BookID == bookID).First();
ToUpdate.Stock = Stock;
ToUpdate.Price = Price;
model.SaveChanges();
}
}
