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); }