private WnbaGameDto CreateGame(WnbaShortGame wnbaShortGame)
{
Guid gameId = wnbaShortGame.GameId;
DateTime startDateTime = wnbaShortGame.StartDateTime;
Guid homeTeamId = wnbaShortGame.HomeTeamId;
Guid awayTeamId = wnbaShortGame.AwayTeamId;
TeamDto homeTeam = GetTeam(homeTeamId);
TeamDto awayTeam = GetTeam(awayTeamId);
List <PlayerDto> homePlayerList = GetPlayers(homeTeamId);
List <PlayerDto> awayPlayerList = GetPlayers(awayTeamId);
homeTeam.PlayerList = homePlayerList;
awayTeam.PlayerList = awayPlayerList;
WnbaGameDto wnbaGameDto = new WnbaGameDto
{
GameId = gameId,
StartDateTime = startDateTime,
HomeTeam = homeTeam,
AwayTeam = awayTeam
};
return(wnbaGameDto);
}
public List <WnbaGameDto> GetGames(int numberGameDays, bool loadPlayers)
{
lock (_lockObject)
{
List <WnbaShortGame> wnbaShortGameList = new List <WnbaShortGame>();
List <WnbaGameDto> wnbaGameList = new List <WnbaGameDto>();
using (NpgsqlConnection npgsqlConnection = new NpgsqlConnection(ConnectionString))
{
npgsqlConnection.Open();
const string sqlCommandText = "select * from wnba.get_games(@number_game_days)";
using (NpgsqlCommand npgsqlCommand = new NpgsqlCommand(sqlCommandText, npgsqlConnection))
{
npgsqlCommand.CommandType = CommandType.Text;
NpgsqlParameter npgsqlParameter1 = new NpgsqlParameter("number_game_days", numberGameDays);
npgsqlCommand.Parameters.Add(npgsqlParameter1);
using (NpgsqlDataReader npgsqlDataReader = npgsqlCommand.ExecuteReader())
{
if (!npgsqlDataReader.HasRows)
{
const string message = "GetGames() has no rows";
Logger.Info(message);
return(wnbaGameList);
}
while (npgsqlDataReader.Read())
{
Guid gameId = npgsqlDataReader.GetGuid("game_id");
DateTime startDateTime = npgsqlDataReader.GetDateTime("schedule");
Guid homeTeamId = npgsqlDataReader.GetGuid("home_id");
Guid awayTeamId = npgsqlDataReader.GetGuid("away_id");
WnbaShortGame wnbaShortGame = new WnbaShortGame
{
GameId = gameId,
StartDateTime = startDateTime,
HomeTeamId = homeTeamId,
AwayTeamId = awayTeamId
};
wnbaShortGameList.Add(wnbaShortGame);
}
}
}
}
foreach (WnbaShortGame wnbaShortGame in wnbaShortGameList)
{
WnbaGameDto wnbaGame = CreateGame(wnbaShortGame);
wnbaGameList.Add(wnbaGame);
}
return(wnbaGameList);
}
}
public static WnbaGame CreateWnbaGameFromWnbaGameDto(WnbaGameDto wnbaGameDto, bool loadPlayers, Container dependencyInjectionContainer)
{
WnbaGame wnbaGame = dependencyInjectionContainer.GetInstance <WnbaGame>();
wnbaGame.GameId = wnbaGameDto.GameId;
wnbaGame.StartDateTime = wnbaGameDto.StartDateTime;
wnbaGame.Started = wnbaGameDto.Started;
wnbaGame.HomeTeam = CreateTeamFromTeamDto(wnbaGameDto.HomeTeam, loadPlayers);
wnbaGame.AwayTeam = CreateTeamFromTeamDto(wnbaGameDto.AwayTeam, loadPlayers);
AssignPlayerNumbers(wnbaGame.HomeTeam.PlayerList, wnbaGame.AwayTeam.PlayerList);
return(wnbaGame);
}
