using ExpenseTracker.Api.Data; using ExpenseTracker.Api.DTOs; using ExpenseTracker.Api.Models; using Microsoft.AspNetCore.Mvc; using Microsoft.EntityFrameworkCore; namespace ExpenseTracker.Api.Controllers; /// Endpoints for managing expense categories. [ApiController] [Route("api/categories")] [Produces("application/json")] public class CategoriesController : ControllerBase { private readonly AppDbContext _db; private readonly ILogger _logger; public CategoriesController(AppDbContext db, ILogger logger) { _db = db; _logger = logger; } // ── GET /api/categories ─────────────────────────────────────────────────── /// Returns all categories sorted by name ascending. [HttpGet] [ProducesResponseType(typeof(List), StatusCodes.Status200OK)] public async Task GetAll() { var categories = await _db.Categories .OrderBy(c => c.Name) .Select(c => new CategoryDto(c.Id, c.Name, c.Color)) .ToListAsync(); return Ok(categories); } // ── POST /api/categories ────────────────────────────────────────────────── /// Creates a new category. [HttpPost] [ProducesResponseType(typeof(CategoryDto), StatusCodes.Status201Created)] [ProducesResponseType(StatusCodes.Status400BadRequest)] public async Task Create([FromBody] CreateCategoryDto dto) { // FluentValidation auto-validation handles 400 before we get here. var category = new Category { Id = Guid.NewGuid(), Name = dto.Name, Color = dto.Color }; _db.Categories.Add(category); await _db.SaveChangesAsync(); _logger.LogInformation("Category '{Name}' created with id {Id}.", category.Name, category.Id); var result = new CategoryDto(category.Id, category.Name, category.Color); return CreatedAtAction(nameof(GetAll), null, result); } // ── DELETE /api/categories/{id} ─────────────────────────────────────────── /// Deletes a category. Returns 409 Conflict if entries reference it. [HttpDelete("{id:guid}")] [ProducesResponseType(StatusCodes.Status204NoContent)] [ProducesResponseType(StatusCodes.Status404NotFound)] [ProducesResponseType(StatusCodes.Status409Conflict)] public async Task Delete(Guid id) { var category = await _db.Categories.FindAsync(id); if (category is null) { _logger.LogWarning("Delete category: id {Id} not found.", id); return NotFound(new { error = "Category not found." }); } bool hasEntries = await _db.Entries.AnyAsync(e => e.CategoryId == id); if (hasEntries) { _logger.LogWarning("Delete category {Id} refused: entries still reference it.", id); return Conflict(new { error = "This category is referenced by one or more entries and cannot be deleted." }); } _db.Categories.Remove(category); await _db.SaveChangesAsync(); _logger.LogInformation("Category {Id} deleted.", id); return NoContent(); } }