feat: Initial commit

3 files changed, 135 insertions, 0 deletions

diff --git a/code/api/src/Endpoints/V1/Projects/CreateProjectRoute.cs b/code/api/src/Endpoints/V1/Projects/CreateProjectRoute.cs
new file mode 100644
index 0000000..bd37faf
--- /dev/null
+++ b/code/api/src/Endpoints/V1/Projects/CreateProjectRoute.cs
@@ -0,0 +1,83 @@
+namespace IOL.GreatOffice.Api.Endpoints.V1.Projects;
+
+public class CreateProjectRoute : RouteBaseAsync.WithRequest<CreateProjectPayload>.WithActionResult
+{
+    private readonly MainAppDatabase _database;
+    private readonly IStringLocalizer<SharedResources> _localizer;
+
+    public CreateProjectRoute(MainAppDatabase database, IStringLocalizer<SharedResources> localizer) {
+        _database = database;
+        _localizer = localizer;
+    }
+
+    [HttpPost("~/v{version:apiVersion}/projects/create")]
+    public override async Task<ActionResult> HandleAsync(CreateProjectPayload request, CancellationToken cancellationToken = default) {
+        var problem = new KnownProblemModel();
+
+        if (request.Name.IsNullOrEmpty()) {
+            problem.AddError("name", _localizer["Name is a required field"]);
+        }
+
+        var project = new Project(LoggedInUser) {
+            Name = request.Name,
+            Description = request.Description,
+            Start = request.Start,
+            Stop = request.Stop,
+        };
+
+        project.SetOwnerIds(default, LoggedInUser.TenantId);
+
+        foreach (var customerId in request.CustomerIds) {
+            var customer = _database.Customers.FirstOrDefault(c => c.Id == customerId);
+            if (customer == default) {
+                problem.AddError("customer_" + customerId, _localizer["Customer not found"]);
+                continue;
+            }
+
+            project.Customers.Add(customer);
+        }
+
+        foreach (var member in request.Members) {
+            var user = _database.Users.FirstOrDefault(c => c.Id == member.UserId);
+            if (user == default) {
+                problem.AddError("members_" + member.UserId, _localizer["User not found"]);
+                continue;
+            }
+
+            project.Members.Add(new ProjectMember() {
+                Project = project,
+                User = user,
+                Role = member.Role
+            });
+        }
+
+        if (problem.Errors.Any()) {
+            problem.Title = _localizer["Invalid form"];
+            problem.Subtitle = _localizer["One or more validation errors occured"];
+            return KnownProblem(problem);
+        }
+
+        _database.Projects.Add(project);
+        await _database.SaveChangesAsync(cancellationToken);
+        return Ok();
+    }
+}
+
+public class CreateProjectResponse
+{ }
+
+public class CreateProjectPayload
+{
+    public string Name { get; set; }
+    public string Description { get; set; }
+    public DateTime Start { get; set; }
+    public DateTime Stop { get; set; }
+    public List<Guid> CustomerIds { get; set; }
+    public List<ProjectMember> Members { get; set; }
+
+    public class ProjectMember
+    {
+        public Guid UserId { get; set; }
+        public ProjectRole Role { get; set; }
+    }
+}
\ No newline at end of file
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
diff --git a/code/api/src/Endpoints/V1/Projects/_calls.http b/code/api/src/Endpoints/V1/Projects/_calls.http
new file mode 100644
index 0000000..af0eba6
--- /dev/null
+++ b/code/api/src/Endpoints/V1/Projects/_calls.http
@@ -0,0 +1,12 @@
+### Create Project
+GET https://localhost:5001/v1/projects/create
+Accept: application/json
+Content-Type: application/json
+Cookie: "" 
+
+{
+  "": ""
+}
+
+### Get Projects
+POST http://localhost