Changeset 63f5ced for resTools_backend

Timestamp:

08/24/22 17:11:52 (2 years ago)

Author:

Danilo <danilo.najkov@…>

Branches:

master

Children:

d86edb7

Parents:

a569b7c

Message:

reviews pagination

Location:

resTools_backend/backend

Files:

• Controllers/ReviewsController.cs (modified) (1 diff)
• Services/RestaurantService.cs (modified) (1 diff)
• Services/ReviewService.cs (modified) (2 diffs)

resTools_backend/backend/Controllers/ReviewsController.cs

@@ -18 +18 @@
         }
 
+        [HttpGet]
+        public async Task<List<ReviewResponse>> GetReviews(int page, int pageSize)
+        {
+            return await _reviewService.GetReviews(page, pageSize);
+        }
+
+        [HttpGet("count")]
+        public async Task<int> GetReviewsCount()
+        {
+            return await _reviewService.GetCount();
+        }
 
         [Authorize]

resTools_backend/backend/Services/RestaurantService.cs

@@ -47 +47 @@
                         Price = x.Price
                     }).ToList(),
-                    Reviews = x.Reviews.OrderByDescending(x => x.CreatedAt).Select(x => new ReviewResponse()
+                    Reviews = x.Reviews.Select(x => new ReviewResponse()
                     {
+                        CreatedAt = x.CreatedAt,
+                        Description = x.Description,
                         Id = x.Id,
+                        Stars = x.Stars,
                         Title = x.Title,
-                        Description = x.Description,
-                        Stars = x.Stars,
-                        CreatedAt = x.CreatedAt,
                         Username = x.User == null ? "Anonymous" : x.User.Email
                     }).ToList(),

resTools_backend/backend/Services/ReviewService.cs

@@ -9 +9 @@
     {
         public Task AddReview(CreateReviewRequest review, int userId);
+        public Task<List<ReviewResponse>> GetReviews(int page, int pageSize);
+        public Task<int> GetCount();
     }
     public class ReviewService : IReviewService
@@ -38 +40 @@
             await _context.SaveChangesAsync();
         }
+
+        public async Task<int> GetCount()
+        {
+            return await _context.Reviews.CountAsync();
+        }
+
+        public async Task<List<ReviewResponse>> GetReviews(int page, int pageSize)
+        {
+            return await _context.Reviews
+                .Include(x => x.User)
+                .OrderByDescending(x => x.CreatedAt)
+                .Skip(page * pageSize)
+                .Take(pageSize)
+                .Select(x => new ReviewResponse()
+                {
+                    CreatedAt = x.CreatedAt,
+                    Description = x.Description,
+                    Id = x.Id,
+                    Stars = x.Stars,
+                    Title = x.Title,
+                    Username = x.User == null ? "Anonymous" : x.User.Email
+                })
+                .ToListAsync();
+        }
     }
 }