public GridJsonNetJObjectResult <GrantAllocationAward> GrantAllocationAwardsGridJsonData(GrantAllocationPrimaryKey grantAllocationPrimaryKey)
{
var grantAllocation = grantAllocationPrimaryKey.EntityObject;
var grantAllocationAwards = grantAllocation.GrantAllocationAwards.ToList();
var gridSpec = new GrantAllocationAwardGridSpec(CurrentPerson, grantAllocation);
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <GrantAllocationAward>(grantAllocationAwards, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <GrantAllocationExpenditure> GrantAllocationExpendituresGridJsonData(GrantAllocationPrimaryKey grantAllocationPrimaryKey)
{
var grantAllocation = grantAllocationPrimaryKey.EntityObject;
var grantAllocationExpenditures = grantAllocation.GrantAllocationExpenditures.ToList();
var gridSpec = new GrantAllocationExpendituresGridSpec();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <GrantAllocationExpenditure>(grantAllocationExpenditures, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <WbsElementObligationItemBudget> ContractualInvoiceGridOnFundDetailJsonData(FundingSourcePrimaryKey fundingSourcePrimaryKey)
{
var gridSpec = new ContractualInvoiceGridSpec(CurrentFirmaSession);
var fundingSource = fundingSourcePrimaryKey.EntityObject;
var obligationItemBudgets = fundingSource.WbsElementObligationItemBudgets.ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <WbsElementObligationItemBudget>(obligationItemBudgets, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Tag> IndexGridJsonData()
{
var hasTagDeletePermission = new FirmaAdminFeature().HasPermissionByFirmaSession(CurrentFirmaSession);
var gridSpec = new TagIndexGridSpec(hasTagDeletePermission);
var tags = HttpRequestStorage.DatabaseEntities.Tags.OrderBy(x => x.TagName).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Tag>(tags, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Person> PersonWithRoleGridJsonData(NeptuneAreaEnum neptuneAreaEnum, int roleID)
{
var role = NeptuneArea.ToType(neptuneAreaEnum).GetRole(roleID);
var gridSpec = new PersonWithRoleGridSpec();
var peopleWithRole = role.GetPeopleWithRole();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Person>(peopleWithRole, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Project> ProjectsGridJsonData(PersonPrimaryKey personPrimaryKey)
{
var person = personPrimaryKey.EntityObject;
var gridSpec = new Views.Project.UserProjectGridSpec(CurrentFirmaSession, person);
var projectPersons = person.GetProjectsWhereYouAreAContact();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Project>(projectPersons, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Notification> UserNotificationsGridJsonData(PersonPrimaryKey personPrimaryKey)
{
var person = personPrimaryKey.EntityObject;
var gridSpec = new UserNotificationGridSpec();
var notifications = person.Notifications.OrderByDescending(x => x.NotificationDate).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Notification>(notifications, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <EvaluationCriteria> EvaluationCriteriaGridJsonData(EvaluationPrimaryKey evaluationPrimaryKey)
{
var gridSpec = new EvaluationCriteriaGridSpec(CurrentFirmaSession);
var evaluation = evaluationPrimaryKey.EntityObject;
var evaluationCriteria = evaluation.EvaluationCriterias.ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <EvaluationCriteria>(evaluationCriteria, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <ProjectEvaluation> EvaluationPortfolioGridJsonData(EvaluationPrimaryKey evaluationPrimaryKey)
{
var evaluation = evaluationPrimaryKey.EntityObject;
var gridSpec = new EvaluationPortfolioGridSpec(CurrentFirmaSession, evaluation);
var projectEvaluations = evaluation.ProjectEvaluations.ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <ProjectEvaluation>(projectEvaluations, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <ReportTemplate> IndexGridJsonData()
{
var hasManagePermissions = new ReportTemplateManageFeature().HasPermissionByFirmaSession(CurrentFirmaSession);
var gridSpec = new ReportTemplateGridSpec(hasManagePermissions);
var reportTemplates = HttpRequestStorage.DatabaseEntities.ReportTemplates.OrderBy(x => x.DisplayName).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <ReportTemplate>(reportTemplates, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <ProjectGrantAllocationRequest> ProjectGrantAllocationRequestsGridJsonData(GrantAllocationPrimaryKey grantAllocationPrimaryKey)
{
var grantAllocation = grantAllocationPrimaryKey.EntityObject;
var projectGrantAllocationRequests = grantAllocation.ProjectGrantAllocationRequests.ToList();
var gridSpec = new ProjectGrantAllocationRequestsGridSpec();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <ProjectGrantAllocationRequest>(projectGrantAllocationRequests, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <RegionalSubbasinRevisionRequest> RegionalSubbasinRevisionRequestGridJsonData()
{
// ReSharper disable once InconsistentNaming
var regionalSubbasinRevisionRequests = GetTreatmentBmpsAndGridSpec(out var gridSpec, CurrentPerson);
var gridJsonNetJObjectResult =
new GridJsonNetJObjectResult <RegionalSubbasinRevisionRequest>(regionalSubbasinRevisionRequests,
gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <AgreementPerson> AgreementPersonGridJsonData(AgreementPrimaryKey agreementPrimaryKey)
{
var agreementID = agreementPrimaryKey.EntityObject.AgreementID;
var gridSpec = new AgreementPersonGridSpec(CurrentPerson);
var agreement = HttpRequestStorage.DatabaseEntities.Agreements.FirstOrDefault(x => x.AgreementID == agreementID);
var agreementPeople = agreement.AgreementPeople.OrderBy(x => x.Person.LastName).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <AgreementPerson>(agreementPeople, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <vProjectAttachment> ProjectAttachmentGridJsonData()
{
var hasManagePermissions = new ProjectAttachmentEditAsAdminFeature().HasPermissionByFirmaSession(CurrentFirmaSession);
var gridSpec = new ProjectAttachmentGridSpec(hasManagePermissions);
var projectAttachments = HttpRequestStorage.DatabaseEntities.vProjectAttachments.Where(x => x.TenantID == CurrentFirmaSession.TenantID)
.ToList().OrderBy(x => x.ProjectAttachmentDisplayName).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <vProjectAttachment>(projectAttachments, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <WbsElementObligationItemBudget> ContractualObligationByObligationNumberGridJsonData(ObligationNumberPrimaryKey obligationNumberPrimaryKey)
{
var gridSpec = new ContractualInvoiceGridSpec(CurrentFirmaSession);
var obligationNumber = obligationNumberPrimaryKey.EntityObject;
var obligationItems = obligationNumber.ObligationItems;
var obligationItemBudgets = obligationItems.GetWbsElementObligationItemBudgetsSorted();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <WbsElementObligationItemBudget>(obligationItemBudgets, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <GeospatialAreaIndexGridSimple> IndexGridJsonData(GeospatialAreaTypePrimaryKey geospatialAreaTypePrimaryKey)
{
var geospatialAreaType = geospatialAreaTypePrimaryKey.EntityObject;
var gridSpec = new IndexGridSpec(CurrentFirmaSession, geospatialAreaType);
var projectIDsViewableByUser = HttpRequestStorage.DatabaseEntities.Projects.ToList().GetActiveProjectsAndProposals(CurrentFirmaSession.CanViewProposals(), CurrentFirmaSession).Select(x => x.ProjectID).ToList();
var geospatialAreaIndexGridSimples = GeospatialAreaModelExtensions.GetGeospatialAreaIndexGridSimples(geospatialAreaType, projectIDsViewableByUser).OrderByDescending(x => x.ProjectViewableByUserCount).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <GeospatialAreaIndexGridSimple>(geospatialAreaIndexGridSimples, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Project> FeaturedProjectsGridJsonData()
{
var projectCustomDefaultGridConfigurations = HttpRequestStorage.DatabaseEntities.ProjectCustomGridConfigurations.Where(x => x.IsEnabled && x.ProjectCustomGridTypeID == ProjectCustomGridType.Default.ProjectCustomGridTypeID).OrderBy(x => x.SortOrder).ToList();
var projectDetails = HttpRequestStorage.DatabaseEntities.vProjectDetails.ToDictionary(x => x.ProjectID);
var gridSpec = new ProjectCustomGridSpec(CurrentFirmaSession, projectCustomDefaultGridConfigurations, ProjectCustomGridType.Default.ToEnum, projectDetails, CurrentTenant, false);
var featuredProjects = HttpRequestStorage.DatabaseEntities.Projects.Where(p => p.IsFeatured).ToList().GetActiveProjects();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Project>(featuredProjects, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <GeospatialAreaType> GeospatialAreaMapLayerGridJsonData()
{
var userCanManage = new FirmaAdminFeature().HasPermission(CurrentFirmaSession).HasPermission;
var gridSpec = new GeospatialAreaMapLayerGridSpec(userCanManage);
var geospatialAreaTypes = HttpRequestStorage.DatabaseEntities.GeospatialAreaTypes.OrderBy(x => x.GeospatialAreaTypeNamePluralized).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <GeospatialAreaType>(geospatialAreaTypes, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <ExternalMapLayer> ExternalMapLayerGridJsonData()
{
var userCanManage = new FirmaAdminFeature().HasPermission(CurrentFirmaSession).HasPermission;
var gridSpec = new ExternalMapLayerGridSpec(userCanManage);
var externalMapLayers = HttpRequestStorage.DatabaseEntities.ExternalMapLayers.OrderBy(x => x.DisplayName).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <ExternalMapLayer>(externalMapLayers, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <InteractionEvent> UserInteractionEventsGridJsonData(PersonPrimaryKey personPrimaryKey)
{
var person = personPrimaryKey.EntityObject;
var interactionEvents =
person.InteractionEventContacts.Where(ie => ie.PersonID == person.PersonID).Select(ie => ie.InteractionEvent).ToList();
var gridSpec = new InteractionEventGridSpec(CurrentPerson, person);
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <InteractionEvent>(interactionEvents, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Project> GeospatialAreaProjectsGridJsonData(GeospatialAreaPrimaryKey geospatialAreaPrimaryKey)
{
var projectCustomDefaultGridConfigurations = HttpRequestStorage.DatabaseEntities.ProjectCustomGridConfigurations.Where(x => x.IsEnabled && x.ProjectCustomGridTypeID == ProjectCustomGridType.Default.ProjectCustomGridTypeID).OrderBy(x => x.SortOrder).ToList();
var projectDetails = HttpRequestStorage.DatabaseEntities.vProjectDetails.ToDictionary(x => x.ProjectID);
var gridSpec = new ProjectCustomGridSpec(CurrentFirmaSession, projectCustomDefaultGridConfigurations, ProjectCustomGridType.Default.ToEnum, projectDetails, CurrentTenant);
var projectGeospatialAreas = geospatialAreaPrimaryKey.EntityObject.GetAssociatedProjects(CurrentFirmaSession);
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Project>(projectGeospatialAreas, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <PerformanceMeasureExpected> PerformanceMeasureExpectedsGridJsonData(
PerformanceMeasurePrimaryKey performanceMeasurePrimaryKey)
{
var performanceMeasureExpecteds =
GetPerformanceMeasureExpectedsAndGridSpec(out var gridSpec, performanceMeasurePrimaryKey.EntityObject);
var gridJsonNetJObjectResult =
new GridJsonNetJObjectResult <PerformanceMeasureExpected>(performanceMeasureExpecteds, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Project> AllActiveProjectsCustomGridDefaultJsonData()
{
var projectCustomGridConfigurations = HttpRequestStorage.DatabaseEntities.ProjectCustomGridConfigurations.Where(x => x.IsEnabled && x.ProjectCustomGridTypeID == ProjectCustomGridType.Default.ProjectCustomGridTypeID).OrderBy(x => x.SortOrder).ToList();
var projectDetails = HttpRequestStorage.DatabaseEntities.vProjectDetails.ToDictionary(x => x.ProjectID);
var gridSpec = new ProjectCustomGridSpec(CurrentFirmaSession, projectCustomGridConfigurations, ProjectCustomGridType.Default.ToEnum, projectDetails, CurrentTenant);
var projects = GetProjectEnumerableWithIncludesForPerformance().GetActiveProjects();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Project>(projects, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult<GrantAllocationBudgetLineItemForGrid> GrantAllocationBudgetLineItemGridJsonDataByGrant(GrantPrimaryKey grantPrimaryKey)
{
var relevantGrant = grantPrimaryKey.EntityObject;
// Create button is irrelevant to this data-only usage
var gridSpec = new GrantAllocationBudgetLineItemGridSpec();
var grantAllocations = relevantGrant.GrantModifications.SelectMany(gm => gm.GrantAllocations).ToList();
var budgetLineItems = grantAllocations.Select(ga => new GrantAllocationBudgetLineItemForGrid(ga)).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult<GrantAllocationBudgetLineItemForGrid>(budgetLineItems, gridSpec);
return gridJsonNetJObjectResult;
}
public GridJsonNetJObjectResult <PerformanceMeasureReportedValue> PerformanceMeasureReportedValuesGridJsonData(
PerformanceMeasurePrimaryKey performanceMeasurePrimaryKey)
{
var performanceMeasureActuals = GetPerformanceMeasureReportedValuesAndGridSpec(out var gridSpec,
performanceMeasurePrimaryKey.EntityObject, CurrentFirmaSession);
var gridJsonNetJObjectResult =
new GridJsonNetJObjectResult <PerformanceMeasureReportedValue>(performanceMeasureActuals, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <DocumentLibrary> IndexGridJsonData()
{
var gridSpec = new IndexGridSpec(new DocumentLibraryManageFeature().HasPermissionByFirmaSession(CurrentFirmaSession));
var documentLibraries = HttpRequestStorage.DatabaseEntities.DocumentLibraries
.ToList()
.OrderBy(x => x.DocumentLibraryName).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <DocumentLibrary>(documentLibraries, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <PerformanceMeasure> PerformanceMeasureGridJsonData()
{
var gridSpec = new PerformanceMeasureGridSpec(CurrentFirmaSession);
var performanceMeasures = HttpRequestStorage.DatabaseEntities.PerformanceMeasures.ToList()
.SortByOrderThenName().ToList();
var gridJsonNetJObjectResult =
new GridJsonNetJObjectResult <PerformanceMeasure>(performanceMeasures, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Vendor> VendorIndexGridJsonData()
{
var gridSpec = new VendorIndexGridSpec(CurrentFirmaSession);
List <Vendor> vendors = HttpRequestStorage.DatabaseEntities.Vendors.ToList();
List <Vendor> orderedVendors = vendors.OrderBy(v => v.VendorText).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Vendor>(orderedVendors, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <GrantAllocation> GrantAllocationGridJsonDataByGrant(GrantPrimaryKey grantPrimaryKey)
{
var relevantGrant = grantPrimaryKey.EntityObject;
// Create button is irrelevant to this data-only usage
var gridSpec = new GrantAllocationGridSpec(CurrentPerson, GrantAllocationGridSpec.GrantAllocationGridCreateButtonType.Hidden, relevantGrant);
var grantAllocations = relevantGrant.GrantModifications.SelectMany(gm => gm.GrantAllocations).ToList();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <GrantAllocation>(grantAllocations, gridSpec);
return(gridJsonNetJObjectResult);
}
public GridJsonNetJObjectResult <Project> AgreementProjectsGridJsonData(AgreementPrimaryKey agreementPrimaryKey)
{
var reclamationAgreement = agreementPrimaryKey.EntityObject;
var gridSpec = new BasicProjectInfoGridSpec(CurrentFirmaSession, true, reclamationAgreement);
//var projectTaxonomyBranches = taxonomyBranchPrimaryKey.EntityObject.GetAssociatedProjects(CurrentPerson);
var projectReclamationAgreements = reclamationAgreement.GetAssociatedProjects();
var gridJsonNetJObjectResult = new GridJsonNetJObjectResult <Project>(projectReclamationAgreements, gridSpec);
return(gridJsonNetJObjectResult);
}
