Notes

using HealthManagementSystem.Models;
using HealthManagementSystem.Services;
using Microsoft.EntityFrameworkCore;

namespace HealthManagementSystem.Data
{
public class BillingAndFinanceManagementDBContext:DbContext
{
private readonly invoiceServices _invoiceservice;
public DbSet<Invoice> Invoices { get; set; }
public DbSet<Transaction> Transactions { get; set; }
public DbSet<Expenditure> Expenditures { get; set; }
public BillingAndFinanceManagementDBContext(DbContextOptions<BillingAndFinanceManagementDBContext> options , invoiceServices invoiceServices) : base(options)
{
_invoiceservice = invoiceServices;
}

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Invoice>()
.HasOne(x => x.Expenditure)
.WithOne()
.HasForeignKey<Invoice>(x => x.ExpenditureId);

modelBuilder.Entity<Invoice>()
.HasOne(x => x.Transaction)
.WithOne()
.HasForeignKey<Invoice>(x => x.TransactionId);

modelBuilder.Entity<Expenditure>()
.HasKey(x => new { x.ExpenditureId});

}
public override int SaveChanges()
{
foreach (var entry in ChangeTracker.Entries<Invoice>())
{
if (entry.State == EntityState.Added || entry.State == EntityState.Modified)
{

var invoice = entry.Entity;
invoice.TotalTransactionAmount = _invoiceservice.GetTotalTransactionAmount(invoice.PatientId);
invoice.TotalExpenditure = _invoiceservice.GetTotalExpenditure(invoice.PatientId);
invoice.AmountDue = _invoiceservice.GetAmountDue(invoice.InvoiceId);
}
}
return base.SaveChanges();
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if(!optionsBuilder.IsConfigured)
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json");
var configuration = builder.Build();
var connectionstring = configuration.GetConnectionString("DefaultConnection");
optionsBuilder.UseSqlServer(connectionstring);
}
}

}
}