public int Count(ScoreCardFilter filter) { var query = this.DbContext.ValuationScoreCards.AsQueryable(); if (filter.State.HasValue) { query = query.Where(v => v.State == filter.State.Value); } return(query.Count()); }
public IPagedList <ValuationScoreCard> FindForUser(ScoreCardFilter filter) { var query = this.DbContext.ValuationScoreCards .Include(s => s.Journal) .Where(s => s.UserProfileId == filter.UserProfileId); if (filter.State.HasValue) { query = query.Where(s => s.State == filter.State); } return(query.OrderByDescending(s => s.DatePublished).ToPagedList(filter.PageNumber, filter.PageSize)); }
public IPagedList <ValuationScoreCard> Find(ScoreCardFilter filter) { var query = this.DbContext.ValuationScoreCards .Include(s => s.UserProfile) .Where(s => s.JournalId == filter.JournalId) .Where(s => s.State == ScoreCardState.Published); if (filter.RequireComment) { query = query.Where(s => s.Remarks != null); } return(query.OrderByDescending(s => s.DatePublished).ToPagedList(filter.PageNumber, filter.PageSize)); }
public async Task <IActionResult> Get([FromQuery] ScoreCardFilter scoreCardFilter) { var result = await _searchService.Get(scoreCardFilter.UnitId, scoreCardFilter.Query, scoreCardFilter.Skip, scoreCardFilter.Take); return(Ok(result)); }