//------------------------------------------------------------------------
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";
}
