private IQueryable <DocEntityUpdate> _ExecSearch(UpdateSearch request, DocQuery query)
{
request = InitSearch <Update, UpdateSearch>(request);
IQueryable <DocEntityUpdate> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityUpdate>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new UpdateFullTextSearch(request);
entities = GetFullTextSearch <DocEntityUpdate, UpdateFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.UPDATE, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (!DocTools.IsNullOrEmpty(request.Body))
{
entities = entities.Where(en => en.Body.Contains(request.Body));
}
if (!DocTools.IsNullOrEmpty(request.Bodys))
{
entities = entities.Where(en => en.Body.In(request.Bodys));
}
if (!DocTools.IsNullOrEmpty(request.DeliveryStatus))
{
entities = entities.Where(en => en.DeliveryStatus.Contains(request.DeliveryStatus));
}
if (!DocTools.IsNullOrEmpty(request.DeliveryStatuss))
{
entities = entities.Where(en => en.DeliveryStatus.In(request.DeliveryStatuss));
}
if (request.EmailAttempts.HasValue)
{
entities = entities.Where(en => request.EmailAttempts.Value == en.EmailAttempts);
}
if (!DocTools.IsNullOrEmpty(request.EmailSent))
{
entities = entities.Where(en => null != en.EmailSent && request.EmailSent.Value.Date == en.EmailSent.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.EmailSentBefore))
{
entities = entities.Where(en => en.EmailSent <= request.EmailSentBefore);
}
if (!DocTools.IsNullOrEmpty(request.EmailSentAfter))
{
entities = entities.Where(en => en.EmailSent >= request.EmailSentAfter);
}
if (true == request.EventsIds?.Any())
{
entities = entities.Where(en => en.Events.Any(r => r.Id.In(request.EventsIds)));
}
if (!DocTools.IsNullOrEmpty(request.Link))
{
entities = entities.Where(en => en.Link.Contains(request.Link));
}
if (!DocTools.IsNullOrEmpty(request.Links))
{
entities = entities.Where(en => en.Link.In(request.Links));
}
if (request.Priority.HasValue)
{
entities = entities.Where(en => request.Priority.Value == en.Priority);
}
if (!DocTools.IsNullOrEmpty(request.Read))
{
entities = entities.Where(en => null != en.Read && request.Read.Value.Date == en.Read.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.ReadBefore))
{
entities = entities.Where(en => en.Read <= request.ReadBefore);
}
if (!DocTools.IsNullOrEmpty(request.ReadAfter))
{
entities = entities.Where(en => en.Read >= request.ReadAfter);
}
if (!DocTools.IsNullOrEmpty(request.SlackSent))
{
entities = entities.Where(en => null != en.SlackSent && request.SlackSent.Value.Date == en.SlackSent.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.SlackSentBefore))
{
entities = entities.Where(en => en.SlackSent <= request.SlackSentBefore);
}
if (!DocTools.IsNullOrEmpty(request.SlackSentAfter))
{
entities = entities.Where(en => en.SlackSent >= request.SlackSentAfter);
}
if (!DocTools.IsNullOrEmpty(request.Subject))
{
entities = entities.Where(en => en.Subject.Contains(request.Subject));
}
if (!DocTools.IsNullOrEmpty(request.Subjects))
{
entities = entities.Where(en => en.Subject.In(request.Subjects));
}
if (!DocTools.IsNullOrEmpty(request.Team) && !DocTools.IsNullOrEmpty(request.Team.Id))
{
entities = entities.Where(en => en.Team.Id == request.Team.Id);
}
if (true == request.TeamIds?.Any())
{
entities = entities.Where(en => en.Team.Id.In(request.TeamIds));
}
if (!DocTools.IsNullOrEmpty(request.User) && !DocTools.IsNullOrEmpty(request.User.Id))
{
entities = entities.Where(en => en.User.Id == request.User.Id);
}
if (true == request.UserIds?.Any())
{
entities = entities.Where(en => en.User.Id.In(request.UserIds));
}
entities = ApplyFilters <DocEntityUpdate, UpdateSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
private IQueryable <DocEntityUserType> _ExecSearch(UserTypeSearch request, DocQuery query)
{
request = InitSearch <UserType, UserTypeSearch>(request);
IQueryable <DocEntityUserType> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityUserType>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new UserTypeFullTextSearch(request);
entities = GetFullTextSearch <DocEntityUserType, UserTypeFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.USERTYPE, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (!DocTools.IsNullOrEmpty(request.PayrollStatus) && !DocTools.IsNullOrEmpty(request.PayrollStatus.Id))
{
entities = entities.Where(en => en.PayrollStatus.Id == request.PayrollStatus.Id);
}
if (true == request.PayrollStatusIds?.Any())
{
entities = entities.Where(en => en.PayrollStatus.Id.In(request.PayrollStatusIds));
}
else if (!DocTools.IsNullOrEmpty(request.PayrollStatus) && !DocTools.IsNullOrEmpty(request.PayrollStatus.Name))
{
entities = entities.Where(en => en.PayrollStatus.Name == request.PayrollStatus.Name);
}
if (true == request.PayrollStatusNames?.Any())
{
entities = entities.Where(en => en.PayrollStatus.Name.In(request.PayrollStatusNames));
}
if (!DocTools.IsNullOrEmpty(request.PayrollType) && !DocTools.IsNullOrEmpty(request.PayrollType.Id))
{
entities = entities.Where(en => en.PayrollType.Id == request.PayrollType.Id);
}
if (true == request.PayrollTypeIds?.Any())
{
entities = entities.Where(en => en.PayrollType.Id.In(request.PayrollTypeIds));
}
else if (!DocTools.IsNullOrEmpty(request.PayrollType) && !DocTools.IsNullOrEmpty(request.PayrollType.Name))
{
entities = entities.Where(en => en.PayrollType.Name == request.PayrollType.Name);
}
if (true == request.PayrollTypeNames?.Any())
{
entities = entities.Where(en => en.PayrollType.Name.In(request.PayrollTypeNames));
}
if (!DocTools.IsNullOrEmpty(request.Type) && !DocTools.IsNullOrEmpty(request.Type.Id))
{
entities = entities.Where(en => en.Type.Id == request.Type.Id);
}
if (true == request.TypeIds?.Any())
{
entities = entities.Where(en => en.Type.Id.In(request.TypeIds));
}
else if (!DocTools.IsNullOrEmpty(request.Type) && !DocTools.IsNullOrEmpty(request.Type.Name))
{
entities = entities.Where(en => en.Type.Name == request.Type.Name);
}
if (true == request.TypeNames?.Any())
{
entities = entities.Where(en => en.Type.Name.In(request.TypeNames));
}
if (true == request.UsersIds?.Any())
{
entities = entities.Where(en => en.Users.Any(r => r.Id.In(request.UsersIds)));
}
entities = ApplyFilters <DocEntityUserType, UserTypeSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
private IQueryable <DocEntityUserSession> _ExecSearch(UserSessionSearch request, DocQuery query)
{
request = InitSearch <UserSession, UserSessionSearch>(request);
IQueryable <DocEntityUserSession> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityUserSession>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new UserSessionFullTextSearch(request);
entities = GetFullTextSearch <DocEntityUserSession, UserSessionFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.USERSESSION, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (!DocTools.IsNullOrEmpty(request.ClientId))
{
entities = entities.Where(en => en.ClientId.Contains(request.ClientId));
}
if (!DocTools.IsNullOrEmpty(request.ClientIds))
{
entities = entities.Where(en => en.ClientId.In(request.ClientIds));
}
if (request.Hits.HasValue)
{
entities = entities.Where(en => request.Hits.Value == en.Hits);
}
if (true == request.ImpersonationsIds?.Any())
{
entities = entities.Where(en => en.Impersonations.Any(r => r.Id.In(request.ImpersonationsIds)));
}
if (!DocTools.IsNullOrEmpty(request.IpAddress))
{
entities = entities.Where(en => en.IpAddress.Contains(request.IpAddress));
}
if (!DocTools.IsNullOrEmpty(request.IpAddresss))
{
entities = entities.Where(en => en.IpAddress.In(request.IpAddresss));
}
if (true == request.RequestsIds?.Any())
{
entities = entities.Where(en => en.Requests.Any(r => r.Id.In(request.RequestsIds)));
}
if (!DocTools.IsNullOrEmpty(request.SessionId))
{
entities = entities.Where(en => en.SessionId.Contains(request.SessionId));
}
if (!DocTools.IsNullOrEmpty(request.SessionIds))
{
entities = entities.Where(en => en.SessionId.In(request.SessionIds));
}
if (!DocTools.IsNullOrEmpty(request.TemporarySessionId))
{
entities = entities.Where(en => en.TemporarySessionId.Contains(request.TemporarySessionId));
}
if (!DocTools.IsNullOrEmpty(request.TemporarySessionIds))
{
entities = entities.Where(en => en.TemporarySessionId.In(request.TemporarySessionIds));
}
if (!DocTools.IsNullOrEmpty(request.User) && !DocTools.IsNullOrEmpty(request.User.Id))
{
entities = entities.Where(en => en.User.Id == request.User.Id);
}
if (true == request.UserIds?.Any())
{
entities = entities.Where(en => en.User.Id.In(request.UserIds));
}
if (true == request.UserHistoryIds?.Any())
{
entities = entities.Where(en => en.UserHistory.Any(r => r.Id.In(request.UserHistoryIds)));
}
entities = ApplyFilters <DocEntityUserSession, UserSessionSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
public new static DocEntityLookupTableBinding Get(int?primaryKey, bool noCache, DocQuery query)
{
if (!(primaryKey > 0))
{
return(null);
}
return(query.SelectAll <DocEntityLookupTableBinding>().FirstOrDefault(e => e.Id == primaryKey.Value));
}
private IQueryable <DocEntityServePortalSet> _ExecSearch(ServePortalSetSearch request, DocQuery query)
{
request = InitSearch <ServePortalSet, ServePortalSetSearch>(request);
IQueryable <DocEntityServePortalSet> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityServePortalSet>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new ServePortalSetFullTextSearch(request);
entities = GetFullTextSearch <DocEntityServePortalSet, ServePortalSetFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.SERVEPORTALSET, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (true == request.ClientsIds?.Any())
{
entities = entities.Where(en => en.Clients.Any(r => r.Id.In(request.ClientsIds)));
}
if (true == request.Confidential?.Any())
{
entities = entities.Where(en => en.Confidential.In(request.Confidential));
}
if (true == request.DivisionsIds?.Any())
{
entities = entities.Where(en => en.Divisions.Any(r => r.Id.In(request.DivisionsIds)));
}
if (true == request.DocumentsIds?.Any())
{
entities = entities.Where(en => en.Documents.Any(r => r.Id.In(request.DocumentsIds)));
}
if (true == request.DocumentSetsIds?.Any())
{
entities = entities.Where(en => en.DocumentSets.Any(r => r.Id.In(request.DocumentSetsIds)));
}
if (true == request.HistoriesIds?.Any())
{
entities = entities.Where(en => en.Histories.Any(r => r.Id.In(request.HistoriesIds)));
}
if (request.LegacyDocumentSetId.HasValue)
{
entities = entities.Where(en => request.LegacyDocumentSetId.Value == en.LegacyDocumentSetId);
}
if (!DocTools.IsNullOrEmpty(request.Name))
{
entities = entities.Where(en => en.Name.Contains(request.Name));
}
if (!DocTools.IsNullOrEmpty(request.Names))
{
entities = entities.Where(en => en.Name.In(request.Names));
}
if (!DocTools.IsNullOrEmpty(request.Owner) && !DocTools.IsNullOrEmpty(request.Owner.Id))
{
entities = entities.Where(en => en.Owner.Id == request.Owner.Id);
}
if (true == request.OwnerIds?.Any())
{
entities = entities.Where(en => en.Owner.Id.In(request.OwnerIds));
}
if (!DocTools.IsNullOrEmpty(request.ProjectTeam) && !DocTools.IsNullOrEmpty(request.ProjectTeam.Id))
{
entities = entities.Where(en => en.ProjectTeam.Id == request.ProjectTeam.Id);
}
if (true == request.ProjectTeamIds?.Any())
{
entities = entities.Where(en => en.ProjectTeam.Id.In(request.ProjectTeamIds));
}
if (true == request.ScopesIds?.Any())
{
entities = entities.Where(en => en.Scopes.Any(r => r.Id.In(request.ScopesIds)));
}
if (true == request.StatsIds?.Any())
{
entities = entities.Where(en => en.Stats.Any(r => r.Id.In(request.StatsIds)));
}
if (request.Type.HasValue)
{
entities = entities.Where(en => request.Type.Value == en.Type);
}
if (!DocTools.IsNullOrEmpty(request.Types))
{
entities = entities.Where(en => en.Type.In(request.Types));
}
if (true == request.UsersIds?.Any())
{
entities = entities.Where(en => en.Users.Any(r => r.Id.In(request.UsersIds)));
}
if (true == request.ClientsIds?.Any())
{
entities = entities.Where(en => en.Clients.Any(r => r.Id.In(request.ClientsIds)));
}
if (true == request.Confidential?.Any())
{
entities = entities.Where(en => en.Confidential.In(request.Confidential));
}
if (true == request.DivisionsIds?.Any())
{
entities = entities.Where(en => en.Divisions.Any(r => r.Id.In(request.DivisionsIds)));
}
if (true == request.DocumentsIds?.Any())
{
entities = entities.Where(en => en.Documents.Any(r => r.Id.In(request.DocumentsIds)));
}
if (true == request.DocumentSetsIds?.Any())
{
entities = entities.Where(en => en.DocumentSets.Any(r => r.Id.In(request.DocumentSetsIds)));
}
if (true == request.DrugClassesIds?.Any())
{
entities = entities.Where(en => en.DrugClasses.Any(r => r.Id.In(request.DrugClassesIds)));
}
if (true == request.HistoriesIds?.Any())
{
entities = entities.Where(en => en.Histories.Any(r => r.Id.In(request.HistoriesIds)));
}
if (true == request.InterventionsIds?.Any())
{
entities = entities.Where(en => en.Interventions.Any(r => r.Id.In(request.InterventionsIds)));
}
if (request.LegacyDocumentSetId.HasValue)
{
entities = entities.Where(en => request.LegacyDocumentSetId.Value == en.LegacyDocumentSetId);
}
if (!DocTools.IsNullOrEmpty(request.Name))
{
entities = entities.Where(en => en.Name.Contains(request.Name));
}
if (!DocTools.IsNullOrEmpty(request.Names))
{
entities = entities.Where(en => en.Name.In(request.Names));
}
if (!DocTools.IsNullOrEmpty(request.Owner) && !DocTools.IsNullOrEmpty(request.Owner.Id))
{
entities = entities.Where(en => en.Owner.Id == request.Owner.Id);
}
if (true == request.OwnerIds?.Any())
{
entities = entities.Where(en => en.Owner.Id.In(request.OwnerIds));
}
if (!DocTools.IsNullOrEmpty(request.ProjectTeam) && !DocTools.IsNullOrEmpty(request.ProjectTeam.Id))
{
entities = entities.Where(en => en.ProjectTeam.Id == request.ProjectTeam.Id);
}
if (true == request.ProjectTeamIds?.Any())
{
entities = entities.Where(en => en.ProjectTeam.Id.In(request.ProjectTeamIds));
}
if (true == request.ScopesIds?.Any())
{
entities = entities.Where(en => en.Scopes.Any(r => r.Id.In(request.ScopesIds)));
}
if (true == request.StatsIds?.Any())
{
entities = entities.Where(en => en.Stats.Any(r => r.Id.In(request.StatsIds)));
}
if (request.Type.HasValue)
{
entities = entities.Where(en => request.Type.Value == en.Type);
}
if (!DocTools.IsNullOrEmpty(request.Types))
{
entities = entities.Where(en => en.Type.In(request.Types));
}
if (true == request.UsersIds?.Any())
{
entities = entities.Where(en => en.Users.Any(r => r.Id.In(request.UsersIds)));
}
entities = ApplyFilters <DocEntityServePortalSet, ServePortalSetSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
private IQueryable <DocEntityFile> _ExecSearch(FileSearch request, DocQuery query)
{
request = InitSearch <File, FileSearch>(request);
IQueryable <DocEntityFile> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityFile>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new FileFullTextSearch(request);
entities = GetFullTextSearch <DocEntityFile, FileFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.FILE, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (request.Cost.HasValue)
{
entities = entities.Where(en => request.Cost.Value == en.Cost);
}
if (!DocTools.IsNullOrEmpty(request.FileLabel))
{
entities = entities.Where(en => en.FileLabel.Contains(request.FileLabel));
}
if (!DocTools.IsNullOrEmpty(request.FileLabels))
{
entities = entities.Where(en => en.FileLabel.In(request.FileLabels));
}
if (!DocTools.IsNullOrEmpty(request.FileName))
{
entities = entities.Where(en => en.FileName.Contains(request.FileName));
}
if (!DocTools.IsNullOrEmpty(request.FileNames))
{
entities = entities.Where(en => en.FileName.In(request.FileNames));
}
if (!DocTools.IsNullOrEmpty(request.OriginalFileName))
{
entities = entities.Where(en => en.OriginalFileName.Contains(request.OriginalFileName));
}
if (!DocTools.IsNullOrEmpty(request.OriginalFileNames))
{
entities = entities.Where(en => en.OriginalFileName.In(request.OriginalFileNames));
}
if (request.Rights.HasValue)
{
entities = entities.Where(en => request.Rights.Value == en.Rights);
}
if (!DocTools.IsNullOrEmpty(request.Rightss))
{
entities = entities.Where(en => en.Rights.In(request.Rightss));
}
if (true == request.ScopesIds?.Any())
{
entities = entities.Where(en => en.Scopes.Any(r => r.Id.In(request.ScopesIds)));
}
if (request.Source.HasValue)
{
entities = entities.Where(en => request.Source.Value == en.Source);
}
if (!DocTools.IsNullOrEmpty(request.Sources))
{
entities = entities.Where(en => en.Source.In(request.Sources));
}
if (request.Type.HasValue)
{
entities = entities.Where(en => request.Type.Value == en.Type);
}
if (!DocTools.IsNullOrEmpty(request.Types))
{
entities = entities.Where(en => en.Type.In(request.Types));
}
entities = ApplyFilters <DocEntityFile, FileSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
private IQueryable <DocEntityEoD> _ExecSearch(EoDSearch request, DocQuery query)
{
request = InitSearch <EoD, EoDSearch>(request);
IQueryable <DocEntityEoD> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityEoD>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new EoDFullTextSearch(request);
entities = GetFullTextSearch <DocEntityEoD, EoDFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.EOD, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (!DocTools.IsNullOrEmpty(request.Assignee) && !DocTools.IsNullOrEmpty(request.Assignee.Id))
{
entities = entities.Where(en => en.Assignee.Id == request.Assignee.Id);
}
if (true == request.AssigneeIds?.Any())
{
entities = entities.Where(en => en.Assignee.Id.In(request.AssigneeIds));
}
if (!DocTools.IsNullOrEmpty(request.Description))
{
entities = entities.Where(en => en.Description.Contains(request.Description));
}
if (!DocTools.IsNullOrEmpty(request.Descriptions))
{
entities = entities.Where(en => en.Description.In(request.Descriptions));
}
if (!DocTools.IsNullOrEmpty(request.DueDate))
{
entities = entities.Where(en => null != en.DueDate && request.DueDate.Value.Date == en.DueDate.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.DueDateBefore))
{
entities = entities.Where(en => en.DueDate <= request.DueDateBefore);
}
if (!DocTools.IsNullOrEmpty(request.DueDateAfter))
{
entities = entities.Where(en => en.DueDate >= request.DueDateAfter);
}
if (!DocTools.IsNullOrEmpty(request.Reporter) && !DocTools.IsNullOrEmpty(request.Reporter.Id))
{
entities = entities.Where(en => en.Reporter.Id == request.Reporter.Id);
}
if (true == request.ReporterIds?.Any())
{
entities = entities.Where(en => en.Reporter.Id.In(request.ReporterIds));
}
if (request.Type.HasValue)
{
entities = entities.Where(en => request.Type.Value == en.Type);
}
if (!DocTools.IsNullOrEmpty(request.Types))
{
entities = entities.Where(en => en.Type.In(request.Types));
}
if (!DocTools.IsNullOrEmpty(request.Workflow) && !DocTools.IsNullOrEmpty(request.Workflow.Id))
{
entities = entities.Where(en => en.Workflow.Id == request.Workflow.Id);
}
if (true == request.WorkflowIds?.Any())
{
entities = entities.Where(en => en.Workflow.Id.In(request.WorkflowIds));
}
if (!DocTools.IsNullOrEmpty(request.Assignee) && !DocTools.IsNullOrEmpty(request.Assignee.Id))
{
entities = entities.Where(en => en.Assignee.Id == request.Assignee.Id);
}
if (true == request.AssigneeIds?.Any())
{
entities = entities.Where(en => en.Assignee.Id.In(request.AssigneeIds));
}
if (!DocTools.IsNullOrEmpty(request.Description))
{
entities = entities.Where(en => en.Description.Contains(request.Description));
}
if (!DocTools.IsNullOrEmpty(request.Descriptions))
{
entities = entities.Where(en => en.Description.In(request.Descriptions));
}
if (!DocTools.IsNullOrEmpty(request.Document) && !DocTools.IsNullOrEmpty(request.Document.Id))
{
entities = entities.Where(en => en.Document.Id == request.Document.Id);
}
if (true == request.DocumentIds?.Any())
{
entities = entities.Where(en => en.Document.Id.In(request.DocumentIds));
}
if (!DocTools.IsNullOrEmpty(request.DueDate))
{
entities = entities.Where(en => null != en.DueDate && request.DueDate.Value.Date == en.DueDate.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.DueDateBefore))
{
entities = entities.Where(en => en.DueDate <= request.DueDateBefore);
}
if (!DocTools.IsNullOrEmpty(request.DueDateAfter))
{
entities = entities.Where(en => en.DueDate >= request.DueDateAfter);
}
if (!DocTools.IsNullOrEmpty(request.Reporter) && !DocTools.IsNullOrEmpty(request.Reporter.Id))
{
entities = entities.Where(en => en.Reporter.Id == request.Reporter.Id);
}
if (true == request.ReporterIds?.Any())
{
entities = entities.Where(en => en.Reporter.Id.In(request.ReporterIds));
}
if (request.Status.HasValue)
{
entities = entities.Where(en => request.Status.Value == en.Status);
}
if (!DocTools.IsNullOrEmpty(request.Statuss))
{
entities = entities.Where(en => en.Status.In(request.Statuss));
}
if (request.Type.HasValue)
{
entities = entities.Where(en => request.Type.Value == en.Type);
}
if (!DocTools.IsNullOrEmpty(request.Types))
{
entities = entities.Where(en => en.Type.In(request.Types));
}
if (!DocTools.IsNullOrEmpty(request.Workflow) && !DocTools.IsNullOrEmpty(request.Workflow.Id))
{
entities = entities.Where(en => en.Workflow.Id == request.Workflow.Id);
}
if (true == request.WorkflowIds?.Any())
{
entities = entities.Where(en => en.Workflow.Id.In(request.WorkflowIds));
}
entities = ApplyFilters <DocEntityEoD, EoDSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
private IQueryable <DocEntityHelp> _ExecSearch(HelpSearch request, DocQuery query)
{
request = InitSearch <Help, HelpSearch>(request);
IQueryable <DocEntityHelp> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityHelp>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new HelpFullTextSearch(request);
entities = GetFullTextSearch <DocEntityHelp, HelpFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.HELP, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (!DocTools.IsNullOrEmpty(request.ConfluenceId))
{
entities = entities.Where(en => en.ConfluenceId.Contains(request.ConfluenceId));
}
if (!DocTools.IsNullOrEmpty(request.ConfluenceIds))
{
entities = entities.Where(en => en.ConfluenceId.In(request.ConfluenceIds));
}
if (!DocTools.IsNullOrEmpty(request.Description))
{
entities = entities.Where(en => en.Description.Contains(request.Description));
}
if (!DocTools.IsNullOrEmpty(request.Descriptions))
{
entities = entities.Where(en => en.Description.In(request.Descriptions));
}
if (!DocTools.IsNullOrEmpty(request.Icon))
{
entities = entities.Where(en => en.Icon.Contains(request.Icon));
}
if (!DocTools.IsNullOrEmpty(request.Icons))
{
entities = entities.Where(en => en.Icon.In(request.Icons));
}
if (request.Order.HasValue)
{
entities = entities.Where(en => request.Order.Value == en.Order);
}
if (true == request.PagesIds?.Any())
{
entities = entities.Where(en => en.Pages.Any(r => r.Id.In(request.PagesIds)));
}
if (true == request.ScopesIds?.Any())
{
entities = entities.Where(en => en.Scopes.Any(r => r.Id.In(request.ScopesIds)));
}
if (!DocTools.IsNullOrEmpty(request.Title))
{
entities = entities.Where(en => en.Title.Contains(request.Title));
}
if (!DocTools.IsNullOrEmpty(request.Titles))
{
entities = entities.Where(en => en.Title.In(request.Titles));
}
if (!DocTools.IsNullOrEmpty(request.Type) && !DocTools.IsNullOrEmpty(request.Type.Id))
{
entities = entities.Where(en => en.Type.Id == request.Type.Id);
}
if (true == request.TypeIds?.Any())
{
entities = entities.Where(en => en.Type.Id.In(request.TypeIds));
}
else if (!DocTools.IsNullOrEmpty(request.Type) && !DocTools.IsNullOrEmpty(request.Type.Name))
{
entities = entities.Where(en => en.Type.Name == request.Type.Name);
}
if (true == request.TypeNames?.Any())
{
entities = entities.Where(en => en.Type.Name.In(request.TypeNames));
}
entities = ApplyFilters <DocEntityHelp, HelpSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
public new static DocEntityMeanVarianceValue Get(int?primaryKey, bool noCache, DocQuery query)
{
if (!(primaryKey > 0))
{
return(null);
}
return(query.SelectAll <DocEntityMeanVarianceValue>().FirstOrDefault(e => e.Id == primaryKey.Value));
}
private IQueryable <DocEntityComment> _ExecSearch(CommentSearch request, DocQuery query)
{
request = InitSearch <Comment, CommentSearch>(request);
IQueryable <DocEntityComment> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityComment>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new CommentFullTextSearch(request);
entities = GetFullTextSearch <DocEntityComment, CommentFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.COMMENT, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (true == request.ScopesIds?.Any())
{
entities = entities.Where(en => en.Scopes.Any(r => r.Id.In(request.ScopesIds)));
}
if (!DocTools.IsNullOrEmpty(request.Text))
{
entities = entities.Where(en => en.Text.Contains(request.Text));
}
if (!DocTools.IsNullOrEmpty(request.Texts))
{
entities = entities.Where(en => en.Text.In(request.Texts));
}
if (!DocTools.IsNullOrEmpty(request.User) && !DocTools.IsNullOrEmpty(request.User.Id))
{
entities = entities.Where(en => en.User.Id == request.User.Id);
}
if (true == request.UserIds?.Any())
{
entities = entities.Where(en => en.User.Id.In(request.UserIds));
}
entities = ApplyFilters <DocEntityComment, CommentSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
