EvaAPI Codebase Navigation Skill

This skill helps you navigate the EvaAPI .NET Core application codebase located at C:\Users\mshepherd\p\leb\EvaAPI.

Project Structure

Core Directories

C:\Users\mshepherd\p\leb\EvaAPI\
├── Data\                           # Database context and entity models
│   ├── EvaDbContext.cs            # Main DbContext with all DbSets
│   └── Models\                    # Entity models organized by domain
│       ├── Committees\            # Committee-related entities
│       │   └── CommitteeReports\  # Committee report entities
│       ├── Calendar\              # Calendar entities
│       ├── Journal\               # Journal entities
│       └── Sessions\              # Session entities
│
├── Services\                      # Business logic services
│   ├── CommitteeManagement\       # Committee-related services
│   │   └── CommitteeReports\      # Committee report services
│   ├── CalendarManagement\        # Calendar services
│   └── JournalManagement\         # Journal services
│
├── Controllers\                   # API endpoints
│   ├── CommitteeReportsController.cs
│   ├── SessionsController.cs
│   └── CalendarController.cs
│
├── Dtos\                          # Data Transfer Objects
│   ├── CommitteeReports\          # DTOs for committee reports
│   └── Calendar\                  # DTOs for calendar
│
├── Migrations\                    # EF Core database migrations
│   └── EvaDbContextModelSnapshot.cs  # Current DB schema snapshot
│
├── Interfaces\                    # Service interfaces
├── Utilities\                     # Helper classes
├── Extensions\                    # Extension methods
├── Filters\                       # API filters
├── Mapping\                       # AutoMapper profiles
└── Settings\                      # Configuration classes

Finding Code by Feature

Database Entities (Models)

Location: Data\Models\[Domain]\

Examples:

• Data\Models\Committees\CommitteeReports\CommitteeReport.cs
• Data\Models\Committees\CommitteeReports\CommitteeReportCommitteeAction.cs
• Data\Models\Sessions\Session.cs

How to find:

# Find entity by name
cd C:\Users\mshepherd\p\leb\EvaAPI
Get-ChildItem -Path Data\Models -Recurse -Filter "*CommitteeReport*.cs"

# Find all models in a domain
Get-ChildItem -Path Data\Models\Committees -Recurse -Filter *.cs

Database Context

Location: Data\EvaDbContext.cs

Contains all DbSet<T> declarations that map to database tables.

Example DbSets:

• DbSet<CommitteeReport> CommitteeReports
• DbSet<CommitteeReportCommitteeAction> CommitteeReportCommitteeActions
• DbSet<Session> Sessions

Services (Business Logic)

Location: Services\[Domain]\

Examples:

• Services\CommitteeManagement\CommitteeReports\CommitteeReportAgendaItemService.cs
• Services\CommitteeManagement\CommitteeReports\CommitteeReportService.cs
• Services\SessionManagement\SessionService.cs

How to find:

# Find service by feature
Get-ChildItem -Path Services -Recurse -Filter "*CommitteeReport*.cs"

# Search for specific method usage
Select-String -Path Services\**\*.cs -Pattern "GetAvailableActions"

Controllers (API Endpoints)

Location: Controllers\

Examples:

• Controllers\CommitteeReportsController.cs
• Controllers\SessionsController.cs

How to find:

# List all controllers
Get-ChildItem -Path Controllers -Filter *.cs

# Find controller by feature
Get-ChildItem -Path Controllers -Filter "*CommitteeReport*.cs"

Migrations

Location: Migrations\

Pattern: {Timestamp}_{Description}.cs

Examples:

• Migrations\20240607134553_2968__CommitteeReportsRewrite.cs
• Migrations\20240820204656_3881_committee-report-additional-actions.cs

Current Schema: Migrations\EvaDbContextModelSnapshot.cs

How to find migrations for a table:

# Find migrations that reference a specific table
Select-String -Path Migrations\*.cs -Pattern "CommitteeReportCommitteeActions" | Select-Object -First 5

Common Search Patterns

Find where a table is used

cd C:\Users\mshepherd\p\leb\EvaAPI

# Search all C# files (excluding migrations)
Get-ChildItem -Recurse -Filter *.cs -Exclude *Migration*,*Designer* |
    Select-String -Pattern "CommitteeReportCommitteeActions" -SimpleMatch

Find entity model and its usage

# 1. Find the entity model
Get-ChildItem -Path Data\Models -Recurse -Filter "*CommitteeReport*.cs"

# 2. Find services using it
Get-ChildItem -Path Services -Recurse -Filter *.cs |
    Select-String -Pattern "CommitteeReport"

# 3. Find controllers using it
Get-ChildItem -Path Controllers -Filter *.cs |
    Select-String -Pattern "CommitteeReport"

Find DTOs for a feature

Get-ChildItem -Path Dtos -Recurse -Filter "*CommitteeReport*.cs"

Search for specific code patterns

# Find all DbSet declarations
Select-String -Path Data\EvaDbContext.cs -Pattern "DbSet<"

# Find all API endpoints for a feature
Select-String -Path Controllers\CommitteeReportsController.cs -Pattern "\[Http"

Entity Naming Conventions

Database Tables

• Plural: CommitteeReports, CommitteeReportActions, Sessions
• Snake_case in old tables, PascalCase in newer tables

C# Entities

• Singular class name: CommitteeReport, CommitteeReportAction, Session
• File matches class name: CommitteeReport.cs

DbSet Properties

• Plural: CommitteeReports, CommitteeReportActions
• Declared in EvaDbContext.cs

Key Files

Main Entry Points

• Program.cs - Application startup and configuration
• appsettings.json - Production configuration
• appsettings.development.json - Development configuration (has connection strings)

Database

• Data\EvaDbContext.cs - Database context with all tables
• Migrations\EvaDbContextModelSnapshot.cs - Current complete schema

Configuration

• Settings\JwtSettings.cs - JWT authentication settings
• Settings\EmailSettings.cs - Email configuration

Tips for Code Navigation

1. Start with the entity model - Find in Data\Models\ to understand the structure
2. Check EvaDbContext.cs - Verify the DbSet exists and see navigation properties
3. Find the service - Look in Services\ for business logic
4. Find the controller - Look in Controllers\ for API endpoints
5. Check migrations - See how the table evolved over time

Common File Locations by Feature

Committee Reports

• Models: Data\Models\Committees\CommitteeReports\
• Services: Services\CommitteeManagement\CommitteeReports\
• Controllers: Controllers\CommitteeReportsController.cs
• DTOs: Dtos\CommitteeReports\

Sessions

• Models: Data\Models\Sessions\
• Services: Services\SessionManagement\
• Controllers: Controllers\SessionsController.cs

Calendar

• Models: Data\Models\Calendar\
• Services: Services\CalendarManagement\
• Controllers: Controllers\CalendarController.cs

Useful PowerShell Commands

See SEARCH-COMMANDS.md for comprehensive search examples.