1 files changed, 40 insertions, 0 deletions
diff --git a/code/api/src/Endpoints/V1/Projects/GetProjectsRoute.cs b/code/api/src/Endpoints/V1/Projects/GetProjectsRoute.cs
new file mode 100644
index 0000000..8fe70a6
--- /dev/null
+++ b/code/api/src/Endpoints/V1/Projects/GetProjectsRoute.cs
@@ -0,0 +1,40 @@
+using MR.AspNetCore.Pagination;
+
+namespace IOL.GreatOffice.Api.Endpoints.V1.Projects;
+
+public class GetProjectsRoute : RouteBaseAsync.WithRequest<GetProjectsQueryParameters>.WithActionResult<KeysetPaginationResult<GetProjectsResponseDto>>
+{
+    private readonly MainAppDatabase _database;
+    private readonly PaginationService _pagination;
+
+    public GetProjectsRoute(MainAppDatabase database, PaginationService pagination) {
+        _database = database;
+        _pagination = pagination;
+    }
+
+    [HttpGet("~/v{version:apiVersion}/projects")]
+    public override async Task<ActionResult<KeysetPaginationResult<GetProjectsResponseDto>>> HandleAsync([FromQuery] GetProjectsQueryParameters request, CancellationToken cancellationToken = default) {
+        var result = await _pagination.KeysetPaginateAsync(
+            _database.Projects.ForTenant(LoggedInUser).ConditionalWhere(() => request.NameQuery.HasValue(), p => p.Name.Contains(request.NameQuery)),
+            b => b.Descending(x => x.CreatedAt),
+            async id => await _database.Projects.FindAsync(id),
+            query => query.Select(p => new GetProjectsResponseDto() {
+                Id = p.Id,
+                Name = p.Name
+            })
+        );
+        return Ok(result);
+    }
+}
+
+public class GetProjectsResponseDto
+{
+    public Guid Id { get; set; }
+    public string Name { get; set; }
+}
+
+public class GetProjectsQueryParameters
+{
+    [FromQuery(Name = "name")]
+    public string NameQuery { get; set; }
+}
+\ No newline at end of file