/// <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);
}
}
/// <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());
}
public Feature MakePointFeatureWithRelevantProperties(DbGeometry projectLocationPoint
, bool addProjectProperties
, bool useDetailedCustomPopup
, string organizationFieldDefinitionLabelSingle
, string organizationFieldDefinitionLabelPluralized
, Dictionary <int, List <ProjectGrantAllocationExpenditure> > projectGrantAllocationExpenditureDict)
{
var feature = DbGeometryToGeoJsonHelper.FromDbGeometry(projectLocationPoint);
feature.Properties.Add("TaxonomyTrunkID",
ProjectType.TaxonomyBranch.TaxonomyTrunkID.ToString(CultureInfo.InvariantCulture));
feature.Properties.Add("ProjectStageID", ProjectStageID.ToString(CultureInfo.InvariantCulture));
if (ProjectStage != null)
{
feature.Properties.Add("ProjectStageColor", ProjectStage.ProjectStageColor);
}
feature.Properties.Add("Info", DisplayName);
if (addProjectProperties)
{
feature.Properties.Add("ProjectID", ProjectID.ToString(CultureInfo.InvariantCulture));
feature.Properties.Add("TaxonomyBranchID",
ProjectType.TaxonomyBranchID.ToString(CultureInfo.InvariantCulture));
feature.Properties.Add("ProjectTypeID", ProjectTypeID.ToString(CultureInfo.InvariantCulture));
feature.Properties.Add("ClassificationID",
string.Join(",", ProjectClassifications.Select(x => x.ClassificationID)));
var associatedOrganizations = this.GetAssociatedOrganizations(organizationFieldDefinitionLabelSingle, organizationFieldDefinitionLabelPluralized, projectGrantAllocationExpenditureDict);
foreach (var relationshipTypeGroup in associatedOrganizations.GroupBy(x => x.RelationshipType.RelationshipTypeName))
{
feature.Properties.Add($"{relationshipTypeGroup.First().RelationshipType.RelationshipTypeName}ID",
relationshipTypeGroup.Select(z => z.Organization.OrganizationID).ToList());
}
if (useDetailedCustomPopup)
{
feature.Properties.Add("PopupUrl", this.GetProjectMapPopupUrl());
}
else
{
feature.Properties.Add("PopupUrl", this.GetProjectSimpleMapPopupUrl());
}
feature.Properties.Add("ProgramID", string.Join(",", ProjectPrograms.Select(x => x.ProgramID)));
feature.Properties.Add("LeadImplementerID", this.ProjectOrganizations.SingleOrDefault(x => x.RelationshipTypeID == RelationshipType.LeadImplementerID)?.OrganizationID.ToString(CultureInfo.InvariantCulture) ?? (-1).ToString(CultureInfo.InvariantCulture));
}
return(feature);
}
/// <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());
}
/// <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());
}