Esempio n. 1
0
       public void Can_Read_From_CSV_File()
        {
            string selectedPath = Path.Combine(FileUtility.GetDefaultDirectory(), "commodity.csv");

            var inputFileDescription = new CsvFileDescription
            {
                // cool - I can specify my own separator!
                SeparatorChar = ',',
                FirstLineHasColumnNames = false,
                EnforceCsvColumnAttribute = false
            };


             var imports = new CsvContext().Read<MasterImportEntity>(selectedPath, inputFileDescription);
             var commodityImports = imports.Select(dataRow => new CommodityImport()
                                                                  {
                                                                      Code = dataRow[0].Value,
                                                                      Name = dataRow[1].Value,
                                                                      CommodityTypeCode = dataRow[2].Value,
                                                                      Description = dataRow[3].Value
                                                                  }).ToList();

             Assert.IsTrue(commodityImports.Any());
            

        }