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