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