using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.Extensions.Configuration;
using BlaServApp.Data.DatabaseModels;
using NLog;

namespace BlaServApp.Data
{
    public partial class BlaServAppContext : DbContext
    {
        #region Private Fields

        private static NLog.Logger Log = LogManager.GetCurrentClassLogger();

        private IConfiguration _configuration;

        #endregion Private Fields

        #region Public Constructors

        public BlaServAppContext()
        {
        }

        public BlaServAppContext(IConfiguration configuration)
        {
            _configuration = configuration;
        }

        public BlaServAppContext(DbContextOptions<BlaServAppContext> options) : base(options)
        {
        }

        #endregion Public Constructors

        #region Public Properties

        public virtual DbSet<Articoli> DbSetArticoli { get; set; }
        public virtual DbSet<Config> DbSetConfig { get; set; }

        #endregion Public Properties

        #region Private Methods

        partial void OnModelCreatingPartial(ModelBuilder modelBuilder);

        #endregion Private Methods

        #region Protected Methods

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            //string connString = "";
            if (!optionsBuilder.IsConfigured)
            {
                //connString = _configuration.GetConnectionString("BlaServApp.Data");
                //optionsBuilder.UseSqlServer(connString);
                optionsBuilder.UseSqlServer("Server=SQL2016DEV;Database=BlaServApp;Trusted_Connection=True;");
            }
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.HasAnnotation("Relational:Collation", "SQL_Latin1_General_CP1_CI_AS");

            modelBuilder.Entity<Config>(entity =>
            {
                entity.Property(e => e.ValoreStd)
                    .HasComment("Valore di default/riferimento per la variabile");
            });

            OnModelCreatingPartial(modelBuilder);
        }

        #endregion Protected Methods
    }
}