public async Task <ActionResult> Post([FromBody] SetOfTracks setOfTracks)
{
foreach (var track in setOfTracks.Tracks)
{
track.Id = await _repo.GetNextId();
track.AirDistance = _geoService.AirDistance((double)track.StartLat, (double)track.StartLng, (double)track.EndLat, (double)track.EndLng);
await _repo.Create(track);
Console.WriteLine(track.Id + " is new Id!\n");
}
Console.WriteLine();
_trackSender.Send(setOfTracks.Tracks);
return(Ok("Tracks saved successfully!"));
}
public async Task DoWork(CancellationToken cancellationToken)
{
System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
if (!cancellationToken.IsCancellationRequested)
{
using (var stream = File.Open("dataSource.xlsx", FileMode.Open, FileAccess.Read))
{
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
do
{
while (!cancellationToken.IsCancellationRequested && reader.Read()) //Each ROW
{
_logger.LogInformation("New row!\n");
if (_started)
{
Track signal = new Track();
Type signalType = typeof(Track);
string currentRow = "";
for (int column = 0; column < reader.FieldCount; column++)
{
if (reader.GetValue(column) != null)
{
currentRow += reader.GetValue(column).ToString() + ", ";
PropertyInfo piInstance = signalType.GetProperty(DeviceParameters.SignalProperties[column]);
string propertyTypeFullName = piInstance.PropertyType.FullName;
if (propertyTypeFullName.Contains("System.Int32"))
{
int convertedValue = Int32.Parse(reader.GetValue(column).ToString());
piInstance.SetValue(signal, convertedValue);
}
else
{
piInstance.SetValue(signal, reader.GetValue(column));
}
}
}
dataFromSensor.Add(signal);
currentRow += "\n";
_logger.LogInformation(currentRow);
counter++;
if (counter == _ammountOfData)
{
object lockObject = new object();
lock (lockObject)
{
_timeLimit = DeviceParameters.TimeLimit;
_ammountOfData = DeviceParameters.AmmountOfData;
}
await Task.Delay(_timeLimit * 1000);
SetOfTracks setOfSignals = new SetOfTracks();
setOfSignals.Tracks.AddRange(dataFromSensor);
//send data to Data_Service
string result = await _httpService.PostRequest("http://data_service/data-service/tracks/array-of-tracks", setOfSignals);
_logger.LogInformation(result);
counter = 0;
dataFromSensor.Clear();
}
}
else
{
_started = true;
}
}
} while (!cancellationToken.IsCancellationRequested && reader.NextResult());
}
}
}
}