[Feature] Add repository and CRUD handlers for Status, Category, and Comment models

[mpaulosky]

Objective

Implement repository interfaces and CRUD handlers for the Status, Category, and Comment models to complete the core data persistence and API endpoint coverage for Sprint 1.

Motivation

• Parity with Issues: Status, Category, and Comment models need the same CRUD operations (Create, Read, Update, Delete/Archive)
• API Completeness: Enable full REST API coverage for issue metadata management
• Vertical Slice Pattern: Each model should follow the same handler + repository + validator structure as Issues
• Soft-Delete Consistency: Comment and other models should support archiving (IsArchived) for consistency

Scope

Models to implement handlers for:

1. Status - Issue status options (Open, In Progress, Closed, etc.)
2. Category - Issue categorization/tagging
3. Comment - Comments on issues (with soft-delete support)

Deliverables per model:

• Repository Interface (\IStatusRepository, \ICategoryRepository, \ICommentRepository)

  • Create, Read (by ID), Read (all, paginated), Update, Archive (soft-delete)
  • MongoDB-specific entity mapping (\StatusEntity, etc.)

• CRUD Handlers (following existing Issue handler pattern)

  • \CreateStatusHandler\ / \CreateCategoryHandler\ / \CreateCommentHandler\
  • \GetStatusHandler\ / \GetCategoryHandler\ / \GetCommentHandler\
  • \ListStatusesHandler\ / \ListCategoriesHandler\ / \ListCommentsHandler\ (with pagination)
  • \UpdateStatusHandler\ / \UpdateCategoryHandler\ / \UpdateCommentHandler\
  • \DeleteStatusHandler\ / \DeleteCategoryHandler\ / \DeleteCommentHandler\ (archive)

• CQRS Queries & Commands

  • Create/Update/Delete/List queries and commands with validators
  • Follow existing pattern: \CreateStatusCommand, \UpdateStatusCommand, etc.

• API Endpoint Registration (in \Program.cs)

  • Wire up minimal API endpoints: POST/PUT/GET/DELETE for each model
  • Routes: /api/v1/statuses, /api/v1/categories, /api/v1/comments\

• Folder Structure (depends on [Refactor] Reorganize Handlers folder by model domain #32)

  • Place handlers in respective subdirectories once [Refactor] Reorganize Handlers folder by model domain #32 is merged
  • Handlers structure: \src/Api/Handlers/{Statuses,Categories,Comments}/\

Acceptance Criteria

• All repository interfaces defined with proper Result return types
• All CRUD handlers implemented and registered
• All handlers support soft-delete (IsArchived, ArchivedBy, ArchivedAt)
• API endpoints registered and working
• Build succeeds with 0 errors
• All tests pass
• Handlers follow existing Issue handler pattern (no deviation)

Dependencies

• Depends on: [Refactor] Reorganize Handlers folder by model domain #32 (Handlers folder restructuring) — merge and move handlers after structure is in place
• Blocks: Future feature work requiring full CRUD API

Notes

• Use existing Issue handlers as template for consistency
• Consider audit trail pattern: capture \ArchivedBy\ and \ArchivedAt\ on soft-delete for all models
• Pagination should follow Issue list pattern (page, pageSize parameters)
• All validators should use FluentValidation like Issue validators

Related Issues

• [Refactor] Reorganize Handlers folder by model domain #32 Reorganize Handlers folder by model domain
• Refactor: DTOs to records and finalize soft-delete audit trail #23 PR: Refactor DTOs and finalize soft-delete audit trail

[github-actions]

🔄 Ralph — Auto-Triage

Assigned to: Aragorn (Backend Dev)
Reason: Matches backend/API domain

Ralph auto-triaged this issue via the squad heartbeat. To reassign, swap the squad:* label.

[github-actions]

🏗️ Squad Triage — Gandalf (Lead)

Issue: #33 — [Feature] Add repository and CRUD handlers for Status, Category, and Comment models
Assigned to: Aragorn (Backend Dev)
Reason: Issue relates to backend/API work

Team roster:

• Gandalf (Lead) → label: squad:gandalf
• Aragorn (Backend Dev) → label: squad:aragorn
• Arwen (Frontend Dev) → label: squad:arwen
• Gimli (Tester) → label: squad:gimli
• Legolas (DevOps/Infrastructure) → label: squad:legolas
• Galadriel (Designer) → label: squad:galadriel
• Elrond (GitHub Ops) → label: squad:elrond
• Ralph (Work Monitor) → label: squad:ralph

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