public static void addAuthor(Author a)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Authors.Add(a);
db.SaveChanges();
}
}
public static void deleteBook(string ISBN)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Books.Remove(db.Books.Where(b => b.ISBN == ISBN).FirstOrDefault());
db.SaveChanges();
}
}
public static void addGenre(Genre g)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Genres.Add(g);
db.SaveChanges();
}
}
public static void addReview(Review r)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Reviews.Add(r);
db.SaveChanges();
}
}
public static void deleteAuthor(int id)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Authors.Remove(db.Authors.Where(g => g.id == id).FirstOrDefault());
db.SaveChanges();
}
}
public static void addBook(Book b)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Books.Add(b);
db.SaveChanges();
}
}
public static void dislikeReview(int reviewId, string userName)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Reviews.Where(b => b.id == reviewId).FirstOrDefault().UsersLikes.
Remove(db.AspNetUsers.Where(u => u.UserName == userName).FirstOrDefault());
db.SaveChanges();
}
}
public static void dislikeBook(string ISBN, string userName)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Books.Where(b => b.ISBN == ISBN).FirstOrDefault().aspnet_UsersLikes.
Remove(db.AspNetUsers.Where(u => u.UserName == userName).FirstOrDefault());
db.SaveChanges();
}
}
public static void updateAuthor(Author author)
{
using (BookClub_Entities db = new BookClub_Entities())
{
var oldAuthor = db.Authors.Where(a => a.id == author.id).FirstOrDefault();
oldAuthor.Name = author.Name;
oldAuthor.description = author.description;
db.SaveChanges();
}
}
public static void updateGenre(Genre genre)
{
using (BookClub_Entities db = new BookClub_Entities())
{
var oldGenre = db.Genres.Where(g => g.id == genre.id).FirstOrDefault();
oldGenre.Name = genre.Name;
oldGenre.description = genre.description;
db.SaveChanges();
}
}
public static List <ReviewView> getReviews(string ISBN)
{
List <ReviewView> reviews;
using (BookClub_Entities db = new BookClub_Entities())
{
reviews = db.ReviewViews.Where(b => b.bookId == ISBN).ToList();
}
return(reviews);
}
public static List <Author> getAllAuthors()
{
List <Author> author;
using (BookClub_Entities db = new BookClub_Entities())
{
author = db.Authors.ToList();
}
return(author);
}
public static List <BookView> getBooksByGenre(int genreId)
{
List <BookView> books;
using (BookClub_Entities db = new BookClub_Entities())
{
books = db.BookViews.Where(b => b.genreId == genreId).ToList();
}
return(books);
}
public static List <BookView> getBooksByAuthor(int authorId)
{
List <BookView> books;
using (BookClub_Entities db = new BookClub_Entities())
{
books = db.BookViews.Where(b => b.authorId == authorId).ToList();
}
return(books);
}
public static Book getBookByISBN(string ISBN)
{
Book book;
using (BookClub_Entities db = new BookClub_Entities())
{
book = db.Books.Where(b => b.ISBN == ISBN).FirstOrDefault();
}
return(book);
}
public static List <Genre> getAllGenres()
{
List <Genre> genre;
using (BookClub_Entities db = new BookClub_Entities())
{
genre = db.Genres.ToList();
}
return(genre);
}
public static List <BookView> getAllBooks()
{
List <BookView> books;
using (BookClub_Entities db = new BookClub_Entities())
{
books = db.BookViews.ToList();
}
return(books);
}
public static AspNetUser getUserByName(string userName)
{
AspNetUser user;
using (BookClub_Entities db = new BookClub_Entities())
{
user = db.AspNetUsers.Where(b => b.UserName == userName).FirstOrDefault();
}
return(user);
}
public static bool ReviewIsLiked(int reviewId, string userName)
{
bool liked = false;
using (BookClub_Entities db = new BookClub_Entities())
{
if (db.Reviews.Where(b => b.id == reviewId).FirstOrDefault().UsersLikes
.FirstOrDefault(u => u.UserName == userName) != null)
{
liked = true;
}
db.SaveChanges();
}
return(liked);
}
public static bool bookIsLiked(string ISBN, string userName)
{
bool liked = false;
using (BookClub_Entities db = new BookClub_Entities())
{
if (db.Books.Where(b => b.ISBN == ISBN).FirstOrDefault().aspnet_UsersLikes
.FirstOrDefault(u => u.UserName == userName) != null)
{
liked = true;
}
db.SaveChanges();
}
return(liked);
}
public static void updateBook(Book book)
{
using (BookClub_Entities db = new BookClub_Entities())
{
var oldBook = db.Books.Where(b => b.ISBN == book.ISBN).FirstOrDefault();
if (oldBook != null)
{
oldBook.title = book.title;
oldBook.image = book.image;
oldBook.genreId = book.genreId;
oldBook.authorId = book.authorId;
oldBook.description = book.description;
oldBook.date = book.date;
db.SaveChanges();
}
}
}
public static List <BookView> getAllLikedBooks(string userName)
{
List <BookView> booksV = new List <BookView>();
using (BookClub_Entities db = new BookClub_Entities())
{
var books = db.AspNetUsers.Where(u => u.UserName == userName).FirstOrDefault().Books;
foreach (var item in books)
{
var m = db.BookViews.Where(b => b.ISBN == item.ISBN).FirstOrDefault();
if (m != null)
{
booksV.Add(m);
}
}
}
return(booksV);
}
