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 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 addGenre(Genre g)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Genres.Add(g);
db.SaveChanges();
}
}
public static void addBook(Book b)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Books.Add(b);
db.SaveChanges();
}
}
public static void addAuthor(Author a)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Authors.Add(a);
db.SaveChanges();
}
}
public static void addReview(Review r)
{
using (BookClub_Entities db = new BookClub_Entities())
{
db.Reviews.Add(r);
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 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();
}
}
}