Changeset 63f5ced for resTools_backend/backend/Services/ReviewService.cs

Timestamp:

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

Author:

Danilo <danilo.najkov@…>

Branches:

master

Children:

d86edb7

Parents:

a569b7c

Message:

reviews pagination

File:

• resTools_backend/backend/Services/ReviewService.cs (modified) (2 diffs)

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();
+        }
     }
 }