[899b19d] | 1 | using backend.Data;
|
---|
| 2 | using backend.DTOs;
|
---|
| 3 | using backend.Entities;
|
---|
| 4 | using Microsoft.EntityFrameworkCore;
|
---|
| 5 |
|
---|
| 6 | namespace backend.Services
|
---|
| 7 | {
|
---|
| 8 | public interface IReviewService
|
---|
| 9 | {
|
---|
| 10 | public Task AddReview(CreateReviewRequest review, int userId);
|
---|
[63f5ced] | 11 | public Task<List<ReviewResponse>> GetReviews(int page, int pageSize);
|
---|
| 12 | public Task<int> GetCount();
|
---|
[899b19d] | 13 | }
|
---|
| 14 | public class ReviewService : IReviewService
|
---|
| 15 | {
|
---|
| 16 | private readonly DataContext _context = null;
|
---|
| 17 |
|
---|
| 18 | public ReviewService(DataContext context)
|
---|
| 19 | {
|
---|
| 20 | _context = context;
|
---|
| 21 | }
|
---|
| 22 |
|
---|
| 23 | public async Task AddReview(CreateReviewRequest review, int userId)
|
---|
| 24 | {
|
---|
| 25 | var user = await _context.Users.FindAsync(userId);
|
---|
| 26 | var res = await _context.Restoraunts.Include(x => x.Reviews).FirstOrDefaultAsync();
|
---|
| 27 | if(res.Reviews == null)
|
---|
| 28 | {
|
---|
| 29 | res.Reviews = new List<Review>();
|
---|
| 30 | }
|
---|
| 31 | res.Reviews.Add(new Review()
|
---|
| 32 | {
|
---|
| 33 | Title = review.Title,
|
---|
| 34 | Description = review.Description,
|
---|
| 35 | Stars = review.Stars,
|
---|
| 36 | CreatedAt = DateTime.UtcNow,
|
---|
| 37 | User = user
|
---|
| 38 | });
|
---|
| 39 | _context.Restoraunts.Update(res);
|
---|
| 40 | await _context.SaveChangesAsync();
|
---|
| 41 | }
|
---|
[63f5ced] | 42 |
|
---|
| 43 | public async Task<int> GetCount()
|
---|
| 44 | {
|
---|
| 45 | return await _context.Reviews.CountAsync();
|
---|
| 46 | }
|
---|
| 47 |
|
---|
| 48 | public async Task<List<ReviewResponse>> GetReviews(int page, int pageSize)
|
---|
| 49 | {
|
---|
| 50 | return await _context.Reviews
|
---|
| 51 | .Include(x => x.User)
|
---|
| 52 | .OrderByDescending(x => x.CreatedAt)
|
---|
| 53 | .Skip(page * pageSize)
|
---|
| 54 | .Take(pageSize)
|
---|
| 55 | .Select(x => new ReviewResponse()
|
---|
| 56 | {
|
---|
| 57 | CreatedAt = x.CreatedAt,
|
---|
| 58 | Description = x.Description,
|
---|
| 59 | Id = x.Id,
|
---|
| 60 | Stars = x.Stars,
|
---|
| 61 | Title = x.Title,
|
---|
| 62 | Username = x.User == null ? "Anonymous" : x.User.Email
|
---|
| 63 | })
|
---|
| 64 | .ToListAsync();
|
---|
| 65 | }
|
---|
[899b19d] | 66 | }
|
---|
| 67 | }
|
---|