public void LoadData()
{
dataLoaded = ReadGoogleSheet.FillDataHasList <TowerData, AttitudeField, LevelAttitude>("1fm4Mitj8s55MOAykzEjo6c6IHV3X9FX_T7HzBV1z22E", "0");
GameData g = GameObject.FindObjectOfType <GameData>();
g.Towers.ReplayData(dataLoaded);
}
protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
ReadGoogleSheet.Init();
while (!stoppingToken.IsCancellationRequested)
{
_logger.LogInformation("Hosted 2 service executing - {0}", DateTime.Now);
using (var scope = _scopeFactory.CreateScope())
{
var _unitOfWork = scope.ServiceProvider.GetRequiredService <IUnitOfWork>();
var _serviceService = scope.ServiceProvider.GetRequiredService <IServiceService>();
var _serviceRequestService = scope.ServiceProvider.GetRequiredService <IServiceRequestService>();
var serviceList = await _unitOfWork.ServiceRepository.GetServices();
foreach (var service in serviceList)
{
if (!string.IsNullOrEmpty(service.SheetLink) && service.SheetLink.Contains("spreadsheets/d/"))
{
//string url = "https://docs.google.com/spreadsheets/d/1skxD2Zt1mdggWnOrb32xeWCNNo5zmy7xCiwIJSDWhpw/edit#gid=221254995";
string url = service.SheetLink;
string[] parts = url.Split("spreadsheets/d/");
string result;
if (parts[1].Contains("/"))
{
string[] parts2 = parts[1].Split("/");
result = parts2[0];
}
else
{
result = parts[1];
}
dynamic jsonList = ReadGoogleSheet.ReadSheet(result);
foreach (var json in jsonList)
{
await _serviceRequestService.UpdateServiceRequest(json.TicketId, new ServiceRequestModel { JsonInformation = json.JsonInformation });
}
}
}
}
await Task.Delay(TimeSpan.FromSeconds(13));
}
}
