using ComputerHardwareStoreDatabaseImplement.Models;
using Microsoft.EntityFrameworkCore;

namespace ComputerHardwareStoreDatabaseImplement
{
    public class ComputerHardwareStoreDBContext : DbContext
    {
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
			//optionsBuilder.UseNpgsql("Host=192.168.1.61:5432;Database=computerhardwarestore;Username=compstore;Password=compstore");
			optionsBuilder.UseNpgsql("Host=localhost;Port=5432;Database=ComputerHardwareStore2;Username=postgres;Password=postgres");
			AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true);
		}
        public virtual DbSet<Component> Components { set; get; }
        public virtual DbSet<Product> Products { set; get; }
        public virtual DbSet<ProductComponent> ProductComponents { set; get; }

        public virtual DbSet<StoreKeeper> StoreKeepers { set; get; }
        public virtual DbSet<Build> Builds { set; get; }
        public virtual DbSet<Order> Orders { set; get; }
        public virtual DbSet<BuildComponent> BuildComponents { set; get; }
        public virtual DbSet<Comment> Comments { set; get; }
        public virtual DbSet<Vendor> Vendors { set; get; }
        public virtual DbSet<Purchase> Purchases { set; get; }
        public virtual DbSet<PurchaseBuild> PurchaseBuilds { set; get; }
        public virtual DbSet<PurchaseProduct> PurchaseProducts { set; get; }
    }
}