public async Task <DeckSearchResult> Search(DeckSearchByUserIdCriteria searchCriteria) { var response = new DeckSearchResult(); var sqlParameters = new List <object>(); var totalRowsCount = new SqlParameter { ParameterName = "TotalRowsCount", Value = 0, Direction = ParameterDirection.Output }; sqlParameters.Add(totalRowsCount); sqlParameters.Add(new SqlParameter("@SearchTerm", (object)searchCriteria.SearchTerm ?? DBNull.Value)); sqlParameters.Add(new SqlParameter("@UserId", searchCriteria.UserId)); sqlParameters.Add(new SqlParameter("@PageSize", searchCriteria.PageSize)); sqlParameters.Add(new SqlParameter("@PageIndex", searchCriteria.PageIndex)); response.Decks = await _dbContext.DeckDetail.FromSql(DeckSearchByUserIdQuery, sqlParameters.ToArray()).ToListAsync(); response.TotalRecords = (int)totalRowsCount.Value; return(response); }
public Task <DeckSearchResult> Search(DeckSearchByUserIdCriteria searchCriteria) { return(_deckRepository.Search(searchCriteria)); }