RhSolutions-AddIn/RhSolutions.AddIn/AddIn/RhSolutionsAddIn.cs

using System.Net;

namespace RhSolutions.AddIn;

public sealed class RhSolutionsAddIn : IExcelAddIn
{
    public static Application Excel { get; private set; }
    public static ServiceProvider ServiceProvider { get; private set; }
    public static IAddInConfiguration Configuration { get; private set; }

    public void AutoOpen()
    {
        IServiceCollection Services = new ServiceCollection();

        Services.AddHttpClient()
            .AddMemoryCache()
            .AddSingleton((Application)ExcelDnaUtil.Application)
            .AddSingleton<IAddInConfiguration, AddInConfiguration>()
            .AddSingleton<IDatabaseClient, DatabaseClient>()
            .AddSingleton<ICurrencyClient, CurrencyClient>()
            .AddTransient<IFileDialog, FileDialog>();

        Services.AddSingleton<WriterFactory>();
        Services.AddTransient<NewPriceWriter>()
            .AddTransient<IWriter, NewPriceWriter>(s => s.GetService<NewPriceWriter>());
        Services.AddTransient<DxfWriter>()
            .AddTransient<IWriter, DxfWriter>(s => s.GetService<DxfWriter>());
        Services.AddTransient<CurrentPriceWriter>()
            .AddTransient<IWriter, CurrentPriceWriter>(s => s.GetService<CurrentPriceWriter>());

        Services.AddSingleton<ReaderFactory>();
        Services.AddTransient<ExcelReader>()
            .AddTransient<IReader, ExcelReader>(s => s.GetService<ExcelReader>());
        Services.AddTransient<GuessReader>()
            .AddTransient<IReader, GuessReader>(s => s.GetService<GuessReader>());

        Services.AddSingleton<FittingsCalculatorFactory>();
        Services.AddTransient<CouplingsCalculator>()
            .AddTransient<IFittingsCalculator, CouplingsCalculator>(s => s.GetService<CouplingsCalculator>());
        Services.AddTransient<SleevesCalculator>()
            .AddTransient<IFittingsCalculator, SleevesCalculator>(s => s.GetService<SleevesCalculator>());

        Services.AddSingleton<ToolFactory>();

        ServiceProvider = Services.BuildServiceProvider();
        Configuration = ServiceProvider.GetService<IAddInConfiguration>();
        Excel = ServiceProvider.GetService<Application>();

        EventsUtil.Initialize();

        ServicePointManager.SecurityProtocol =
            SecurityProtocolType.Tls12;
        ServicePointManager.DefaultConnectionLimit = 50;
    }

    public void AutoClose()
    {
        EventsUtil.Uninitialize();
    }
}