protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
while (!stoppingToken.IsCancellationRequested)
{
_logger.LogInformation("Hosted 3 service executing - {0}", DateTime.Now);
using (var scope = _scopeFactory.CreateScope())
{
var _unitOfWork = scope.ServiceProvider.GetRequiredService <IUnitOfWork>();
var serviceRequests = await _unitOfWork.ServiceRequestRepository.GetAll(new SearchServiceRequestModel());
if (serviceRequests != null && serviceRequests.Count > 0)
{
RequestSheetUtils.ClearAllRow(Constants.GoogleSheet.SHEET_REQUEST_SERVICE);
RequestSheetUtils.ClearAllRow(Constants.GoogleSheet.SHEET_FINISHED);
RequestSheetUtils.ClearAllRow(Constants.GoogleSheet.SHEET_IN_PROGRESS);
RequestSheetUtils.ClearAllRow(Constants.GoogleSheet.SHEET_REJECTED);
List <ServiceRequestModel> listRequest = new List <ServiceRequestModel>();
List <ServiceRequestModel> listRequestInProgress = new List <ServiceRequestModel>();
List <ServiceRequestModel> listRequestRejected = new List <ServiceRequestModel>();
List <ServiceRequestModel> listRequestFinished = new List <ServiceRequestModel>();
foreach (var request in serviceRequests)
{
//RequestSheetUtils.Add(request, Constants.GoogleSheet.SHEET_REQUEST_SERVICE);
listRequest.Add(request);
if (request.Status == "In-Progress")
{
listRequestInProgress.Add(request);
//RequestSheetUtils.Add(request, Constants.GoogleSheet.SHEET_IN_PROGRESS);
}
else if (request.Status == "Rejected")
{
listRequestRejected.Add(request);
//RequestSheetUtils.Add(request, Constants.GoogleSheet.SHEET_REJECTED);
}
else if (request.Status == "Finished")
{
listRequestFinished.Add(request);
//RequestSheetUtils.Add(request, Constants.GoogleSheet.SHEET_FINISHED);
}
}
RequestSheetUtils.AddList(listRequest, Constants.GoogleSheet.SHEET_REQUEST_SERVICE);
RequestSheetUtils.AddList(listRequestInProgress, Constants.GoogleSheet.SHEET_IN_PROGRESS);
RequestSheetUtils.AddList(listRequestRejected, Constants.GoogleSheet.SHEET_REJECTED);
RequestSheetUtils.AddList(listRequestFinished, Constants.GoogleSheet.SHEET_FINISHED);
}
}
await Task.Delay(TimeSpan.FromSeconds(30));
}
}
public static void Main(string[] args)
{
RequestSheetUtils.Init();
CreateHostBuilder(args).Build().Run();
}