public List <WorldCupPlayer> SearchWorldCupPlayers(WorldCupPlayerSearch criteria) { LogInformation($"Searching World Cup Players for criteria: {JsonSerialize(criteria)}"); var parameters = new DynamicParameters(); parameters.Add(SQL.WorldCupPlayerID, criteria.WorldCupPlayerID, DbType.Int32); parameters.Add(SQL.TeamID, criteria.TeamID, DbType.Int32); parameters.Add(SQL.DateOfBirthRangeBegin, criteria.DateOfBirthRangeBegin, DbType.Date); parameters.Add(SQL.DateOfBirthRangeEnd, criteria.DateOfBirthRangeEnd, DbType.Date); parameters.Add(SQL.IncludeArchived, criteria.IncludeArchived, DbType.Boolean); parameters.Add(SQL.Rows, criteria.Rows, DbType.Int32); parameters.Add(SQL.Page, criteria.Page, DbType.Int32); using (var con = new SqlConnection(GetBaseConnection())) { using (var response = con.QueryMultiple( SQL.GetWorldCupPlayer, parameters, commandType: CommandType.StoredProcedure)) { return(response.Read <WorldCupPlayer>().AsList()); } } }
public IEnumerable <WorldCupPlayer> Search([FromBody] WorldCupPlayerSearch criteria) { LogInformation($"Searching World Cup Players for criteria: {JsonSerialize(criteria)}"); if (criteria == null) { throw new InvalidOperationException("Criteria cannot be null"); } return(WorldCupPlayerDataService.SearchWorldCupPlayers(criteria)); }