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); } }