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));
}
internal static County CreateCounty(ICounty data)
{
if (data == null)
{
return(null);
}
var result = new County
{
Code = data.Code,
Name = data.Name,
Continent = CreateContinent(data.Continent),
};
if (data.Cities != null && data.Cities.Count > 0)
{
var cities = new List <City>();
for (var i = 0; i < data.Cities.Count; i++)
{
cities.Add(CreateCity(data.Cities[i]));
}
result.Cities = cities;
}
return(result);
}
/// <summary>
/// Asynchronously adds a county.
/// </summary>
/// <param name="county">The county to be added.</param>
/// <returns>Returns <see cref="Task{Boolean}"/> indicating whether the operation was executed successfuly.</returns>
/// <exception cref="ArgumentNullException">Thrown when <paramref name="county"/> is null.</exception>
public Task<bool> AddAsync(ICounty county)
{
if(county == null)
{
throw new ArgumentNullException("county");
}
return repository.AddAsync(Mapper.Map<CountyEntity>(county));
}
ProcessTransactionByCounty(Product product, int unitsSold, ICounty county)
{
var result = (totalCostPrice : 0m, totalSalePrice : 0m, totalSalePriceWithTax : 0m, totalSaleProfit : 0m);
result.totalCostPrice = decimal.Round(product.CostPrice * unitsSold, 2, MidpointRounding.AwayFromZero);
result.totalSalePrice = decimal.Round(result.totalCostPrice * (1 + (county.MarkUp / 100)), 2, MidpointRounding.AwayFromZero);
result.totalSalePriceWithTax = decimal.Round(result.totalSalePrice * (1 + (county.SalesTax / 100)), 2, MidpointRounding.AwayFromZero);
result.totalSaleProfit = decimal.Round(result.totalSalePrice - result.totalCostPrice, 2, MidpointRounding.AwayFromZero);
return(result);
}
public Ip64ClientData(
string ipV6,
ICity city,
ICounty county,
IContinent continent,
ILocation location)
{
IpV6 = ipV6;
City = city;
County = county;
Continent = continent;
Location = location;
}
public IpV4ClientImpl(
string ipV4,
ICity city,
ICounty county,
IContinent continent,
ILocation location)
{
IpV4 = ipV4;
City = city;
County = county;
Continent = continent;
Location = location;
}
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 static CounrtyModel CreateCountry(ICounty county)
{
var result = new CounrtyModel
{
Code = county.Code,
Name = county.Name,
Continent = CreateContinent(county.Continent),
};
if (county.Cities.Count > 0)
{
for (var i = 0; i < county.Cities.Count; i++)
{
result.Cities.Add(CreateCity(county.Cities[i]));
}
}
return(result);
}
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 CityImpl(string name, ICounty county)
{
Name = name;
County = county;
}
public CountiesController(ICounty county)
{
_county = county;
}
/// <summary>
/// Asynchronously updates a county.
/// </summary>
/// <param name="county">The county to be updated.</param>
/// <returns>Returns <see cref="Task{bool}"/> indicating whether the operation was executed successfuly.</returns>
/// <exception cref="ArgumentNullException">Thrown when <paramref name="county"/> is null.</exception>
public Task<bool> UpdateAsync(ICounty county)
{
if(county == null)
{
throw new ArgumentNullException("county");
}
return repository.UpdateAsync(county);
}
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));
}
public CityData(string name, ICounty county)
{
Name = name;
County = county;
}
