public void TestValidateDublicateNameInDb() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="DoubleName", LastName="DoubleName", Age="20", Sex = "Male"}, }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo>(); List<InvalidRecord> expectedInvalid = new List<InvalidRecord> { new InvalidRecord{FirstName="DoubleName", LastName="DoubleName", Age="20", Sex = "Male", Comment="1) Dublicate name: [DoubleName DoubleName]. "} }; ExcelDocumentImportResult expextedResult = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalid }; ExcelDocumentImportResult actualResult = stService.GetRecords(records, "en-us"); Assert.AreEqual(expextedResult, actualResult); }
public void TestValidateWrongSexAndInvalidCharsUk() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="John", LastName="Conn", Age="20", Sex = "MALe"}, new RawStudentInfo{FirstName="Sarah", LastName="Libouee", Age="25", Sex = "Famale"}, new RawStudentInfo{FirstName="Lucia", LastName="Fabi0", Age="22", Sex = "Female"} }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo> { new RawStudentInfo{FirstName="John", LastName="Conn", Age="20", Sex = "Male"} }; List<InvalidRecord> expectedInvalid = new List<InvalidRecord> { new InvalidRecord{FirstName="Sarah", LastName="Libouee", Age="25", Sex = "Famale", Comment="1) Неправильний формат статі. "}, new InvalidRecord{FirstName="Lucia", LastName="Fabi0", Age="22", Sex = "Female", Comment = "1) Прізвище містить недозволені символи. "} }; ExcelDocumentImportResult expextedResult = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalid }; ExcelDocumentImportResult actualResult = stService.GetRecords(records, "uk-ua"); Assert.AreEqual(expextedResult, actualResult); }
public void TestValidateWrongFormatOfAgeUk() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="John", LastName="Conn", Age="Twenty", Sex = "MALe"}, }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo>(); List<InvalidRecord> expectedInvalid = new List<InvalidRecord> { new InvalidRecord{FirstName="John", LastName="Conn", Age="Twenty", Sex = "MALe", Comment="1) Неправильний формат віку. "} }; ExcelDocumentImportResult expextedResult = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalid }; ExcelDocumentImportResult actualResult = stService.GetRecords(records, "uk-ua"); Assert.AreEqual(expextedResult, actualResult); }
public void TestValidateWrongSexAndInvalidChars() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="John", LastName="Conn", Age="20", Sex = "MALe"}, new RawStudentInfo{FirstName="Sarah", LastName="Libouee", Age="25", Sex = "Famale"}, new RawStudentInfo{FirstName="Lucia", LastName="Fabi0", Age="22", Sex = "Female"} }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo> { new RawStudentInfo{FirstName="John", LastName="Conn", Age="20", Sex = "Male"} }; List<InvalidRecord> expectedInvalid = new List<InvalidRecord> { new InvalidRecord{FirstName="Sarah", LastName="Libouee", Age="25", Sex = "Famale", Comment="1) Sex is not in valid format. "}, new InvalidRecord{FirstName="Lucia", LastName="Fabi0", Age="22", Sex = "Female", Comment = "1) Last name contains restricted symbols. "} }; ExcelDocumentImportResult expextedResult = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalid }; ExcelDocumentImportResult actualResult = stService.GetRecords(records, "en-us"); Assert.AreEqual(expextedResult, actualResult); }
public void TestValidateInvalidCharsUk() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="Sarah9", LastName="Libouee)(", Age="25", Sex = "Female"}, new RawStudentInfo{FirstName="Lucia", LastName="Fabi", Age="22", Sex = "Female"} }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo> { new RawStudentInfo{FirstName="Lucia", LastName="Fabi", Age="22", Sex = "Female"} }; List<InvalidRecord> expectedInvalid = new List<InvalidRecord> { new InvalidRecord{FirstName="Sarah9", LastName="Libouee)(", Age="25", Sex = "Female", Comment = "1) Ім'я містить недозволені символи. 2) Прізвище містить недозволені символи. " } }; ExcelDocumentImportResult expextedResult = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalid }; ExcelDocumentImportResult actualResult = stService.GetRecords(records, "uk-ua"); Assert.AreEqual(expextedResult, actualResult); }
public void TestValidateHaveOneWithEmptyFirstNameUk() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="", LastName="Conn", Age="20", Sex = "Male"}, new RawStudentInfo{FirstName="Sarah", LastName="Libouee", Age="25", Sex = "Female"}, new RawStudentInfo{FirstName="Lucia", LastName="Fabi", Age="22", Sex = "Female"} }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo> { new RawStudentInfo{FirstName="Sarah", LastName="Libouee", Age="25", Sex = "Female"}, new RawStudentInfo{FirstName="Lucia", LastName="Fabi", Age="22", Sex = "Female"} }; List<InvalidRecord> expectedInvalidUk = new List<InvalidRecord> { new InvalidRecord{FirstName="", LastName="Conn", Age="20", Sex = "Male", Comment="1) Ім'я порожнє. "} }; ExcelDocumentImportResult expextedResultUk = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalidUk }; ExcelDocumentImportResult actualResultUk = stService.GetRecords(records, "uk-ua"); Assert.AreEqual(expextedResultUk, actualResultUk); }
public void TestValidateFormatName() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="PaUl", LastName="FRAnkliN", Age="19", Sex = "Male"}, }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo> { new RawStudentInfo{FirstName="Paul", LastName="Franklin", Age="19", Sex="Male"} }; List<InvalidRecord> expectedInvalid = new List<InvalidRecord>(); ExcelDocumentImportResult expextedResult = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalid }; ExcelDocumentImportResult actualResult = stService.GetRecords(records, "en-us"); Assert.AreEqual(expextedResult, actualResult); }
public void TestValidateEmptyNamesUk() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="", LastName="", Age="20", Sex = "Male"}, new RawStudentInfo{FirstName="Lucia", LastName="Fabi", Age="22", Sex = "Female"} }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo> { new RawStudentInfo{FirstName="Lucia", LastName="Fabi", Age="22", Sex = "Female"} }; List<InvalidRecord> expectedInvalid = new List<InvalidRecord> { new InvalidRecord{FirstName="", LastName="", Age="20", Sex = "Male", Comment = "1) Ім'я порожнє. 2) Прізвище порожнє. " } }; ExcelDocumentImportResult expextedResult = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalid }; ExcelDocumentImportResult actualResult = stService.GetRecords(records, "uk-ua"); Assert.AreEqual(expextedResult, actualResult); }
public void TestValidateDublicateNameInDocUk() { List<RawStudentInfo> records = new List<RawStudentInfo> { new RawStudentInfo{FirstName="John", LastName="Conn", Age="18", Sex = "Male"}, new RawStudentInfo{FirstName="John", LastName="Conn", Age="25", Sex = "Male"} }; List<RawStudentInfo> expectedValid = new List<RawStudentInfo> { new RawStudentInfo{FirstName="John", LastName="Conn", Age="18", Sex = "Male"} }; List<InvalidRecord> expectedInvalid = new List<InvalidRecord> { new InvalidRecord{FirstName="John", LastName="Conn", Age="25", Sex = "Male", Comment="1) Повтор імені: [John Conn]. "} }; ExcelDocumentImportResult expextedResult = new ExcelDocumentImportResult { ValidRecords = expectedValid, InvalidRecords = expectedInvalid }; ExcelDocumentImportResult actualResult = stService.GetRecords(records, "uk-ua"); Assert.AreEqual(expextedResult, actualResult); }