/// <summary>
/// Query to get a list of participant people
/// </summary>
/// <param name="context">The context to query</param>
/// <returns>List of participant people</returns>
public static IQueryable <SimpleParticipantPersonDTO> CreateGetSimpleParticipantPersonsDTOQuery(EcaContext context)
{
Contract.Requires(context != null, "The context must not be null.");
var organizationQuery = OrganizationQueries.CreateGetOrganizationDTOsQuery(context);
var query = (from p in context.ParticipantPersons
select new SimpleParticipantPersonDTO
{
ParticipantId = p.ParticipantId,
SevisId = p.SevisId,
ProjectId = p.Participant.ProjectId,
HomeInstitutionAddressId = p.HomeInstitutionAddressId,
HostInstitutionAddressId = p.HostInstitutionAddressId,
ParticipantType = p.Participant.ParticipantType != null ? p.Participant.ParticipantType.Name : null,
ParticipantTypeId = p.Participant.ParticipantTypeId,
ParticipantStatus = p.Participant.Status != null ? p.Participant.Status.Status : null,
ParticipantStatusId = p.Participant.ParticipantStatusId,
HomeInstitution = organizationQuery.Where(x => x.OrganizationId == p.HomeInstitutionId).FirstOrDefault(),
HostInstitution = organizationQuery.Where(x => x.OrganizationId == p.HostInstitutionId).FirstOrDefault(),
SevisStatus = p.ParticipantPersonSevisCommStatuses.Count == 0 ? "None" : p.ParticipantPersonSevisCommStatuses.OrderByDescending(s => s.AddedOn).FirstOrDefault().SevisCommStatus.SevisCommStatusName,
SevisStatusId = p.ParticipantPersonSevisCommStatuses.Count == 0 ? 0 : p.ParticipantPersonSevisCommStatuses.OrderByDescending(s => s.AddedOn).FirstOrDefault().SevisCommStatus.SevisCommStatusId,
PlacementOrganization = organizationQuery.Where(x => x.OrganizationId == p.PlacementOrganizationId).FirstOrDefault(),
PlacementOrganizationAddressId = p.PlacementOrganizationAddressId
});
return(query);
}
/// <summary>
/// Get the organization roles
/// </summary>
/// <param name="queryOperator">The query operator to apply</param>
/// <returns>List of organization roles</returns>
public async Task <PagedQueryResults <SimpleLookupDTO> > GetOrganizationRolesAsync(QueryableOperator <SimpleLookupDTO> queryOperator)
{
var organizationRoles = await OrganizationQueries.CreateGetOrganizationRolesQuery(this.Context, queryOperator).ToPagedQueryResultsAsync(queryOperator.Start, queryOperator.Limit);
this.logger.Trace("Retrieved organization roles with query operator [{0}].", queryOperator);
return(organizationRoles);
}
/// <summary>
/// Returns list of organizations asyncronously
/// </summary>
/// <param name="queryOperator">The query operator to apply</param>
/// <returns>List of organizations</returns>
public Task <PagedQueryResults <SimpleOrganizationDTO> > GetOrganizationsWOFundingSourceAsync(QueryableOperator <SimpleOrganizationDTO> queryOperator)
{
var organizations = OrganizationQueries.CreateGetSimpleOrganizationsDTOQueryWOFundingSource(this.Context, queryOperator).ToPagedQueryResultsAsync(queryOperator.Start, queryOperator.Limit);
this.logger.Trace("Retrieved organizations with query operator [{0}].", queryOperator);
return(organizations);
}
/// <summary>
/// Gets the organization with the given id.
/// </summary>
/// <param name="organizationId">The organization id.</param>
/// <returns>The organization.</returns>
public async Task <OrganizationDTO> GetOrganizationByIdAsync(int organizationId)
{
var dto = await OrganizationQueries.CreateGetOrganizationDTOByOrganizationIdQuery(this.Context, organizationId).FirstOrDefaultAsync();
this.logger.Trace("Retreived organization by id [{0}].", organizationId);
return(dto);
}
/// <summary>
/// Gets the organization with the given id.
/// </summary>
/// <param name="organizationId">The organization id.</param>
/// <returns>The organization.</returns>
public OrganizationDTO GetOrganizationById(int organizationId)
{
var dto = OrganizationQueries.CreateGetOrganizationDTOByOrganizationIdQuery(this.Context, organizationId).FirstOrDefault();
this.logger.Trace("Retreived organization by id [{0}].", organizationId);
return(dto);
}
public CommonForumInfo()
{
_forumQueries = DependencyResolver.Current.GetService<ForumQueries>();
_orgQueries = DependencyResolver.Current.GetService<OrganizationQueries>();
_categoryQueries = DependencyResolver.Current.GetService<CategoryQueries>();
_userQueries = DependencyResolver.Current.GetService<UserQueries>();
_contentQueries = DependencyResolver.Current.GetService<ContentQueries>();
_tagQueries = DependencyResolver.Current.GetService<TagQueries>();
}
public OrganizationController(OrganizationUserQueries userQueries, OrganizationQueries organizationQueries)
{
_userQueries = userQueries;
_organizationQueries = organizationQueries;
}
/// <summary>
/// Returns a query to get organization dtos.
/// </summary>
/// <returns>The query.</returns>
public override IQueryable <OrganizationDTO> CreateGetDocumentsQuery()
{
return(OrganizationQueries.CreateGetOrganizationDTOsQuery(this.Context)
.Where(x => !Organization.OFFICE_ORGANIZATION_TYPE_IDS.Contains(x.OrganizationTypeId))
.OrderBy(x => x.OrganizationId));
}
