void DoGetCsvColumn()
{
CsvData _data = CsvData.GetReference(reference.Value);
if (_data == null)
{
Fsm.Event(errorEvent);
result.Resize(0);
return;
}
int _column = zeroBasedIndexing?column.Value:column.Value - 1;
if (_data.ColumnCount <= _column)
{
LogError("Csv Data '" + reference.Value + "' doesn't have " + (_column) + " columns, only " + _data.ColumnCount);
Fsm.Event(errorEvent);
result.Resize(0);
return;
}
result.Resize(_data.RecordCount);
for (int i = 0; i < _data.RecordCount; i++)
{
result.Set(i, _data.GetFieldAt(i, _column, false));
}
result.SaveChanges();
}
void GetCsvEntry()
{
CsvData _data = CsvData.GetReference(reference.Value);
if (_data == null)
{
Fsm.Event(errorEvent);
field.Value = string.Empty;
return;
}
int _record = zeroBasedIndexing?record.Value:record.Value - 1;
int _column = zeroBasedIndexing?column.Value:column.Value - 1;
if (_data.RecordCount <= _record)
{
LogError("Csv Data '" + reference.Value + "' doesn't have " + (_record + 1) + " records, only " + _data.RecordCount);
Fsm.Event(errorEvent);
field.Value = string.Empty;
return;
}
if (_data.ColumnCount <= _column)
{
LogError("Csv Data '" + reference.Value + "' doesn't have " + (_column + 1) + " columns, only " + _data.ColumnCount);
Fsm.Event(errorEvent);
field.Value = string.Empty;
return;
}
field.Value = _data.GetFieldAt(_record, _column);
}
void GetCsvFields()
{
CsvData _data = CsvData.GetReference(reference.Value);
if (_data == null)
{
Fsm.Event(errorEvent);
field.Value = string.Empty;
return;
}
if (!_data.HasHeader)
{
LogError("Csv Data (" + reference.Value + ") has no header");
Fsm.Event(errorEvent);
field.Value = string.Empty;
return;
}
int _record = zeroBasedIndexing?record.Value:record.Value - 1;
if (_data.RecordCount <= _record)
{
LogError("Csv Data '" + reference.Value + "' doesn't have " + (_record + 1) + " records, only " + _data.RecordCount);
Fsm.Event(errorEvent);
field.Value = string.Empty;
return;
}
int _column = _data.HeaderKeys.IndexOf(key.Value);
if (_data.ColumnCount <= _column)
{
LogError("Csv Data '" + reference.Value + "' doesn't have " + (_column + 1) + " columns based on key " + key.Value + ", only " + _data.ColumnCount);
Fsm.Event(errorEvent);
field.Value = string.Empty;
return;
}
field.Value = _data.GetFieldAt(record.Value, key.Value);
}
void DoGetCsvColumn()
{
CsvData _data = CsvData.GetReference(reference.Value);
if (_data == null)
{
Fsm.Event(errorEvent);
fields.Resize(0);
return;
}
if (!_data.HasHeader)
{
LogError("Csv Data '" + reference.Value + "' has no header");
Fsm.Event(errorEvent);
fields.Resize(0);
return;
}
int _column = _data.HeaderKeys.IndexOf(key.Value);
if (_data.ColumnCount <= _column)
{
LogError("Csv Data '" + reference.Value + "' doesn't have " + (_column + 1) + " columns based on key " + key.Value + ", only " + _data.ColumnCount);
Fsm.Event(errorEvent);
fields.Resize(0);
return;
}
fields.Resize(_data.RecordCount);
for (int i = 0; i < _data.RecordCount; i++)
{
fields.Set(i, _data.GetFieldAt(i, _column, false));
}
fields.SaveChanges();
}
