using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.Extensions.Configuration;
using MP.Data.DbModels;
using MP.Data.DTO;
using NLog;

#nullable disable
// <Auto-Generated>
// This is here so CodeMaid doesn't reorganize this document
// </Auto-Generated>
namespace MP.Data
{
    public partial class MoonProAdminContext : DbContext
    {
        #region Private Fields

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

        private IConfiguration _configuration;

        #endregion Private Fields

        #region Public Constructors

        public MoonProAdminContext(IConfiguration configuration)
        {
            _configuration = configuration;
            // timeout esecuzione a 5 min (std: 30 sec)...
            Database.SetCommandTimeout(TimeSpan.FromSeconds(300));
        }

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

        #endregion Public Constructors

        #region Private Methods

        partial void OnModelCreatingPartial(ModelBuilder modelBuilder);

        #endregion Private Methods

        #region Protected Methods

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
            {
                string connString = _configuration.GetConnectionString("MP.Data");
                if (string.IsNullOrEmpty(connString))
                {
                    connString = _configuration.GetConnectionString("MP.Mon");
                }
                if (string.IsNullOrEmpty(connString))
                {
                    connString = _configuration.GetConnectionString("MP.STATS");
                }

                optionsBuilder.UseSqlServer(connString);
            }
        }

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

            OnModelCreatingPartial(modelBuilder);
        }

        #endregion Protected Methods
    }
}