public long AddGame(Game game)
{
long id;
using (var conn = GetConnection())
{
var cmd = new MySqlCommand(INSERT_GAME, conn);
cmd.Parameters.AddWithValue("@season", game.Season);
cmd.Parameters.AddWithValue("@type", game.SeasonType);
cmd.Parameters.AddWithValue("@week", game.Week);
cmd.Parameters.AddWithValue("@gameTime", game.GameTime);
cmd.Parameters.AddWithValue("@homeTeamId", game.HomeTeam.Id);
cmd.Parameters.AddWithValue("@awayTeamId", game.AwayTeam.Id);
cmd.Parameters.AddWithValue("@awayTeamPoints", game.AwayTeamScore);
cmd.Parameters.AddWithValue("@homeTeamPoints", game.HomeTeamScore);
cmd.Parameters.AddWithValue("@winningTeamId", game.WinningTeamId);
cmd.Parameters.AddWithValue("@isGameOver", game.IsGameOver);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
id = cmd.LastInsertedId;
}
return id;
}
private Game CreateNewGame(NflDotComGame nflDotComGame, Dictionary<string, Team> teamsDictionary)
{
var game = new Game
{
AwayTeamScore = nflDotComGame.AwayScore,
GameTime = nflDotComGame.DateTime,
HomeTeamScore = nflDotComGame.HomeScore,
IsGameOver = nflDotComGame.IsFinal,
Season = nflDotComGame.Season,
Week = nflDotComGame.WeekNumber
};
if (nflDotComGame.AwayTeam != null && !String.IsNullOrWhiteSpace(nflDotComGame.AwayTeam.Abbreviation))
{
Team sportPicksTeam;
if (teamsDictionary.TryGetValue(nflDotComGame.AwayTeam.Abbreviation.ToUpper(), out sportPicksTeam))
{
game.AwayTeam = sportPicksTeam;
}
}
if (nflDotComGame.HomeTeam != null && !String.IsNullOrWhiteSpace(nflDotComGame.HomeTeam.Abbreviation))
{
Team sportPicksTeam;
if (teamsDictionary.TryGetValue(nflDotComGame.HomeTeam.Abbreviation.ToUpper(), out sportPicksTeam))
{
game.HomeTeam = sportPicksTeam;
}
}
if (nflDotComGame.Winner != null && !String.IsNullOrWhiteSpace(nflDotComGame.Winner.Abbreviation))
{
Team sportPicksTeam;
if (teamsDictionary.TryGetValue(nflDotComGame.Winner.Abbreviation.ToUpper(), out sportPicksTeam))
{
game.WinningTeamId = sportPicksTeam.Id;
}
}
return game;
}
private static bool IsGameMatchingBySeasonWeekAndParticipants(Game game, NflDotComGame nflDotComGame)
{
return game.Season == nflDotComGame.Season
&& game.Week == nflDotComGame.WeekNumber
&& game.HomeTeam.Abbreviation.ToUpper() == nflDotComGame.HomeTeam.Abbreviation.ToUpper()
&& game.AwayTeam.Abbreviation.ToUpper() == nflDotComGame.AwayTeam.Abbreviation.ToUpper();
}
public long AddGame(Game game)
{
return _gameRepository.AddGame(game);
}
private void PopulateTeamsForGame(Game game)
{
_teams = _teams ?? _teamRepository.GetAll();
game.AwayTeam = _teams.FirstOrDefault(team => team.Id == game.AwayTeam.Id);
game.HomeTeam = _teams.FirstOrDefault(team => team.Id == game.HomeTeam.Id);
}
public void UpdateGame(Game game)
{
_gameRepository.UpdateGame(game);
}
private static bool IsGameMatchingBySeasonWeekTypeAndParticipants(Game game, FantasyDataGame fantasyDataGame)
{
return game.Season == fantasyDataGame.Season
&& (int) game.SeasonType == fantasyDataGame.SeasonType
&& game.Week == fantasyDataGame.Week
&& game.HomeTeam.Abbreviation.ToUpper() == fantasyDataGame.HomeTeam.ToUpper()
&& game.AwayTeam.Abbreviation.ToUpper() == fantasyDataGame.AwayTeam.ToUpper();
}
private static Game CreateNewGame(FantasyDataGame fantasyDataGame, Dictionary<string, Team> teamsDictionary)
{
var game = new Game
{
AwayTeamScore = fantasyDataGame.AwayScore,
GameTime = fantasyDataGame.Date,
HomeTeamScore = fantasyDataGame.HomeScore,
IsGameOver = fantasyDataGame.IsOver,
Season = fantasyDataGame.Season,
SeasonType = (SeasonType) fantasyDataGame.SeasonType,
Week = fantasyDataGame.Week
};
if (!String.IsNullOrWhiteSpace(fantasyDataGame.AwayTeam))
{
Team sportPicksTeam;
if (teamsDictionary.TryGetValue(fantasyDataGame.AwayTeam.ToUpper(), out sportPicksTeam))
{
game.AwayTeam = sportPicksTeam;
}
}
if (!String.IsNullOrWhiteSpace(fantasyDataGame.HomeTeam))
{
Team sportPicksTeam;
if (teamsDictionary.TryGetValue(fantasyDataGame.HomeTeam.ToUpper(), out sportPicksTeam))
{
game.HomeTeam = sportPicksTeam;
}
}
if (fantasyDataGame.WinningTeam != null && !String.IsNullOrWhiteSpace(fantasyDataGame.WinningTeam))
{
Team sportPicksTeam;
if (teamsDictionary.TryGetValue(fantasyDataGame.WinningTeam.ToUpper(), out sportPicksTeam))
{
game.WinningTeamId = sportPicksTeam.Id;
}
}
return game;
}
private static Game MapGame(MySqlDataReader dr)
{
var game = new Game
{
AwayTeam = new Team
{
Id = dr.GetInt32("awayTeamId"),
},
GameTime = dr.GetDateTime("gameTime"),
HomeTeam = new Team
{
Id = dr.GetInt32("homeTeamId")
},
Id = dr.GetInt64("id"),
IsGameOver = dr.GetBoolean("isGameOver"),
Season = dr.GetInt32("season"),
SeasonType = (SeasonType) dr.GetInt32("type"),
Week = dr.GetInt32("week")
};
if (dr["awayTeamPoints"] != DBNull.Value)
{
game.AwayTeamScore = dr.GetInt32("awayTeamPoints");
}
if (dr["homeTeamPoints"] != DBNull.Value)
{
game.HomeTeamScore = dr.GetInt32("homeTeamPoints");
}
if (dr["winningTeamId"] != DBNull.Value)
{
game.WinningTeamId = dr.GetInt32("winningTeamId");
}
game.GameTime = game.GameTime.AddDays(ConfigSettings.GameTimeOffSetInDays);
return game;
}
public void UpdateGame(Game game)
{
using (var conn = GetConnection())
{
var cmd = new MySqlCommand(UPDATE_GAME, conn);
cmd.Parameters.AddWithValue("@season", game.Season);
cmd.Parameters.AddWithValue("@week", game.Week);
cmd.Parameters.AddWithValue("@type", game.SeasonType);
cmd.Parameters.AddWithValue("@gameTime", game.GameTime);
cmd.Parameters.AddWithValue("@homeTeamId", game.HomeTeam.Id);
cmd.Parameters.AddWithValue("@awayTeamId", game.AwayTeam.Id);
cmd.Parameters.AddWithValue("@awayTeamPoints", game.AwayTeamScore);
cmd.Parameters.AddWithValue("@homeTeamPoints", game.HomeTeamScore);
cmd.Parameters.AddWithValue("@winningTeamId", game.WinningTeamId);
cmd.Parameters.AddWithValue("@isGameOver", game.IsGameOver);
cmd.Parameters.AddWithValue("@id", game.Id);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
private static List<Game> CreateGames(int? winningTeamId)
{
var games = new List<Game>();
var game = new Game
{
AwayTeam = new Team
{
Id = AWAY_TEAM_ID
},
HomeTeam = new Team
{
Id = HOME_TEAM_ID
},
IsGameOver = true,
WinningTeamId = winningTeamId
};
games.Add(game);
return games;
}