public async Task <DeckSearchResult> Search(DeckSearchCriteria 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("@PageSize", searchCriteria.PageSize));
sqlParameters.Add(new SqlParameter("@PageIndex", searchCriteria.PageIndex));
response.Decks = await _dbContext.DeckDetail.FromSql(DeckSearchQuery, sqlParameters.ToArray()).ToListAsync();
response.TotalRecords = (int)totalRowsCount.Value;
return(response);
}
public Task <DeckSearchResult> Search(DeckSearchCriteria searchCriteria)
{
return(_deckRepository.Search(searchCriteria));
}
