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