[Feature] API: Add DeleteStatus handler and archive endpoint

[mpaulosky]

Summary

The Statuses API is missing a Delete/Archive endpoint. Same gap as Categories — the domain model supports soft-delete but no handler or endpoint exists to trigger it.

Current State

StatusEndpoints.cs exposes:

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

Work Required

Following the existing CQRS vertical slice pattern (mirror the Categories implementation):

1. Command + Handler

Create src/Api/Handlers/Statuses/DeleteStatusHandler.cs:

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

• Set ArchivedBy, ArchivedOn, Archived = true
• Persist via IStatusRepository

2. Endpoint

Add to StatusEndpoints.cs:

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

3. Repository

Verify IStatusRepository supports archive/update for the archived fields.

Acceptance Criteria

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

Files

• src/Api/Handlers/Statuses/DeleteStatusHandler.cs (new)
• src/Api/Handlers/Statuses/StatusEndpoints.cs
• src/Api/Repositories/IStatusRepository.cs

[github-actions]

📋 Assigned to Sam (Backend Dev)

Issue: #121 — [Feature] API: Add DeleteStatus 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 #121

[github-actions]

🏗️ Squad Triage — Aragorn (Lead)

Issue: #121 — [Feature] API: Add DeleteStatus 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.

[github-actions]

📋 Marked as release:backlog — assign a release target when ready.