public void WennIchNachFilterkriteriumBahnSuche(string strassennameFilter)
{
var strassenabschnittGridCommand = new StrassenabschnittGridCommand {
StrassennameFilter = strassennameFilter
};
BrowserDriver.InvokePostAction <NetzdefinitionUndStrassenabschnittController, StrassenabschnittGridCommand>((c, r) => c.GetAll(dataSourceRequest, r), strassenabschnittGridCommand);
}
public FileStreamResult DownloadExcelReport(StrassenabschnittGridCommand command)
{
var data = strassenabschnittService.GetAllStrassenabschnittImportModels(command.StrassennameFilter);
var doc = new XlsxDoc(14);
for (var j = 1; j < (data.Count + 2); j++)
{
var i = 0;
if (j == 1)
{
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.Strassenname;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.BezeichnungVon;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.BezeichnungBis;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.StrassenabschnittImportModel_ExternalId;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.StrassenabschnittImportModel_Abschnittsnummer;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.Strasseneigentuemer;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.Ortsbezeichnung;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.Belastungskategorie;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.Belag;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.BreiteFahrbahn;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.Laenge;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.Trottoir;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.BreiteTrottoirLinks;
doc.worksheet.Row(j).Cell(++i).Value = ModelLocalization.BreiteTrottoirRechts;
}
else
{
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].Strassenname;
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].BezeichnungVon;
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].BezeichnungBis;
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].ExternalId;
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].Abschnittsnummer;
doc.worksheet.Row(j).Cell(++i).Value = localizationService.GetLocalizedEnum(data[j - 2].Strasseneigentuemer);
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].Ortsbezeichnung;
doc.worksheet.Row(j).Cell(++i).Value = localizationService.GetLocalizedBelastungskategorieTyp(data[j - 2].BelastungskategorieTyp);
doc.worksheet.Row(j).Cell(++i).Value = localizationService.GetLocalizedEnum(data[j - 2].Belag);
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].BreiteFahrbahn;
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].Laenge;
doc.worksheet.Row(j).Cell(++i).Value = localizationService.GetLocalizedEnum(data[j - 2].Trottoir);
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].BreiteTrottoirLinks;
doc.worksheet.Row(j).Cell(++i).Value = data[j - 2].BreiteTrottoirRechts;
}
}
var fileSteam = doc.Save();
fileSteam.Seek(0, SeekOrigin.Begin);
var file = File(fileSteam, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
file.FileDownloadName = TextLocalization.Strassenabschnitte + ".xlsx";
return(file);
}
private SerializableDataSourceResult GetGridModel([DataSourceRequest] DataSourceRequest request, StrassenabschnittGridCommand command)
{
PrepareBelastungskategorien();
var strassenabschnittModels = strassenabschnittService.GetCurrentModelsByStrassenname(command.StrassennameFilter, command.Ortsbezeichnung);
return(new SerializableDataSourceResult(strassenabschnittModels.OrderBy(m => m.Strassenname).ThenBy(m => m.Abschnittsnummer).ToDataSourceResult(request)));
}
public ActionResult GetAll([DataSourceRequest] DataSourceRequest dataSourceRequest, StrassenabschnittGridCommand command)
{
return(Json(GetGridModel(dataSourceRequest, command)));
}
