public void Delete(RatingSearch request) { var matches = Get(request) as List <Rating>; if (true != matches?.Any()) { throw new HttpError(HttpStatusCode.NotFound, "No matches for request"); } matches.ForEach(match => { Delete(match); }); }
public PagedResponse <ReadRatingDto> Execute(RatingSearch search) { var query = _context.Ratings.AsQueryable(); if (!string.IsNullOrEmpty(search.UserEmail) || !string.IsNullOrWhiteSpace(search.UserEmail)) { query = query.Where(x => x.User.Email.ToLower().Contains(search.UserEmail.ToLower())); } if (!string.IsNullOrEmpty(search.PostTitle) || !string.IsNullOrWhiteSpace(search.PostTitle)) { query = query.Where(x => x.Post.Title.ToLower().Contains(search.PostTitle.ToLower())); } if (search.MinRatingValue != null) { query = query.Where(x => x.Value >= search.MinRatingValue); } if (search.MaxRatingValue != null) { query = query.Where(x => x.Value <= search.MaxRatingValue); } var skipCount = search.PerPage * (search.Page - 1); var response = new PagedResponse <ReadRatingDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new ReadRatingDto { Id = x.Id, Value = x.Value, UserEmail = x.User.Email, UserId = x.User.Id, PostId = x.Post.Id, PostTitle = x.Post.Title }).ToList() }; return(response); }
private IQueryable <DocEntityRating> _ExecSearch(RatingSearch request, DocQuery query) { request = InitSearch <Rating, RatingSearch>(request); IQueryable <DocEntityRating> entities = null; query.Run(session => { entities = query.SelectAll <DocEntityRating>(); if (!DocTools.IsNullOrEmpty(request.FullTextSearch)) { var fts = new RatingFullTextSearch(request); entities = GetFullTextSearch <DocEntityRating, RatingFullTextSearch>(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.RATING, 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 (request.Rating.HasValue) { entities = entities.Where(en => request.Rating.Value == en.Rating); } if (!DocTools.IsNullOrEmpty(request.Ratings)) { entities = entities.Where(en => en.Rating.In(request.Ratings)); } if (request.ReasonRejected.HasValue) { entities = entities.Where(en => request.ReasonRejected.Value == en.ReasonRejected); } if (!DocTools.IsNullOrEmpty(request.ReasonRejecteds)) { entities = entities.Where(en => en.ReasonRejected.In(request.ReasonRejecteds)); } 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)); } entities = ApplyFilters <DocEntityRating, RatingSearch>(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 object Get(RatingSearch request) => GetSearchResultWithCache <Rating, DocEntityRating, RatingSearch>(DocConstantModelName.RATING, request, _ExecSearch);
public object Post(RatingSearch request) => Get(request);
public IActionResult Get([FromQuery] RatingSearch search, [FromServices] IGetRatingsQuery query) { return(Ok(_executor.ExecuteQuery(query, search))); }