internal static async Task ImportFileContentAsync(LarsCosmosDbCollectionSettings settings, DocumentClient client, string fileName, Stream stream)
{
if (TryGetCollectionId(settings, fileName, out string collectionId))
{
var headings = new List <string>();
using (var reader = new StreamReader(stream))
{
var lineNumber = 0;
foreach (var line in DelimitedFileReader.ReadLines(reader, new DelimitedFileSettings(true)))
{
lineNumber++;
if (lineNumber == 1)
{
headings = line.Fields.Select(f => CleanHeading(f.Value)).ToList();
continue;
}
var dict = new Dictionary <string, object>();
foreach (var field in line.Fields)
{
dict[headings[field.Number - 1]] = field.Value;
}
var doc = dict.ToExpandoObject();
await client.CreateDocumentAsync(
UriFactory.CreateDocumentCollectionUri(settings.DatabaseId, collectionId),
doc);
}
}
}
}
