public async Task <Result> UpdateCategoriesAndProductsInformation()
{
var productApi = new ApiFetcherProduct();
int TimeBetweenQueries;
Result <Database.Model.Parameter> resultParam;
try
{
Result <List <ScraperCategory> > categoriesResult = await scraper.GetCategoriesAndProducts();
if (categoriesResult.IsFailed)
{
return(categoriesResult.ToResult());
}
#region Parameters
resultParam = await parametersService.GetParameterAsync(ParametersKeys.TIME_BETWEEN_QUERIES);
if (resultParam.IsFailed)
{
throw new Exception(resultParam.Errors.Join());
}
else
{
TimeBetweenQueries = Convert.ToInt32(resultParam.Value.Value);
}
logger.LogInformation("TimeBetweenQueries: " + TimeBetweenQueries);
#endregion Parameters
var categories = categoriesResult.Value;
foreach (var scrapedCategory in categories)
{
logger.LogInformation("Getting product from scraped category {0}", scrapedCategory.Description);
var category = unitOfWork.CategoryRepository.Get(c => c.ExternalCategoryId == scrapedCategory.CategoryId, null, string.Join(",", nameof(Category.Products))).FirstOrDefault();
if (category is null)
{
category = new Category()
{
Name = scrapedCategory.Description,
ExternalCategoryId = scrapedCategory.CategoryId,
Products = new List <Product>()
};
unitOfWork.CategoryRepository.Insert(category);
}
else
{
category.Name = scrapedCategory.Description;
category.ExternalCategoryId = scrapedCategory.CategoryId;
unitOfWork.CategoryRepository.Update(category);
}
unitOfWork.Save();
foreach (var scrapedProduct in scrapedCategory.Products)
{
logger.LogInformation("Saving {JsonScrapedProduct}", JsonSerializer.Serialize(scrapedProduct));
{
logger.LogInformation("Saving {0}", scrapedProduct.Name);
var productApiResult = await apiFetcher.GetProductById(scrapedProduct.ProductId);
productApiResult.Log();
if (productApiResult.IsFailed)
{
logger.LogError(string.Format("Could not get product {0} from api on iteration", scrapedProduct.Name));
continue;
}
productApi = productApiResult.Value;
logger.LogInformation("productApi: {0}", productApi.Name);
var prod = unitOfWork.ProductRepository.Get(c => c.ExternalProductId == scrapedProduct.ProductId, null, string.Join(",", nameof(Product.Prices))).FirstOrDefault();
if (prod is null)
{
prod = new Product()
{
Name = productApi.Name,
ExternalProductId = scrapedProduct.ProductId,
Category = category,
CategoryId = category.Id,
BrandId = productApi.BrandId,
Saleable = (productApi.Saleable ?? 0) == 1,
Code = productApi.Code,
Prices = new List <ProductPrice>()
};
category.Products.Add(prod);
}
else
{
prod.Name = productApi.Name;
prod.ExternalProductId = scrapedProduct.ProductId;
prod.Category = category;
prod.CategoryId = category.Id;
prod.BrandId = productApi.BrandId;
prod.Saleable = (productApi.Saleable ?? 0) == 1;
prod.Code = productApi.Code;
}
prod.Prices.Add(new ProductPrice()
{
ListPrice = (productApi.ListPrice ?? 0),
PreviousListPrice = (productApi.PreviousListPrice ?? 0),
PreviousSpecialPrice = (productApi.PreviousSpecialPrice ?? 0),
SpecialPrice = (productApi.SpecialPrice ?? 0),
Product = prod
});
unitOfWork.CategoryRepository.Update(category);
unitOfWork.Save();
}
}
}
return(Result.Ok());
}
catch (Exception e)
{
logger.LogError(e, e.Message);
return(Result.Fail(new Error(e.Message).CausedBy(e)).Log());
}
finally
{
unitOfWork?.Dispose();
}
}
