public void TestIncorrectHeaderOrder()
{
ILocalizationService localizationService = new StubLocalizationService();
var strassenabschnittXlsxImportService = GetStrassenabschnittXlsxImportService(localizationService);
Stream memoryStream = new MemoryStream();
var xlWorkbook = new XLWorkbook();
IXLWorksheet ws = xlWorkbook.Worksheets.Add("Import");
var i = 0;
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.Strassenname);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.BezeichnungVon);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.BezeichnungBis);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.ExternalId);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.Abschnittsnummer);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.Strasseneigentuemer);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.Ortsbezeichnung);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.BelastungskategorieTyp);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.Belag);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.BreiteFahrbahn);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.Laenge);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.Trottoir);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.BreiteTrottoirRechts);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.BreiteTrottoirLinks);
xlWorkbook.SaveAs(memoryStream);
Stream xlsxTemplateStream = memoryStream;
var importResultModel = strassenabschnittXlsxImportService.ImportStrassenabschnitte(xlsxTemplateStream);
Assert.AreEqual(1, importResultModel.Errors.Count);
Assert.AreEqual(string.Format(localizationService.GetLocalizedError(ValidationError.IncorrectHeaderText), 12), importResultModel.Errors.First());
}
public void TestEmptyStream()
{
ILocalizationService localizationService = new StubLocalizationService();
var strassenabschnittXlsxImportService = GetStrassenabschnittXlsxImportService(localizationService);
var importResultModel = strassenabschnittXlsxImportService.ImportStrassenabschnitte(new MemoryStream());
Assert.AreEqual(1, importResultModel.Errors.Count);
Assert.AreEqual(localizationService.GetLocalizedError(ValidationError.WrongFileFormat), importResultModel.Errors.First());
}
public void TestXlsxWhitMissingSheet()
{
ILocalizationService localizationService = new StubLocalizationService();
var strassenabschnittXlsxImportService = GetStrassenabschnittXlsxImportService(localizationService);
Stream memoryStream = new MemoryStream();
var xlWorkbook = new XLWorkbook();
xlWorkbook.SaveAs(memoryStream);
var importResultModel = strassenabschnittXlsxImportService.ImportStrassenabschnitte(memoryStream);
Assert.AreEqual(1, importResultModel.Errors.Count);
Assert.AreEqual(localizationService.GetLocalizedError(ValidationError.WrongFileFormat), importResultModel.Errors.First());
}
