[Feature] API: Add DeleteCategory handler and archive endpoint

[mpaulosky]

Summary

The Categories API is missing a Delete/Archive endpoint. The domain model has ArchivedBy and ArchivedOn fields indicating soft-delete is the intended pattern — but no handler or endpoint exists to perform it.

Current State

CategoryEndpoints.cs exposes:

• GET /api/v1/categories — List all
• GET /api/v1/categories/{id} — Get by ID
• POST /api/v1/categories — Create
• PUT /api/v1/categories/{id} — Update
• ❌ No Delete/Archive endpoint

Work Required

Following the existing CQRS vertical slice pattern:

1. Command + Handler

Create src/Api/Handlers/Categories/DeleteCategoryHandler.cs:

public record DeleteCategoryCommand(string Id, string ArchivedBy) : IRequest<Result<bool>>;

• Set ArchivedBy, ArchivedOn on the entity
• Set Archived = true
• Persist via ICategoryRepository

2. Endpoint

Add to CategoryEndpoints.cs:

app.MapDelete("/{id}", async (string id, ClaimsPrincipal user, ISender sender) => ...)
   .RequireAuthorization("Admin");

• Admin-only authorization (match UpdateCategory pattern)
• Return 204 No Content on success, 404 if not found

3. Repository

Verify ICategoryRepository has ArchiveAsync or UpdateAsync that covers the archived state.

Acceptance Criteria

• DELETE /api/v1/categories/{id} returns 204 for valid admin request
• Returns 404 when category not found
• Returns 401/403 for non-admin requests
• Archived category is NOT returned in the default list (or is filtered out)
• Handler tests pass (see linked test issue)

Files

• src/Api/Handlers/Categories/DeleteCategoryHandler.cs (new)
• src/Api/Handlers/Categories/CategoryEndpoints.cs
• src/Api/Repositories/ICategoryRepository.cs

[github-actions]

📋 Assigned to Sam (Backend Dev)

Issue: #120 — [Feature] API: Add DeleteCategory handler and archive endpoint

Sam will pick this up in the next Copilot session.

For Copilot coding agent: If enabled, this issue will be worked automatically.
Otherwise, start a Copilot session and say:
Sam, work on issue #120

[github-actions]

🏗️ Squad Triage — Aragorn (Lead)

Issue: #120 — [Feature] API: Add DeleteCategory handler and archive endpoint
Assigned to: Legolas (Frontend Dev)
Reason: Issue relates to frontend/UI work

@copilot evaluation: 🔴 Not suitable — issue involves work outside the coding agent's capability profile.

Team roster:

• Aragorn (Lead) → label: squad:aragorn
• Legolas (Frontend Dev) → label: squad:legolas
• Sam (Backend Dev) → label: squad:sam
• Gimli (Tester) → label: squad:gimli
• Boromir (DevOps) → label: squad:boromir
• Frodo (Tech Writer) → label: squad:frodo
• Gandalf (Security Officer) → label: squad:gandalf
• Ralph (Work Monitor) → label: squad:ralph
• @copilot (🤖 Coding Agent) → label: squad:@copilot
• @copilot (Coding Agent) → label: squad:copilot

To reassign, remove the current squad:* label and add the correct one.