144 lines
7.7 KiB
C#
144 lines
7.7 KiB
C#
using Microsoft.EntityFrameworkCore;
|
|
using ExpenseTracker.Api.Models;
|
|
|
|
namespace ExpenseTracker.Api.Data;
|
|
|
|
public class AppDbContext : DbContext
|
|
{
|
|
public AppDbContext(DbContextOptions<AppDbContext> options) : base(options) { }
|
|
|
|
public DbSet<Month> Months => Set<Month>();
|
|
public DbSet<Entry> Entries => Set<Entry>();
|
|
public DbSet<Category> Categories => Set<Category>();
|
|
public DbSet<AppSetting> AppSettings => Set<AppSetting>();
|
|
|
|
protected override void OnModelCreating(ModelBuilder modelBuilder)
|
|
{
|
|
base.OnModelCreating(modelBuilder);
|
|
|
|
// ── Month ────────────────────────────────────────────────────────────
|
|
modelBuilder.Entity<Month>(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<Category>(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<Entry>(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<string>()
|
|
.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<AppSetting>(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<Category>().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<AppSetting>().HasData(
|
|
new AppSetting
|
|
{
|
|
Id = new Guid("20000000-0000-0000-0000-000000000001"),
|
|
Key = "default_salary",
|
|
Value = "0"
|
|
}
|
|
);
|
|
}
|
|
}
|