public static List <Book> GetAllBooks()
{
using (var db = new SE407_BookstoreContext())
{
return(db.Books.ToList());
}
}
public static List <Book> GetAllAuthorBooks(String author)
{
using (var db = new SE407_BookstoreContext())
{
return(db.Books
.Join(db.Authors,
b => b.AuthorId,
a => a.AuthorId,
(b, a) => new
{
BookId = b.BookId,
BookTitle = b.BookTitle,
GenreId = b.GenreId,
AuthorId = b.AuthorId,
YearOfRelease = b.YearOfRelease,
AuthorLast = a.AuthorLast
}).Where(w => w.AuthorLast == author)
.Select(b => new Book
{
BookId = b.BookId,
BookTitle = b.BookTitle,
GenreId = b.GenreId,
AuthorId = b.AuthorId,
YearOfRelease = b.YearOfRelease
}).ToList());
}
}
public static Book GetBookByTitle(String titleStr)
{
using (var db = new SE407_BookstoreContext())
{
return(db.Books.Where(b => b.BookTitle == titleStr).FirstOrDefault());
}
}
public static List <Genre> GetAllGenres()
{
using (var db = new SE407_BookstoreContext())
{
return(db.Genres.ToList());
}
}
public static List <Author> GetAllAuthors()
{
using (var db = new SE407_BookstoreContext())
{
return(db.Authors.ToList());
}
}
public static List <Book> GetAllBooksFull()
{
using (var db = new SE407_BookstoreContext())
{
var books = db.Books
.Include(books => books.Author)
.Include(books => books.Genre)
.ToList();
return(books);
}
}
public static Book GetFullBookById(int id)
{
using (var db = new SE407_BookstoreContext())
{
var book = db.Books
.Include(b => b.Author)
.Include(b => b.Genre)
.Where(b => b.BookId == id)
.FirstOrDefault();
return(book);
}
}
public static void addBook(Book book)
{
try
{
using (var db = new SE407_BookstoreContext())
{
db.Books.Add(book);
db.SaveChanges();
}
}
catch (Exception e)
{
}
}
public static void deleteBook(int id)
{
try
{
using (var db = new SE407_BookstoreContext())
{
var bookToDelete = db.Books.Find(id);
db.Books.Remove(bookToDelete);
db.SaveChanges();
}
}
catch (Exception e)
{
}
}
