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();
}
}