public IActionResult County([FromQuery] int id)
{
ViewBag.ContextViewModel = _contextViewModelHelper.Create(_contextViewModelHelper.Id2Key(id, true));
ICounty county = _countyService.Get(id);
MapViewModel mapViewModel = new MapViewModel(county);
string sld = _dataQualityClassificationService.GetSld();
Dictionary <string, string> customParameters = new Dictionary <string, string>
{
{
"SLD_BODY", sld
}
};
mapViewModel.AddService(_ServiceType, _url, _Layer, customParameters);
AddAdminUnitsToServices(mapViewModel);
DataQualityClassificationViewModel model = new DataQualityClassificationViewModel
{
Classifications = _dataQualityClassificationService.GetByCounty(id),
AdministrativeUnitName = county.Name,
Type = AdministrativeUnitType.County,
LegendItemStyles = _dataQualityClassificationService.GetLegendItemStyles(),
MetadataUrl = _metadataUrl,
MapViewModel = mapViewModel
};
return(View("Views/FkbData/DataContent/Aspects/DataQualityClassification.cshtml", model));
}
public IActionResult County([FromQuery] int id)
{
ViewBag.ContextViewModel = _contextViewModelHelper.Create(_contextViewModelHelper.Id2Key(id, true));
ICounty county = _countyService.Get(id);
MapViewModel mapViewModel = new MapViewModel(county);
DataQualityDistributionViewModel model = new DataQualityDistributionViewModel(
_dataQualityDistributionService.GetByCounty(id),
_applicationSettings.QualityCategoryColors,
_applicationSettings.DataQualityDataSetToLayerMap)
{
AdministrativeUnitName = county.Name,
Type = AdministrativeUnitType.County,
MetadataUrl = _applicationSettings.ExternalUrls.MetadataDataQualityDistribution,
MapViewModel = mapViewModel
};
return(View("Views/FkbData/DataContent/Aspects/DataQualityDistribution.cshtml", model));
}
public IActionResult County([FromQuery] int id)
{
ViewBag.ContextViewModel = _contextViewModelHelper.Create(_contextViewModelHelper.Id2Key(id, true));
ICounty county = _countyService.Get(id);
MapViewModel mapViewModel = new MapViewModel(county);
List <ITransactionData> transactionData = _transactionDataService.GetByCounty(id);
mapViewModel.AddService(_ServiceType, _url, _Layer);
TransactionDataViewModel model = new TransactionDataViewModel
{
TransactionData = transactionData,
AdministrativeUnitName = county.Name,
LegendItemStyles = _transactionDataService.GetLayerStyles(transactionData),
MapViewModel = mapViewModel,
MetadataUrl = _metadataUrl
};
return(View("Views/FkbData/Management/Aspects/TransactionData/County.cshtml", model));
}
public IActionResult County([FromQuery] int id)
{
string url = $"{_applicationSettings.UrlThematicGeoJson}/{_geoJsonService.GetFileNameCounty(id)}";
ICounty county = _countyService.Get(id);
MapViewModel mapViewModel = new MapViewModel(county);
mapViewModel.AddService(_serviceType, url, _layer);
MunicipalitiesViewModel model = new MunicipalitiesViewModel()
{
Municipalities = _municipalityService.GetByCounty(id),
CountyName = county.Name,
MapViewModel = mapViewModel
};
model.DirectUpdateCount = model.Municipalities.Where(m => m.IntroductionState == IntroductionState.Introduced).Count();
ViewBag.ContextViewModel = _contextViewModelHelper.Create(_contextViewModelHelper.Id2Key(id, true));
return(View("Views/FkbData/Management/Aspects/DirectUpdateInfo/County.cshtml", model));
}
public IActionResult Index([FromQuery] int id, [FromQuery] bool isCounty)
{
XmlTextReader reader = new XmlTextReader(_operationalStatus);
SyndicationFeed feed = SyndicationFeed.Load(reader);
List <AtomFeedEntryViewModel> entries = new List <AtomFeedEntryViewModel>();
foreach (SyndicationItem item in feed.Items ?? Enumerable.Empty <SyndicationItem>())
{
entries.Add(new AtomFeedEntryViewModel()
{
Title = item.Title.Text,
Content = ((TextSyndicationContent)item.Content).Text,
Published = item.PublishDate.DateTime,
Updated = item.LastUpdatedTime.DateTime
});
}
ViewBag.ContextViewModel = _contextViewModelHelper.Create(_contextViewModelHelper.Id2Key(id, isCounty));
return(View("Views/FkbData/Management/OperationalStatus/OperationalStatus.cshtml", entries));
}
public IActionResult Country([FromQuery] int id, [FromQuery] bool isCounty)
{
ViewBag.ContextViewModel = _contextViewModelHelper.Create(_contextViewModelHelper.Id2Key(id, isCounty));
return(View("Views/FkbData/Management/Aspects/ActivityOverview/Activities.cshtml"));
}
public IActionResult County([FromQuery] int id)
{
ICounty county = _countyService.Get(id);
MunicipalitiesViewModel model = new MunicipalitiesViewModel()
{
CountyName = county.Name
};
string idSql = id.ToString();
if (idSql.Length == 1)
{
idSql = "0" + idSql;
}
_dbContext.Database.OpenConnection();
using (var command = _dbContext.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "SELECT COUNT(PlanInfo.Kommune_Kommunenr) AS TotalKommunerCount FROM PlanInfo INNER JOIN Kommune ON PlanInfo.Kommune_Kommunenr = Kommune.Kommunenr INNER JOIN Fylke ON Kommune.Fylke_Fylkesnr = Fylke.Fylkesnr WHERE (Kommune.Aktiv = 1) AND (Fylke.Fylkesnr = @fylkesnr)";
command.Parameters.Add(new SqlParameter("@fylkesnr", id));
using (var result = command.ExecuteReader())
{
if (result.HasRows)
{
result.Read();
model.Count = result.GetInt32(0);
}
}
}
using (var command = _dbContext.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "SELECT COUNT(PlanInfo.Kommune_Kommunenr) AS GeosynchIntroducedCount FROM PlanInfo INNER JOIN Kommune ON PlanInfo.Kommune_Kommunenr = Kommune.Kommunenr INNER JOIN Fylke ON Kommune.Fylke_Fylkesnr = Fylke.Fylkesnr WHERE(PlanInfo.GeosynkInnfort IS NOT NULL) AND (Kommune.Aktiv = 1) AND (Fylke.Fylkesnr = @fylkesnr)";
command.Parameters.Add(new SqlParameter("@fylkesnr", id));
using (var result = command.ExecuteReader())
{
if (result.HasRows)
{
result.Read();
model.CountGeosynch = result.GetInt32(0);
}
}
}
using (var command = _dbContext.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "SELECT DISTINCT FDVProsjekt.Kommune_Kommunenr, Kommune.Kommunenavn, FDVDatasettForvaltningstype.Type FROM FDVDatasett INNER JOIN FDVProsjekt ON FDVDatasett.FDVProsjekt_Id = FDVProsjekt.Id INNER JOIN Kommune ON FDVProsjekt.Kommune_Kommunenr = Kommune.Kommunenr INNER JOIN Datasett ON FDVDatasett.Datasett_Id = Datasett.Id LEFT OUTER JOIN FDVDatasettForvaltningstype ON FDVDatasett.FDVDatasettForvaltningstype_Id = FDVDatasettForvaltningstype.Id WHERE Datasett.Navn = 'Reguleringsplan - vedtatt' and(FDVProsjekt.Kommune_Kommunenr LIKE @fylkesnr) AND(Kommune.Aktiv = 1) AND(FDVProsjekt.Aktiv = 1) and FDVProsjekt.Ar = (select max(Ar) from FDVProsjekt where Kommune_Kommunenr LIKE @fylkesnr ) GROUP BY FDVProsjekt.Ar,FDVProsjekt.Kommune_Kommunenr, FDVDatasettForvaltningstype.Type, Kommune.Kommunenavn ORDER BY FDVProsjekt.Kommune_Kommunenr";
command.Parameters.Add(new SqlParameter("@fylkesnr", idSql + "%"));
using (var result = command.ExecuteReader())
{
model.Municipalities = new List <GeosynchInfo>();
while (result.Read())
{
GeosynchInfo geosynchInfo = new GeosynchInfo();
geosynchInfo.MunicipalityNumber = result.GetString(0);
geosynchInfo.MunicipalityName = result.GetString(1);
geosynchInfo.UpdateType = result.GetString(2);
if (geosynchInfo.UpdateType == "SOSI originaldata")
{
geosynchInfo.UpdateType = "Periodisk ajourhold";
}
GetStatus(ref geosynchInfo);
model.Municipalities.Add(geosynchInfo);
}
}
}
ViewBag.ContextViewModel = _contextViewModelHelper.Create(_contextViewModelHelper.Id2Key(id, true));
return(View("Views/NAP/Management/Aspects/Geosynchronization/County.cshtml", model));
}
