using Core;
using Core.DTO;
using Core.Models;
using Liman.CadCam.DbModel;
using LiMan.DB;
using LiMan.DB.Controllers;
using LiMan.DB.DBModels;
using LiMan.DB.DTO;
using LiMan.DB.Services;
using LiMan.GLS;
using Microsoft.AspNetCore.Identity.UI.Services;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Caching.Distributed;
using Microsoft.Extensions.Caching.Memory;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using NLog;
using Org.BouncyCastle.Asn1.Pkcs;
using StackExchange.Redis;
using System;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Linq;
using System.Runtime;
using System.Text;
using System.Threading.Tasks;
using static Core.Enum;

namespace LiMan.UI.Data
{
    public class LiManDataService : CommonDataServices
    {
        #region Public Fields

        public static GLS.Controllers.LicManController dbControllerGLS;

        #endregion Public Fields

        #region Public Constructors

        public LiManDataService(IConfiguration configuration, IConnectionMultiplexer redisConnMult, IEmailSender emailSender) : base(configuration, redisConnMult, emailSender)
        {
            // conf DB
            string connStrGLS = _configuration.GetConnectionString("LiMan.GLS");
            if (string.IsNullOrEmpty(connStrGLS))
            {
                Log.Error("Empty ConnString for LiMan.GLS!");
            }
            else
            {
                dbControllerGLS = new LiMan.GLS.Controllers.LicManController(configuration);
                Log.Info("DbController for LiMan.GLS OK");
            }
        }

        #endregion Public Constructors

        #region Public Methods

        public async Task<List<GLS.DatabaseModels.AnagApplicazioni>> ApplicazioniGLSGetAll()
        {
            string source = "DB";
            List<GLS.DatabaseModels.AnagApplicazioni>? dbResult = new List<GLS.DatabaseModels.AnagApplicazioni>();
            try
            {
                string currKey = $"{Const.rKeyConfig}:GLS:Applicazioni";
                Stopwatch sw = new Stopwatch();
                sw.Start();
                string? rawData = await redisDb.StringGetAsync(currKey);
                if (!string.IsNullOrEmpty(rawData))
                {
                    source = "REDIS";
                    var tempResult = JsonConvert.DeserializeObject<List<GLS.DatabaseModels.AnagApplicazioni>>(rawData);
                    if (tempResult == null)
                    {
                        dbResult = new List<GLS.DatabaseModels.AnagApplicazioni>();
                    }
                    else
                    {
                        dbResult = tempResult;
                    }
                }
                else
                {
                    dbResult = dbControllerGLS.GetApplicazioni();
                    rawData = JsonConvert.SerializeObject(dbResult, JSSettings);
                    await redisDb.StringSetAsync(currKey, rawData, UltraLongCache);
                }
                if (dbResult == null)
                {
                    dbResult = new List<GLS.DatabaseModels.AnagApplicazioni>();
                }
                sw.Stop();
                Log.Debug($"ApplicazioniGLSGetAll | {source} in: {sw.Elapsed.TotalMilliseconds:N2} ms");
            }
            catch (Exception exc)
            {
                Log.Error($"Error during ApplicazioniGLSGetAll:{Environment.NewLine}{exc}");
            }
            return dbResult;
        }

        public async Task<bool> ApplicazioniGLSUpdate(GLS.DatabaseModels.AnagApplicazioni currItem)
        {
            bool done = false;
            try
            {
                done = dbControllerGLS.UpdateApplicazioni(currItem);
                await FlushRedisCache();
            }
            catch (Exception exc)
            {
                Log.Error($"Eccezione in ApplicazioniGLSUpdate:{Environment.NewLine}{exc}");
            }
            return await Task.FromResult(done);
        }

        public async Task<bool> DbForceMigrate()
        {
            return await Task.FromResult(dbControllerGLS.DbForceMigrate());
        }

        public override void Dispose()
        {
            base.Dispose();
            // Clear database controller
            dbControllerGLS.Dispose();
        }

        public async Task<List<GLS.DatabaseModels.AnagInstallazioni>> InstallazioniGLSGetAll()
        {
            string source = "DB";
            List<GLS.DatabaseModels.AnagInstallazioni> dbResult = new List<GLS.DatabaseModels.AnagInstallazioni>();
            try
            {
                string currKey = $"{Const.rKeyConfig}:GLS:Installazioni:List";
                Stopwatch sw = new Stopwatch();
                sw.Start();
                string? rawData = await redisDb.StringGetAsync(currKey);
                if (!string.IsNullOrEmpty(rawData))
                {
                    source = "REDIS";
                    var tempResult = JsonConvert.DeserializeObject<List<GLS.DatabaseModels.AnagInstallazioni>>(rawData);
                    if (tempResult == null)
                    {
                        dbResult = new List<GLS.DatabaseModels.AnagInstallazioni>();
                    }
                    else
                    {
                        dbResult = tempResult;
                    }
                }
                else
                {
                    dbResult = dbControllerGLS.GetInstallazioni();
                    rawData = JsonConvert.SerializeObject(dbResult, JSSettings);
                    await redisDb.StringSetAsync(currKey, rawData, UltraLongCache);
                }
                if (dbResult == null)
                {
                    dbResult = new List<GLS.DatabaseModels.AnagInstallazioni>();
                }
                sw.Stop();
                Log.Debug($"InstallazioniGLSGetAll | {source} in: {sw.Elapsed.TotalMilliseconds:N2} ms");
            }
            catch (Exception exc)
            {
                Log.Error($"Error during InstallazioniGLSGetAll:{Environment.NewLine}{exc}");
            }
            return dbResult;

#if false
            List<GLS.DatabaseModels.AnagInstallazioni> dbResult = new List<GLS.DatabaseModels.AnagInstallazioni>();
            string cacheKey = mHash("GLS:Installazioni");
            string rawData;
            var redisDataList = await distributedCache.GetAsync(cacheKey);
            if (redisDataList != null)
            {
                rawData = Encoding.UTF8.GetString(redisDataList);
                dbResult = JsonConvert.DeserializeObject<List<GLS.DatabaseModels.AnagInstallazioni>>(rawData);
            }
            else
            {
                Stopwatch stopWatch = new Stopwatch();
                stopWatch.Start();
                dbResult = dbControllerGLS.GetInstallazioni();
                rawData = JsonConvert.SerializeObject(dbResult);
                redisDataList = Encoding.UTF8.GetBytes(rawData);
                await distributedCache.SetAsync(cacheKey, redisDataList, cacheOpt(true));
                stopWatch.Stop();
                TimeSpan ts = stopWatch.Elapsed;
                Log.Trace($"Effettuata lettura da DB + caching per InstallazioniGLSGetAll: {ts.TotalMilliseconds} ms");
            }
            return await Task.FromResult(dbResult);
#endif
        }

        public async Task<bool> InstallazioniGLSUpdate(GLS.DatabaseModels.AnagInstallazioni currItem)
        {
            bool done = false;
            try
            {
                done = dbControllerGLS.UpdateInstallazioni(currItem);
                await FlushRedisCache();
            }
            catch (Exception exc)
            {
                Log.Error($"Eccezione in InstallazioniGLSUpdate:{Environment.NewLine}{exc}");
            }
            return await Task.FromResult(done);
        }

        /// <summary>
        /// Trasferisce una licenza da GLS a Next come LOG di una licenza scaduta
        /// </summary>
        /// <param name="currItem"></param>
        /// <returns></returns>
        public async Task<bool> LicenzaLogGlsNext(GLS.DatabaseModels.LicenzeAttive currItem, int IdxLicNext)
        {
            bool done = false;

            var currLicenza = dbController.GetLicenza(IdxLicNext);
            // step 1: converto licenza, faccio upsert
            var logLicNext = new LogLicenzaModel()
            {
                CodApp = currItem.ApplicativoNavigation.Applicativo,
                CodInst = currItem.InstallazioneNavigation.Installazione,
                Chiave = currItem.Licenza,
                NumLicenze = currItem.NumLicenze,
                Scadenza = currItem.Scadenza,
                Descrizione = currItem.ApplicativoNavigation.Descrizione,
                Tipo = TipoLicenza.GLS,
                IdxLic = IdxLicNext,
                Locked = true
            };
            bool step1 = dbController.UpsertLogLic(logLicNext);

            if (currLicenza != null && step1)
            {
                // step 2: disattivo vecchia licenza
                currItem.Locked = true;
                done = dbControllerGLS.UpdateLicenze(currItem);
            }
            return await Task.FromResult(done);
        }

        /// <summary>
        /// Trasferisce una licenza da GLS a Next
        /// </summary>
        /// <param name="currItem"></param>
        /// <returns></returns>
        public async Task<bool> LicenzaTransferGlsNext(GLS.DatabaseModels.LicenzeAttive currItem)
        {
            bool done = false;
            // step 1: controllo applicazione esistente
            ApplicativoModel appNext = new ApplicativoModel()
            {
                CodApp = currItem.ApplicativoNavigation.Applicativo,
                Descrizione = currItem.ApplicativoNavigation.Descrizione
            };
            bool step1 = dbController.ApplicazioniNextUpdate(appNext);

            // step 2: controllo installazione esistente
            var instNext = new InstallazioneModel()
            {
                Cliente = currItem.InstallazioneNavigation.Installazione,
                CodInst = currItem.InstallazioneNavigation.Installazione,
                Contatto = currItem.InstallazioneNavigation.Contatto,
                Email = currItem.InstallazioneNavigation.Email,
                Descrizione = currItem.ApplicativoNavigation.Descrizione
            };
            bool step2 = dbController.UpsertInstallazione(instNext);

            // step 3: converto licenza, faccio upsert
            var licNext = new LicenzaModel()
            {
                CodApp = currItem.ApplicativoNavigation.Applicativo,
                CodInst = currItem.InstallazioneNavigation.Installazione,
                Chiave = currItem.Licenza,
                NumLicenze = currItem.NumLicenze,
                Scadenza = currItem.Scadenza,
                Descrizione = currItem.ApplicativoNavigation.Descrizione,
                Tipo = TipoLicenza.GLS,
                Enigma = "",
                Payload = "",
                DataEnigma = DateTime.Now
            };
            bool step3 = dbController.UpsertLicenza(licNext);

            if (step1 && step2 && step3)
            {
                // step 4: disattivo vecchia licenza
                currItem.Locked = true;
                done = dbControllerGLS.UpdateLicenze(currItem);
            }
            return await Task.FromResult(done);
        }

        public async Task<List<GLS.DatabaseModels.LicenzeAttive>> LicenzeGLSGetAll()
        {
            string source = "DB";
            List<GLS.DatabaseModels.LicenzeAttive> dbResult = new List<GLS.DatabaseModels.LicenzeAttive>();
            try
            {
                string currKey = $"{Const.rKeyConfig}:GLS:Licenze:List";
                Stopwatch sw = new Stopwatch();
                sw.Start();
                string rawData = await redisDb.StringGetAsync(currKey);
                if (!string.IsNullOrEmpty(rawData))
                {
                    source = "REDIS";
                    var tempResult = JsonConvert.DeserializeObject<List<GLS.DatabaseModels.LicenzeAttive>>(rawData);
                    if (tempResult == null)
                    {
                        dbResult = new List<GLS.DatabaseModels.LicenzeAttive>();
                    }
                    else
                    {
                        dbResult = tempResult;
                    }
                }
                else
                {
                    dbResult = dbControllerGLS.GetLicenze();
                    rawData = JsonConvert.SerializeObject(dbResult, JSSettings);
                    await redisDb.StringSetAsync(currKey, rawData, UltraLongCache);
                }
                if (dbResult == null)
                {
                    dbResult = new List<GLS.DatabaseModels.LicenzeAttive>();
                }
                sw.Stop();
                Log.Debug($"LicenzeGLSGetAll | {source} in: {sw.Elapsed.TotalMilliseconds:N2} ms");
            }
            catch (Exception exc)
            {
                Log.Error($"Error during LicenzeGLSGetAll:{Environment.NewLine}{exc}");
            }
            return dbResult;

#if false
            List<GLS.DatabaseModels.LicenzeAttive> dbResult = new List<GLS.DatabaseModels.LicenzeAttive>();
            string cacheKey = mHash("GLS:Licenze");
            string rawData;
            var redisDataList = await distributedCache.GetAsync(cacheKey);
            if (redisDataList != null)
            {
                rawData = Encoding.UTF8.GetString(redisDataList);
                dbResult = JsonConvert.DeserializeObject<List<GLS.DatabaseModels.LicenzeAttive>>(rawData);
            }
            else
            {
                Stopwatch stopWatch = new Stopwatch();
                stopWatch.Start();
                dbResult = dbControllerGLS.GetLicenze();
                rawData = JsonConvert.SerializeObject(dbResult);
                redisDataList = Encoding.UTF8.GetBytes(rawData);
                await distributedCache.SetAsync(cacheKey, redisDataList, cacheOpt(true));
                stopWatch.Stop();
                TimeSpan ts = stopWatch.Elapsed;
                Log.Trace($"Effettuata lettura da DB + caching per LicenzeGLSGetAll: {ts.TotalMilliseconds} ms");
            }
            return await Task.FromResult(dbResult);
#endif
        }

        /// <summary>
        /// Recupera licenze SENZA cache
        /// </summary>
        /// <param name="CurrFilter"></param>
        /// <returns></returns>
        public async Task<List<GLS.DatabaseModels.LicenzeAttive>> LicenzeGLSGetFilt(SelectGLS CurrFilter)
        {
            Stopwatch sw = new Stopwatch();
            List<GLS.DatabaseModels.LicenzeAttive> dbResult = new List<GLS.DatabaseModels.LicenzeAttive>();
            sw.Start();
            dbResult = dbControllerGLS.GetLicenzeFilt(CurrFilter.OnlyActive, CurrFilter.OnlyUnlock, CurrFilter.ApplicazioneSel, CurrFilter.InstallazioneSel);
            sw.Stop();
            Log.Trace($"Effettuata lettura da DB per LicenzeGLSGetFilt: {sw.Elapsed.TotalMilliseconds} ms");
            return await Task.FromResult(dbResult);
        }

        public async Task<bool> LicenzeGLSUpdate(GLS.DatabaseModels.LicenzeAttive currItem)
        {
            bool done = false;
#if false
            try
            {
                done = dbControllerGLS.UpdateApplicazioni(currItem);
                await InvalidateAllCache();
            }
            catch (Exception exc)
            {
                Log.Error($"Eccezione in ApplicazioniUpdate:{Environment.NewLine}{exc}");
            }
#endif
            return await Task.FromResult(done);
        }

        public void rollBackEditGLS(object item)
        {
            dbControllerGLS.rollBackEntity(item);
        }

        #endregion Public Methods

        #region Protected Fields

        protected new static Logger Log = LogManager.GetCurrentClassLogger();

        #endregion Protected Fields
    }
}