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