public FundaService(ILogger <FundaService> logger, HttpClient client, MainSqlServerDbContext context, IMapper mapper)
{
_logger = logger;
_client = client;
_context = context;
_mapper = mapper;
}
public AanbodController(ILogger <AanbodController> logger, MainSqlServerDbContext context, FundaService service, IServiceProvider provider)
{
_logger = logger;
_context = context;
_service = service;
_provider = provider;
}
private async Task <bool> DeleteAllData(MainSqlServerDbContext dbContext)
{
try
{
foreach (var entity in dbContext.Aanbod)
{
dbContext.Aanbod.Remove(entity);
}
await dbContext.SaveChangesAsync();
return(true);
} catch (Exception e)
{
_logger.LogError(0, e, "Error while processing delete all data");
return(false);
}
}
public async Task <bool> FetchDataAndPopulateDB <ResponseDTO>(MainSqlServerDbContext dbContext)
{
try
{
// fetch all data using url provided
List <Aanbod> aanbods = await this.FetchData();
if (aanbods == null)
{
_logger.LogInformation($"Fetching data did not retrive any results at {DateTime.UtcNow.ToLongTimeString()}");
return(false);
}
// truncate table
bool successfulDelete = await this.DeleteAllData(dbContext);
if (!successfulDelete)
{
_logger.LogInformation($"Deleting data did not finish sucessfully {DateTime.UtcNow.ToLongTimeString()}");
return(false);
}
//populate database
await dbContext.Aanbod.AddRangeAsync(aanbods);
var numberOfItemsSaved = await dbContext.SaveChangesAsync();
var success = numberOfItemsSaved > 0 ? true : false;
return(success);
}
catch (Exception e)
{
_logger.LogError(0, e, "Error while processing request from FetchDataAndPopulateDB");
return(false);
}
}
