public bool LoadUserDataFromCsv() { var result = false; try { if (!_context.Users.Any()) { string rootDirectoryPath = AppDomain.CurrentDomain.BaseDirectory; string pathFinalAccessFile = Path.Combine(rootDirectoryPath, "App_Data", ConfigurationReader.ReadAppConfig("CsvData.csv", "CsvData.csv")); using (var textReader = new StreamReader(pathFinalAccessFile)) { var users = CsvHelpers.ReadFileWithoutHeader <UserDto>(textReader, typeof(UserCsvMap)); if (users != null && users.Any()) { _context.Users.AddRange(_mapper.Map <IEnumerable <User> >(users)); _context.SaveChanges(); result = true; } } } } catch (Exception ex) { //Log error } return(result); }
public void ReadFileTest() { var baseDir = AppDomain.CurrentDomain.BaseDirectory; var filePath = Path.Combine(baseDir, "TestFiles", "CsvData.csv"); var csvTestDataTextReader = new StreamReader(filePath, System.Text.Encoding.UTF8); var users = CsvHelpers.ReadFileWithoutHeader <UserDto>(csvTestDataTextReader, typeof(UserCsvMap)); Assert.IsTrue(users?.Count() > 0); }