private void UpdateStatistics(YahooLeague myLeague, int iTeam, List<int> aPlayers, DateTime currentDate)
{
XmlDocument oDoc = new XmlDocument();
XmlNamespaceManager nsmgr = new XmlNamespaceManager(oDoc.NameTable);
nsmgr.AddNamespace("yahoo", "http://fantasysports.yahooapis.com/fantasy/v2/base.rng");
foreach (int myPlayer in aPlayers)
{
int iAtBats = 0, iRuns = 0, iHits = 0, iHR = 0, iRBI = 0, iSB = 0, iSF = 0, iBB = 0, iHBP = 0;
int iWin = 0, iSave = 0, iOuts = 0, iHitsAllowed = 0, iER = 0, iWalks = 0, iK = 0;
string sURL = m_pOAuthClass.GenerateURL("http://fantasysports.yahooapis.com/fantasy/v2/player/mlb.p." + myPlayer.ToString() + "/stats;type=date;date=" + currentDate.ToString("yyyy-MM-dd"), m_sConsumerKey, m_sSignature, m_sFullOauth_token, m_sFullOauth_token_secret);
WebClient myClient = new WebClient();
string sContents = myClient.DownloadString(sURL);
oDoc.LoadXml(sContents);
XmlElement oRootNode = (XmlElement)oDoc.ChildNodes[1]; //(XmlElement)oDoc.SelectSingleNode("/fantasy_content/users/user/games/game/leagues");
XmlElement oStats = (XmlElement)oRootNode.SelectSingleNode("descendant::yahoo:player/yahoo:player_stats/yahoo:stats", nsmgr);
if (oStats != null)
{
XmlNodeList oStatList = oStats.SelectNodes("descendant::yahoo:stat", nsmgr);
foreach (XmlElement myElement in oStatList)
{
XmlElement oStat = (XmlElement)myElement.SelectSingleNode("descendant::yahoo:stat_id", nsmgr);
XmlElement oValue = (XmlElement)myElement.SelectSingleNode("descendant::yahoo:value", nsmgr);
if (oValue.InnerText != "-")
{
if (oStat.InnerText == "6")
iAtBats = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "7")
iRuns = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "8")
iHits = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "12")
iHR = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "13")
iRBI = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "15")
iSF = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "16")
iSB = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "18")
iBB = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "20")
iHBP = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "28")
iWin = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "32")
iSave = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "33")
iOuts = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "34")
iHitsAllowed = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "37")
iER = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "39")
iWalks = Convert.ToInt32(oValue.InnerText);
else if (oStat.InnerText == "42")
iK = Convert.ToInt32(oValue.InnerText);
}
}
}
string sSql = "INSERT INTO tblStatistics (LeagueID, TeamID, PlayerID, StatsDate, AtBats, " +
"Runs, Hits, HR, RBI, SB, SF, BB, HBP, Wins, Saves, Outs, HitsAllowed, " +
"EarnedRuns, Walks, Strikeouts) VALUES (?, ?, " +
"?, ?, ?, ?, ?, ?, ?, ?, ?, " +
"?, ?, ?, ?, ?, ?, ?, ?, ?)";
//OleDbCommand pCommand = new OleDbCommand(sSql, m_pConnection);
//pCommand.Parameters.Add(new OleDbParameter("@LeagueID", myLeague.LeagueId));
//pCommand.Parameters.Add(new OleDbParameter("@TeamID", iTeam));
//pCommand.Parameters.Add(new OleDbParameter("@PlayerID", myPlayer));
//pCommand.Parameters.Add(new OleDbParameter("@StatsDate", currentDate.ToShortDateString()));
//pCommand.Parameters.Add(new OleDbParameter("@AtBats", iAtBats));
//pCommand.Parameters.Add(new OleDbParameter("@Runs", iRuns));
//pCommand.Parameters.Add(new OleDbParameter("@Hits", iHits));
//pCommand.Parameters.Add(new OleDbParameter("@HR", iHR));
//pCommand.Parameters.Add(new OleDbParameter("@RBI", iRBI));
//pCommand.Parameters.Add(new OleDbParameter("@SB", iSB));
//pCommand.Parameters.Add(new OleDbParameter("@SF", iSF));
//pCommand.Parameters.Add(new OleDbParameter("@BB", iBB));
//pCommand.Parameters.Add(new OleDbParameter("@HBP", iHBP));
//pCommand.Parameters.Add(new OleDbParameter("@Wins", iWin));
//pCommand.Parameters.Add(new OleDbParameter("@Saves", iSave));
//pCommand.Parameters.Add(new OleDbParameter("@Outs", iOuts));
//pCommand.Parameters.Add(new OleDbParameter("@HitsAllowed", iHitsAllowed));
//pCommand.Parameters.Add(new OleDbParameter("@EarnedRuns", iER));
//pCommand.Parameters.Add(new OleDbParameter("@Walks", iWalks));
//pCommand.Parameters.Add(new OleDbParameter("@Strikeouts", iK));
OdbcCommand pCommand = new OdbcCommand(sSql, m_pConnection);
OdbcParameter pParam = new OdbcParameter();
pParam.Value = myLeague.LeagueId;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iTeam;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = myPlayer;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = currentDate.ToShortDateString();
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iAtBats;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iRuns;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iHits;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iHR;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iRBI;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iSB;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iSF;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iBB;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iHBP;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iWin;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iSave;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iOuts;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iHitsAllowed;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iER;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iWalks;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = iK;
pCommand.Parameters.Add(pParam);
pCommand.ExecuteNonQuery();
}
}
private void AddDailyScores(YahooLeague pLeague, int iID, int iTeam, DateTime dteStartDate, DateTime dteEndDate)
{
try
{
TimeSpan mySpan = dteEndDate.Subtract(dteStartDate);
for (int i = 0; i <= mySpan.TotalDays; i++)
{
DateTime currDate = dteStartDate.AddDays(i);
int iAtBats1 = 0, iRuns1 = 0, iHits1 = 0, iHR1 = 0, iRBI1 = 0, iSB1 = 0, iSF1 = 0, iBB1 = 0, iHBP1 = 0;
int iWin1 = 0, iSave1 = 0, iOuts1 = 0, iHitsAllowed1 = 0, iER1 = 0, iWalks1 = 0, iK1 = 0;
float fAVG1 = 0, fOBP1 = 0, fERA1 = 0, fWHIP1 = 0;
string sSql = "SELECT SUM(AtBats) As SumAtBats, SUM(Runs) As SumRuns, SUM(Hits) As SumHits, SUM(HR) As SumHR, SUM(RBI) As SumRBI, SUM(SF) As SumSF, " +
"SUM(SB) As SumSB, SUM(BB) As SumBB, SUM(HBP) As SumHBP, SUM(Wins) As SumWins, SUM(Saves) As SumSaves, SUM(Outs) As SumOuts, SUM(HitsAllowed) As SumHitsAllowed, " +
"SUM(EarnedRuns) As SumEarnedRuns, SUM(Walks) As SumWalks, SUM(Strikeouts) As SumStrikeouts " +
"FROM tblStatistics WHERE (TeamID = ?) AND (StatsDate = ?)";
//OleDbCommand pCommand = new OleDbCommand(sSql, m_pConnection);
//pCommand.Parameters.Add(new OleDbParameter("@TeamID", iTeam));
//pCommand.Parameters.Add(new OleDbParameter("@StartDate", currDate.ToShortDateString()));
OdbcCommand pCommand = new OdbcCommand(sSql, m_pConnection);
OdbcParameter pParam = new OdbcParameter();
pParam.Value = iTeam;
pCommand.Parameters.Add(pParam);
pParam = new OdbcParameter();
pParam.Value = currDate.ToShortDateString();
pCommand.Parameters.Add(pParam);
//OleDbDataReader dr = pCommand.ExecuteReader();
OdbcDataReader dr = pCommand.ExecuteReader();
if (dr.Read())
{
int.TryParse(dr["SumAtBats"].ToString(), out iAtBats1);
int.TryParse(dr["SumRuns"].ToString(), out iRuns1);
int.TryParse(dr["SumHits"].ToString(), out iHits1);
int.TryParse(dr["SumHR"].ToString(), out iHR1);
int.TryParse(dr["SumRBI"].ToString(), out iRBI1);
int.TryParse(dr["SumSB"].ToString(), out iSB1);
int.TryParse(dr["SumSF"].ToString(), out iSF1);
int.TryParse(dr["SumBB"].ToString(), out iBB1);
int.TryParse(dr["SumHBP"].ToString(), out iHBP1);
int.TryParse(dr["SumWins"].ToString(), out iWin1);
int.TryParse(dr["SumSaves"].ToString(), out iSave1);
int.TryParse(dr["SumOuts"].ToString(), out iOuts1);
int.TryParse(dr["SumHitsAllowed"].ToString(), out iHitsAllowed1);
int.TryParse(dr["SumEarnedRuns"].ToString(), out iER1);
int.TryParse(dr["SumWalks"].ToString(), out iWalks1);
int.TryParse(dr["SumStrikeouts"].ToString(), out iK1);
fAVG1 = (float)iHits1 / (float)iAtBats1;
fOBP1 = (float)(iHits1 + iBB1 + iHBP1) / (float)(iAtBats1 + iBB1 + iHBP1 + iSF1);
if (iOuts1 > 0)
{
fERA1 = (float)(iER1 * 9) / (float)((float)iOuts1 / (float)3);
fWHIP1 = (float)(iWalks1 + iHitsAllowed1) / (float)((float)iOuts1 / (float)3);
}
}
dr.Close();
grdDaily.Rows.Add(iID, pLeague.Teams[iTeam - 1].TeamName, currDate.ToShortDateString(), iRuns1, iHR1, iRBI1, iSB1, fAVG1.ToString("F3"), fOBP1.ToString("F3"), iWin1, iSave1, iK1, fERA1.ToString("F2"), fWHIP1.ToString("F2"));
}
}
catch (Exception ex)
{
clsStatic.ShowError(ex.ToString());
}
}
private void RefreshScores(YahooLeague pLeague)
{
grdScores.Rows.Clear();
foreach (Matchup myMatchup in m_pMatchups)
{
int iAtBats1 = 0, iRuns1 = 0, iHits1 = 0, iHR1 = 0, iRBI1 = 0, iSB1 = 0, iSF1 = 0, iBB1 = 0, iHBP1 = 0;
int iWin1 = 0, iSave1 = 0, iOuts1 = 0, iHitsAllowed1 = 0, iER1 = 0, iWalks1 = 0, iK1 = 0;
float fAVG1 = 0, fOBP1 = 0, fERA1 = 0, fWHIP1 = 0;
string sSql = "SELECT SUM(AtBats) As SumAtBats, SUM(Runs) As SumRuns, SUM(Hits) As SumHits, SUM(HR) As SumHR, SUM(RBI) As SumRBI, SUM(SF) As SumSF, " +
"SUM(SB) As SumSB, SUM(BB) As SumBB, SUM(HBP) As SumHBP, SUM(Wins) As SumWins, SUM(Saves) As SumSaves, SUM(Outs) As SumOuts, SUM(HitsAllowed) As SumHitsAllowed, " +
"SUM(EarnedRuns) As SumEarnedRuns, SUM(Walks) As SumWalks, SUM(Strikeouts) As SumStrikeouts " +
"FROM tblStatistics WHERE (TeamID = ?) AND (StatsDate >= ?) AND (StatsDate <= ?)";
//OleDbCommand pCommand = new OleDbCommand(sSql, m_pConnection);
//pCommand.Parameters.Add(new OleDbParameter("@TeamID", myMatchup.Team1));
//pCommand.Parameters.Add(new OleDbParameter("@StartDate", myMatchup.StartDate.ToShortDateString()));
//pCommand.Parameters.Add(new OleDbParameter("@EndDate", myMatchup.EndDate.ToShortDateString()));
OdbcCommand pCommand = new OdbcCommand(sSql, m_pConnection);
OdbcParameter pParam1 = new OdbcParameter();
pParam1.Value = myMatchup.Team1;
pCommand.Parameters.Add(pParam1);
OdbcParameter pParam2 = new OdbcParameter();
pParam2.Value = myMatchup.StartDate.ToShortDateString();
pCommand.Parameters.Add(pParam2);
OdbcParameter pParam3 = new OdbcParameter();
pParam3.Value = myMatchup.EndDate.ToShortDateString();
pCommand.Parameters.Add(pParam3);
//OleDbDataReader dr = pCommand.ExecuteReader();
OdbcDataReader dr = pCommand.ExecuteReader();
if (dr.Read())
{
int.TryParse(dr["SumAtBats"].ToString(), out iAtBats1);
int.TryParse(dr["SumRuns"].ToString(), out iRuns1);
int.TryParse(dr["SumHits"].ToString(), out iHits1);
int.TryParse(dr["SumHR"].ToString(), out iHR1);
int.TryParse(dr["SumRBI"].ToString(), out iRBI1);
int.TryParse(dr["SumSB"].ToString(), out iSB1);
int.TryParse(dr["SumSF"].ToString(), out iSF1);
int.TryParse(dr["SumBB"].ToString(), out iBB1);
int.TryParse(dr["SumHBP"].ToString(), out iHBP1);
int.TryParse(dr["SumWins"].ToString(), out iWin1);
int.TryParse(dr["SumSaves"].ToString(), out iSave1);
int.TryParse(dr["SumOuts"].ToString(), out iOuts1);
int.TryParse(dr["SumHitsAllowed"].ToString(), out iHitsAllowed1);
int.TryParse(dr["SumEarnedRuns"].ToString(), out iER1);
int.TryParse(dr["SumWalks"].ToString(), out iWalks1);
int.TryParse(dr["SumStrikeouts"].ToString(), out iK1);
fAVG1 = (float)iHits1 / (float)iAtBats1;
fOBP1 = (float)(iHits1 + iBB1 + iHBP1) / (float)(iAtBats1 + iBB1 + iHBP1 + iSF1);
if (iOuts1 > 0)
{
fERA1 = (float)(iER1 * 9) / (float)((float)iOuts1 / (float)3);
fWHIP1 = (float)(iWalks1 + iHitsAllowed1) / (float)((float)iOuts1 / (float)3);
}
}
dr.Close();
int iAtBats2 = 0, iRuns2 = 0, iHits2 = 0, iHR2 = 0, iRBI2 = 0, iSB2 = 0, iSF2 = 0, iBB2 = 0, iHBP2 = 0;
int iWin2 = 0, iSave2 = 0, iOuts2 = 0, iHitsAllowed2 = 0, iER2 = 0, iWalks2 = 0, iK2 = 0;
float fAVG2 = 0, fOBP2 = 0, fERA2 = 0, fWHIP2 = 0;
//pCommand = new OleDbCommand(sSql, m_pConnection);
//pCommand.Parameters.Add(new OleDbParameter("@TeamID", myMatchup.Team2));
//pCommand.Parameters.Add(new OleDbParameter("@StartDate", myMatchup.StartDate.ToShortDateString()));
//pCommand.Parameters.Add(new OleDbParameter("@EndDate", myMatchup.EndDate.ToShortDateString()));
pCommand = new OdbcCommand(sSql, m_pConnection);
pParam1 = new OdbcParameter();
pParam1.Value = myMatchup.Team2;
pCommand.Parameters.Add(pParam1);
pParam2 = new OdbcParameter();
pParam2.Value = myMatchup.StartDate.ToShortDateString();
pCommand.Parameters.Add(pParam2);
pParam3 = new OdbcParameter();
pParam3.Value = myMatchup.EndDate.ToShortDateString();
pCommand.Parameters.Add(pParam3);
//pCommand = new OdbcCommand(sSql, m_pConnection);
dr = pCommand.ExecuteReader();
if (dr.Read())
{
int.TryParse(dr["SumAtBats"].ToString(), out iAtBats2);
int.TryParse(dr["SumRuns"].ToString(), out iRuns2);
int.TryParse(dr["SumHits"].ToString(), out iHits2);
int.TryParse(dr["SumHR"].ToString(), out iHR2);
int.TryParse(dr["SumRBI"].ToString(), out iRBI2);
int.TryParse(dr["SumSB"].ToString(), out iSB2);
int.TryParse(dr["SumSF"].ToString(), out iSF2);
int.TryParse(dr["SumBB"].ToString(), out iBB2);
int.TryParse(dr["SumHBP"].ToString(), out iHBP2);
int.TryParse(dr["SumWins"].ToString(), out iWin2);
int.TryParse(dr["SumSaves"].ToString(), out iSave2);
int.TryParse(dr["SumOuts"].ToString(), out iOuts2);
int.TryParse(dr["SumHitsAllowed"].ToString(), out iHitsAllowed2);
int.TryParse(dr["SumEarnedRuns"].ToString(), out iER2);
int.TryParse(dr["SumWalks"].ToString(), out iWalks2);
int.TryParse(dr["SumStrikeouts"].ToString(), out iK2);
fAVG2 = (float)iHits2 / (float)iAtBats2;
fOBP2 = (float)(iHits2 + iBB2 + iHBP2) / (float)(iAtBats2 + iBB2 + iHBP2 + iSF2);
if (iOuts2 > 0)
{
fERA2 = (float)(iER2 * 9) / (float)((float)iOuts2 / (float)3);
fWHIP2 = (float)(iWalks2 + iHitsAllowed2) / (float)((float)iOuts2 / (float)3);
}
}
dr.Close();
int iScore1 = 0, iScore2 = 0;
int[] Team1Wins = new int[11];
int[] Team2Wins = new int[11];
if (iRuns1 > iRuns2)
{
iScore1++;
Team1Wins[0] = 1;
}
else if (iRuns2 > iRuns1)
{
iScore2++;
Team2Wins[0] = 1;
}
if (iHR1 > iHR2)
{
iScore1++;
Team1Wins[1] = 1;
}
else if (iHR2 > iHR1)
{
iScore2++;
Team2Wins[1] = 1;
}
if (iRBI1 > iRBI2)
{
iScore1++;
Team1Wins[2] = 1;
}
else if (iRBI2 > iRBI1)
{
iScore2++;
Team2Wins[2] = 1;
}
if (iSB1 > iSB2)
{
iScore1++;
Team1Wins[3] = 1;
}
else if (iSB2 > iSB1)
{
iScore2++;
Team2Wins[3] = 1;
}
if (fAVG1 > fAVG2)
{
iScore1++;
Team1Wins[4] = 1;
}
else if (fAVG2 > fAVG1)
{
iScore2++;
Team2Wins[4] = 1;
}
if (fOBP1 > fOBP2)
{
iScore1++;
Team1Wins[5] = 1;
}
else if (fOBP2 > fOBP1)
{
iScore2++;
Team2Wins[5] = 1;
}
if (iWin1 > iWin2)
{
iScore1++;
Team1Wins[6] = 1;
}
else if (iWin2 > iWin1)
{
iScore2++;
Team2Wins[6] = 1;
}
if (iSave1 > iSave2)
{
iScore1++;
Team1Wins[7] = 1;
}
else if (iSave2 > iSave1)
{
iScore2++;
Team2Wins[7] = 1;
}
if (iK1 > iK2)
{
iScore1++;
Team1Wins[8] = 1;
}
else if (iK2 > iK1)
{
iScore2++;
Team2Wins[8] = 1;
}
if (fERA1 < fERA2)
{
iScore1++;
Team1Wins[9] = 1;
}
else if (fERA2 < fERA1)
{
iScore2++;
Team2Wins[9] = 1;
}
if (fWHIP1 < fWHIP2)
{
iScore1++;
Team1Wins[10] = 1;
}
else if (fWHIP2 < fWHIP1)
{
iScore2++;
Team2Wins[10] = 1;
}
int iRow = grdScores.Rows.Add(myMatchup.ID, pLeague.Teams[myMatchup.Team1 - 1].TeamName, iRuns1, iHR1, iRBI1, iSB1, fAVG1.ToString("F3"), fOBP1.ToString("F3"), iWin1, iSave1, iK1, fERA1.ToString("F2"), fWHIP1.ToString("F2"), iScore1);
for (int n = 0; n < 11; n++)
{
if (Team1Wins[n] == 1)
{
DataGridViewCell myCell = grdScores.Rows[iRow].Cells[n + 2];
myCell.Style.Font = new Font(myCell.InheritedStyle.Font, FontStyle.Bold);
}
}
iRow = grdScores.Rows.Add(myMatchup.ID, pLeague.Teams[myMatchup.Team2 - 1].TeamName, iRuns2, iHR2, iRBI2, iSB2, fAVG2.ToString("F3"), fOBP2.ToString("F3"), iWin2, iSave2, iK2, fERA2.ToString("F2"), fWHIP2.ToString("F2"), iScore2);
for (int n = 0; n < 11; n++)
{
if (Team2Wins[n] == 1)
{
DataGridViewCell myCell = grdScores.Rows[iRow].Cells[n + 2];
myCell.Style.Font = new Font(myCell.InheritedStyle.Font, FontStyle.Bold);
}
}
}
}
private void RefreshMatchups(YahooLeague pLeague)
{
try
{
m_pMatchups.Clear();
grdMatchups.Rows.Clear();
string sSql = "SELECT * FROM tblMatchups WHERE LeagueID = ? ORDER BY ID ASC";
//OleDbCommand pCommand = new OleDbCommand(sSql, m_pConnection);
OdbcCommand pCommand = new OdbcCommand(sSql, m_pConnection);
//pCommand.Parameters.Add(new OleDbParameter("@LeagueID", pLeague.LeagueId));
OdbcParameter pParam = new OdbcParameter();
pParam.Value = pLeague.LeagueId;
pCommand.Parameters.Add(pParam);
//OleDbDataReader dr = pCommand.ExecuteReader();
OdbcDataReader dr = pCommand.ExecuteReader();
while (dr.Read())
{
string sID = dr["ID"].ToString();
string sTeam1 = pLeague.Teams[Convert.ToInt32(dr["Team1"]) - 1].TeamName;
string sTeam2 = pLeague.Teams[Convert.ToInt32(dr["Team2"]) - 1].TeamName;
string sStart = Convert.ToDateTime(dr["StartDate"].ToString()).ToShortDateString();
string sEnd = Convert.ToDateTime(dr["EndDate"].ToString()).ToShortDateString();
grdMatchups.Rows.Add(sID, sTeam1, sTeam2, sStart, sEnd);
Matchup myMatchup = new Matchup();
myMatchup.ID = Convert.ToInt32(sID);
myMatchup.Team1 = Convert.ToInt32(dr["Team1"]);
myMatchup.Team2 = Convert.ToInt32(dr["Team2"]);
myMatchup.StartDate = Convert.ToDateTime(dr["StartDate"]);
myMatchup.EndDate = Convert.ToDateTime(dr["EndDate"]);
m_pMatchups.Add(myMatchup);
}
dr.Close();
cmbMatchups.Items.Clear();
foreach (Matchup thisMatchup in m_pMatchups)
cmbMatchups.Items.Add(pLeague.Teams[thisMatchup.Team1 - 1].TeamName + " vs. " + pLeague.Teams[thisMatchup.Team2 - 1].TeamName);
if (cmbMatchups.Items.Count > 0)
cmbMatchups.SelectedIndex = 0;
}
catch (Exception ex)
{
clsStatic.ShowError(ex.ToString());
}
}
private void RefreshDaily(YahooLeague pLeague)
{
if (grdDaily.Rows.Count > 0)
grdDaily.Rows.Clear();
if (cmbMatchups.SelectedIndex > -1)
{
Matchup myMatchup = m_pMatchups[cmbMatchups.SelectedIndex];
AddDailyScores(pLeague, myMatchup.ID, myMatchup.Team1, myMatchup.StartDate, myMatchup.EndDate);
AddDailyScores(pLeague, myMatchup.ID, myMatchup.Team2, myMatchup.StartDate, myMatchup.EndDate);
}
}
private void ListLeagues(string sContents)
{
XmlDocument oDoc = new XmlDocument();
oDoc.LoadXml(sContents);
XmlElement oRootNode = (XmlElement)oDoc.ChildNodes[1]; //(XmlElement)oDoc.SelectSingleNode("/fantasy_content/users/user/games/game/leagues");
XmlNamespaceManager nsmgr = new XmlNamespaceManager(oDoc.NameTable);
nsmgr.AddNamespace("yahoo", "http://fantasysports.yahooapis.com/fantasy/v2/base.rng");
XmlElement oLeagues = (XmlElement)oRootNode.SelectSingleNode("descendant::yahoo:users/yahoo:user/yahoo:games/yahoo:game[yahoo:code=\"mlb\"]/yahoo:leagues", nsmgr);
if (oLeagues != null)
{
m_pLeagues.Clear();
cmbLeagues.Items.Clear();
XmlNodeList oList = oLeagues.SelectNodes("descendant::yahoo:league", nsmgr);
foreach (XmlElement myElement in oList)
{
YahooLeague myLeague = new YahooLeague();
XmlElement oNode = (XmlElement)myElement.SelectSingleNode("descendant::yahoo:league_id", nsmgr);
myLeague.LeagueId = Convert.ToInt32(oNode.InnerText);
oNode = (XmlElement)myElement.SelectSingleNode("descendant::yahoo:name", nsmgr);
myLeague.LeagueName = oNode.InnerText;
m_pLeagues.Add(myLeague);
cmbLeagues.Items.Add(oNode.InnerText);
}
if (cmbLeagues.Items.Count > 0)
cmbLeagues.SelectedIndex = 0;
}
}
private List<DateTime> GetStatsDates(YahooLeague pLeague)
{
List<DateTime> aResult = new List<DateTime>();
string sSql = "SELECT DISTINCT StatsDate FROM tblStatistics WHERE LeagueID = ?";
//OleDbCommand pCommand = new OleDbCommand(sSql, m_pConnection);
//pCommand.Parameters.Add(new OleDbParameter("@LeagueID", pLeague.LeagueId));
//OleDbDataReader dr = pCommand.ExecuteReader();
OdbcCommand pCommand = new OdbcCommand(sSql, m_pConnection);
OdbcParameter pParam = new OdbcParameter();
pParam.Value = pLeague.LeagueId;
pCommand.Parameters.Add(pParam);
OdbcDataReader dr = pCommand.ExecuteReader();
while (dr.Read())
{
aResult.Add(Convert.ToDateTime(dr["StatsDate"]));
}
dr.Close();
return aResult;
}
private void ExportMatchups(string sFileName, YahooLeague pLeague)
{
StringBuilder sb = new StringBuilder();
if (grdScores.Rows.Count > 0)
{
int i = 0;
foreach (DataGridViewColumn myColumn in grdScores.Columns)
{
if (!(myColumn.HeaderText.Contains(",")))
sb.Append(myColumn.HeaderText + ",");
else
sb.Append(String.Format("\"{0}\",", myColumn.HeaderText));
if (i == 1)
sb.Append("Date,");
i++;
}
if (sb.Length > 0)
sb.Remove(sb.Length - 1, 1);
sb.Append(Environment.NewLine);
for (int j = 0; j < m_pMatchups.Count; j++)
{
cmbMatchups.SelectedIndex = j;
foreach (DataGridViewRow myRow in grdDaily.Rows)
{
if (!(myRow.IsNewRow))
{
foreach (DataGridViewCell myCell in myRow.Cells)
{
if (!(myCell.Value.ToString().Contains(",")))
sb.Append(myCell.Value.ToString() + ",");
else
sb.Append(String.Format("\"{0}\",", myCell.Value.ToString()));
}
}
if (sb.Length > 0)
sb.Remove(sb.Length - 1, 1);
sb.Append(Environment.NewLine);
}
}
foreach (DataGridViewRow myRow in grdScores.Rows)
{
if (!(myRow.IsNewRow))
{
i = 0;
foreach (DataGridViewCell myCell in myRow.Cells)
{
if (!(myCell.Value.ToString().Contains(",")))
sb.Append(myCell.Value.ToString() + ",");
else
sb.Append(String.Format("\"{0}\",", myCell.Value.ToString()));
if (i == 1)
sb.Append("Total,");
i++;
}
}
if (sb.Length > 0)
sb.Remove(sb.Length - 1, 1);
sb.Append(Environment.NewLine);
}
using (TextWriter tw = new StreamWriter(sFileName))
{
tw.Write(sb.ToString());
}
}
}
