/// <summary>
/// Active Dependent type names of this object
/// </summary>
public List <string> DependentObjectNames()
{
var dependentObjects = new List <string>();
if (GisUploadSourceOrganizations.Any())
{
dependentObjects.Add(typeof(GisUploadSourceOrganization).Name);
}
if (ProgramPeople.Any())
{
dependentObjects.Add(typeof(ProgramPerson).Name);
}
if (ProjectLocations.Any())
{
dependentObjects.Add(typeof(ProjectLocation).Name);
}
if (ProjectPrograms.Any())
{
dependentObjects.Add(typeof(ProjectProgram).Name);
}
if (Treatments.Any())
{
dependentObjects.Add(typeof(Treatment).Name);
}
return(dependentObjects.Distinct().ToList());
}
/// <summary>
/// Dependent type names of this entity
/// </summary>
public void DeleteChildren(DatabaseEntities dbContext)
{
foreach (var x in GisUploadSourceOrganizations.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProgramPeople.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectLocations.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectPrograms.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in Treatments.ToList())
{
x.DeleteFull(dbContext);
}
}
public List <ProjectLocation> GetProjectLocationDetailedAsProjectLocations(bool showLocationIfPrivate)
{
if (LocationIsPrivate && !showLocationIfPrivate)
{
return(new List <ProjectLocation>());
}
return(ProjectLocations.ToList());
}
public bool HasProjectLocationDetailed(bool includePrivateLocation)
{
if (LocationIsPrivate && !includePrivateLocation)
{
return(false);
}
return(ProjectLocations.Any());
}
public void AutoAssignProjectPriorityLandscapesAndDnrUplandRegions()
{
var detailedProjectLocations = ProjectLocations.Select(x => x.ProjectLocationGeometry).ToList();
var projectHasDetailedLocations = HasProjectLocationDetail;
var detailedProjectLocationsAggregated = HasProjectLocationDetail ? detailedProjectLocations.Aggregate((x, y) => x.Union(y)) : null;
var detailedProjectLocationsAggregatedMadeValid = HasProjectLocationDetail ? (detailedProjectLocationsAggregated.IsValid ? detailedProjectLocationsAggregated : detailedProjectLocationsAggregated.ToSqlGeometry().MakeValid().ToDbGeometryWithCoordinateSystem()) : null;
var projectLocationPoint = this.ProjectLocationPoint;
var projectLocationPointExists = this.HasProjectLocationPoint;
var updatedProjectPriorityLandscapes = HttpRequestStorage.DatabaseEntities.PriorityLandscapes
.Where(x => (projectHasDetailedLocations && x.PriorityLandscapeLocation.Intersects(detailedProjectLocationsAggregatedMadeValid)) || (projectLocationPointExists && x.PriorityLandscapeLocation.Intersects(projectLocationPoint)))
.ToList()
.Select(x => new ProjectPriorityLandscape(ProjectID, x.PriorityLandscapeID))
.ToList();
if (!updatedProjectPriorityLandscapes.Any())
{
NoPriorityLandscapesExplanation =
"Neither the simple location nor the detailed location on this project intersects with any Priority Landscape.";
}
else
{
NoPriorityLandscapesExplanation = null;
}
ProjectPriorityLandscapes.Merge(updatedProjectPriorityLandscapes, HttpRequestStorage.DatabaseEntities.ProjectPriorityLandscapes.Local, (x, y) => x.ProjectID == y.ProjectID && x.PriorityLandscapeID == y.PriorityLandscapeID);
var updatedProjectRegions = HttpRequestStorage.DatabaseEntities.DNRUplandRegions
.Where(x => (projectHasDetailedLocations && x.DNRUplandRegionLocation.Intersects(detailedProjectLocationsAggregatedMadeValid)) || (projectLocationPointExists && x.DNRUplandRegionLocation.Intersects(projectLocationPoint)))
.ToList()
.Select(x => new ProjectRegion(ProjectID, x.DNRUplandRegionID))
.ToList();
if (!updatedProjectRegions.Any())
{
NoRegionsExplanation =
"Neither the simple location nor the detailed location on this project intersects with any DNR Upland Region.";
}
else
{
NoRegionsExplanation = null;
}
ProjectRegions.Merge(updatedProjectRegions, HttpRequestStorage.DatabaseEntities.ProjectRegions.Local, (x, y) => x.ProjectID == y.ProjectID && x.DNRUplandRegionID == y.DNRUplandRegionID);
}
/// <summary>
/// Dependent type names of this entity
/// </summary>
public void DeleteChildren(DatabaseEntities dbContext)
{
foreach (var x in NotificationProjects.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in PerformanceMeasureActuals.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in PerformanceMeasureExpecteds.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectAssessmentQuestions.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectAttachments.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectClassifications.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectContacts.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectCustomAttributes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectEvaluations.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectExemptReportingYears.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectExternalLinks.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectFundingSourceBudgets.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectFundingSourceExpenditures.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectGeospatialAreas.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectGeospatialAreaTypeNotes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectImages.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectInternalNotes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectLocations.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectLocationStagings.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectNoFundingSourceIdentifieds.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectNotes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectOrganizations.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectProjectStatuses.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectRelevantCostTypes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectTags.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectUpdateBatches.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in SecondaryProjectTaxonomyLeafs.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in TechnicalAssistanceRequests.ToList())
{
x.DeleteFull(dbContext);
}
}
/// <summary>
/// Active Dependent type names of this object
/// </summary>
public List <string> DependentObjectNames()
{
var dependentObjects = new List <string>();
if (NotificationProjects.Any())
{
dependentObjects.Add(typeof(NotificationProject).Name);
}
if (PerformanceMeasureActuals.Any())
{
dependentObjects.Add(typeof(PerformanceMeasureActual).Name);
}
if (PerformanceMeasureExpecteds.Any())
{
dependentObjects.Add(typeof(PerformanceMeasureExpected).Name);
}
if (ProjectAssessmentQuestions.Any())
{
dependentObjects.Add(typeof(ProjectAssessmentQuestion).Name);
}
if (ProjectAttachments.Any())
{
dependentObjects.Add(typeof(ProjectAttachment).Name);
}
if (ProjectClassifications.Any())
{
dependentObjects.Add(typeof(ProjectClassification).Name);
}
if (ProjectContacts.Any())
{
dependentObjects.Add(typeof(ProjectContact).Name);
}
if (ProjectCustomAttributes.Any())
{
dependentObjects.Add(typeof(ProjectCustomAttribute).Name);
}
if (ProjectEvaluations.Any())
{
dependentObjects.Add(typeof(ProjectEvaluation).Name);
}
if (ProjectExemptReportingYears.Any())
{
dependentObjects.Add(typeof(ProjectExemptReportingYear).Name);
}
if (ProjectExternalLinks.Any())
{
dependentObjects.Add(typeof(ProjectExternalLink).Name);
}
if (ProjectFundingSourceBudgets.Any())
{
dependentObjects.Add(typeof(ProjectFundingSourceBudget).Name);
}
if (ProjectFundingSourceExpenditures.Any())
{
dependentObjects.Add(typeof(ProjectFundingSourceExpenditure).Name);
}
if (ProjectGeospatialAreas.Any())
{
dependentObjects.Add(typeof(ProjectGeospatialArea).Name);
}
if (ProjectGeospatialAreaTypeNotes.Any())
{
dependentObjects.Add(typeof(ProjectGeospatialAreaTypeNote).Name);
}
if (ProjectImages.Any())
{
dependentObjects.Add(typeof(ProjectImage).Name);
}
if (ProjectInternalNotes.Any())
{
dependentObjects.Add(typeof(ProjectInternalNote).Name);
}
if (ProjectLocations.Any())
{
dependentObjects.Add(typeof(ProjectLocation).Name);
}
if (ProjectLocationStagings.Any())
{
dependentObjects.Add(typeof(ProjectLocationStaging).Name);
}
if (ProjectNoFundingSourceIdentifieds.Any())
{
dependentObjects.Add(typeof(ProjectNoFundingSourceIdentified).Name);
}
if (ProjectNotes.Any())
{
dependentObjects.Add(typeof(ProjectNote).Name);
}
if (ProjectOrganizations.Any())
{
dependentObjects.Add(typeof(ProjectOrganization).Name);
}
if (ProjectProjectStatuses.Any())
{
dependentObjects.Add(typeof(ProjectProjectStatus).Name);
}
if (ProjectRelevantCostTypes.Any())
{
dependentObjects.Add(typeof(ProjectRelevantCostType).Name);
}
if (ProjectTags.Any())
{
dependentObjects.Add(typeof(ProjectTag).Name);
}
if (ProjectUpdateBatches.Any())
{
dependentObjects.Add(typeof(ProjectUpdateBatch).Name);
}
if (SecondaryProjectTaxonomyLeafs.Any())
{
dependentObjects.Add(typeof(SecondaryProjectTaxonomyLeaf).Name);
}
if (TechnicalAssistanceRequests.Any())
{
dependentObjects.Add(typeof(TechnicalAssistanceRequest).Name);
}
return(dependentObjects.Distinct().ToList());
}
/// <summary>
/// Does this object have any dependent objects? (If it does have dependent objects, these would need to be deleted before this object could be deleted.)
/// </summary>
/// <returns></returns>
public bool HasDependentObjects()
{
return(NotificationProjects.Any() || PerformanceMeasureActuals.Any() || PerformanceMeasureExpecteds.Any() || ProjectAssessmentQuestions.Any() || ProjectAttachments.Any() || ProjectClassifications.Any() || ProjectContacts.Any() || ProjectCustomAttributes.Any() || ProjectEvaluations.Any() || ProjectExemptReportingYears.Any() || ProjectExternalLinks.Any() || ProjectFundingSourceBudgets.Any() || ProjectFundingSourceExpenditures.Any() || ProjectGeospatialAreas.Any() || ProjectGeospatialAreaTypeNotes.Any() || ProjectImages.Any() || ProjectInternalNotes.Any() || ProjectLocations.Any() || ProjectLocationStagings.Any() || ProjectNoFundingSourceIdentifieds.Any() || ProjectNotes.Any() || ProjectOrganizations.Any() || ProjectProjectStatuses.Any() || ProjectRelevantCostTypes.Any() || ProjectTags.Any() || ProjectUpdateBatches.Any() || SecondaryProjectTaxonomyLeafs.Any() || TechnicalAssistanceRequests.Any());
}
/// <summary>
/// Does this object have any dependent objects? (If it does have dependent objects, these would need to be deleted before this object could be deleted.)
/// </summary>
/// <returns></returns>
public bool HasDependentObjects()
{
return(GisUploadSourceOrganizations.Any() || ProgramPeople.Any() || ProjectLocations.Any() || ProjectPrograms.Any() || Treatments.Any());
}
public FeatureCollection DetailedLocationsByTypeToGeoJsonFeatureCollection(
ProjectLocationType projectLocationType)
{
return(ProjectLocations.Where(x => x.ProjectLocationTypeID == projectLocationType.ProjectLocationTypeID)
.ToGeoJsonFeatureCollection());
}
public FeatureCollection AllDetailedLocationsToGeoJsonFeatureCollection()
{
return(ProjectLocations.ToGeoJsonFeatureCollection());
}
public IEnumerable <IProjectLocation> GetProjectLocationDetails()
{
return(ProjectLocations.ToList());
}
/// <summary>
/// Dependent type names of this entity
/// </summary>
public void DeleteChildren(DatabaseEntities dbContext)
{
foreach (var x in GrantAllocationAwardLandownerCostShareLineItems.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in InteractionEventProjects.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in NotificationProjects.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in PerformanceMeasureActuals.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in PerformanceMeasureExpecteds.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectClassifications.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectCustomAttributes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectDocuments.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectExemptReportingYears.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectExternalLinks.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectFundingSources.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectGrantAllocationExpenditures.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectGrantAllocationRequests.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectImages.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectInternalNotes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectLocations.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectLocationStagings.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectNotes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectOrganizations.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectPeople.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectPriorityLandscapes.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectPrograms.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectRegions.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectTags.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in ProjectUpdateBatches.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in Treatments.ToList())
{
x.DeleteFull(dbContext);
}
}
/// <summary>
/// Active Dependent type names of this object
/// </summary>
public List <string> DependentObjectNames()
{
var dependentObjects = new List <string>();
if (GrantAllocationAwardLandownerCostShareLineItems.Any())
{
dependentObjects.Add(typeof(GrantAllocationAwardLandownerCostShareLineItem).Name);
}
if (InteractionEventProjects.Any())
{
dependentObjects.Add(typeof(InteractionEventProject).Name);
}
if (NotificationProjects.Any())
{
dependentObjects.Add(typeof(NotificationProject).Name);
}
if (PerformanceMeasureActuals.Any())
{
dependentObjects.Add(typeof(PerformanceMeasureActual).Name);
}
if (PerformanceMeasureExpecteds.Any())
{
dependentObjects.Add(typeof(PerformanceMeasureExpected).Name);
}
if (ProjectClassifications.Any())
{
dependentObjects.Add(typeof(ProjectClassification).Name);
}
if (ProjectCustomAttributes.Any())
{
dependentObjects.Add(typeof(ProjectCustomAttribute).Name);
}
if (ProjectDocuments.Any())
{
dependentObjects.Add(typeof(ProjectDocument).Name);
}
if (ProjectExemptReportingYears.Any())
{
dependentObjects.Add(typeof(ProjectExemptReportingYear).Name);
}
if (ProjectExternalLinks.Any())
{
dependentObjects.Add(typeof(ProjectExternalLink).Name);
}
if (ProjectFundingSources.Any())
{
dependentObjects.Add(typeof(ProjectFundingSource).Name);
}
if (ProjectGrantAllocationExpenditures.Any())
{
dependentObjects.Add(typeof(ProjectGrantAllocationExpenditure).Name);
}
if (ProjectGrantAllocationRequests.Any())
{
dependentObjects.Add(typeof(ProjectGrantAllocationRequest).Name);
}
if (ProjectImages.Any())
{
dependentObjects.Add(typeof(ProjectImage).Name);
}
if (ProjectInternalNotes.Any())
{
dependentObjects.Add(typeof(ProjectInternalNote).Name);
}
if (ProjectLocations.Any())
{
dependentObjects.Add(typeof(ProjectLocation).Name);
}
if (ProjectLocationStagings.Any())
{
dependentObjects.Add(typeof(ProjectLocationStaging).Name);
}
if (ProjectNotes.Any())
{
dependentObjects.Add(typeof(ProjectNote).Name);
}
if (ProjectOrganizations.Any())
{
dependentObjects.Add(typeof(ProjectOrganization).Name);
}
if (ProjectPeople.Any())
{
dependentObjects.Add(typeof(ProjectPerson).Name);
}
if (ProjectPriorityLandscapes.Any())
{
dependentObjects.Add(typeof(ProjectPriorityLandscape).Name);
}
if (ProjectPrograms.Any())
{
dependentObjects.Add(typeof(ProjectProgram).Name);
}
if (ProjectRegions.Any())
{
dependentObjects.Add(typeof(ProjectRegion).Name);
}
if (ProjectTags.Any())
{
dependentObjects.Add(typeof(ProjectTag).Name);
}
if (ProjectUpdateBatches.Any())
{
dependentObjects.Add(typeof(ProjectUpdateBatch).Name);
}
if (Treatments.Any())
{
dependentObjects.Add(typeof(Treatment).Name);
}
return(dependentObjects.Distinct().ToList());
}
/// <summary>
/// Does this object have any dependent objects? (If it does have dependent objects, these would need to be deleted before this object could be deleted.)
/// </summary>
/// <returns></returns>
public bool HasDependentObjects()
{
return(GrantAllocationAwardLandownerCostShareLineItems.Any() || InteractionEventProjects.Any() || NotificationProjects.Any() || PerformanceMeasureActuals.Any() || PerformanceMeasureExpecteds.Any() || ProjectClassifications.Any() || ProjectCustomAttributes.Any() || ProjectDocuments.Any() || ProjectExemptReportingYears.Any() || ProjectExternalLinks.Any() || ProjectFundingSources.Any() || ProjectGrantAllocationExpenditures.Any() || ProjectGrantAllocationRequests.Any() || ProjectImages.Any() || ProjectInternalNotes.Any() || ProjectLocations.Any() || ProjectLocationStagings.Any() || ProjectNotes.Any() || ProjectOrganizations.Any() || ProjectPeople.Any() || ProjectPriorityLandscapes.Any() || ProjectPrograms.Any() || ProjectRegions.Any() || ProjectTags.Any() || ProjectUpdateBatches.Any() || Treatments.Any());
}
