//------------------------------------------------------------------------ public ResultInfo <Object> ImportFromExcel(String pathOfExcel) { ResultInfo <Object> resultInfo = new ResultInfo <Object> (); ListOfModelDirectory.Clear(); try { FactoryModelDirectory factoryModelDirectory = new FactoryModelDirectory(this); CsvImporter csvImport = new CsvImporter(pathOfExcel); List <int> listOfNumbers = csvImport.Import(); foreach (int number in listOfNumbers) { ListOfModelDirectory.Add(factoryModelDirectory.Construct(number)); } if (listOfNumbers.Count == 0) { resultInfo.SetResult(1, "Es konnten keine Verzeichnisse gefunden werden", null); } else { resultInfo.SetResult(0, "", null); } } catch (Exception) { ListOfModelDirectory.Clear(); } return(resultInfo); }
static void Main(string[] args) { int result = 2; while (result == 2) { IGarageManager garageManager = new GarageManagerFactory().Create(); IConsoleInputOutput consoleInputOutput = new ConsoleInputOutput(); IVehicleManager vehicleManager = VehicleManagerFactory.Create(garageManager); IVehicleParser vehicleParser = new VehicleParser(); IGarageParser garageParser = new GarageParser(); IFileInputOutput file = new FileInputOutput(); ICsvImporter csvImporter = new CsvImporter(file, vehicleParser); ICommandExecuterFactory commandExecuterFactory = new CommandExecuterFactory(vehicleManager, consoleInputOutput, vehicleParser, garageManager, garageParser, csvImporter, file); var commandLineParser = new CommandLineParser(consoleInputOutput, CommandDictionaryFactory.Create(), vehicleManager, commandExecuterFactory); while ((result = commandLineParser.ReadCommand()) == 1) { ; } if (result == 2) { consoleInputOutput.WriteInfo("Daten werden wiederhergestellt."); } } }
public void ColumnHeaderTest() { var s = "First Name, Last Name, Age"; var csv = new CsvImporter(); var onHeaderReadCalled = false; csv.OnHeaderRead += _sb => { Assert.AreEqual(s, _sb.ToString(), "Header string should match"); onHeaderReadCalled = true; }; csv.ColumnNameSpaceReplacement = "_"; csv.ImportString(s); Assert.IsTrue(onHeaderReadCalled, "Should have called OnHeaderRead lambda"); var data = csv.GetData(); Assert.AreEqual(0, data.Count, "No Data- should be zero length"); var cols = csv.GetColumnNames(); Assert.IsNotNull(cols); Assert.AreEqual(3, cols.Count, "Column Count"); Assert.AreEqual("First_Name", cols[0], "0"); Assert.AreEqual("Last__Name", cols[1], "1"); Assert.AreEqual("Age", cols[2], "2"); }
private static LineUp GetBestLineups(int playerCount) { IList <GameSnapshot> snapshots = CsvImporter.GetGameSnapShots(CSV_3_SNAPSHOTS); var lineup = LineUp.GetBestLineup(playerCount, snapshots); return(lineup); }
private static IList <PlayerData> GetPlayers() { var snapshots = CsvImporter.GetGameSnapShots(CSV_3_SNAPSHOTS); var players = PlayerData.GetData(snapshots); return(players); }
public async Task TestRecordAsync() { Recorder <CloseChangeRecordModel> recorder = new("Test", AppDomain.CurrentDomain.BaseDirectory); DateTime date = DateTime.Now; recorder.Insert(new CloseChangeRecordModel { CoinBalance1 = 1, Balance = 2, Assets = 3, Date = date }); recorder.Insert(new CloseChangeRecordModel { CoinBalance1 = 4, Balance = 5, Assets = 6, Date = date }); await recorder.SaveAsync(); IImporter importer = new CsvImporter(); var result = (await importer.Import <CloseChangeRecordModel>(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Test.csv"))).Data.ToList(); Assert.AreEqual(date.ToString(), result[0].Date.ToString()); Assert.AreEqual(1, result[0].CoinBalance1); Assert.AreEqual(2, result[0].Balance); Assert.AreEqual(3, result[0].Assets); Assert.AreEqual(date.ToString(), result[1].Date.ToString()); Assert.AreEqual(4, result[1].CoinBalance1); Assert.AreEqual(5, result[1].Balance); Assert.AreEqual(6, result[1].Assets); }
public void Load_FileDoesNotExist_ThrowsFileNotFoundException() { String filename = @"c:\temp\missing-file.csv"; CsvSettings settings = null; Assert.Throws <FileNotFoundException>(() => { CsvImporter <TestClassBase> .Load(filename, settings); }); }
public void Load_StreamIsNull_ThrowsArgumentNullException() { Stream stream = null; CsvSettings settings = null; Assert.Throws <ArgumentNullException>(() => { CsvImporter <TestClassBase> .Load(stream, settings); }); }
public void Load_DataConversionSucceeds_ResultIsAsExpected() { String content = "Label,Enabled,Number,Currency\r\n" + "Label-1,true,42,\"1,234\"\r\n" + "Label-2,true,42,\"1,234\"\r\n"; CsvSettings settings = new CsvSettings(); List <TestClass4> expected = new List <TestClass4>() { new TestClass4() { Label = "Label-1", Enabled = true, Number = 42, Currency = 1.234m, }, new TestClass4() { Label = "Label-2", Enabled = true, Number = 42, Currency = 1.234m, }, }; using (MemoryStream stream = new MemoryStream(settings.Encoding.GetBytes(content))) { List <TestClass4> actual = CsvImporter <TestClass4> .Load(stream, settings).ToList(); Assert.AreEqual(expected, actual); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new MvcTitleContext( serviceProvider.GetRequiredService < DbContextOptions <MvcTitleContext> >())) { if (context.User.Any()) { return; } var user = new User { Name = "Ryan", Email = "*****@*****.**" }; context.User.Add(user); context.SaveChanges(); if (context.Title.Any()) { return; } var csvImporter = new CsvImporter(); csvImporter.ImportTitles(context); } }
public void TestRemoveTrailingWhitespace() { var s = " hello "; var sb = new StringBuilder(s); CsvImporter.RemoveTrailingWhitespace(sb); Assert.AreEqual(" hello", sb.ToString(), "Simple Removal"); s = "hello"; sb = new StringBuilder(s); CsvImporter.RemoveTrailingWhitespace(sb); Assert.AreEqual("hello", sb.ToString(), "Removal of nothing"); sb = new StringBuilder(" "); CsvImporter.RemoveTrailingWhitespace(sb); Assert.AreEqual("", sb.ToString(), "Results in empty string"); try { CsvImporter.RemoveTrailingWhitespace(null); } catch (ArgumentNullException) { return; } Assert.Fail("Expected ArgumentNullException from RemoveTrailingWhitespace"); }
public void ParseStringSimpleTest() { var sb = new StringBuilder(" hello "); var en = CsvImporter.ParseString(sb, ",", true).GetEnumerator(); Assert.AreEqual(true, en.MoveNext(), "First Token"); Assert.AreEqual("hello", en.Current, "Token Value"); Assert.AreEqual(false, en.MoveNext(), "No more Tokens"); sb = new StringBuilder(" Bob, \"Billy Bob\""); en = CsvImporter.ParseString(sb, ",", true).GetEnumerator(); // remove quotes Assert.AreEqual(true, en.MoveNext(), "First Token"); Assert.AreEqual("Bob", en.Current, "Token 1 Value"); Assert.AreEqual(true, en.MoveNext(), "Second Token"); Assert.AreEqual("Billy Bob", en.Current, "Token 2 Value"); Assert.AreEqual(false, en.MoveNext(), "No more Tokens"); en = CsvImporter.ParseString(sb, ",", false).GetEnumerator(); // don't remove quotes Assert.AreEqual(true, en.MoveNext(), "First Token"); Assert.AreEqual("Bob", en.Current, "Token 1 Value"); Assert.AreEqual(true, en.MoveNext(), "Second Token"); Assert.AreEqual("\"Billy Bob\"", en.Current, "Token 2 Value"); Assert.AreEqual(false, en.MoveNext(), "No more Tokens"); Assert.AreEqual(false, en.MoveNext(), "No more Tokens #2"); }
public void Execute(object parameter) { IDataImporter dataImporter = new CsvImporter(); Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.FileName = "Document"; dlg.DefaultExt = ".txt"; dlg.Filter = "CSV documents (.csv)|*.csv|Text documents (.txt)|*.txt|All Files (*.*)|*.*"; Nullable <bool> result = dlg.ShowDialog(); if (result == true) { DataTable d; try { d = dataImporter.Import(dlg.FileName); _ivm.FeedData(d, true); } catch { _ivm.FeedData(null, false); } } else { _ivm.FeedData(null, false); } }
public void EmptyObjectTest() { var x = new CsvImporter(); Assert.IsNull(x.GetColumnNames(), "Column Names"); Assert.IsNull(x.GetData(), "Get Data"); }
public void AliasTest1() { var sb = new StringBuilder("Given Name, Family Name, Age, Height").AppendLine(); sb.Append("Homer, \"Simpson\" , 41, 5.6").AppendLine(); sb.Append("\"Lisa Anne\", Simpson, 7, 3.9").AppendLine(); var aliases = new Dictionary <string, string> { ["Given Name"] = "FirstName", ["Family Name"] = "LastName" }; var csv = new CsvImporter { ColumnNameSpaceReplacement = " " }; csv.ImportString(sb.ToString()); Assert.AreEqual(2, csv.GetData().Count, "Should be 2 lines of data"); var list = csv.GetData <CTestPerson>(aliases).ToList(); Assert.AreEqual(2, list.Count, "List count should also be 2"); list[0].TestPerson("Homer", "Simpson", 41, 5.6); list[1].TestPerson("Lisa Anne", "Simpson", 7, 3.9); }
public void UnknownColumnNameTest() { var invalidColumnFound = false; var invalidColumnCount = 0; var sb = new StringBuilder("FirstName, Last_Name, Age, Height").AppendLine(); sb.Append("Homer, \"Simpson\" , 41, 5.6").AppendLine(); sb.Append("\"Lisa Anne\", Simpson, 7, 3.9").AppendLine(); sb.Append(" "); var csv = new CsvImporter { ColumnNameSpaceReplacement = null }; csv.OnUnusableColumn += _colname => { invalidColumnCount++; if (_colname == "Last_Name") { invalidColumnFound = true; } }; csv.ImportString(sb.ToString()); csv.GetData <CTestPerson>().ToList(); Assert.AreEqual(1, invalidColumnCount, "Invalid column count wrong"); Assert.IsTrue(invalidColumnFound, "Didn't find the invalid column"); }
private void SyncByCompany(string url, Company company, IList <Price> prices) { var data = CsvImporter.GetCsv(url); data.RemoveAt(0); if (!data.Any()) { Logger.Warn($"No data available for company {company.Code}"); } using (var priceRepository = _priceRepositoryFactory.CreateInstance()) { var inserted = false; // ReSharper disable once LoopCanBePartlyConvertedToQuery foreach (var row in data) { var currentDate = DateTime.Parse(row[0]); // ReSharper disable once InvertIf if (!prices.Any(item => item.CompanyId == company.Id && item.Date == currentDate)) { priceRepository.Insert(PriceConverter.Convert(row, company)); inserted = true; } } if (inserted) { priceRepository.Save(); } } }
public void BlankLinesTest() { var sb = new StringBuilder("FirstName, Last Name, Age, Height").AppendLine(); sb.AppendLine(); sb.Append("Homer, \"Simpson\" , 41, 5.6").AppendLine(); sb.Append(" ").AppendLine(); sb.AppendLine(); sb.Append("\"Lisa Anne\", Simpson, 7, 3.9").AppendLine(); sb.Append(" ").AppendLine(); sb.Append(" ").AppendLine(); sb.AppendLine(); sb.Append(" ").AppendLine(); sb.AppendLine(); sb.Append(" "); var csv = new CsvImporter { ColumnNameSpaceReplacement = null }; csv.ImportString(sb.ToString()); Assert.AreEqual(2, csv.GetData().Count, "Should be 2 lines of data"); var list = csv.GetData <CTestPerson>().ToList(); Assert.AreEqual(2, list.Count, "List count should also be 2"); list[0].TestPerson("Homer", "Simpson", 41, 5.6); list[1].TestPerson("Lisa Anne", "Simpson", 7, 3.9); }
private void Button_ImportCSV_Click(object sender, RoutedEventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); //openFileDialog.Filter = "ImageCSV (*.csv;)"; if (openFileDialog.ShowDialog() == true) { CsvImporter csvIMporter = new CsvImporter(); Dictionary <string, List <string> > import = csvIMporter.ReadCsv(openFileDialog.FileName); string tableName = Path.GetFileNameWithoutExtension(openFileDialog.FileName); var columns = new List <string>(); foreach (string column in import.Keys) { columns.Add(column); } databaseController.CreateEmptyTable(tableName, columns); ReloadTableNames(); TableNamesComboBox.SelectedIndex = TableNamesComboBox.Items.IndexOf(tableName); databaseController.AddEntries(SelectedTableName, import); DisplayTable(uiDataGrid, databaseController.ImportedDatabaseModel.GetTable(SelectedTableName)); } }
private void btnNewCsv_Click(object sender, RoutedEventArgs e) { var myDoc = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); var fileName = "GameStats_" + DateTime.Now.ToString() .Replace("\\", "_") .Replace("/", "_") .Replace(" ", "_") .Replace(":", "_"); var path = System.IO.Path.Combine(myDoc, fileName); path = System.IO.Path.ChangeExtension(path, ".csv"); try { CsvImporter.CreateTemplate(path); this.CsvPath = path; System.Diagnostics.Process.Start(path); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public override async Task ImportZakupyFromCsv(string fullFilePath) { await Task.Run(() => { var collection = CsvImporter.GetCollectionFromCsv <EwidencjaZakupWiersz>(fullFilePath); Jpk.Ewidencja.ZakupWiersze = new ObservableCollection <EwidencjaZakupWiersz>(collection); }); }
public async Task ImportZakupyFromCsv(string fullFilePath) { await Task.Run(() => { var collection = CsvImporter.GetCollectionFromCsv <ZakupWiersz>(fullFilePath); Jpk.ZakupWiersz = new ObservableCollection <ZakupWiersz>(collection); }); }
public async Task ImportMmWartoscFromCsv(string fullFilePath) { await Task.Run(() => { var collection = CsvImporter.GetCollectionFromCsv <MmWartosc>(fullFilePath); Jpk.Mm.MmWartosc = new ObservableCollection <MmWartosc>(collection); }); }
public async Task ImportFakturaRrWierszFromCsv(string fullFilePath) { await Task.Run(() => { var collection = CsvImporter.GetCollectionFromCsv <FakturaRrWiersz>(fullFilePath); Jpk.FakturaRrWiersz = new ObservableCollection <FakturaRrWiersz>(collection); }); }
public void Load_SettingsAreNull_ThrowsArgumentNullException() { using (Stream stream = new MemoryStream()) { CsvSettings settings = null; Assert.Throws <ArgumentNullException>(() => { CsvImporter <TestClassBase> .Load(stream, settings); }); } }
public async Task ImportDziennikFromCsv(string fullFilePath) { await Task.Run(() => { var collection = CsvImporter.GetCollectionFromCsv <Dziennik>(fullFilePath); Jpk.Dziennik = new ObservableCollection <Dziennik>(collection); }); }
public async Task ImportWyciagFromCsv(string fullFilePath) { await Task.Run(() => { var collection = CsvImporter.GetCollectionFromCsv <WyciagWiersz>(fullFilePath); Jpk.WyciagWiersze = new ObservableCollection <WyciagWiersz>(collection); }); }
public async Task ImportSpisFromCsv(string fullFilePath) { await Task.Run(() => { var collection = CsvImporter.GetCollectionFromCsv <PkpirSpis>(fullFilePath); Jpk.PkpirSpis = new ObservableCollection <PkpirSpis>(collection); }); }
public async Task <IActionResult> ImportSubjects(IFormFile postedFile) { CsvImporter <SubjectType> importer = new CsvImporter <SubjectType>(); int inserted = await ImportRecords(postedFile, importer); TempData["message"] = inserted + " subjects were inserted"; return(RedirectToAction("Index")); }
public async Task ImportOswiadczenieFromCsv(string fullFilePath) { await Task.Run(() => { var collection = CsvImporter.GetCollectionFromCsv <Oswiadczenie>(fullFilePath); Jpk.Oswiadczenie = new ObservableCollection <Oswiadczenie>(collection); }); }
public ShellViewModel(BarcodeManagerViewModel barcodeManager, BarcodePrinter barcodePrinter, CsvImporter csvImporter) { BarcodeManager = barcodeManager; BarcodePrinter = barcodePrinter; CsvImporter = csvImporter; barcodeManager.ConductWith(this); DisplayName = "Capidema Barcodes"; }