using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;

namespace MAX.Models
{
    public class MAXContext : DbContext
    {
        public MAXContext(DbContextOptions<MAXContext> options) : base(options) { }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

            modelBuilder.Entity<Batch>()
                .HasIndex(b => new { b.ReadyForDownload, b.OrderDate });

            modelBuilder.Entity<Voucher>()
                .HasIndex(v => new { v.BatchId, v.SequenceNumber })
                .IsUnique();
        }

        public DbSet<Account> Accounts { get; set;  }

        public DbSet<Batch> Batches { get; set; }

        public DbSet<User> Users { get; set; }

        public DbSet<Vendor> Vendors { get; set; }

        public DbSet<Voucher> Vouchers { get; set; }

        public DbSet<Warehouse> Warehouses { get; set;  }
    }
}