public void UpdatePoints2()
{
// Setup Data Model & Co
string dbFilename = TestUtilities.CreateWorkingFileFrom(testContextInstance.TestDeploymentDir, @"1554MSBS.mdb");
Database db = new Database();
db.Connect(dbFilename);
AppDataModel model = new AppDataModel(db);
Race race = model.GetRace(0);
// Import DSV Point List
DSVImportReader dsvImportReader = new DSVImportReader(new DSVImportReaderZip(@"Punktelisten.zip", DSVImportReaderZipBase.EDSVListType.Pupils_U14U16));
// Check two prior
Assert.AreEqual(148.86, race.GetParticipants().First(r => r.SvId == "24438").Points);
Assert.AreEqual(129.12, race.GetParticipants().First(r => r.SvId == "25399").Points);
var impRes = DSVUpdatePoints.UpdatePoints(model, dsvImportReader.Data, dsvImportReader.Mapping, dsvImportReader.UsedDSVList);
Assert.AreEqual(1, impRes.Count);
Assert.AreEqual(125, impRes[0].SuccessCount);
Assert.AreEqual(2, impRes[0].ErrorCount);
Assert.AreEqual(110.96, race.GetParticipants().First(r => r.SvId == "24438").Points);
Assert.AreEqual(100.33, race.GetParticipants().First(r => r.SvId == "25399").Points);
Assert.AreEqual("DSVSA20END", model.GetDB().GetKeyValue("DSV_UsedDSVList"));
}
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"]);
}
}
public void ImportPointListViaZIP()
{
IDSVImportReaderFile fileReader = new DSVImportReaderZip(@"Punktelisten.zip", DSVImportReaderZipBase.EDSVListType.Pupils_U14U16);
DSVImportReader reader = new DSVImportReader(fileReader);
Assert.AreEqual("DSVSA20END", reader.UsedDSVList);
Assert.AreEqual(new DateTime(2020, 4, 15), 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(211.61, row["Points"]);
Assert.AreEqual("M", row["Sex"]);
}
{
DataRow row = reader.Data.Tables[0].Rows[reader.Data.Tables[0].Rows.Count - 1];
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(207.98, row["Points"]);
Assert.AreEqual("W", row["Sex"]);
}
}
public void ImportPointListViaWeb_U18()
{
IDSVImportReaderFile fileReader = new DSVImportReaderOnline(DSVImportReaderZipBase.EDSVListType.Youth_U18AndOlder);
DSVImportReader reader = new DSVImportReader(fileReader);
Assert.IsTrue(reader.UsedDSVList.StartsWith("DSVA"));
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]);
Assert.IsTrue(reader.Data.Tables[0].Rows.Count > 0, "Some rows generated");
}
public void DSVInterfaceModel_Test1()
{
// Setup Data Model & Co
string dbFilename = TestUtilities.CreateWorkingFileFrom(testContextInstance.TestDeploymentDir, @"1554MSBS.mdb");
Database db = new Database();
db.Connect(dbFilename);
AppDataModel dm = new AppDataModel(db);
{
// Initially, there aren't any data available
DSVInterfaceModel dsvIF = new DSVInterfaceModel(dm);
Assert.IsNull(dsvIF.Data, "Is null initially");
Assert.IsNull(dsvIF.Date, "Is null initially");
var reader = new DSVImportReader(new DSVImportReaderZip("Punktelisten.zip", DSVImportReaderZipBase.EDSVListType.Pupils_U14U16));
dsvIF.UpdateDSVList(new DSVImportReaderZip("Punktelisten.zip", DSVImportReaderZipBase.EDSVListType.Pupils_U14U16));
Assert.AreEqual(reader.Data.Tables[0].Rows.Count, dsvIF.Data.Tables[0].Rows.Count);
Assert.AreEqual(reader.Date, dsvIF.Date);
Assert.AreEqual(reader.UsedDSVList, dsvIF.UsedDSVList);
}
}
