public BookAverageRating Update(BookAverageRating ratingChanges) { var rating = context.BookAverageRatings.Attach(ratingChanges); rating.State = Microsoft.EntityFrameworkCore.EntityState.Modified; context.SaveChanges(); return(ratingChanges); }
public BookAverageRating Delete(int id) { BookAverageRating bookAverageRating = _bookAverageRating.FirstOrDefault(e => e.Id == id); if (bookAverageRating != null) { _bookAverageRating.Remove(bookAverageRating); } return(bookAverageRating); }
public BookAverageRating Update(BookAverageRating ratingChanges) { BookAverageRating book = _bookAverageRating.FirstOrDefault(e => e.Id == ratingChanges.Id); if (book != null) { book.AverageRating = ratingChanges.AverageRating; book.Book = ratingChanges.Book; } return(book); }
public BookAverageRating Delete(int id) { BookAverageRating rating = context.BookAverageRatings.Find(id); if (rating != null) { context.BookAverageRatings.Remove(rating); context.SaveChanges(); } return(rating); }
public BookAverageRating Add(BookAverageRating bookAverageRating) { bookAverageRating.Id = _bookAverageRating.Max(e => e.Id) + 1; var review5 = reviewRepository.GetAllReviews().Where(p => p.BookId == bookAverageRating.Book.Id).Where(p => p.Rating == 5).Count(); var review4 = reviewRepository.GetAllReviews().Where(p => p.BookId == bookAverageRating.Book.Id).Where(p => p.Rating == 4).Count(); var review3 = reviewRepository.GetAllReviews().Where(p => p.BookId == bookAverageRating.Book.Id).Where(p => p.Rating == 3).Count(); var review2 = reviewRepository.GetAllReviews().Where(p => p.BookId == bookAverageRating.Book.Id).Where(p => p.Rating == 2).Count(); var review1 = reviewRepository.GetAllReviews().Where(p => p.BookId == bookAverageRating.Book.Id).Where(p => p.Rating == 1).Count(); double total = ((5 * review5) + (4 * review4) + (3 * review3) + (2 * review2) + (1 * review1)); var totalReviews = (review1 + review2 + review3 + review4 + review5); var average = total / totalReviews; bookAverageRating.AverageRating = average; _bookAverageRating.Add(bookAverageRating); return(bookAverageRating); }
public BookAverageRating Add(BookAverageRating bookAverageRating) { context.BookAverageRatings.Add(bookAverageRating); context.SaveChanges(); return(bookAverageRating); }