private static void IncreaseBookCopies(BookShopLabContext context)
{
Console.WriteLine("Please enter a date:");
DateTime date = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Please enter book copies (int):");
int bookCopies = int.Parse(Console.ReadLine());
var books = context.Books
.Where(b => b.ReleaseDate > date);
Console.WriteLine("Result: ");
Console.WriteLine(books.Count() * bookCopies);
var updatedBooks = context.Books
.Where(b => b.ReleaseDate > date)
.Update(b => new Book()
{
Copies = b.Copies + bookCopies
});
Console.WriteLine("Updated Books: {0}", updatedBooks);
context.SaveChanges();
}
private static void GetRelatedBooks(BookShopLabContext context)
{
var books = context.Books
.Take(3)
.ToList();
books[0].RelatedBooks.Add(books[1]);
books[1].RelatedBooks.Add(books[0]);
books[0].RelatedBooks.Add(books[2]);
books[2].RelatedBooks.Add(books[0]);
context.SaveChanges();
var booksFromQuery = context.Books
.Select(b => new
{
b.Title,
relatedBooks = b.RelatedBooks
})
.Take(3);
foreach (var book in booksFromQuery)
{
Console.WriteLine("--{0}", book.Title);
foreach (var b in book.relatedBooks)
{
Console.WriteLine(b.Title);
}
}
}
private static void RemoveBooks(BookShopLabContext context)
{
Console.WriteLine("Please enter number (int):");
int number = int.Parse(Console.ReadLine());
var books = context.Books
.Where(b => b.Copies < number)
.Delete();
Console.WriteLine($"Deleted books: {books}");
context.SaveChanges();
}
