public async System.Threading.Tasks.Task CheckProductDataSheetAvailabilityAsync_NonExistingURL()
        {
            var options = new DbContextOptionsBuilder <ChemiCleanContext>()
                          .UseSqlServer(connectionString)
                          .Options;
            var dbContext = new ChemiCleanContext(options);

            ProductsRepository productsRepository = new ProductsRepository(dbContext);
            ProductsService    productsService    = new ProductsService(productsRepository);
            var product = productsRepository.GetProducts().FirstOrDefault();

            if (product != null)
            {
                product.Url = "None";
                productsRepository.Commit();
            }
            var NonExistingFile = await productsService.CheckProductDataSheetAvailabilityAsync(product.Id);

            Assert.False(NonExistingFile);
        }