using Microsoft.EntityFrameworkCore; using ExpenseTracker.Api.Models; namespace ExpenseTracker.Api.Data; public class AppDbContext : DbContext { public AppDbContext(DbContextOptions options) : base(options) { } public DbSet Months => Set(); public DbSet Entries => Set(); public DbSet Categories => Set(); public DbSet AppSettings => Set(); protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); // ── Month ──────────────────────────────────────────────────────────── modelBuilder.Entity(e => { e.ToTable("months"); e.HasKey(m => m.Id); e.Property(m => m.Id).HasColumnName("id"); e.Property(m => m.Year).HasColumnName("year").IsRequired(); e.Property(m => m.MonthNumber).HasColumnName("month").IsRequired(); e.Property(m => m.DefaultSalary) .HasColumnName("default_salary") .HasColumnType("DECIMAL(12,2)") .IsRequired(); e.Property(m => m.CreatedAt).HasColumnName("created_at").IsRequired(); e.HasIndex(m => new { m.Year, m.MonthNumber }) .IsUnique() .HasDatabaseName("ix_months_year_month_unique"); }); // ── Category ───────────────────────────────────────────────────────── modelBuilder.Entity(e => { e.ToTable("categories"); e.HasKey(c => c.Id); e.Property(c => c.Id).HasColumnName("id"); e.Property(c => c.Name) .HasColumnName("name") .HasMaxLength(100) .IsRequired(); e.Property(c => c.Color) .HasColumnName("color") .HasMaxLength(7) .IsRequired(); }); // ── Entry ───────────────────────────────────────────────────────────── modelBuilder.Entity(e => { e.ToTable("entries"); e.HasKey(en => en.Id); e.Property(en => en.Id).HasColumnName("id"); e.Property(en => en.MonthId).HasColumnName("month_id").IsRequired(); e.Property(en => en.Type) .HasColumnName("type") .HasConversion() .IsRequired(); e.Property(en => en.Amount) .HasColumnName("amount") .HasColumnType("DECIMAL(12,2)") .IsRequired(); e.Property(en => en.Label) .HasColumnName("label") .HasMaxLength(200) .IsRequired(); e.Property(en => en.CategoryId).HasColumnName("category_id"); e.Property(en => en.EntryDate).HasColumnName("entry_date").IsRequired(); e.Property(en => en.CreatedAt).HasColumnName("created_at").IsRequired(); e.HasOne(en => en.Month) .WithMany(m => m.Entries) .HasForeignKey(en => en.MonthId) .OnDelete(DeleteBehavior.Cascade); e.HasOne(en => en.Category) .WithMany(c => c.Entries) .HasForeignKey(en => en.CategoryId) .IsRequired(false) .OnDelete(DeleteBehavior.SetNull); e.HasIndex(en => en.MonthId).HasDatabaseName("ix_entries_month_id"); e.HasIndex(en => en.CategoryId).HasDatabaseName("ix_entries_category_id"); }); // ── AppSetting ──────────────────────────────────────────────────────── modelBuilder.Entity(e => { e.ToTable("app_settings"); e.HasKey(s => s.Id); e.Property(s => s.Id).HasColumnName("id"); e.Property(s => s.Key) .HasColumnName("key") .HasMaxLength(100) .IsRequired(); e.Property(s => s.Value).HasColumnName("value").IsRequired(); e.HasIndex(s => s.Key) .IsUnique() .HasDatabaseName("ix_app_settings_key_unique"); }); // ── Seed data ───────────────────────────────────────────────────────── // Category names are derived from bank-export "Sous categorie" values: // everything after " - " is stripped and the result is trimmed, so that // the import matching (Contains) can resolve e.g. "Banque et assurance - autre" // against the stored name "Banque et assurance". modelBuilder.Entity().HasData( new Category { Id = new Guid("10000000-0000-0000-0000-000000000001"), Name = "Ameublement et appareil", Color = "#f97316" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000002"), Name = "Banque et assurance", Color = "#6b7280" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000003"), Name = "Credit", Color = "#22c55e" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000004"), Name = "Energie", Color = "#eab308" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000005"), Name = "Frais bancaires", Color = "#ef4444" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000006"), Name = "Hygiene", Color = "#ec4899" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000007"), Name = "Impots et taxes", Color = "#dc2626" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000008"), Name = "Internet et telephonie", Color = "#3b82f6" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000009"), Name = "Juridique et administratif", Color = "#8b5cf6" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000010"), Name = "Prelevement", Color = "#64748b" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000011"), Name = "Salaires", Color = "#16a34a" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000012"), Name = "Shopping et services", Color = "#a855f7" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000013"), Name = "Sport, Gym et Equipement", Color = "#0ea5e9" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000014"), Name = "Transaction differee", Color = "#94a3b8" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000015"), Name = "Virement emis", Color = "#f59e0b" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000016"), Name = "Virement recu", Color = "#10b981" }, new Category { Id = new Guid("10000000-0000-0000-0000-000000000017"), Name = "Autre", Color = "#6b7280" } ); modelBuilder.Entity().HasData( new AppSetting { Id = new Guid("20000000-0000-0000-0000-000000000001"), Key = "default_salary", Value = "0" } ); } }