public IEnumerable <ValidationResult> GetValidationResults()
{
var errors = new List <ValidationResult>();
if (ProjectExemptReportingYears != null && ProjectExemptReportingYears.Any(x => x.IsExempt) && string.IsNullOrWhiteSpace(Explanation))
{
errors.Add(new SitkaValidationResult <PerformanceMeasuresViewModel, string>(FirmaValidationMessages.ExplanationNecessaryForProjectExemptYears, x => x.Explanation));
}
errors.AddRange(ValidatePerformanceMeasures().GetWarningMessages().Select(m =>
new ValidationResult(m)));
return(errors);
}
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
{
var errors = new List <ValidationResult>();
if (ProjectExemptReportingYears != null && ProjectExemptReportingYears.Any(x => x.IsExempt) && string.IsNullOrWhiteSpace(Explanation))
{
errors.Add(new ValidationResult(FirmaValidationMessages.ExplanationNecessaryForProjectExemptYears));
}
var exemptYears = ProjectExemptReportingYears?.Where(x => x.IsExempt).Select(x => x.CalendarYear).ToList();
var performanceMeasureActualsWithDuplicatesDisplayNames = PerformanceMeasureActuals
?.GroupBy(x => new { x.PerformanceMeasureID, x.CalendarYear })
.Select(x => x.ToList())
.ToList()
.Select(x => x)
.Where(x => x.Select(m => m.PerformanceMeasureActualSubcategoryOptions).ToList()
.Select(z => String.Join("_", z.Select(s => s.PerformanceMeasureSubcategoryOptionID).ToList()))
.ToList().HasDuplicates()).SelectMany(x => x.Select(y => y.PerformanceMeasureActualName).Distinct())
.ToList();
var performanceMeasureActualsWithMissingDataDisplayNames = PerformanceMeasureActuals?.Where(x =>
x.ActualValue == null ||
x.PerformanceMeasureActualSubcategoryOptions.Any(y =>
y.PerformanceMeasureSubcategoryOptionID == null))
.Select(x => x.PerformanceMeasureActualName).Distinct().ToList();
var performanceMeasureActualsWithValuesInExemptYearsDisplayNames = PerformanceMeasureActuals
?.Where(x => exemptYears.Contains(x.CalendarYear))
.Select(x => x.PerformanceMeasureActualName).Distinct().ToList();
performanceMeasureActualsWithMissingDataDisplayNames?.ForEach(x => errors.Add(new ValidationResult($"{x} has rows with missing data. All values are required.")));
performanceMeasureActualsWithDuplicatesDisplayNames?.ForEach(x => errors.Add(new ValidationResult($"{x} has duplicate rows. The {FieldDefinitionEnum.PerformanceMeasureSubcategory.ToType().GetFieldDefinitionLabelPluralized()} must be unique for each {MultiTenantHelpers.GetPerformanceMeasureName()}. Collapse the duplicate rows into one entry row then save the page.")));
performanceMeasureActualsWithValuesInExemptYearsDisplayNames?.ForEach(x =>
errors.Add(new ValidationResult(
$"{x} has reported values for exempt years. For years which it is indicated that there are no accomplishments to report, you cannot enter {MultiTenantHelpers.GetPerformanceMeasureNamePluralized()}. You must either correct the years for which you have no accomplishments to report, or the reported {MultiTenantHelpers.GetPerformanceMeasureNamePluralized()}.")));
return(errors);
}
public void UpdateModel(List <Models.PerformanceMeasureActual> currentPerformanceMeasureActuals,
IList <Models.PerformanceMeasureActual> allPerformanceMeasureActuals,
IList <PerformanceMeasureActualSubcategoryOption> allPerformanceMeasureActualSubcategoryOptions,
Models.Project project)
{
UpdateModelImpl(currentPerformanceMeasureActuals, allPerformanceMeasureActuals, allPerformanceMeasureActualSubcategoryOptions);
var currentProjectExemptYears = project.GetPerformanceMeasuresExemptReportingYears();
HttpRequestStorage.DatabaseEntities.ProjectExemptReportingYears.Load();
var allProjectExemptYears = HttpRequestStorage.DatabaseEntities.ProjectExemptReportingYears.Local;
var projectExemptReportingYears = new List <ProjectExemptReportingYear>();
if (ProjectExemptReportingYears != null)
{
// Completely rebuild the list
projectExemptReportingYears =
ProjectExemptReportingYears.Where(x => x.IsExempt).Select(x => new ProjectExemptReportingYear(x.ProjectID, x.CalendarYear, ProjectExemptReportingType.PerformanceMeasures.ProjectExemptReportingTypeID)).ToList();
}
currentProjectExemptYears.Merge(projectExemptReportingYears, allProjectExemptYears, (x, y) => x.ProjectID == y.ProjectID && x.CalendarYear == y.CalendarYear && x.ProjectExemptReportingTypeID == y.ProjectExemptReportingTypeID);
project.PerformanceMeasureActualYearsExemptionExplanation = Explanation;
}
/// <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());
}
public void UpdateModel(List <Models.PerformanceMeasureActual> currentPerformanceMeasureActuals,
IList <Models.PerformanceMeasureActual> allPerformanceMeasureActuals,
IList <PerformanceMeasureActualSubcategoryOption> allPerformanceMeasureActualSubcategoryOptions,
Models.Project project)
{
var currentPerformanceMeasureActualSubcategoryOptions =
currentPerformanceMeasureActuals.SelectMany(x => x.PerformanceMeasureActualSubcategoryOptions).ToList();
var performanceMeasureActualsUpdated = new List <Models.PerformanceMeasureActual>();
if (PerformanceMeasureActuals != null)
{
// Completely rebuild the list
performanceMeasureActualsUpdated = PerformanceMeasureActuals.Select(x =>
{
var performanceMeasureActual = new Models.PerformanceMeasureActual(x.PerformanceMeasureActualID.GetValueOrDefault(),
x.ProjectID.GetValueOrDefault(),
x.PerformanceMeasureID.GetValueOrDefault(),
x.CalendarYear.GetValueOrDefault(),
x.ActualValue.GetValueOrDefault());
if (x.PerformanceMeasureActualSubcategoryOptions != null)
{
performanceMeasureActual.PerformanceMeasureActualSubcategoryOptions =
x.PerformanceMeasureActualSubcategoryOptions.Where(pmavsou => ModelObjectHelpers.IsRealPrimaryKeyValue(pmavsou.PerformanceMeasureSubcategoryOptionID))
.Select(
y =>
new PerformanceMeasureActualSubcategoryOption(performanceMeasureActual.PerformanceMeasureActualID,
y.PerformanceMeasureSubcategoryOptionID.GetValueOrDefault(),
y.PerformanceMeasureID,
y.PerformanceMeasureSubcategoryID))
.ToList();
}
return(performanceMeasureActual);
}).ToList();
}
currentPerformanceMeasureActuals.Merge(performanceMeasureActualsUpdated,
allPerformanceMeasureActuals,
(x, y) => x.PerformanceMeasureActualID == y.PerformanceMeasureActualID,
(x, y) =>
{
x.CalendarYear = y.CalendarYear;
x.ActualValue = y.ActualValue;
});
currentPerformanceMeasureActualSubcategoryOptions.Merge(
performanceMeasureActualsUpdated.SelectMany(x => x.PerformanceMeasureActualSubcategoryOptions).ToList(),
allPerformanceMeasureActualSubcategoryOptions,
(x, y) => x.PerformanceMeasureActualID == y.PerformanceMeasureActualID && x.PerformanceMeasureSubcategoryID == y.PerformanceMeasureSubcategoryID && x.PerformanceMeasureID == y.PerformanceMeasureID,
(x, y) => x.PerformanceMeasureSubcategoryOptionID = y.PerformanceMeasureSubcategoryOptionID);
var currentProjectExemptYears = project.GetPerformanceMeasuresExemptReportingYears();
HttpRequestStorage.DatabaseEntities.ProjectExemptReportingYears.Load();
var allProjectExemptYears = HttpRequestStorage.DatabaseEntities.ProjectExemptReportingYears.Local;
var projectExemptReportingYears = new List <ProjectExemptReportingYear>();
if (ProjectExemptReportingYears != null)
{
// Completely rebuild the list
projectExemptReportingYears =
ProjectExemptReportingYears.Where(x => x.IsExempt)
.Select(x => new ProjectExemptReportingYear(x.ProjectExemptReportingYearID, x.ProjectID, x.CalendarYear, ProjectExemptReportingType.PerformanceMeasures.ProjectExemptReportingTypeID))
.ToList();
}
currentProjectExemptYears.Merge(projectExemptReportingYears,
allProjectExemptYears,
(x, y) => x.ProjectID == y.ProjectID && x.CalendarYear == y.CalendarYear && x.ProjectExemptReportingTypeID == y.ProjectExemptReportingTypeID);
project.PerformanceMeasureActualYearsExemptionExplanation = Explanation;
}
/// <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());
}
