private List <TimeSeriesNote> LoadNotes(IDbClient dbClient)
{
if (RowNotes.Any())
{
return(RowNotes);
}
if (string.IsNullOrWhiteSpace(Context.DbNotesQuery))
{
return(new List <TimeSeriesNote>());
}
var query = ResolveQuery(Context.DbNotesQuery, nameof(Context.DbNotesQuery));
var table = dbClient.ExecuteTable(query);
ValidateTable(table, new List <Field>
{
Context.NoteStartField,
Context.NoteEndField,
Context.NoteTextField,
});
return(table
.Rows.Cast <DataRow>()
.Select(ConvertRowToNote)
.Where(note => note != null)
.ToList());
}
