public DetailViewData(Person currentPerson, StormwaterJurisdiction stormwaterJurisdiction) : base(currentPerson, NeptuneArea.OCStormwaterTools) { StormwaterJurisdiction = stormwaterJurisdiction; PageTitle = stormwaterJurisdiction.GetOrganizationDisplayName(); EntityName = $"{FieldDefinitionType.Jurisdiction.GetFieldDefinitionLabelPluralized()}"; EntityUrl = SitkaRoute <JurisdictionController> .BuildUrlFromExpression(x => x.Index()); TreatmentBMPGridSpec = new TreatmentBMPGridSpec(currentPerson, false, false) { ObjectNameSingular = "Treatment BMP", ObjectNamePlural = $"Treatment BMPs for {stormwaterJurisdiction.GetOrganizationDisplayName()}", SaveFiltersInCookie = true }; TreatmentBMPGridName = "jurisdictionTreatmentBMPGrid"; TreatmentBMPGridDataUrl = SitkaRoute <JurisdictionController> .BuildUrlFromExpression(x => x.JurisdictionTreatmentBMPGridJsonData(stormwaterJurisdiction)); UsersAssignedToJurisdiction = StormwaterJurisdiction.PeopleWhoCanManageStormwaterJurisdictionExceptSitka().ToList(); UserHasJurisdictionEditPermissions = new NeptuneAdminFeature().HasPermissionByPerson(CurrentPerson); EditStormwaterJurisdictionLink = UserHasJurisdictionEditPermissions ? ModalDialogFormHelper.MakeEditIconLink(SitkaRoute <JurisdictionController> .BuildUrlFromExpression(c => c.Edit(stormwaterJurisdiction)), $"Edit Jurisdiction - {StormwaterJurisdiction.GetOrganizationDisplayName()}", true) : new HtmlString(string.Empty); }
// done public static double TargetLoadReduction(StormwaterJurisdiction jurisdiction) { var vTrashGeneratingUnitLoadStatistics = HttpRequestStorage.DatabaseEntities.vTrashGeneratingUnitLoadStatistics.Where(x => x.StormwaterJurisdictionID == jurisdiction.StormwaterJurisdictionID && x.PriorityLandUseTypeID != PriorityLandUseType.ALU.PriorityLandUseTypeID); return(vTrashGeneratingUnitLoadStatistics.Any() ? vTrashGeneratingUnitLoadStatistics.Sum(x => x.Area * (double)(x.BaselineLoadingRate - FullTrashCaptureLoading) * DbSpatialHelper.SquareMetersToAcres) : 0); }
public static double LoadBasedPartialCapture(StormwaterJurisdiction jurisdiction) { var vTrashGeneratingUnitLoadStatistics = HttpRequestStorage.DatabaseEntities.vTrashGeneratingUnitLoadStatistics.Where(x => x.StormwaterJurisdictionID == jurisdiction.StormwaterJurisdictionID && x.IsPartialTrashCapture); return(vTrashGeneratingUnitLoadStatistics.Any() ? vTrashGeneratingUnitLoadStatistics.Sum(x => x.Area * (double)(x.BaselineLoadingRate - x.CurrentLoadingRate) * DbSpatialHelper.SquareMetersToAcres) : 0); }
public static double LoadBasedOVTAProgressScores(StormwaterJurisdiction jurisdiction) { var vTrashGeneratingUnitLoadStatistics = HttpRequestStorage.DatabaseEntities.vTrashGeneratingUnitLoadStatistics.Where(x => x.StormwaterJurisdictionID == jurisdiction.StormwaterJurisdictionID && x.HasBaselineScore == true && x.HasProgressScore == true); return(vTrashGeneratingUnitLoadStatistics.Any() ? vTrashGeneratingUnitLoadStatistics.Sum(x => x.Area * (double)(x.BaselineLoadingRate - x.ProgressLoadingRate) * DbSpatialHelper.SquareMetersToAcres) : 0); }
public InitiateOVTAViewData(Person currentPerson, Models.OnlandVisualTrashAssessment ovta, List <StormwaterJurisdiction> jurisdictions, SelectOVTAAreaMapInitJson mapInitJson, IEnumerable <Models.OnlandVisualTrashAssessmentArea> onlandVisualTrashAssessmentAreas, StormwaterJurisdiction defaultJurisdiction, string geoServerUrl) : base(currentPerson, Models.OVTASection.InitiateOVTA, ovta) { Jurisdictions = jurisdictions; MapInitJson = mapInitJson; DefaultJurisdiction = defaultJurisdiction; var useDefaultJurisdiction = defaultJurisdiction != null; ViewDataForAngular = new ViewDataForAngularClass(mapInitJson, onlandVisualTrashAssessmentAreas, useDefaultJurisdiction, jurisdictions, geoServerUrl); }
public ViewResult Index() { var stormwaterJurisdictionsPersonCanView = CurrentPerson.GetStormwaterJurisdictionsPersonCanView().ToList(); if (!stormwaterJurisdictionsPersonCanView.Any()) { throw new SitkaRecordNotAuthorizedException( "You are not assigned to any Jurisdictions. Please log out and log in as a different user or request additional permissions"); } var stormwaterJurisdictionIDsPersonCanView = stormwaterJurisdictionsPersonCanView.Select(x => x.StormwaterJurisdictionID); var treatmentBmps = CurrentPerson.GetTreatmentBmpsPersonCanView(); var treatmentBMPLayerGeoJson = new LayerGeoJson("Treatment BMPs", treatmentBmps.ToGeoJsonFeatureCollectionForTrashMap(), "blue", 1, LayerInitialVisibility.Show) { EnablePopups = false }; var parcels = HttpRequestStorage.DatabaseEntities.Parcels.Include(x => x.WaterQualityManagementPlanParcels).Include(x => x.WaterQualityManagementPlanParcels.Select(y => y.WaterQualityManagementPlan)).Where(x => x.WaterQualityManagementPlanParcels.Any()).ToList(); var parcelLayerGeoJson = new LayerGeoJson("Parcels", parcels.ToGeoJsonFeatureCollectionForTrashMap(), "blue", 1, LayerInitialVisibility.Show) { EnablePopups = false }; var boundingBox = BoundingBox.GetBoundingBox(stormwaterJurisdictionsPersonCanView); var geoJsonForJurisdictions = StormwaterJurisdiction.ToGeoJsonFeatureCollection(stormwaterJurisdictionsPersonCanView); var jurisdictionLayersGeoJson = new List <LayerGeoJson> { new LayerGeoJson(MapInitJsonHelpers.CountyCityLayerName, geoJsonForJurisdictions, "#FF6C2D", 0m, LayerInitialVisibility.Hide) }.ToList(); var ovtaBasedMapInitJson = new TrashModuleMapInitJson("ovtaBasedResultsMap", treatmentBMPLayerGeoJson, parcelLayerGeoJson, boundingBox, jurisdictionLayersGeoJson) { LayerControlClass = "ovta-based-map-layer-control" }; var areaBasedMapInitJson = new StormwaterMapInitJson("areaBasedResultsMap", boundingBox, jurisdictionLayersGeoJson) { LayerControlClass = "area-based-map-layer-control" }; var loadBasedMapInitJson = new StormwaterMapInitJson("loadBasedResultsMap", boundingBox, jurisdictionLayersGeoJson) { LayerControlClass = "load-based-map-layer-control" }; var neptunePage = NeptunePage.GetNeptunePageByPageType(NeptunePageType.TrashHomePage); var viewData = new IndexViewData(CurrentPerson, neptunePage, ovtaBasedMapInitJson, areaBasedMapInitJson, loadBasedMapInitJson, treatmentBmps, TrashCaptureStatusType.All, parcels, stormwaterJurisdictionsPersonCanView, geoJsonForJurisdictions); return(RazorView <Index, IndexViewData>(viewData)); }
public static StormwaterJurisdiction Create() { var jurisdiction = new StormwaterJurisdiction(TestOrganization.Create(), null, StormwaterJurisdictionPublicBMPVisibilityType.VerifiedOnly, StormwaterJurisdictionPublicWQMPVisibilityType.ActiveAndInactive); return(jurisdiction); }
private List <vTreatmentBMPDetailed> GetJurisdictionTreatmentBMPsAndGridSpec(out TreatmentBMPGridSpec gridSpec, Person currentPerson, StormwaterJurisdiction stormwaterJurisdiction) { gridSpec = new TreatmentBMPGridSpec(currentPerson, false, false); return(HttpRequestStorage.DatabaseEntities.vTreatmentBMPDetaileds.ToList() .Where(x => currentPerson.IsAssignedToStormwaterJurisdiction(x.StormwaterJurisdictionID) && x.StormwaterJurisdictionID == stormwaterJurisdiction.StormwaterJurisdictionID).ToList()); }
public StormwaterJurisdictionSimple(StormwaterJurisdiction stormwaterJurisdiction) { StormwaterJurisdictionID = stormwaterJurisdiction.StormwaterJurisdictionID; StormwaterJurisdictionDisplayName = stormwaterJurisdiction.GetOrganizationDisplayName(); }