public async Task <IEnumerable <ISearchResult> > SearchTeams(string searchText, DateTime viewDate) { var teamGroups = await TeamNames .Where(w => w.Description.Contains(searchText.Trim()) && w.TeamV.IsActive) .Select(s => s.TeamV) .GroupBy(g => g.HeaderKey).ToListAsync(); var teamVs = new List <TeamV>(); foreach (var teamGroup in teamGroups) { teamVs.Add(teamGroup.OrderByDescending(t => t.EffectiveFrom).First()); } return(teamVs.ToViewModels(viewDate).Cast <ISearchResult>()); }
public async Task <IEnumerable <string> > GetTeamAutoCompleteList(Guid userId, bool isAdmin, string searchText) { var teams = await TeamNames.Where(w => w.Description.Contains(searchText.Trim()) && w.TeamV.IsActive).ToListAsync(); return(teams.Select(s => s.Description).Distinct().OrderBy(o => o)); }