private void btnDSVImportFile_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == true)
{
string path = openFileDialog.FileName;
IDSVImportReaderFile dsvImportReader;
if (System.IO.Path.GetExtension(path).ToLowerInvariant() == ".zip")
{
dsvImportReader = new DSVImportReaderZip(path, DSVImportReaderZipBase.EDSVListType.Pupils_U14U16);
}
else
{
dsvImportReader = new DSVImportReaderFile(path);
}
try
{
_dsvData.UpdateDSVList(dsvImportReader);
}
catch (Exception exc)
{
MessageBox.Show("Die DSV Liste konnte nicht importiert werden.\n\nFehlermeldung: " + exc.Message, "Fehler", MessageBoxButton.OK, MessageBoxImage.Error);
}
updateDSVGrid();
}
}
public void ImportPointList()
{
IDSVImportReaderFile fileReader = new DSVImportReaderFile(@"DSVSA2008.txt");
DSVImportReader reader = new DSVImportReader(fileReader);
Assert.AreEqual("DSVSA2008", reader.UsedDSVList);
Assert.AreEqual(new DateTime(2020, 2, 23), reader.Date);
Assert.IsNotNull(reader.Mapping);
Assert.AreEqual("SvId", reader.Columns[0]);
Assert.AreEqual("Name", reader.Columns[1]);
Assert.AreEqual("Firstname", reader.Columns[2]);
Assert.AreEqual("Year", reader.Columns[3]);
Assert.AreEqual("Club", reader.Columns[4]);
Assert.AreEqual("Verband", reader.Columns[5]);
Assert.AreEqual("Points", reader.Columns[6]);
Assert.AreEqual("Sex", reader.Columns[7]);
{
DataRow row = reader.Data.Tables[0].Rows[0];
Assert.AreEqual("22444", row["SvId"]);
Assert.AreEqual("ABBOLD", row["Name"]);
Assert.AreEqual("Markus", row["Firstname"]);
Assert.AreEqual(2004U, row["Year"]);
Assert.AreEqual("SC Garmisch", row["Club"]);
Assert.AreEqual("BSV-WF", row["Verband"]);
Assert.AreEqual(181.61, row["Points"]);
Assert.AreEqual("M", row["Sex"]);
}
{
DataRow row = reader.Data.Tables[0].Rows[1881];
Assert.AreEqual("26134", row["SvId"]);
Assert.AreEqual("OETSCHMANN", row["Name"]);
Assert.AreEqual("Sophie", row["Firstname"]);
Assert.AreEqual(2005U, row["Year"]);
Assert.AreEqual("DAV Peissenberg", row["Club"]);
Assert.AreEqual("BSV-WF", row["Verband"]);
Assert.AreEqual(177.98, row["Points"]);
Assert.AreEqual("W", row["Sex"]);
}
}
