private TableInfo GetStructure(LumenWorks.Framework.IO.Csv.CsvReader reader)
{
var res = new TableInfo(null);
if (HasHeaders)
{
foreach (string col in reader.GetFieldHeaders())
{
res.Columns.Add(new ColumnInfo(res)
{
CommonType = new DbTypeString(), DataType = "nvarchar", Name = col
});
}
}
else
{
for (int i = 1; i <= reader.FieldCount; i++)
{
res.Columns.Add(new ColumnInfo(res)
{
CommonType = new DbTypeString(), DataType = "nvarchar", Name = String.Format("#{0}", i)
});
}
}
return(res);
}
private void CountActivities(CsvReader csv)
{
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord())
{
string activityName = csv[(int)Fields.ActivityName];
if (_activityCount.ContainsKey(activityName))
{
_activityCount[activityName]++;
}
else
{
_activityCount.Add(activityName, 1);
}
}
}
private string SerializeCsv(CsvReader csv)
{
string results = "";
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord())
{
for (int i = 0; i < fieldCount; i++)
{
results += csv[i] + " ";
}
results += "\n";
}
return(results);
}
