public void TestImportCSV2() { TVerificationResultCollection VerificationResult = null; string doc = String.Empty; using (StreamReader sr = new StreamReader("../../demodata/partners/samplefilepartnerimport2.csv")) { doc = sr.ReadToEnd(); } PartnerImportExportTDS MainDS = TImportExportWebConnector.ImportFromCSVFileReturnDataSet(doc, "dMy", ",", out VerificationResult); if (VerificationResult != null) { Assert.IsFalse(VerificationResult.HasCriticalErrors, "there was an error importing the csv file"); } foreach (PFamilyRow f in MainDS.PFamily.Rows) { Console.WriteLine("Family name : " + f.FamilyName); } // we are currently ignoring UNIT and ORGANISATION partners, only importing the 7 FAMILY partners. // due to the strange format of the file, each row is imported as a separate partner, ending up with 27 invalid partners Assert.AreEqual(7, MainDS.PPartner.Rows.Count); }
public void TestImportCSVUnknownColumn() { TVerificationResultCollection VerificationResult = null; string doc = String.Empty; using (StreamReader sr = new StreamReader("../../csharp/ICT/Testing/lib/MPartner/SampleData/samplePartnerImport_unknown_column.csv")) { doc = sr.ReadToEnd(); } TImportExportWebConnector.ImportFromCSVFileReturnDataSet(doc, "DMY", ";", out VerificationResult); Assert.IsNotNull(VerificationResult, "Expected to get errors"); Assert.AreEqual(1, VerificationResult.Count, "there should be one error"); Assert.AreEqual("Unknown Column(s): Test2", VerificationResult[0].ResultText, "VerificationResult message"); }
public void TestImportCSV_Dates_MDY() { TVerificationResultCollection VerificationResult = null; string doc = String.Empty; using (StreamReader sr = new StreamReader("../../csharp/ICT/Testing/lib/MPartner/SampleData/samplePartnerImport_dates_mdy.csv")) { doc = sr.ReadToEnd(); } PartnerImportExportTDS MainDS = TImportExportWebConnector.ImportFromCSVFileReturnDataSet(doc, "mdy", ";", out VerificationResult); if (VerificationResult != null) { if (VerificationResult.HasCriticalErrors) { Assert.AreEqual(String.Empty, VerificationResult.BuildVerificationResultString(), "there was an error importing the csv file"); } } // there should be 2 partners imported (2 x family) Assert.AreEqual(2, MainDS.PPartner.Rows.Count); Assert.AreEqual(2, MainDS.PFamily.Rows.Count); Assert.AreEqual(new DateTime(1979, 8, 19), MainDS.PFamily[0].DateOfBirth, "date of birth is wrong!"); // Now try with the wrong date format VerificationResult = null; MainDS = TImportExportWebConnector.ImportFromCSVFileReturnDataSet(doc, "dmy", ";", out VerificationResult); Assert.IsNotNull(VerificationResult, "Expected to get errors"); int numErrors = 0; for (int i = 0; i < VerificationResult.Count; i++) { if (VerificationResult[i].ResultSeverity != TResultSeverity.Resv_Status) { numErrors++; } } Assert.AreEqual(2, numErrors, "Wrong number of errors"); }
public void TestImportCSVWithoutName() { TVerificationResultCollection VerificationResult = null; string doc = String.Empty; using (StreamReader sr = new StreamReader("../../csharp/ICT/Testing/lib/MPartner/SampleData/samplePartnerImport_invalid.csv")) { doc = sr.ReadToEnd(); } TImportExportWebConnector.ImportFromCSVFileReturnDataSet(doc, "DMY", ";", out VerificationResult); Assert.IsNotNull(VerificationResult, "Expected to get errors"); Assert.AreEqual(2, VerificationResult.Count, "there should be two errors"); Assert.AreEqual("Missing Firstname or family name in line 2", VerificationResult[0].ResultText, "VerificationResult message"); Assert.AreEqual("We need either a valid address, phone number, email address or IBAN in line 4", VerificationResult[1].ResultText, "VerificationResult message"); }
public void TestImportCSV_Dates_MDY() { TVerificationResultCollection VerificationResult = null; string doc = String.Empty; using (StreamReader sr = new StreamReader("../../demodata/partners/samplePartnerImport_dates_mdy.csv")) { doc = sr.ReadToEnd(); } PartnerImportExportTDS MainDS = TImportExportWebConnector.ImportFromCSVFileReturnDataSet(doc, "mdy", ";", out VerificationResult); if (VerificationResult != null) { Assert.IsFalse(VerificationResult.HasCriticalErrors, "there was an error importing the csv file"); } // there should be 4 partners imported (2 x family + 2 x person) Assert.AreEqual(4, MainDS.PPartner.Rows.Count); Assert.AreEqual(2, MainDS.PmPassportDetails.Rows.Count); Assert.AreEqual(((PmPassportDetailsRow)MainDS.PmPassportDetails.Rows[0]).DateOfIssue, new DateTime(2016, 5, 22), "passport date of issue is wrong!"); // Now try with the wrong date format VerificationResult = null; MainDS = TImportExportWebConnector.ImportFromCSVFileReturnDataSet(doc, "dmy", ";", out VerificationResult); Assert.IsNotNull(VerificationResult, "Expected to get errors"); int numErrors = 0; for (int i = 0; i < VerificationResult.Count; i++) { if (VerificationResult[i].ResultSeverity != TResultSeverity.Resv_Status) { numErrors++; } } Assert.AreEqual(5, numErrors, "Wrong number of errors"); }
public void TestImportCSV() { TVerificationResultCollection VerificationResult = null; string doc = String.Empty; using (StreamReader sr = new StreamReader("../../demodata/partners/samplePartnerImport.csv")) { doc = sr.ReadToEnd(); } PartnerImportExportTDS MainDS = TImportExportWebConnector.ImportFromCSVFileReturnDataSet(doc, "DMY", ";", out VerificationResult); if (VerificationResult != null) { Assert.IsFalse(VerificationResult.HasCriticalErrors, "there was an error importing the csv file"); } // there should be 2 partners imported Assert.AreEqual(2, MainDS.PPartner.Rows.Count); }