Files
Kevin Harlay ebfaf6f5ec Initial commit
2026-09-07 13:33:22 +02:00

131 lines
4.8 KiB
C#

using ExpenseTracker.Api.Data;
using ExpenseTracker.Api.DTOs;
using ExpenseTracker.Api.Models;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
namespace ExpenseTracker.Api.Controllers;
/// <summary>Endpoints for managing budget months.</summary>
[ApiController]
[Route("api/months")]
[Produces("application/json")]
public class MonthsController : ControllerBase
{
private readonly AppDbContext _db;
private readonly ILogger<MonthsController> _logger;
public MonthsController(AppDbContext db, ILogger<MonthsController> logger)
{
_db = db;
_logger = logger;
}
// ── GET /api/months ───────────────────────────────────────────────────────
/// <summary>Returns all months sorted by year then month number, descending.</summary>
[HttpGet]
[ProducesResponseType(typeof(List<MonthDto>), StatusCodes.Status200OK)]
public async Task<IActionResult> GetAll()
{
var months = await _db.Months
.OrderByDescending(m => m.Year)
.ThenByDescending(m => m.MonthNumber)
.Select(m => new MonthDto(m.Id, m.Year, m.MonthNumber, m.DefaultSalary, m.CreatedAt))
.ToListAsync();
return Ok(months);
}
// ── POST /api/months ──────────────────────────────────────────────────────
/// <summary>Creates a new month. Automatically inserts an INCOME entry for the salary if &gt; 0.</summary>
[HttpPost]
[ProducesResponseType(typeof(MonthDto), StatusCodes.Status201Created)]
[ProducesResponseType(StatusCodes.Status400BadRequest)]
[ProducesResponseType(StatusCodes.Status409Conflict)]
public async Task<IActionResult> Create([FromBody] CreateMonthDto dto)
{
// FluentValidation auto-validation handles 400 before we get here.
bool exists = await _db.Months
.AnyAsync(m => m.Year == dto.Year && m.MonthNumber == dto.Month);
if (exists)
{
_logger.LogWarning("Conflict: month {Year}-{Month} already exists.", dto.Year, dto.Month);
return Conflict(new { error = "A month with this year and month number already exists." });
}
var month = new Month
{
Id = Guid.NewGuid(),
Year = dto.Year,
MonthNumber = dto.Month,
DefaultSalary = dto.DefaultSalary,
CreatedAt = DateTime.UtcNow
};
_db.Months.Add(month);
if (dto.DefaultSalary > 0)
{
var income = new Entry
{
Id = Guid.NewGuid(),
MonthId = month.Id,
Type = EntryType.INCOME,
Amount = dto.DefaultSalary,
Label = "Salaire",
CategoryId = null,
EntryDate = new DateOnly(dto.Year, dto.Month, 1),
CreatedAt = DateTime.UtcNow
};
_db.Entries.Add(income);
}
await _db.SaveChangesAsync();
_logger.LogInformation("Month {Year}-{Month} created with id {Id}.", month.Year, month.MonthNumber, month.Id);
var result = new MonthDto(month.Id, month.Year, month.MonthNumber, month.DefaultSalary, month.CreatedAt);
return CreatedAtAction(nameof(GetSummary), new { id = month.Id }, result);
}
// ── GET /api/months/{id}/summary ──────────────────────────────────────────
/// <summary>Returns the balance summary for a given month.</summary>
[HttpGet("{id:guid}/summary")]
[ProducesResponseType(typeof(MonthSummaryDto), StatusCodes.Status200OK)]
[ProducesResponseType(StatusCodes.Status404NotFound)]
public async Task<IActionResult> GetSummary(Guid id)
{
var month = await _db.Months.FindAsync(id);
if (month is null)
{
_logger.LogWarning("GetSummary: month {Id} not found.", id);
return NotFound(new { error = "Month not found." });
}
var entries = await _db.Entries
.Where(e => e.MonthId == id)
.ToListAsync();
decimal totalIncome = entries.Where(e => e.Type == EntryType.INCOME).Sum(e => e.Amount);
decimal totalExpense = entries.Where(e => e.Type == EntryType.EXPENSE).Sum(e => e.Amount);
decimal balance = totalIncome - totalExpense;
var summary = new MonthSummaryDto(
MonthId: month.Id,
Year: month.Year,
MonthNumber: month.MonthNumber,
TotalIncome: totalIncome,
TotalExpense: totalExpense,
Balance: balance);
return Ok(summary);
}
}