public void ExportProductsToExcelFilesByBrands(AppConfiguration appConfiguration) { string[] brands = appConfiguration.Brands.Split(";"); log.Info("Getting List of Products for Brand from Nop DB"); GenericService.products = _productService.FindAllProducts(); log.Info("List of Products from Nop DB are Gathered"); log.Info("Getting List of Specification Attribute Values from Nop DB"); SpecificationAttributeOptionUtil.specificationAttributes = _specificationAttributeService.FindAllSpecificationAttributes(); log.Info("List of Specification Attributes from Nop DB are Gathered"); log.Info("Getting List of Specification Attribute Option Values from Nop DB"); SpecificationAttributeOptionUtil.specificationAttributeOptions = _specificationAttributeOptionService.FindAllSpecificationAttributeOptions(); log.Info("List of Specification Attribute Options from Nop DB are Gathered"); foreach (string brand in brands) { _allExcelProductService.ExportProductsToExcelFilesByBrands(brand); } }