private ICollection <string> ParseLine(string line, ImportProfile importProfile)
{
var columns = line.Split(importProfile.FieldDelimiter);
if (importProfile.TextQualifier != 0)
{
return(columns
.Select(col => col.Trim(importProfile.TextQualifier))
.ToList());
}
return(columns);
}
private IDictionary <string, object> MapColumns(ICollection <string> columns, ImportProfile importProfile)
{
var row = new Dictionary <string, object>();
for (int i = 0; i < columns.Count; i++)
{
var columnValue = columns.ElementAt(i);
var map = importProfile
.RecordDefinitions.First()
.FieldMappings
.FirstOrDefault(m => m.FieldDefinitionNumber == (i + 1));
if (map != null)
{
row.Add(map.FieldName, columnValue);
}
}
return(row);
}