private void CaclulateFourFactors(NBAGameStats team, NBAGameStats opponent)
{
team.O_eFG = (team.FGM + 0.5 * team.FG3M) / team.FGA;
team.D_eFG = (opponent.FGM + 0.5 * opponent.FG3M) / opponent.FGA;
team.O_TOV = team.TOV * 100.0 / (team.FGA + 0.44 * team.FTA + team.TOV);
team.D_TOV = opponent.TOV * 100.0 / (opponent.FGA + 0.44 * opponent.FTA + opponent.TOV);
team.ORB = team.OREB * 100.0 / (team.OREB + opponent.DREB);
team.DRB = team.DREB * 100.0 / (team.DREB + opponent.OREB);
team.O_FT_FGA = team.FTM / team.FGA;
team.D_FT_FGA = opponent.FTM / opponent.FGA;
double num = 0.5 * (team.FGA + 0.4 * team.FTA - 1.07 * (team.OREB / (team.OREB + opponent.DREB)) * (team.FGA - team.FGM) + team.TOV + (opponent.FGA + 0.4 * opponent.FTA - 1.07 * (opponent.OREB / (opponent.OREB + team.DREB)) * (opponent.FGA - opponent.FGM) + opponent.TOV));
team.Pace = 48.0 * (num + num) / (2.0 * team.MP / 5.0);
team.ORtg = team.PTS * 100.0 / (team.Pace * team.MP / 240.0);
team.DRtg = opponent.PTS * 100.0 / (team.Pace * opponent.MP / 240.0);
opponent.O_eFG = team.D_eFG;
opponent.D_eFG = team.O_eFG;
opponent.O_TOV = team.D_TOV;
opponent.D_TOV = team.O_TOV;
opponent.ORB = opponent.OREB * 100.0 / (opponent.OREB + team.DREB);
opponent.DRB = opponent.DREB * 100.0 / (opponent.DREB + team.OREB);
opponent.O_FT_FGA = team.D_FT_FGA;
opponent.D_FT_FGA = team.O_FT_FGA;
opponent.Pace = team.Pace;
opponent.ORtg = team.DRtg;
opponent.DRtg = team.ORtg;
}
private void ExportFourFactorsToPredict(List <NBAGameStats> gameStats, string gameDate, string awayAbbr, string homeAbbr)
{
string[] strArray1 = new string[14]
{
"Team",
"Home",
"Pace_Calc",
"O_eFG",
"O_TOV",
"ORB",
"O_FT_FGA",
"ORtg",
"D_eFG",
"D_TOV",
"DRB",
"D_FT_FGA",
"DRtg",
"Pace_Mix"
};
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(string.Join(",", strArray1));
int num = gameStats.Count / 2;
for (int index = 0; index < num; ++index)
{
NBAGameStats nbaGameStats1 = gameStats[2 * index];
NBAGameStats nbaGameStats2 = gameStats[2 * index + 1];
stringBuilder.AppendLine();
stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13}", (object)awayAbbr, (object)nbaGameStats1.Home, (object)nbaGameStats2.Pace, (object)nbaGameStats2.O_eFG, (object)nbaGameStats2.O_TOV, (object)nbaGameStats2.ORB, (object)nbaGameStats2.O_FT_FGA, (object)nbaGameStats2.ORtg, (object)nbaGameStats2.D_eFG, (object)nbaGameStats2.D_TOV, (object)nbaGameStats2.DRB, (object)nbaGameStats2.D_FT_FGA, (object)nbaGameStats2.DRtg, (object)nbaGameStats2.Mix_Pace);
stringBuilder.AppendLine();
stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13}", (object)homeAbbr, (object)nbaGameStats2.Home, (object)nbaGameStats1.Pace, (object)nbaGameStats1.O_eFG, (object)nbaGameStats1.O_TOV, (object)nbaGameStats1.ORB, (object)nbaGameStats1.O_FT_FGA, (object)nbaGameStats1.ORtg, (object)nbaGameStats1.D_eFG, (object)nbaGameStats1.D_TOV, (object)nbaGameStats1.DRB, (object)nbaGameStats1.D_FT_FGA, (object)nbaGameStats1.DRtg, (object)nbaGameStats1.Mix_Pace);
}
string path = string.Format("D:\\Derek\\NBA\\{0}", (object)gameDate);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string str = string.Format("{0}\\{1}vs{2}.csv", (object)path, (object)awayAbbr, (object)homeAbbr);
File.WriteAllText(str, stringBuilder.ToString());
this.StartRConsole(str);
string[] strArray2 = File.ReadAllLines(str);
for (int index = 1; index < strArray2.Length; ++index)
{
string[] strArray3 = strArray2[index].Split(new string[1]
{
","
}, StringSplitOptions.RemoveEmptyEntries);
gameStats[index - 1].Pred_PTS = Convert.ToDouble(strArray3[13]);
if (index % 2 == 0)
{
gameStats[index - 1].LP = gameStats[index - 1].Pred_PTS - gameStats[index - 2].Pred_PTS;
gameStats[index - 2].LP = -gameStats[index - 1].LP;
gameStats[index - 1].SP = gameStats[index - 1].Pred_PTS + gameStats[index - 2].Pred_PTS;
gameStats[index - 2].SP = gameStats[index - 1].SP;
}
}
}
private NBAGameStats RetrieveStatsFromTable(DataTable team)
{
DataRow dataRow = team.Rows[0];
int num = Convert.ToInt32(dataRow[16]);
NBAGameStats nbaGameStats = new NBAGameStats();
nbaGameStats.GamePlayed = num;
nbaGameStats.FGM = Convert.ToDouble(dataRow[0]) / (double)num;
nbaGameStats.FGA = Convert.ToDouble(dataRow[1]) / (double)num;
nbaGameStats.FGP = nbaGameStats.FGM * 100.0 / nbaGameStats.FGA;
nbaGameStats.FG3M = Convert.ToDouble(dataRow[2]) / (double)num;
nbaGameStats.FG3A = Convert.ToDouble(dataRow[3]) / (double)num;
nbaGameStats.FG3P = nbaGameStats.FG3M * 100.0 / nbaGameStats.FG3A;
nbaGameStats.FTM = Convert.ToDouble(dataRow[4]) / (double)num;
nbaGameStats.FTA = Convert.ToDouble(dataRow[5]) / (double)num;
nbaGameStats.FTP = nbaGameStats.FTM * 100.0 / nbaGameStats.FTA;
nbaGameStats.OREB = Convert.ToDouble(dataRow[6]) / (double)num;
nbaGameStats.DREB = Convert.ToDouble(dataRow[7]) / (double)num;
nbaGameStats.REB = Convert.ToDouble(dataRow[8]) / (double)num;
nbaGameStats.AST = Convert.ToDouble(dataRow[9]) / (double)num;
nbaGameStats.STL = Convert.ToDouble(dataRow[10]) / (double)num;
nbaGameStats.BLK = Convert.ToDouble(dataRow[11]) / (double)num;
nbaGameStats.TOV = Convert.ToDouble(dataRow[12]) / (double)num;
nbaGameStats.PF = Convert.ToDouble(dataRow[13]) / (double)num;
nbaGameStats.PTS = Convert.ToDouble(dataRow[14]) / (double)num;
nbaGameStats.MP = Convert.ToDouble(dataRow[15]) / (double)num;
return(nbaGameStats);
}
private List <NBAGameStats> PrepareTeamsData(string awayId, string awayName, string homeId, string homeName, int year, DateTime gameTime, GamePos pos, int gameCount)
{
List <NBAGameStats> gameStats = new List <NBAGameStats>();
NBAGameStats nbaGameStats1 = this.RetrieveGameStats(awayId, year, gameTime, pos == GamePos.None ? GamePos.Away : pos, gameCount);
if (nbaGameStats1 != null)
{
nbaGameStats1.Home = 0;
nbaGameStats1.TeamName = awayName;
gameStats.Add(nbaGameStats1);
}
NBAGameStats nbaGameStats2 = this.RetrieveGameStats(homeId, year, gameTime, pos == GamePos.None ? GamePos.Home : pos, gameCount);
if (nbaGameStats2 != null)
{
nbaGameStats2.Home = 1;
nbaGameStats2.TeamName = homeName;
gameStats.Add(nbaGameStats2);
}
if (gameStats.Count > 0)
{
this.CaclulateMixPace(gameStats);
}
return(gameStats);
}
private void CaclulateMixPace(List <NBAGameStats> gameStats)
{
if (gameStats.Count != 2)
{
return;
}
NBAGameStats nbaGameStats1 = gameStats[0];
NBAGameStats nbaGameStats2 = gameStats[1];
double num = 0.5 * (nbaGameStats1.FGA + 0.4 * nbaGameStats1.FTA - 1.07 * (nbaGameStats1.OREB / nbaGameStats1.REB) * (nbaGameStats1.FGA - nbaGameStats1.FGM) + nbaGameStats1.TOV + (nbaGameStats2.FGA + 0.4 * nbaGameStats2.FTA - 1.07 * (nbaGameStats2.OREB / nbaGameStats2.REB) * (nbaGameStats2.FGA - nbaGameStats2.FGM) + nbaGameStats2.TOV));
nbaGameStats1.Mix_Pace = 48.0 * (num + num) / (2.0 * nbaGameStats1.MP / 5.0);
nbaGameStats2.Mix_Pace = nbaGameStats1.Mix_Pace;
}
public void ExportFourFactorsPerGameToCSV(string date, bool fromDB)
{
string[] strArray = new string[15]
{
"Team",
"PTS",
"Home",
"LP",
"Pace_Calc",
"O_eFG",
"O_TOV",
"ORB",
"O_FT_FGA",
"ORtg",
"D_eFG",
"D_TOV",
"DRB",
"D_FT_FGA",
"DRtg"
};
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(string.Join(",", strArray));
foreach (IGrouping <int, NBAGameStats> grouping in Enumerable.GroupBy <NBAGameStats, int>(!fromDB ? (IEnumerable <NBAGameStats>) this.handler.GetAllGameStats("214", date) : (IEnumerable <NBAGameStats>) this.handler.GetFourFactors("214", date), (Func <NBAGameStats, int>)(g => g.GameId)))
{
NBAGameStats team = (NBAGameStats)null;
NBAGameStats opponent = (NBAGameStats)null;
foreach (NBAGameStats nbaGameStats in (IEnumerable <NBAGameStats>)grouping)
{
if (team == null)
{
team = nbaGameStats;
}
else if (opponent == null)
{
opponent = nbaGameStats;
}
}
if (!fromDB)
{
this.CaclulateFourFactors(team, opponent);
}
stringBuilder.AppendLine();
stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14}", (object)opponent.TeamName, (object)opponent.PTS, (object)opponent.Home, (object)(opponent.PTS - team.PTS), (object)opponent.Pace, (object)team.O_eFG, (object)team.O_TOV, (object)team.ORB, (object)team.O_FT_FGA, (object)team.ORtg, (object)team.D_eFG, (object)team.D_TOV, (object)team.DRB, (object)team.D_FT_FGA, (object)team.DRtg);
stringBuilder.AppendLine();
stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14}", (object)team.TeamName, (object)team.PTS, (object)team.Home, (object)(team.PTS - opponent.PTS), (object)team.Pace, (object)opponent.O_eFG, (object)opponent.O_TOV, (object)opponent.ORB, (object)opponent.O_FT_FGA, (object)opponent.ORtg, (object)opponent.D_eFG, (object)opponent.D_TOV, (object)opponent.DRB, (object)opponent.D_FT_FGA, (object)opponent.DRtg);
}
File.WriteAllText("D:\\Derek\\NBA\\NBA_FourFactors_PerGame.csv", stringBuilder.ToString());
}
public void ExportRatingBeforeGamePlay(int preGameCount, GamePos pos, DateTime gameTime, string awayId, string homeId)
{
string[] strArray = new string[7]
{
"Team_Id",
"ORtg",
"DRtg",
"Opp_ORtg",
"Opp_DRtg",
"Act_ORtg",
"Home"
};
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(string.Join(",", strArray));
IEnumerable <NBAGameInfo> source = Enumerable.Where <NBAGameInfo>((IEnumerable <NBAGameInfo>) this.handler.GetGamesBySeason("214"), (Func <NBAGameInfo, bool>)(g => !string.IsNullOrWhiteSpace(g.FinalScore)));
if (gameTime != DateTime.MinValue)
{
source = Enumerable.Where <NBAGameInfo>(source, (Func <NBAGameInfo, bool>)(g => g.GameTime < gameTime));
}
if (!string.IsNullOrEmpty(awayId) && !string.IsNullOrEmpty(homeId))
{
source = Enumerable.Where <NBAGameInfo>(source, (Func <NBAGameInfo, bool>)(g => g.AwayId == Convert.ToInt32(awayId) || g.HomeId == Convert.ToInt32(awayId) || (g.AwayId == Convert.ToInt32(homeId) || g.HomeId == Convert.ToInt32(homeId))));
}
Dictionary <int, Tuple <Decimal, Decimal> > eachGameRating = this.handler.GetEachGameRating("214");
foreach (NBAGameInfo nbaGameInfo in (IEnumerable <NBAGameInfo>)Enumerable.OrderBy <NBAGameInfo, int>(source, (Func <NBAGameInfo, int>)(g => g.GameId)))
{
List <NBAGameStats> list = this.PrepareTeamsData(nbaGameInfo.AwayId.ToString(), nbaGameInfo.AwayEnName, nbaGameInfo.HomeId.ToString(), nbaGameInfo.HomeEnName, 2014, nbaGameInfo.GameTime, pos, preGameCount);
if (list.Count != 0 && list.Count != 1)
{
NBAGameStats nbaGameStats1 = Enumerable.FirstOrDefault <NBAGameStats>((IEnumerable <NBAGameStats>)list, (Func <NBAGameStats, bool>)(g => g.Home == 1));
NBAGameStats nbaGameStats2 = Enumerable.FirstOrDefault <NBAGameStats>((IEnumerable <NBAGameStats>)list, (Func <NBAGameStats, bool>)(g => g.Home == 0));
stringBuilder.AppendLine();
stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6}", (object)nbaGameInfo.HomeAbbr, (object)nbaGameStats1.ORtg, (object)nbaGameStats1.DRtg, (object)nbaGameStats2.ORtg, (object)nbaGameStats2.DRtg, (object)eachGameRating[nbaGameInfo.GameId].Item1, (object)1);
stringBuilder.AppendLine();
stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6}", (object)nbaGameInfo.AwayAbbr, (object)nbaGameStats2.ORtg, (object)nbaGameStats2.DRtg, (object)nbaGameStats1.ORtg, (object)nbaGameStats1.DRtg, (object)eachGameRating[nbaGameInfo.GameId].Item2, (object)0);
}
}
if (pos == GamePos.None)
{
preGameCount = 5;
}
File.WriteAllText(string.Format("D:\\Derek\\NBA\\Ratings{0}.csv", (object)preGameCount), stringBuilder.ToString(), Encoding.GetEncoding("GB2312"));
}
private NBAGameStats RetrieveGameStats(string teamId, int year, DateTime gameTime, GamePos pos, int gameCount)
{
List <int> list = this.handler.GetPreviousGames(teamId, year, gameTime, pos);
NBAGameStats team = (NBAGameStats)null;
if (list.Count > 0)
{
if (gameCount > 0)
{
list = Enumerable.ToList <int>(Enumerable.Take <int>((IEnumerable <int>)list, gameCount));
}
team = this.RetrieveStatsFromTable(this.handler.GetSumStatistics(teamId, (IEnumerable <int>)list));
team.TeamId = Convert.ToInt32(teamId);
team.Home = 1;
NBAGameStats opponent = this.RetrieveStatsFromTable(this.handler.GetOppoSumStatistics(teamId, (IEnumerable <int>)list));
opponent.Home = 0;
this.CaclulateFourFactors(team, opponent);
}
return(team);
}
private void SumTeamStats(IDataReader reader, NBAGameStats team)
{
team.GameId = reader.GetInt32(0);
++team.GamePlayed;
team.FGM += (double)reader.GetInt32(2);
team.FGA += (double)reader.GetInt32(3);
team.FG3M += (double)reader.GetInt32(5);
team.FG3A += (double)reader.GetInt32(6);
team.FTM += (double)reader.GetInt32(8);
team.FTA += (double)reader.GetInt32(9);
team.OREB += (double)reader.GetInt32(11);
team.DREB += (double)reader.GetInt32(12);
team.REB += (double)reader.GetInt32(13);
team.AST += (double)reader.GetInt32(14);
team.STL += (double)reader.GetInt32(15);
team.BLK += (double)reader.GetInt32(16);
team.TOV += (double)reader.GetInt32(17);
team.PF += (double)reader.GetInt32(18);
team.PTS += (double)reader.GetInt32(27);
team.MP += (double)reader.GetInt32(28);
}
public Dictionary <GameStats, NBAGameStats> GetGameStatsByTeam(int id, string year)
{
SqlParameter[] sqlParameterArray = new SqlParameter[2]
{
new SqlParameter("@team_id", (object)id),
null
};
sqlParameterArray[0].DbType = DbType.Int32;
sqlParameterArray[1] = new SqlParameter("@year_filter", (object)year);
sqlParameterArray[1].DbType = DbType.AnsiString;
using (IDataReader reader = (IDataReader)this._helper.ExecuteReader(CommandType.StoredProcedure, "dbo.getTeamStats", sqlParameterArray))
{
Dictionary <GameStats, NBAGameStats> dictionary = new Dictionary <GameStats, NBAGameStats>();
NBAGameStats team1 = new NBAGameStats();
NBAGameStats team2 = new NBAGameStats();
dictionary.Add(GameStats.Team, team1);
dictionary.Add(GameStats.Opponent, team2);
while (reader.Read())
{
int int32 = reader.GetInt32(1);
if (int32 == id)
{
team1.TeamId = int32;
this.SumTeamStats(reader, team1);
}
else
{
team2.TeamId = int32;
this.SumTeamStats(reader, team2);
}
}
team1.FGP = team1.FGM / team1.FGA;
team1.FG3P = team1.FG3M / team1.FG3A;
team1.FTP = team1.FTM / team1.FTA;
team2.FGP = team1.FGM / team1.FGA;
team2.FG3P = team1.FG3M / team1.FG3A;
team2.FTP = team1.FTM / team1.FTA;
return(dictionary);
}
}
public void SaveFourFactorPerGameToDB(DateTime date)
{
foreach (IGrouping <int, NBAGameStats> grouping in Enumerable.GroupBy <NBAGameStats, int>((IEnumerable <NBAGameStats>) this.handler.GetAllGameStats("214", date.ToString("yyyy-MM-dd")), (Func <NBAGameStats, int>)(g => g.GameId)))
{
NBAGameStats team = (NBAGameStats)null;
NBAGameStats nbaGameStats1 = (NBAGameStats)null;
foreach (NBAGameStats nbaGameStats2 in (IEnumerable <NBAGameStats>)grouping)
{
if (team == null)
{
team = nbaGameStats2;
}
else if (nbaGameStats1 == null)
{
nbaGameStats1 = nbaGameStats2;
}
}
this.CaclulateFourFactors(team, nbaGameStats1);
this.handler.SaveFourFactor(team);
this.handler.SaveFourFactor(nbaGameStats1);
}
}
public void SaveFourFactorByOpp(NBAGameStats team, int gameId, int pts, int type)
{
string cmdText = "SET NOCOUNT ON;\r\nINSERT INTO GameFourFactorsByOpp (game_id,team_id,type,[Pace],[O_eFG],[O_TOV],[ORB],[O_FT_FGA],[ORtg],[D_eFG],[D_TOV],[DRB],[D_FT_FGA],[DRtg],[PTS],[Home]) \r\nSELECT @id,@team_id,@type,@pace,@oefg,@otov,@orb,@oftfga,@ortg,@defg,@dtov,@drb,@dftfga,@drtg,@pts,@home\r\nWHERE NOT EXISTS (SELECT 1 FROM GameFourFactorsByOpp WHERE game_id=@id AND team_id=@team_id AND type=@type);\r\nSET NOCOUNT OFF;";
SqlParameter[] sqlParameterArray = new SqlParameter[16];
sqlParameterArray[0] = new SqlParameter("@id", (object)gameId);
sqlParameterArray[0].DbType = DbType.Int32;
sqlParameterArray[1] = new SqlParameter("@team_id", (object)team.TeamId);
sqlParameterArray[1].DbType = DbType.Int32;
sqlParameterArray[2] = new SqlParameter("@pace", (object)team.Pace);
sqlParameterArray[2].DbType = DbType.Decimal;
sqlParameterArray[3] = new SqlParameter("@oefg", (object)team.O_eFG);
sqlParameterArray[3].DbType = DbType.Decimal;
sqlParameterArray[4] = new SqlParameter("@otov", (object)team.O_TOV);
sqlParameterArray[4].DbType = DbType.Decimal;
sqlParameterArray[5] = new SqlParameter("@orb", (object)team.ORB);
sqlParameterArray[5].DbType = DbType.Decimal;
sqlParameterArray[6] = new SqlParameter("@oftfga", (object)team.O_FT_FGA);
sqlParameterArray[6].DbType = DbType.Decimal;
sqlParameterArray[7] = new SqlParameter("@ortg", (object)team.ORtg);
sqlParameterArray[7].DbType = DbType.Decimal;
sqlParameterArray[8] = new SqlParameter("@defg", (object)team.D_eFG);
sqlParameterArray[8].DbType = DbType.Decimal;
sqlParameterArray[9] = new SqlParameter("@dtov", (object)team.D_TOV);
sqlParameterArray[9].DbType = DbType.Decimal;
sqlParameterArray[10] = new SqlParameter("@drb", (object)team.DRB);
sqlParameterArray[10].DbType = DbType.Decimal;
sqlParameterArray[11] = new SqlParameter("@dftfga", (object)team.D_FT_FGA);
sqlParameterArray[11].DbType = DbType.Decimal;
sqlParameterArray[12] = new SqlParameter("@drtg", (object)team.DRtg);
sqlParameterArray[12].DbType = DbType.Decimal;
sqlParameterArray[13] = new SqlParameter("@pts", (object)pts);
sqlParameterArray[13].DbType = DbType.Decimal;
sqlParameterArray[14] = new SqlParameter("@home", (object)team.Home);
sqlParameterArray[14].DbType = DbType.Int32;
sqlParameterArray[15] = new SqlParameter("@type", (object)type);
sqlParameterArray[15].DbType = DbType.Int32;
this._helper.ExecuteNonQuery(CommandType.Text, cmdText, sqlParameterArray);
}
public void SaveFourFactorPerTeamToDB(DateTime date)
{
foreach (NBAGameInfo nbaGameInfo in this.handler.GetGamesByDate(date.ToString("yyyy-MM-dd")))
{
int num1 = nbaGameInfo.AwayId;
string awayId = num1.ToString();
num1 = nbaGameInfo.HomeId;
string homeId = num1.ToString();
int year = 2014;
DateTime gameTime = nbaGameInfo.GameTime;
int num2 = 1;
foreach (KeyValuePair <int, List <NBAGameStats> > keyValuePair in this.GetPredictData(awayId, homeId, year, gameTime, num2 != 0))
{
if (keyValuePair.Key >= 2 && keyValuePair.Value.Count == 2)
{
NBAGameStats team1 = keyValuePair.Value[0];
NBAGameStats team2 = keyValuePair.Value[1];
this.handler.SaveFourFactorByOpp(team1, nbaGameInfo.GameId, team1.Home == 0 ? nbaGameInfo.AwayPTS : nbaGameInfo.HomePTS, keyValuePair.Key);
this.handler.SaveFourFactorByOpp(team2, nbaGameInfo.GameId, team2.Home == 0 ? nbaGameInfo.AwayPTS : nbaGameInfo.HomePTS, keyValuePair.Key);
}
}
}
}
private void CalculateLetPoints(List <NBAGameStats> gameStats)
{
if (gameStats.Count != 2)
{
return;
}
NBAGameStats nbaGameStats1 = gameStats[0];
NBAGameStats nbaGameStats2 = gameStats[1];
double num1 = nbaGameStats1.FGA - 0.35 * nbaGameStats2.BLK + 0.45 * nbaGameStats1.FTA;
double num2 = nbaGameStats2.FGA - 0.35 * nbaGameStats1.BLK + 0.45 * nbaGameStats2.FTA;
double num3 = nbaGameStats1.FGM + 0.45 * nbaGameStats1.FTM;
double num4 = nbaGameStats2.FGM + 0.45 * nbaGameStats2.FTM;
double num5 = 1.0 - (nbaGameStats1.OREB + nbaGameStats2.OREB) / (num1 + num2 - (num3 + num4));
double num6 = num3 + (num1 - num3) * num5;
double num7 = num4 + (num2 - num4) * num5;
double num8 = (nbaGameStats1.PTS + nbaGameStats2.PTS) / (num6 + num7);
double num9 = (nbaGameStats1.PTS - num6 * num8) * 2.0;
double num10 = (nbaGameStats2.PTS - num7 * num8) * 2.0;
double num11 = nbaGameStats1.OREB * num5 + (num2 - num4 - nbaGameStats2.OREB) * (1.0 - num5);
double num12 = nbaGameStats2.OREB * num5 + (num1 - num3 - nbaGameStats1.OREB) * (1.0 - num5);
double num13 = num1 - nbaGameStats1.OREB + nbaGameStats1.TOV;
double num14 = num2 - nbaGameStats2.OREB + nbaGameStats2.TOV;
double num15 = -(nbaGameStats1.TOV - 0.5 * nbaGameStats2.STL) / nbaGameStats1.TOV;
double num16 = -(nbaGameStats2.TOV - 0.5 * nbaGameStats1.STL) / nbaGameStats2.TOV;
double num17 = nbaGameStats1.TOV * num15;
double num18 = nbaGameStats2.TOV * num16;
double num19 = nbaGameStats1.STL * 0.5;
double num20 = nbaGameStats2.STL * 0.5;
double num21 = num11 + num19 + num17 - num12 - num20 - num18 + num13 - num14;
double num22 = num12 + num20 + num18 - num11 - num19 - num17 + num14 - num13;
double num23 = num9 + num21 * num8;
double num24 = num10 + num22 * num8;
nbaGameStats1.LP = num23;
nbaGameStats2.LP = num24;
}
public List <NBAGameStats> GetAllGameStats(string year, string date)
{
using (IDataReader dataReader = (IDataReader)this._helper.ExecuteReader(CommandType.Text, string.Format("select g.*, t.*, Home=(case when gi.id IS null then 0 else 1 end) \r\nfrom GameStats g \r\nleft join TeamInfo t on g.team_id=t.id \r\nleft join GameInfo gi on g.game_id=gi.id and g.team_id = gi.home \r\nwhere game_id in(\r\n\tselect id from GameInfo where id like '{0}%' and time<'{1}'\r\n)", (object)year, (object)date), new SqlParameter[0]))
{
List <NBAGameStats> list = new List <NBAGameStats>();
while (dataReader.Read())
{
NBAGameStats nbaGameStats = new NBAGameStats();
nbaGameStats.GameId = dataReader.GetInt32(0);
nbaGameStats.TeamId = dataReader.GetInt32(1);
nbaGameStats.FGM = (double)dataReader.GetInt32(2);
nbaGameStats.FGA = (double)dataReader.GetInt32(3);
nbaGameStats.FGP = nbaGameStats.FGM / nbaGameStats.FGA;
nbaGameStats.FG3M = (double)dataReader.GetInt32(5);
nbaGameStats.FG3A = (double)dataReader.GetInt32(6);
nbaGameStats.FG3P = nbaGameStats.FG3M / nbaGameStats.FG3A;
nbaGameStats.FTM = (double)dataReader.GetInt32(8);
nbaGameStats.FTA = (double)dataReader.GetInt32(9);
nbaGameStats.FTP = nbaGameStats.FTM / nbaGameStats.FTA;
nbaGameStats.OREB = (double)dataReader.GetInt32(11);
nbaGameStats.DREB = (double)dataReader.GetInt32(12);
nbaGameStats.REB = (double)dataReader.GetInt32(13);
nbaGameStats.AST = (double)dataReader.GetInt32(14);
nbaGameStats.STL = (double)dataReader.GetInt32(15);
nbaGameStats.BLK = (double)dataReader.GetInt32(16);
nbaGameStats.TOV = (double)dataReader.GetInt32(17);
nbaGameStats.PF = (double)dataReader.GetInt32(18);
nbaGameStats.PTS = (double)dataReader.GetInt32(27);
nbaGameStats.MP = (double)dataReader.GetInt32(28);
nbaGameStats.TeamName = dataReader.GetString(35);
nbaGameStats.Home = dataReader.GetInt32(29);
list.Add(nbaGameStats);
}
return(list);
}
}
public void ExportFourFactorsPerTeamToCSV(string date, bool fromDB)
{
string[] strArray = new string[16]
{
"Team",
"PTS",
"Home",
"LP",
"Pace_Calc",
"O_eFG",
"O_TOV",
"ORB",
"O_FT_FGA",
"ORtg",
"D_eFG",
"D_TOV",
"DRB",
"D_FT_FGA",
"DRtg",
"Type"
};
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(string.Join(",", strArray));
if (fromDB)
{
//foreach (IGrouping<\u003C\u003Ef__AnonymousType1<int, int>, NBAGameStats> grouping in Enumerable.GroupBy((IEnumerable<NBAGameStats>) this.handler.GetFourFactorsByOpp("214", date), g =>
//{
// var fAnonymousType1 = new
// {
// GameId = g.GameId,
// Type = g.Type
// };
// return fAnonymousType1;
//}))
//{
// NBAGameStats nbaGameStats1 = (NBAGameStats) null;
// NBAGameStats nbaGameStats2 = (NBAGameStats) null;
// foreach (NBAGameStats nbaGameStats3 in (IEnumerable<NBAGameStats>) grouping)
// {
// if (nbaGameStats1 == null)
// nbaGameStats1 = nbaGameStats3;
// else if (nbaGameStats2 == null)
// nbaGameStats2 = nbaGameStats3;
// }
// stringBuilder.AppendLine();
// stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15}", (object) nbaGameStats2.TeamName, (object) nbaGameStats2.PTS, (object) nbaGameStats2.Home, (object) (nbaGameStats2.PTS - nbaGameStats1.PTS), (object) nbaGameStats1.Pace, (object) nbaGameStats1.O_eFG, (object) nbaGameStats1.O_TOV, (object) nbaGameStats1.ORB, (object) nbaGameStats1.O_FT_FGA, (object) nbaGameStats1.ORtg, (object) nbaGameStats1.D_eFG, (object) nbaGameStats1.D_TOV, (object) nbaGameStats1.DRB, (object) nbaGameStats1.D_FT_FGA, (object) nbaGameStats1.DRtg, (object) nbaGameStats2.Type);
// stringBuilder.AppendLine();
// stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15}", (object) nbaGameStats1.TeamName, (object) nbaGameStats1.PTS, (object) nbaGameStats1.Home, (object) (nbaGameStats1.PTS - nbaGameStats2.PTS), (object) nbaGameStats2.Pace, (object) nbaGameStats2.O_eFG, (object) nbaGameStats2.O_TOV, (object) nbaGameStats2.ORB, (object) nbaGameStats2.O_FT_FGA, (object) nbaGameStats2.ORtg, (object) nbaGameStats2.D_eFG, (object) nbaGameStats2.D_TOV, (object) nbaGameStats2.DRB, (object) nbaGameStats2.D_FT_FGA, (object) nbaGameStats2.DRtg, (object) nbaGameStats1.Type);
//}
}
else
{
List <NBAGameInfo> gamesByDate = this.handler.GetGamesByDate(date);
Convert.ToDateTime(date);
foreach (NBAGameInfo nbaGameInfo in gamesByDate)
{
foreach (KeyValuePair <int, List <NBAGameStats> > keyValuePair in this.GetPredictData(nbaGameInfo.AwayId.ToString(), nbaGameInfo.HomeId.ToString(), 2014, nbaGameInfo.GameTime, true))
{
if (keyValuePair.Key != 3 && keyValuePair.Value.Count == 2)
{
NBAGameStats nbaGameStats1 = keyValuePair.Value[0];
NBAGameStats nbaGameStats2 = keyValuePair.Value[1];
stringBuilder.AppendLine();
stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15}", (object)nbaGameStats2.TeamName, (object)nbaGameInfo.AwayPTS, (object)nbaGameStats2.Home, (object)(nbaGameStats2.PTS - nbaGameStats1.PTS), (object)nbaGameStats1.Pace, (object)nbaGameStats1.O_eFG, (object)nbaGameStats1.O_TOV, (object)nbaGameStats1.ORB, (object)nbaGameStats1.O_FT_FGA, (object)nbaGameStats1.ORtg, (object)nbaGameStats1.D_eFG, (object)nbaGameStats1.D_TOV, (object)nbaGameStats1.DRB, (object)nbaGameStats1.D_FT_FGA, (object)nbaGameStats1.DRtg, (object)keyValuePair.Key);
stringBuilder.AppendLine();
stringBuilder.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15}", (object)nbaGameStats1.TeamName, (object)nbaGameInfo.HomePTS, (object)nbaGameStats1.Home, (object)(nbaGameStats1.PTS - nbaGameStats2.PTS), (object)nbaGameStats2.Pace, (object)nbaGameStats2.O_eFG, (object)nbaGameStats2.O_TOV, (object)nbaGameStats2.ORB, (object)nbaGameStats2.O_FT_FGA, (object)nbaGameStats2.ORtg, (object)nbaGameStats2.D_eFG, (object)nbaGameStats2.D_TOV, (object)nbaGameStats2.DRB, (object)nbaGameStats2.D_FT_FGA, (object)nbaGameStats2.DRtg, (object)keyValuePair.Key);
}
}
}
}
File.WriteAllText("D:\\Derek\\NBA\\NBA_FourFactors_PerTeam.csv", stringBuilder.ToString());
}
