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