public static List <MlbGameSummaryModel> UpdateSeasonForTeam(MlbSeasonType mlbSeasonType, MlbTeamShortName mlbTeam, int seasonYear)
{
// Get latest results
List <MlbGameSummaryModel> gamesToAdd = MlbAttendanceQuery.GetSeasonForTeam(mlbSeasonType, mlbTeam, seasonYear);
// Remove existing results from DB and save new ones
using (SportsDataContext db = new SportsDataContext())
{
string mlbTeamString = mlbTeam.ToString(); // http://stackoverflow.com/questions/5899683/linq-to-entities-does-not-recognize-the-method-system-string-tostring-method
var gamesToRemove = from g in db.MlbGameSummaryModel_DbSet
where g.MlbSeasonType == mlbSeasonType &&
g.Year == seasonYear &&
g.Home.Equals(mlbTeamString, StringComparison.InvariantCultureIgnoreCase)
select g;
foreach (MlbGameSummaryModel gameToRemove in gamesToRemove)
{
db.MlbGameSummaryModel_DbSet.Remove(gameToRemove);
}
if (null != gamesToAdd)
{
foreach (MlbGameSummaryModel gameToAdd in gamesToAdd)
{
db.MlbGameSummaryModel_DbSet.Add(gameToAdd);
}
}
db.SaveChanges();
}
return(gamesToAdd);
}
public static List<MlbGameSummaryModel> UpdateSeasonForTeam(MlbSeasonType mlbSeasonType, MlbTeamShortName mlbTeam, int seasonYear)
{
// Get latest results
List<MlbGameSummaryModel> gamesToAdd = MlbAttendanceQuery.GetSeasonForTeam(mlbSeasonType, mlbTeam, seasonYear);
// Remove existing results from DB and save new ones
using (SportsDataContext db = new SportsDataContext())
{
string mlbTeamString = mlbTeam.ToString(); // http://stackoverflow.com/questions/5899683/linq-to-entities-does-not-recognize-the-method-system-string-tostring-method
var gamesToRemove = from g in db.MlbGameSummaryModel_DbSet
where g.MlbSeasonType == mlbSeasonType &&
g.Year == seasonYear &&
g.Home.Equals(mlbTeamString, StringComparison.InvariantCultureIgnoreCase)
select g;
foreach (MlbGameSummaryModel gameToRemove in gamesToRemove)
{
db.MlbGameSummaryModel_DbSet.Remove(gameToRemove);
}
if (null != gamesToAdd)
{
foreach (MlbGameSummaryModel gameToAdd in gamesToAdd)
{
db.MlbGameSummaryModel_DbSet.Add(gameToAdd);
}
}
db.SaveChanges();
}
return gamesToAdd;
}
public static List<MlbGameSummaryModel> GetSeasonForTeam(MlbSeasonType mlbSeasonType, MlbTeamShortName mlbTeam, int seasonYear)
{
string relativeUrl;
List<MlbGameSummaryModel> results;
switch (mlbSeasonType)
{
case MlbSeasonType.Spring:
relativeUrl = String.Format(MlbAttendanceQuery.preSeasonFormatString, mlbTeam.ToString(), seasonYear);
results = MlbAttendanceQuery.GetPage(relativeUrl, mlbTeam, seasonYear);
break;
case MlbSeasonType.Regular:
// Collect first half of the season
relativeUrl = String.Format(MlbAttendanceQuery.regSeasonFormatString, mlbTeam.ToString(), seasonYear, 1);
List<MlbGameSummaryModel> firstHalf = MlbAttendanceQuery.GetPage(relativeUrl, mlbTeam, seasonYear);
// Collect second half of the season
relativeUrl = String.Format(MlbAttendanceQuery.regSeasonFormatString, mlbTeam.ToString(), seasonYear, 2);
List<MlbGameSummaryModel> secondHalf = MlbAttendanceQuery.GetPage(relativeUrl, mlbTeam, seasonYear);
// Merge them together
results = new List<MlbGameSummaryModel>();
results.AddRange(firstHalf);
results.AddRange(secondHalf);
break;
case MlbSeasonType.PostSeason:
relativeUrl = String.Format(MlbAttendanceQuery.postSeasonFormatString, mlbTeam.ToString(), seasonYear);
results = MlbAttendanceQuery.GetPage(relativeUrl, mlbTeam, seasonYear);
break;
default:
throw new ArgumentException(String.Format("Unrecognized season type {0}", mlbSeasonType.ToString()));
}
// Add the season type and year to every item
if (null != results)
{
results.ForEach(x =>
{
x.MlbSeasonType = mlbSeasonType;
x.Year = seasonYear;
});
}
return results;
}
private static void DetermineHomeAndAway(HtmlNode gameStatusNode, MlbTeamShortName mlbTeam, string opponentTeamCity, ref MlbGameSummaryModel game)
{
//Figure out home/away teams and then return
if (gameStatusNode.InnerText.Equals("vs", StringComparison.InvariantCultureIgnoreCase))
{
// home game for mlbTeam
game.Home = mlbTeam.ToString();
string shortName = MlbAttendanceQuery.LookupShortName(opponentTeamCity);
game.Visitor = String.IsNullOrWhiteSpace(shortName) ? opponentTeamCity : shortName;
}
else if (gameStatusNode.InnerText.Equals("@", StringComparison.InvariantCultureIgnoreCase))
{
// away game for mlbTeam
string shortName = MlbAttendanceQuery.LookupShortName(opponentTeamCity);
game.Home = String.IsNullOrWhiteSpace(shortName) ? opponentTeamCity : shortName;
game.Visitor = mlbTeam.ToString();
}
}
public void Mlb_UpdateRegularSeasonForTeamTest()
{
MlbSeasonType seasonType = MlbSeasonType.Regular;
MlbTeamShortName teamName = MlbTeamShortName.SD;
int seasonYear = 2005;
List <MlbGameSummaryModel> result = MlbAttendanceData.UpdateSeasonForTeam(seasonType, teamName, seasonYear);
Assert.AreEqual(81, result.Count, "Verify that there are 81 home games returned");
using (SportsDataContext db = new SportsDataContext())
{
string teamNameString = teamName.ToString(); // http://stackoverflow.com/questions/5899683/linq-to-entities-does-not-recognize-the-method-system-string-tostring-method
Assert.AreEqual(81, db.MlbGameSummaryModel_DbSet.Where(g => g.MlbSeasonType == seasonType &&
g.Home.Equals(teamNameString, StringComparison.InvariantCultureIgnoreCase) &&
g.Year == seasonYear).Count(),
"Verify that there are 81 games in the db");
}
}
private static void DetermineHomeAndAway(HtmlNode gameStatusNode, MlbTeamShortName mlbTeam, string opponentTeamCity, ref MlbGameSummaryModel game)
{
//Figure out home/away teams and then return
if (gameStatusNode.InnerText.Equals("vs", StringComparison.InvariantCultureIgnoreCase))
{
// home game for mlbTeam
game.Home = mlbTeam.ToString();
string shortName = MlbAttendanceQuery.LookupShortName(opponentTeamCity);
game.Visitor = String.IsNullOrWhiteSpace(shortName) ? opponentTeamCity : shortName;
}
else if (gameStatusNode.InnerText.Equals("@", StringComparison.InvariantCultureIgnoreCase))
{
// away game for mlbTeam
string shortName = MlbAttendanceQuery.LookupShortName(opponentTeamCity);
game.Home = String.IsNullOrWhiteSpace(shortName) ? opponentTeamCity : shortName;
game.Visitor = mlbTeam.ToString();
}
}
private static MlbGameSummaryModel ParseRow(HtmlNodeCollection columns, MlbTeamShortName mlbTeam, int seasonYear, bool includeHomeGamesOnly = true)
{
MlbGameSummaryModel game = new MlbGameSummaryModel();
// Check if this is a home or away game and if we should proceed parsing
HtmlNode gameStatusNode = columns[1].SelectSingleNode(@".//li[@class='game-status']");
if (gameStatusNode.InnerText.Equals("@") && includeHomeGamesOnly)
{
// This is an away game and we don't want to include away games so return null
return null;
}
// Game Date
HtmlNode dateNode = columns[0];
DateTime date = Convert.ToDateTime(dateNode.InnerText + " " + seasonYear);
game.Date = date;
if (date >= DateTime.Now.Date) // Don't retrieve games from today or future
{
return null;
}
// Determine the Opponent
HtmlNode opponentNode = columns[1];
HtmlNode opponentTeamNode = opponentNode.SelectSingleNode(@".//li[@class='team-name']");
string opponentTeamCity = opponentTeamNode.InnerText;
// Check if the game was postponed
if (columns[2].InnerText.Equals("postponed", StringComparison.InvariantCultureIgnoreCase) || columns[3].InnerText.Equals("delayed", StringComparison.InvariantCultureIgnoreCase) || columns[3].InnerText.Equals("suspended", StringComparison.InvariantCultureIgnoreCase))
{
// The game was postponed. Figure out home/away teams and then return
game.Postponed = true;
MlbAttendanceQuery.DetermineHomeAndAway(gameStatusNode, mlbTeam, opponentTeamCity, ref game);
return game;
}
else
{
game.Postponed = false;
}
// Game Result
HtmlNode gameResultNode = columns[2];
HtmlNode scoreNode = gameResultNode.SelectSingleNode(@".//li[contains(@class,'score')]");
// Check if the score can be parsed out and if not then return
if (null == scoreNode)
{
MlbAttendanceQuery.DetermineHomeAndAway(gameStatusNode, mlbTeam, opponentTeamCity, ref game);
return game;
}
// Check if there were extra innings
string score = scoreNode.InnerText;
string fToken = "f/"; // This string implies there were extra innings
int fIndex = score.IndexOf(fToken, StringComparison.InvariantCultureIgnoreCase);
if (fIndex >= 0)
{
game.Innings = Convert.ToInt32(score.Substring(fIndex + fToken.Length));
score = score.Substring(0, fIndex).Trim();
}
else
{
game.Innings = 9;
}
int winningScore;
int losingScore;
try
{
winningScore = score.Split('-').Max(x => Convert.ToInt32(x));
losingScore = score.Split('-').Min(x => Convert.ToInt32(x));
}
catch (FormatException)
{
winningScore = 0;
losingScore = 0;
MlbAttendanceQuery.DetermineHomeAndAway(gameStatusNode, mlbTeam, opponentTeamCity, ref game);
return game;
}
// Figure out if the home team won or lost
HtmlNode winLossNode = gameResultNode.SelectSingleNode(@".//li[contains(@class,'game-status')]");
int mlbTeamScore;
int opponentScore;
if (winLossNode.Attributes["class"].Value.IndexOf("win", StringComparison.InvariantCultureIgnoreCase) >= 0) // case-insensitive 'contains'
{
mlbTeamScore = winningScore;
opponentScore = losingScore;
}
else if (winLossNode.Attributes["class"].Value.IndexOf("loss", StringComparison.InvariantCultureIgnoreCase) >= 0) // case-insensitive 'contains'
{
mlbTeamScore = losingScore;
opponentScore = winningScore;
}
else if (winLossNode.Attributes["class"].Value.IndexOf("tie", StringComparison.InvariantCultureIgnoreCase) >= 0) // case-insensitive 'contains'
{
mlbTeamScore = winningScore;
opponentScore = winningScore;
}
else
{
throw new Exception("Could not determine win or loss");
}
// Get Win-Loss record for mlbTeam
HtmlNode winLossRecordNode = columns[3];
string[] winLossRecord = winLossRecordNode.InnerText.Split('-');
if (null != winLossRecord && winLossRecord.Length == 2)
{
game.WinsToDate = Convert.ToInt32(winLossRecord[0]);
game.LossesToDate = Convert.ToInt32(winLossRecord[1]);
}
else
{
// do not set any values since we couldn't parse out the win-loss record
}
// Get pitchers
HtmlNode winningPitcherNode = columns[4].SelectSingleNode(@".//a");
game.WPitcher = winningPitcherNode != null ? winningPitcherNode.InnerText : null;
HtmlNode losingPitcherNode = columns[5].SelectSingleNode(@".//a");
game.LPitcher = losingPitcherNode != null ? losingPitcherNode.InnerText : null;
HtmlNode savingPitcherNode = columns[6].SelectSingleNode(@".//a");
game.SavePitcher = savingPitcherNode != null ? savingPitcherNode.InnerText : null;
// Determine home and away teams and which was the winner or loser
// Note: gameStatusNode was initialized at the start of the method
if (gameStatusNode.InnerText.Equals("vs", StringComparison.InvariantCultureIgnoreCase))
{
// home game for mlbTeam
game.Home = mlbTeam.ToString();
game.HomeScore = mlbTeamScore;
string shortName = MlbAttendanceQuery.LookupShortName(opponentTeamCity);
game.Visitor = String.IsNullOrWhiteSpace(shortName) ? opponentTeamCity : shortName;
game.VisitorScore = opponentScore;
}
else if (gameStatusNode.InnerText.Equals("@", StringComparison.InvariantCultureIgnoreCase))
{
// away game for mlbTeam
string shortName = MlbAttendanceQuery.LookupShortName(opponentTeamCity);
game.Home = String.IsNullOrWhiteSpace(shortName) ? opponentTeamCity : shortName;
game.HomeScore = opponentScore;
game.Visitor = mlbTeam.ToString();
game.VisitorScore = mlbTeamScore;
}
// Get Attendance Data
HtmlNode attendanceNode = columns[7];
int attendance = 0;
Int32.TryParse(attendanceNode.InnerText, NumberStyles.AllowThousands, CultureInfo.InvariantCulture, out attendance);
game.Attendance = attendance;
return game;
}
public static List <MlbGameSummaryModel> GetSeasonForTeam(MlbSeasonType mlbSeasonType, MlbTeamShortName mlbTeam, int seasonYear)
{
string relativeUrl;
List <MlbGameSummaryModel> results;
switch (mlbSeasonType)
{
case MlbSeasonType.Spring:
relativeUrl = String.Format(MlbAttendanceQuery.preSeasonFormatString, mlbTeam.ToString(), seasonYear);
results = MlbAttendanceQuery.GetPage(relativeUrl, mlbTeam, seasonYear);
break;
case MlbSeasonType.Regular:
// Collect first half of the season
relativeUrl = String.Format(MlbAttendanceQuery.regSeasonFormatString, mlbTeam.ToString(), seasonYear, 1);
List <MlbGameSummaryModel> firstHalf = MlbAttendanceQuery.GetPage(relativeUrl, mlbTeam, seasonYear);
// Collect second half of the season
relativeUrl = String.Format(MlbAttendanceQuery.regSeasonFormatString, mlbTeam.ToString(), seasonYear, 2);
List <MlbGameSummaryModel> secondHalf = MlbAttendanceQuery.GetPage(relativeUrl, mlbTeam, seasonYear);
// Merge them together
results = new List <MlbGameSummaryModel>();
results.AddRange(firstHalf);
results.AddRange(secondHalf);
break;
case MlbSeasonType.PostSeason:
relativeUrl = String.Format(MlbAttendanceQuery.postSeasonFormatString, mlbTeam.ToString(), seasonYear);
results = MlbAttendanceQuery.GetPage(relativeUrl, mlbTeam, seasonYear);
break;
default:
throw new ArgumentException(String.Format("Unrecognized season type {0}", mlbSeasonType.ToString()));
}
// Add the season type and year to every item
if (null != results)
{
results.ForEach(x =>
{
x.MlbSeasonType = mlbSeasonType;
x.Year = seasonYear;
});
}
return(results);
}
private static MlbGameSummaryModel ParseRow(HtmlNodeCollection columns, MlbTeamShortName mlbTeam, int seasonYear, bool includeHomeGamesOnly = true)
{
MlbGameSummaryModel game = new MlbGameSummaryModel();
// Check if this is a home or away game and if we should proceed parsing
HtmlNode gameStatusNode = columns[1].SelectSingleNode(@".//li[@class='game-status']");
if (gameStatusNode.InnerText.Equals("@") && includeHomeGamesOnly)
{
// This is an away game and we don't want to include away games so return null
return(null);
}
// Game Date
HtmlNode dateNode = columns[0];
DateTime date = Convert.ToDateTime(dateNode.InnerText + " " + seasonYear);
game.Date = date;
if (date >= DateTime.Now.Date) // Don't retrieve games from today or future
{
return(null);
}
// Determine the Opponent
HtmlNode opponentNode = columns[1];
HtmlNode opponentTeamNode = opponentNode.SelectSingleNode(@".//li[@class='team-name']");
string opponentTeamCity = opponentTeamNode.InnerText;
// Check if the game was postponed
if (columns[2].InnerText.Equals("postponed", StringComparison.InvariantCultureIgnoreCase) || columns[3].InnerText.Equals("delayed", StringComparison.InvariantCultureIgnoreCase) || columns[3].InnerText.Equals("suspended", StringComparison.InvariantCultureIgnoreCase))
{
// The game was postponed. Figure out home/away teams and then return
game.Postponed = true;
MlbAttendanceQuery.DetermineHomeAndAway(gameStatusNode, mlbTeam, opponentTeamCity, ref game);
return(game);
}
else
{
game.Postponed = false;
}
// Game Result
HtmlNode gameResultNode = columns[2];
HtmlNode scoreNode = gameResultNode.SelectSingleNode(@".//li[contains(@class,'score')]");
// Check if the score can be parsed out and if not then return
if (null == scoreNode)
{
MlbAttendanceQuery.DetermineHomeAndAway(gameStatusNode, mlbTeam, opponentTeamCity, ref game);
return(game);
}
// Check if there were extra innings
string score = scoreNode.InnerText;
string fToken = "f/"; // This string implies there were extra innings
int fIndex = score.IndexOf(fToken, StringComparison.InvariantCultureIgnoreCase);
if (fIndex >= 0)
{
game.Innings = Convert.ToInt32(score.Substring(fIndex + fToken.Length));
score = score.Substring(0, fIndex).Trim();
}
else
{
game.Innings = 9;
}
int winningScore;
int losingScore;
try
{
winningScore = score.Split('-').Max(x => Convert.ToInt32(x));
losingScore = score.Split('-').Min(x => Convert.ToInt32(x));
}
catch (FormatException)
{
winningScore = 0;
losingScore = 0;
MlbAttendanceQuery.DetermineHomeAndAway(gameStatusNode, mlbTeam, opponentTeamCity, ref game);
return(game);
}
// Figure out if the home team won or lost
HtmlNode winLossNode = gameResultNode.SelectSingleNode(@".//li[contains(@class,'game-status')]");
int mlbTeamScore;
int opponentScore;
if (winLossNode.Attributes["class"].Value.IndexOf("win", StringComparison.InvariantCultureIgnoreCase) >= 0) // case-insensitive 'contains'
{
mlbTeamScore = winningScore;
opponentScore = losingScore;
}
else if (winLossNode.Attributes["class"].Value.IndexOf("loss", StringComparison.InvariantCultureIgnoreCase) >= 0) // case-insensitive 'contains'
{
mlbTeamScore = losingScore;
opponentScore = winningScore;
}
else if (winLossNode.Attributes["class"].Value.IndexOf("tie", StringComparison.InvariantCultureIgnoreCase) >= 0) // case-insensitive 'contains'
{
mlbTeamScore = winningScore;
opponentScore = winningScore;
}
else
{
throw new Exception("Could not determine win or loss");
}
// Get Win-Loss record for mlbTeam
HtmlNode winLossRecordNode = columns[3];
string[] winLossRecord = winLossRecordNode.InnerText.Split('-');
if (null != winLossRecord && winLossRecord.Length == 2)
{
game.WinsToDate = Convert.ToInt32(winLossRecord[0]);
game.LossesToDate = Convert.ToInt32(winLossRecord[1]);
}
else
{
// do not set any values since we couldn't parse out the win-loss record
}
// Get pitchers
HtmlNode winningPitcherNode = columns[4].SelectSingleNode(@".//a");
game.WPitcher = winningPitcherNode != null ? winningPitcherNode.InnerText : null;
HtmlNode losingPitcherNode = columns[5].SelectSingleNode(@".//a");
game.LPitcher = losingPitcherNode != null ? losingPitcherNode.InnerText : null;
HtmlNode savingPitcherNode = columns[6].SelectSingleNode(@".//a");
game.SavePitcher = savingPitcherNode != null ? savingPitcherNode.InnerText : null;
// Determine home and away teams and which was the winner or loser
// Note: gameStatusNode was initialized at the start of the method
if (gameStatusNode.InnerText.Equals("vs", StringComparison.InvariantCultureIgnoreCase))
{
// home game for mlbTeam
game.Home = mlbTeam.ToString();
game.HomeScore = mlbTeamScore;
string shortName = MlbAttendanceQuery.LookupShortName(opponentTeamCity);
game.Visitor = String.IsNullOrWhiteSpace(shortName) ? opponentTeamCity : shortName;
game.VisitorScore = opponentScore;
}
else if (gameStatusNode.InnerText.Equals("@", StringComparison.InvariantCultureIgnoreCase))
{
// away game for mlbTeam
string shortName = MlbAttendanceQuery.LookupShortName(opponentTeamCity);
game.Home = String.IsNullOrWhiteSpace(shortName) ? opponentTeamCity : shortName;
game.HomeScore = opponentScore;
game.Visitor = mlbTeam.ToString();
game.VisitorScore = mlbTeamScore;
}
// Get Attendance Data
HtmlNode attendanceNode = columns[7];
int attendance = 0;
Int32.TryParse(attendanceNode.InnerText, NumberStyles.AllowThousands, CultureInfo.InvariantCulture, out attendance);
game.Attendance = attendance;
return(game);
}