void WriteAggregateResponseToExcel(AggregateResponse response, string path)
{
var workbook = new XSSFWorkbook();
var sheet = workbook.CreateSheet(StocksTicker);
var header = sheet.CreateRow(0);
header.CreateCell(0).SetCellValue("UTC");
header.CreateCell(1).SetCellValue("Open");
header.CreateCell(2).SetCellValue("High");
header.CreateCell(3).SetCellValue("Low");
header.CreateCell(4).SetCellValue("Close");
header.CreateCell(5).SetCellValue("Volume");
header.CreateCell(6).SetCellValue("Samples");
var rowCount = 1;
foreach (var rowResult in response.Results)
{
var row = sheet.CreateRow(rowCount);
row.CreateCell(0).SetCellValue(rowResult.Timestamp.UtcDateTime.ToString("yyyy-MM-dd HH:mm:ss"));
row.CreateCell(1).SetCellValue((double)rowResult.Open);
row.CreateCell(2).SetCellValue((double)rowResult.High);
row.CreateCell(3).SetCellValue((double)rowResult.Low);
row.CreateCell(4).SetCellValue((double)rowResult.Close);
row.CreateCell(5).SetCellValue((double)rowResult.Volume);
row.CreateCell(6).SetCellValue((double)rowResult.Samples);
rowCount++;
}
var sw = File.Create(path);
workbook.Write(sw);
sw.Close();
}
public async Task <List <Event <T> > > GetEventsAsync <T>(string streamName, Guid streamId)
{
streamName = streamName.ToLower();
AggregateResponse <T> events = await _aggregatesClient.GetAsync <T>(streamName, streamId);
return(events.Events.Select(x => new Event <T>
{
Data = x.Data
}).ToList());
}
public override void WriteJson(JsonWriter writer, AggregateResponse <T> value, JsonSerializer serializer)
{
writer.WriteStartArray();
foreach (var item in value.Items)
{
foreach (var v in item)
{
serializer.Serialize(writer, v);
}
}
writer.WriteEndArray();
}
public override void WriteJson(JsonWriter writer, AggregateResponse <CompletionList> value, JsonSerializer serializer)
{
var values = value.Items.ToArray();
if (!values.Any(z => z.IsIncomplete))
{
writer.WriteStartArray();
foreach (var item in value.Items)
{
foreach (var v in item)
{
serializer.Serialize(writer, v);
}
}
writer.WriteEndArray();
return;
}
writer.WriteStartObject();
writer.WritePropertyName("isIncomplete");
writer.WriteValue(true);
writer.WritePropertyName("items");
writer.WriteStartArray();
foreach (var item in value.Items)
{
foreach (var v in item)
{
serializer.Serialize(writer, v);
}
}
writer.WriteEndArray();
writer.WriteEndObject();
}
public override AggregateResponse <CompletionList> ReadJson(
JsonReader reader, Type objectType, AggregateResponse <CompletionList> existingValue, bool hasExistingValue, JsonSerializer serializer
) => throw new NotImplementedException();