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());
}
private static XLWorkbook GetTemplateXlWorkbook()
{
var xlWorkbook = new XLWorkbook();
IXLWorksheet ws = xlWorkbook.Worksheets.Add("Import");
var localizationService = new StubLocalizationService();
ws.Cell(1, 1).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, string>(s => s.Strassenname);
ws.Cell(1, 2).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, string>(s => s.BezeichnungVon);
ws.Cell(1, 3).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, string>(s => s.BezeichnungBis);
ws.Cell(1, 4).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, string>(s => s.ExternalId);
ws.Cell(1, 5).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, int?>(s => s.Abschnittsnummer);
ws.Cell(1, 6).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, EigentuemerTyp>(s => s.Strasseneigentuemer);
ws.Cell(1, 7).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, string>(s => s.Ortsbezeichnung);
ws.Cell(1, 8).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, string>(s => s.BelastungskategorieTyp);
ws.Cell(1, 9).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, BelagsTyp>(s => s.Belag);
ws.Cell(1, 10).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, decimal?>(s => s.BreiteFahrbahn);
ws.Cell(1, 11).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, decimal?>(s => s.Laenge);
ws.Cell(1, 12).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, TrottoirTyp>(s => s.Trottoir);
ws.Cell(1, 13).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, decimal?>(s => s.BreiteTrottoirLinks);
ws.Cell(1, 14).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, decimal?>(s => s.BreiteTrottoirRechts);
return(xlWorkbook);
}
private static XLWorkbook GetTemplateXlWorkbook()
{
var xlWorkbook = new XLWorkbook();
IXLWorksheet ws = xlWorkbook.Worksheets.Add("Import");
var localizationService = new StubLocalizationService();
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.BreiteTrottoirLinks);
ws.Cell(1, ++i).Value = localizationService.GetLocalizedModelPropertyText <StrassenabschnittImportModel, object>(s => s.BreiteTrottoirRechts);
return(xlWorkbook);
}
