using Microsoft.Data.SqlClient;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using NLog;
using StockMan.Data.DbModels;

namespace StockMan.Data.Controllers
{
    public class StoManController : IDisposable
    {
        #region Public Constructors

        public StoManController(IConfiguration configuration)
        {
            _configuration = configuration;
            Log.Info("Avviata classe StoManController");
        }

        #endregion Public Constructors

        #region Public Methods

        /// <summary>
        /// Conferma movimenti
        /// </summary>
        /// <param name="itemID"></param>
        /// <returns></returns>
        public async Task<bool> ConfermaMov(int itemID)
        {
            bool answ = false;
            using (var dbCtx = new StockManContext(_configuration))
            {
                var ItemID = new SqlParameter("@ItemID", itemID);

                var callResult = await dbCtx
                            .Database
                            .ExecuteSqlRawAsync("exec dbo.stp_ItemConsolidate  @ItemID", ItemID);

                answ = true;
            }
            return answ;
        }

        /// <summary>
        /// Lista Contatori
        /// </summary>
        /// <returns></returns>
        public List<CountersListModel> CountersGetAll()
        {
            List<CountersListModel> dbResult = new List<CountersListModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetCountersList
                            .OrderBy(x => x.Id)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Flux Delete
        /// </summary>
        /// <returns></returns>
        public async Task<bool> DeleteFlux(ItemFluxModel currRec)
        {
            bool fatto = false;
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var dbResult = localDbCtx
                                .DbSetItemFlux
                                .Where(x => x.Id == currRec.Id)
                                .FirstOrDefault();
                    if (dbResult != null)
                    {
                        localDbCtx
                                .DbSetItemFlux
                                .Remove(dbResult);
                        await localDbCtx.SaveChangesAsync();
                        fatto = true;
                    }
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante DeleteFlux{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        public void Dispose()
        {
            GC.Collect();
        }

        /// <summary>
        /// Elimina movimenti duplicati
        /// </summary>
        /// <param name="itemID"></param>
        /// <returns></returns>
        public async Task<bool> EliminaDup(int itemID)
        {
            bool answ = false;
            using (var dbCtx = new StockManContext(_configuration))
            {
                var ItemID = new SqlParameter("@ItemID", itemID);

                var callResult = await dbCtx
                            .Database
                            .ExecuteSqlRawAsync("exec dbo.stp_ItemShrinkHist  @ItemID", ItemID);

                answ = true;
            }
            return answ;
        }

        /// <summary>
        /// aggiunta item
        /// </summary>
        /// <returns></returns>
        public async Task<bool> FluxAdd(ItemFluxModel newRec)
        {
            bool fatto = false;
            List<ItemFluxModel> dbResult = new List<ItemFluxModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetItemFlux
                                        .Where(x => x.Id == newRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        fatto = false;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetItemFlux
                            .Add(newRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante FluxAdd{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Modifica flux
        /// </summary>
        /// <returns></returns>
        public async Task<bool> FluxMod(ItemFluxModel editRec)
        {
            bool fatto = false;
            //List<ItemModel> dbResult = new List<ItemModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetItemFlux
                                        .Where(x => x.Id == editRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        currRec.ItemId = editRec.ItemId;
                        currRec.LocationId = editRec.LocationId;
                        currRec.MovTypeId = editRec.MovTypeId;
                        currRec.ExtLocationId = editRec.ExtLocationId;
                        currRec.DtMov = editRec.DtMov;
                        currRec.Qta = editRec.Qta;
                        currRec.TotValue = editRec.TotValue;
                        currRec.OperatorId = "ND";
                        currRec.Note = editRec.Note;
                        currRec.CodDoc = editRec.CodDoc;
                        currRec.ModOperatorId = "ND";
                        localDbCtx.Entry(currRec).State = EntityState.Modified;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetItemFlux
                            .Add(editRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante FluxMod;{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// aggiunta item
        /// </summary>
        /// <returns></returns>
        public async Task<bool> ItemAdd(ItemModel newRec)
        {
            bool fatto = false;
            List<ItemModel> dbResult = new List<ItemModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetItem
                                        .Where(x => x.Id == newRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        fatto = false;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetItem
                            .Add(newRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante ItemAdd{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Aggiunta famiglia di item
        /// </summary>
        /// <returns></returns>
        public async Task<bool> ItemFamilyAdd(ItemFamilyModel newRec)
        {
            bool fatto = false;
            List<ItemFamilyModel> dbResult = new List<ItemFamilyModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetItemFamily
                                        .Where(x => x.Id == newRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        fatto = false;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetItemFamily
                            .Add(newRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante ItemFamilyAdd{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Lista Items
        /// </summary>
        /// <returns></returns>
        public async Task<bool> ItemFamilyDeleteByID(ItemFamilyModel currRec)
        {
            bool fatto = false;
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var dbResult = localDbCtx
                                .DbSetItemFamily
                                .Where(x => x.Id == currRec.Id)
                                .FirstOrDefault();
                    if (dbResult != null)
                    {
                        localDbCtx
                                .DbSetItemFamily
                                .Remove(dbResult);
                        await localDbCtx.SaveChangesAsync();
                        fatto = true;
                    }
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante ItemFamilyDeleteByID{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Lista Famiglie Articoli
        /// </summary>
        /// <returns></returns>
        public List<ItemFamilyModel> ItemFamilyGetAll()
        {
            List<ItemFamilyModel> dbResult = new List<ItemFamilyModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetItemFamily
                            .OrderBy(x => x.Descr)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Lista Famiglie Articoli da ricerca
        /// </summary>
        /// <returns></returns>
        public List<ItemFamilyModel> ItemFamilyGetSearch(string searchVal)
        {
            List<ItemFamilyModel> dbResult = new List<ItemFamilyModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetItemFamily
                            .Where(x => x.Descr.Contains(searchVal))
                            .OrderBy(x => x.Descr)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Modifica famiglia articoli
        /// </summary>
        /// <returns></returns>
        public async Task<bool> ItemFamilyMod(ItemFamilyModel editRec)
        {
            bool fatto = false;
            List<ItemFamilyModel> dbResult = new List<ItemFamilyModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetItemFamily
                                        .Where(x => x.Id == editRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        currRec.Descr = editRec.Descr;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetItemFamily
                            .Add(editRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante ItemFamilyMod{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Lista Flux x item
        /// </summary>
        /// <returns></returns>
        public List<ItemFluxModel> ItemFluxGetById(int id)
        {
            List<ItemFluxModel> dbResult = new List<ItemFluxModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetItemFlux
                            .Include(l => l.Location)
                            .Include(e => e.ExtLocation)
                            .Where(x => x.ItemId == id)
                            .OrderByDescending(x => x.Id)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Modifica item,
        /// </summary>
        /// <returns></returns>
        public async Task<bool> ItemMod(ItemModel editRec)
        {
            bool fatto = false;
            //List<ItemModel> dbResult = new List<ItemModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetItem
                                        .Where(x => x.Id == editRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        currRec.Descr = editRec.Descr;
                        currRec.CodInt = editRec.CodInt;
                        currRec.ItemFamilyId = editRec.ItemFamilyId;
                        currRec.CodExt = editRec.CodExt;
                        currRec.DescrExt = editRec.DescrExt;
                        currRec.QtaMin = editRec.QtaMin;
                        currRec.QtaBatch = editRec.QtaBatch;
                        currRec.CurrValue = editRec.CurrValue;
                        currRec.QtaCurr = editRec.QtaCurr;
                        currRec.QtaPend = editRec.QtaPend;
                        currRec.Um = editRec.Um;
                        localDbCtx.Entry(currRec).State = EntityState.Modified;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetItem
                            .Add(editRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante ItemMod{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Lista Items
        /// </summary>
        /// <returns></returns>
        public List<ItemModel> ItemsGetAll()
        {
            List<ItemModel> dbResult = new List<ItemModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetItem
                            .OrderBy(x => x.Descr)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Lista Items da ricerca
        /// </summary>
        /// <returns></returns>
        public List<ItemModel> ItemsGetByID(int id)
        {
            List<ItemModel> dbResult = new List<ItemModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                var risultato = localDbCtx
                            .DbSetItem
                            .Where(x => ((x.Id == id)))
                            .ToList();

                if (risultato != null)
                {
                    dbResult = risultato;
                }
            }
            return dbResult;
        }

        /// <summary>
        /// Lista Items da ricerca
        /// </summary>
        /// <returns></returns>
        public List<ItemStockModel> ItemsGetByLocation(string locationSel)
        {
            List<ItemStockModel> dbResult = new List<ItemStockModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetItemStock
                            .Where(x => x.LocationId == locationSel)
                            .Include(l => l.ItemNav)
                            .ToList();
            }
            return dbResult;
        }

        ///// <summary>
        ///// Lista Items da ricerca
        ///// </summary>
        ///// <returns></returns>
        //public List<ItemModel> ItemsGetSearch(string searchVal, string famID)
        //{
        //    List<ItemModel> dbResult = new List<ItemModel>();
        //    using (StockManContext localDbCtx = new StockManContext(_configuration))
        //    {
        //        dbResult = localDbCtx
        //                    .DbSetItem
        //                    .Where(x => (x.ItemFamilyId == famID || string.IsNullOrEmpty(famID)) && (x.CodExt.Contains(searchVal) || x.Descr.Contains(searchVal) || x.DescrExt.Contains(searchVal) || string.IsNullOrEmpty(searchVal)))
        //                    .OrderBy(x => x.Descr)
        //                    .ToList();
        //    }
        //    return dbResult;
        //}
        /// <summary>
        /// Lista Items da ricerca
        /// </summary>
        /// <returns></returns>
        public List<ItemModel> ItemsGetSearch(string searchVal, string itemFamId)
        {
            List<ItemModel> dbResult = new List<ItemModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                if (!string.IsNullOrEmpty(searchVal) && itemFamId == "*")
                {
                    var risultato = localDbCtx
                                .DbSetItem
                                .Where(x => ((x.Id.ToString() == searchVal)) || (x.CodInt.Contains(searchVal)) || (x.CodExt.Contains(searchVal)) || (x.Descr.Contains(searchVal) || (x.CurrValue.ToString().Contains(searchVal))))
                                .ToList();

                    if (risultato != null)
                    {
                        dbResult = risultato;
                    }
                }
                else if (itemFamId != "*" && string.IsNullOrEmpty(searchVal))
                {
                    var risultato = localDbCtx
                               .DbSetItem
                               .Where(x => ((x.ItemFamilyId == itemFamId)))
                               .ToList();

                    if (risultato != null)
                    {
                        dbResult = risultato;
                    }
                }
                else if (itemFamId != "*" && !string.IsNullOrEmpty(searchVal))
                {
                    var risultato = localDbCtx
                               .DbSetItem
                               .Where(x => ((x.ItemFamilyId == itemFamId) && ((x.CodInt.Contains(searchVal)) || (x.CodExt.Contains(searchVal)) || (x.Descr.Contains(searchVal) || (x.CurrValue.ToString().Contains(searchVal))))))
                               .ToList();

                    if (risultato != null)
                    {
                        dbResult = risultato;
                    }
                }
                else
                {
                    dbResult = localDbCtx
                                .DbSetItem
                                .OrderBy(x => x.Id)
                                .ToList();
                }
            }
            return dbResult;
        }

        /// <summary>
        /// Lista Item Stock (ALL!)
        /// </summary>
        /// <returns></returns>
        public List<ItemStockModel> ItemsStockGetAll()
        {
            List<ItemStockModel> dbResult = new List<ItemStockModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetItemStock
                            .OrderBy(x => x.Id)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Lista Item Stock (By ID)
        /// </summary>
        /// <param name="ItemID"></param>
        /// <returns></returns>
        public List<ItemStockModel> ItemsStockGetById(int ItemID)
        {
            List<ItemStockModel> dbResult = new List<ItemStockModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetItemStock
                            .Where(x => x.ItemId == ItemID)
                            .OrderBy(x => x.Id)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Aggiungi Locazione
        /// </summary>
        /// <returns></returns>
        public async Task<bool> LocationAddNew(LocationModel editRec)
        {
            bool fatto = false;
            List<LocationModel> dbResult = new List<LocationModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetLocation
                                        .Where(x => x.Id == editRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        fatto = false;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetLocation
                            .Add(editRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante LocationAddNew{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Lista Locazioni
        /// </summary>
        /// <returns></returns>
        public List<LocationModel> LocationGetAll()
        {
            List<LocationModel> dbResult = new List<LocationModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetLocation
                            .OrderBy(x => x.Descr)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Lista Locazioni join con tabella location type
        /// </summary>
        /// <returns></returns>
        public List<LocationModel> LocationGetLocType()
        {
            List<LocationModel> dbResult = new List<LocationModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetLocation
                            .Include(l => l.LocTypeNav)
                            .Where(x => x.LocTypeNav.IsStock)
                            .OrderBy(x => x.Id)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Modifica Locazione
        /// </summary>
        /// <returns></returns>
        public async Task<bool> LocationMod(LocationModel editRec)
        {
            bool fatto = false;
            List<LocationModel> dbResult = new List<LocationModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetLocation
                                        .Where(x => x.Id == editRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        currRec.Descr = editRec.Descr;
                        currRec.LocTypeId = editRec.LocTypeId;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetLocation
                            .Add(editRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante LocationMod{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Lista Tipi Locazioni
        /// </summary>
        /// <returns></returns>
        public List<LocTypeModel> LocTypeGetAll()
        {
            List<LocTypeModel> dbResult = new List<LocTypeModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetLocType
                            .OrderBy(x => x.Descr)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Muove gli items nei vari scaffali
        /// </summary>
        /// <returns></returns>
        public async Task<bool> MoveItems(int stockId, string locationIdFrom, string locationIdTo, string oprId)
        {
            bool answ = false;
            using (var dbCtx = new StockManContext(_configuration))
            {
                var StockId = new SqlParameter("@StockID", stockId);
                var LocationIdFrom = new SqlParameter("@LocationID_FROM", locationIdFrom);
                var LocationIdTo = new SqlParameter("@LocationID_TO", locationIdTo);
                var OprId = new SqlParameter("@OperatorID", oprId);

                var callResult = await dbCtx
                            .Database
                            .ExecuteSqlRawAsync("exec dbo.stp_ItemStockMove  @StockID, @LocationID_FROM, @LocationID_TO, @OperatorID", StockId, LocationIdFrom, LocationIdTo, OprId);

                answ = true;
            }
            return answ;
        }

        /// <summary>
        /// Muove gli items nei vari scaffali
        /// </summary>
        /// <returns></returns>
        public async Task<bool> MoveItems_New(int stockId, string locationIdFrom, string locationIdTo, string oprId, int qtyMov)
        {
            bool answ = false;
            using (var dbCtx = new StockManContext(_configuration))
            {
                var StockId = new SqlParameter("@StockID", stockId);
                var LocationIdFrom = new SqlParameter("@LocationID_FROM", locationIdFrom);
                var LocationIdTo = new SqlParameter("@LocationID_TO", locationIdTo);
                var OprId = new SqlParameter("@OperatorID", oprId);
                var QtyMov = new SqlParameter("@QtyMov", qtyMov);

                var callResult = await dbCtx
                            .Database
                            .ExecuteSqlRawAsync("exec stp_ItemStockMove_New  @StockID, @LocationID_FROM, @LocationID_TO, @OperatorID, @QtyMov", StockId, LocationIdFrom, LocationIdTo, OprId, QtyMov);

                answ = true;
            }
            return answ;
        }

        /// <summary>
        /// Lista Tipi Movimenti
        /// </summary>
        /// <returns></returns>
        public List<MovTypeModel> MovTypeGetAll()
        {
            List<MovTypeModel> dbResult = new List<MovTypeModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetMovType
                            .OrderBy(x => x.Descr)
                            .ToList();
            }
            return dbResult;
        }

        //}
        /// <summary>
        /// Aggiungi Operatore
        /// </summary>
        /// <returns></returns>
        public async Task<bool> OperatorAddNew(OperatorModel editRec)
        {
            bool fatto = false;
            List<OperatorModel> dbResult = new List<OperatorModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetOperator
                                        .Where(x => x.CodExt == editRec.CodExt)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        fatto = false;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetOperator
                            .Add(editRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante OperatorMod{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        ///// <summary>
        ///// Modifica Famiglie Articoli
        ///// </summary>
        ///// <returns></returns>
        //public List<ItemFamilyModel> ItemFamilyMod()
        //{
        //    List<ItemFamilyModel> dbResult = new List<ItemFamilyModel>();
        //    using (StockManContext localDbCtx = new StockManContext(_configuration))
        //    {
        //        dbResult = localDbCtx
        //                    .DbSetItemFamily
        //                    .OrderBy(x => x.Descr)
        //                    .ToList();
        //    }
        //    return dbResult;
        /// <summary>
        /// Modifica Operatore
        /// </summary>
        /// <returns></returns>
        public async Task<bool> OperatorMod(OperatorModel editRec)
        {
            bool fatto = false;
            List<OperatorModel> dbResult = new List<OperatorModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                try
                {
                    var currRec = localDbCtx
                                        .DbSetOperator
                                        .Where(x => x.Id == editRec.Id)
                                        .FirstOrDefault();
                    if (currRec != null)
                    {
                        currRec.CodExt = editRec.CodExt;
                        currRec.LastName = editRec.LastName;
                        currRec.FirstName = editRec.FirstName;
                    }
                    else
                    {
                        localDbCtx
                            .DbSetOperator
                            .Add(editRec);
                    }
                    await localDbCtx.SaveChangesAsync();
                    fatto = true;
                }
                catch (Exception exc)
                {
                    Log.Error($"Eccezione durante OperatorMod{Environment.NewLine}{exc}");
                }
            }
            return fatto;
        }

        /// <summary>
        /// Lista Operatori
        /// </summary>
        /// <returns></returns>
        public List<OperatorModel> OperatorsGetAll()
        {
            List<OperatorModel> dbResult = new List<OperatorModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetOperator
                            .OrderBy(x => x.LastName)
                            .ThenBy(x => x.FirstName)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Operatore cercato
        /// </summary>
        /// <returns></returns>
        public OperatorModel OperatorsGetByCodExt(string codExt)
        {
            OperatorModel dbResult = new OperatorModel();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                var risultato = localDbCtx
                            .DbSetOperator
                            .Where(x => x.CodExt == codExt)
                            .OrderBy(x => x.LastName)
                            .ThenBy(x => x.FirstName)
                            .FirstOrDefault();

                if (risultato != null)
                {
                    dbResult = risultato;
                }
            }
            return dbResult;
        }

        /// <summary>
        /// Lista Permessi
        /// </summary>
        /// <returns></returns>
        public List<PermessiModel> PermessiGetAll()
        {
            List<PermessiModel> dbResult = new List<PermessiModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetPermessi
                            .OrderBy(x => x.GRUPPO)
                            .ToList();
            }
            return dbResult;
        }

        /// <summary>
        /// Lista Item Stock (raggruppati x location)
        /// </summary>
        /// <returns></returns>
        public List<VLocationValModel> StockStatus()
        {
            List<VLocationValModel> dbResult = new List<VLocationValModel>();
            using (StockManContext localDbCtx = new StockManContext(_configuration))
            {
                dbResult = localDbCtx
                            .DbSetVLocationVal
                            .Include(l => l.LocationNav)
                            .ToList();
            }
            return dbResult;
        }

        #endregion Public Methods

        #region Private Fields

        private static IConfiguration _configuration = null!;

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

        #endregion Private Fields
    }
}