/// <summary>
/// Handles the Click event of the mnuMiscEnablePlayers control. Allows the user to enable/disable (i.e. show/hide) specific
/// players in the current season.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">
/// The <see cref="RoutedEventArgs" /> instance containing the event data.
/// </param>
private void mnuMiscEnablePlayers_Click(object sender, RoutedEventArgs e)
{
AddInfo = "";
var etw = new DualListWindow(CurrentDB, CurSeason, SQLiteIO.GetMaxSeason(CurrentDB), DualListWindow.Mode.HiddenPlayers);
etw.ShowDialog();
if (AddInfo == "$$PLAYERSENABLED")
{
PST = SQLiteIO.GetPlayersFromDatabase(CurrentDB, TST, TSTOpp, CurSeason, SQLiteIO.GetMaxSeason(CurrentDB));
UpdateStatus("Players were enabled/disabled. Database saved.");
}
}
private void btnTrade_Click(object sender, RoutedEventArgs e)
{
var w = new DualListWindow(_curTeam, _curTeam == 0 ? 1 : 0);
var res = w.ShowDialog();
if (res == true)
{
MessageBox.Show("Players traded successfully. The database will be saved now. This may take a few moments.");
MainWindow.MWInstance.btnSaveCurrentSeason_Click(null, null);
linkInternalsToMainWindow();
cmbTeam_SelectionChanged(null, null);
}
}
/// <summary>
/// Imports all team (and optionally) player stats from an REDitor-exported set of CSV files.
/// </summary>
/// <param name="tst">The team stats dictionary.</param>
/// <param name="tstOpp">The opposing team stats dictionary.</param>
/// <param name="pst">The player stats dictionary.</param>
/// <param name="folder">The folder containing the exported CSV files.</param>
/// <param name="teamsOnly">
/// if set to <c>true</c>, only team stats will be imported.
/// </param>
/// <returns></returns>
public static int ImportAll(ref Dictionary<int, TeamStats> tst, ref Dictionary<int, TeamStats> tstOpp,
ref Dictionary<int, PlayerStats> pst, string folder, bool teamsOnly = false)
{
List<Dictionary<string, string>> teams;
List<Dictionary<string, string>> players;
List<Dictionary<string, string>> teamStats;
List<Dictionary<string, string>> playerStats;
if (populateREDitorDictionaryLists(folder, out teams, out players, out teamStats, out playerStats) == -1)
{
return -1;
}
var importMessages = new List<string>();
var tradesList = new List<string>();
var faSigningsList = new List<string>();
var reSigningsList = new List<string>();
var waiversList = new List<string>();
var injuredList = new List<string>();
var reInjuredList = new List<string>();
var recoveredList = new List<string>();
#region Import Teams & Team Stats
var legalTTypes = new List<string> {"0", "4"};
List<Dictionary<string, string>> validTeams = teams.FindAll(delegate(Dictionary<string, string> team)
{
if (legalTTypes.IndexOf(team["TType"]) != -1)
{
return true;
}
return false;
});
List<Dictionary<string, string>> activeTeams = validTeams.FindAll(delegate(Dictionary<string, string> team)
{
if (team["StatCurS"] != "-1")
{
return true;
}
return false;
});
if (activeTeams.Count < 30)
{
var dlw = new DualListWindow(validTeams, activeTeams);
if (dlw.ShowDialog() == false)
{
return -1;
}
activeTeams = new List<Dictionary<string, string>>(MainWindow.SelectedTeams);
if (MainWindow.SelectedTeamsChanged)
{
CreateSettingsFile(activeTeams, folder);
}
}
bool madeNew = false;
if (tst.Count != activeTeams.Count)
{
tst = new Dictionary<int, TeamStats>();
tstOpp = new Dictionary<int, TeamStats>();
madeNew = true;
}
Dictionary<int, TeamStats> oldTST = tst.ToDictionary(ts => ts.Key, ts => ts.Value.Clone());
Dictionary<int, TeamStats> oldtstOpp = tstOpp.ToDictionary(ts => ts.Key, ts => ts.Value.Clone());
Dictionary<int, PlayerStats> oldPST = pst.ToDictionary(ps => ps.Key, ps => ps.Value.Clone());
CreateDivisions();
var activeTeamsIDs = new List<int>();
var rosters = new Dictionary<int, List<int>>();
activeTeams.Sort((p1, p2) => Convert.ToInt32(p1["ID"]).CompareTo(Convert.ToInt32(p2["ID"])));
foreach (var team in activeTeams)
{
string name = team["Name"];
int redID = Convert.ToInt32(team["ID"]);
if (tst.Values.All(ts => ts.Name != name))
{
if (tst.Keys.Contains(redID))
{
string oldName = tst[redID].Name;
tst[redID].Name = name;
tstOpp[redID].Name = name;
if (oldName == tst[redID].DisplayName)
{
tst[redID].DisplayName = name;
tstOpp[redID].DisplayName = name;
}
}
}
int id = tst.Values.Single(ts => ts.Name == name).ID;
activeTeamsIDs.Add(Convert.ToInt32(team["ID"]));
if (madeNew)
{
tst[id] = new TeamStats(id, name);
tstOpp[id] = new TeamStats(id, name);
}
int sStatsID = Convert.ToInt32(team["StatCurS"]);
int pStatsID = Convert.ToInt32(team["StatCurP"]);
Dictionary<string, string> sStats = teamStats.Find(delegate(Dictionary<string, string> s)
{
if (s["ID"] == sStatsID.ToString())
{
return true;
}
return false;
});
tst[id].ID = id;
tstOpp[id].ID = id;
tst[id].Division = Convert.ToInt32(team["Division"]);
tstOpp[id].Division = Convert.ToInt32(team["Division"]);
if (sStats != null)
{
tst[id].Record[0] = Convert.ToByte(sStats["Wins"]);
tst[id].Record[1] = Convert.ToByte(sStats["Losses"]);
tst[id].Totals[TAbbr.MINS] = Convert.ToUInt16(sStats["Mins"]);
tst[id].Totals[TAbbr.PF] = Convert.ToUInt16(sStats["PtsFor"]);
tst[id].Totals[TAbbr.PA] = Convert.ToUInt16(sStats["PtsAg"]);
tst[id].Totals[TAbbr.FGM] = Convert.ToUInt16(sStats["FGMade"]);
tst[id].Totals[TAbbr.FGA] = Convert.ToUInt16(sStats["FGAtt"]);
tst[id].Totals[TAbbr.TPM] = Convert.ToUInt16(sStats["3PTMade"]);
tst[id].Totals[TAbbr.TPA] = Convert.ToUInt16(sStats["3PTAtt"]);
tst[id].Totals[TAbbr.FTM] = Convert.ToUInt16(sStats["FTMade"]);
tst[id].Totals[TAbbr.FTA] = Convert.ToUInt16(sStats["FTAtt"]);
tst[id].Totals[TAbbr.DREB] = Convert.ToUInt16(sStats["DRebs"]);
tst[id].Totals[TAbbr.OREB] = Convert.ToUInt16(sStats["ORebs"]);
tst[id].Totals[TAbbr.STL] = Convert.ToUInt16(sStats["Steals"]);
tst[id].Totals[TAbbr.BLK] = Convert.ToUInt16(sStats["Blocks"]);
tst[id].Totals[TAbbr.AST] = Convert.ToUInt16(sStats["Assists"]);
tst[id].Totals[TAbbr.FOUL] = Convert.ToUInt16(sStats["Fouls"]);
tst[id].Totals[TAbbr.TOS] = Convert.ToUInt16(sStats["TOs"]);
if (pStatsID != -1)
{
Dictionary<string, string> pStats = teamStats.Find(delegate(Dictionary<string, string> s)
{
if (s["ID"] == pStatsID.ToString())
{
return true;
}
return false;
});
tst[id].PlRecord[0] = Convert.ToByte(pStats["Wins"]);
tst[id].PlRecord[1] = Convert.ToByte(pStats["Losses"]);
tst[id].PlTotals[TAbbr.MINS] = Convert.ToUInt16(pStats["Mins"]);
tst[id].PlTotals[TAbbr.PF] = Convert.ToUInt16(pStats["PtsFor"]);
tst[id].PlTotals[TAbbr.PA] = Convert.ToUInt16(pStats["PtsAg"]);
tst[id].PlTotals[TAbbr.FGM] = Convert.ToUInt16(pStats["FGMade"]);
tst[id].PlTotals[TAbbr.FGA] = Convert.ToUInt16(pStats["FGAtt"]);
tst[id].PlTotals[TAbbr.TPM] = Convert.ToUInt16(pStats["3PTMade"]);
tst[id].PlTotals[TAbbr.TPA] = Convert.ToUInt16(pStats["3PTAtt"]);
tst[id].PlTotals[TAbbr.FTM] = Convert.ToUInt16(pStats["FTMade"]);
tst[id].PlTotals[TAbbr.FTA] = Convert.ToUInt16(pStats["FTAtt"]);
tst[id].PlTotals[TAbbr.DREB] = Convert.ToUInt16(pStats["DRebs"]);
tst[id].PlTotals[TAbbr.OREB] = Convert.ToUInt16(pStats["ORebs"]);
tst[id].PlTotals[TAbbr.STL] = Convert.ToUInt16(pStats["Steals"]);
tst[id].PlTotals[TAbbr.BLK] = Convert.ToUInt16(pStats["Blocks"]);
tst[id].PlTotals[TAbbr.AST] = Convert.ToUInt16(pStats["Assists"]);
tst[id].PlTotals[TAbbr.FOUL] = Convert.ToUInt16(pStats["Fouls"]);
tst[id].PlTotals[TAbbr.TOS] = Convert.ToUInt16(pStats["TOs"]);
}
}
tst[id].CalcAvg();
rosters[id] = new List<int>
{
Convert.ToInt32(team["Ros_PG"]),
Convert.ToInt32(team["Ros_SG"]),
Convert.ToInt32(team["Ros_SF"]),
Convert.ToInt32(team["Ros_PF"]),
Convert.ToInt32(team["Ros_C"])
};
for (int i = 6; i <= 12; i++)
{
int cur = Convert.ToInt32(team["Ros_S" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
for (int i = 13; i <= 20; i++)
{
int cur = Convert.ToInt32(team["Ros_R" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
}
#endregion
#region Import Players & Player Stats
var duplicatePlayers = new List<string>();
if (!teamsOnly)
{
List<Dictionary<string, string>> validPlayers = players.FindAll(delegate(Dictionary<string, string> player)
{
if (player["PlType"] == "4" || player["PlType"] == "5" || player["PlType"] == "6")
{
if ((player["IsFA"] == "0" && player["TeamID1"] != "-1") || (player["IsFA"] == "1"))
{
return true;
}
}
return false;
});
foreach (var player in validPlayers)
{
int playerID = Convert.ToInt32(player["ID"]);
string lastName = player["Last_Name"];
string firstName = player["First_Name"];
#if DEBUG
//if (LastName == "Felton") System.Diagnostics.Debugger.Break();
#endif
int pTeam;
var curTeam = new TeamStats();
try
{
pTeam = rosters.Single(r => r.Value.Contains(playerID)).Key;
curTeam = tst[pTeam];
}
catch (InvalidOperationException)
{
pTeam = -1;
}
if (pTeam == -1 && player["IsFA"] != "1")
{
if (pst.ContainsKey(playerID) && pst[playerID].LastName == lastName && pst[playerID].FirstName == firstName)
{
pst[playerID].IsActive = false;
pst[playerID].TeamF = -1;
pst[playerID].IsHidden = true;
}
continue;
}
int playerStatsID = Convert.ToInt32(player["StatY0"]);
Dictionary<string, string> plStats = playerStats.Find(delegate(Dictionary<string, string> s)
{
if (s["ID"] == playerStatsID.ToString())
{
return true;
}
return false;
});
if (pst.ContainsKey(playerID) && (pst[playerID].LastName != lastName || pst[playerID].FirstName != firstName))
{
List<KeyValuePair<int, PlayerStats>> candidates =
pst.Where(
pair =>
pair.Value.LastName == lastName && pair.Value.FirstName == firstName && pair.Value.IsHidden == false)
.ToList();
if (candidates.Count > 0)
{
bool found = false;
Dictionary<int, TeamStats> temptst = tst;
List<KeyValuePair<int, PlayerStats>> c2 =
candidates.Where(pair => temptst.ContainsKey(pair.Value.TeamF)).ToList();
if (c2.Count() == 1)
{
playerID = c2.First().Value.ID;
found = true;
}
else
{
List<KeyValuePair<int, PlayerStats>> c4 =
candidates.Where(pair => pair.Value.YearOfBirth.ToString() == player["BirthYear"]).ToList();
if (c4.Count == 1)
{
playerID = c4.First().Value.ID;
found = true;
}
else
{
if (pTeam != -1)
{
List<KeyValuePair<int, PlayerStats>> c3 =
candidates.Where(pair => pair.Value.TeamF == curTeam.ID).ToList();
if (c3.Count == 1)
{
playerID = c3.First().Value.ID;
found = true;
}
}
}
}
if (!found)
{
var choices = new List<string>();
foreach (var pair in candidates)
{
string choice = String.Format("{0}: {1} {2} (Born {3}", pair.Value.ID, pair.Value.FirstName,
pair.Value.LastName, pair.Value.YearOfBirth);
if (pair.Value.IsActive)
{
choice += String.Format(", plays in {0}", tst[pair.Value.TeamF].DisplayName);
}
else
{
choice += ", free agent";
}
choice += ")";
choices.Add(choice);
}
string message = String.Format("{0}: {1} {2} (Born {3}", player["ID"], player["First_Name"],
player["Last_Name"], player["BirthYear"]);
if (pTeam != -1)
{
message += String.Format(", plays in {0}", curTeam.DisplayName);
}
else
{
message += ", free agent";
}
message += ")";
var ccw = new ComboChoiceWindow(message, choices);
if (ccw.ShowDialog() != true)
{
duplicatePlayers.Add(firstName + " " + lastName);
continue;
}
else
{
playerID = Convert.ToInt32(ComboChoiceWindow.UserChoice.Split(':')[0]);
}
}
}
else
{
playerID = createNewPlayer(ref pst, player);
}
}
else if (!pst.ContainsKey(playerID))
{
playerID = createNewPlayer(ref pst, player, playerID);
}
PlayerStats curPlayer = pst[playerID];
PlayerStats oldPlayer = curPlayer.Clone();
curPlayer.Position1 = (Position) Enum.Parse(typeof (Position), player["Pos"]);
curPlayer.Position2 = (Position) Enum.Parse(typeof (Position), player["SecondPos"]);
curPlayer.IsHidden = false;
curPlayer.YearsPro = Convert.ToInt32(player["YearsPro"]);
curPlayer.YearOfBirth = Convert.ToInt32(player["BirthYear"]);
curPlayer.Contract.Option = (PlayerContractOption) Enum.Parse(typeof (PlayerContractOption), player["COption"]);
curPlayer.Contract.ContractSalaryPerYear.Clear();
for (int i = 1; i < 7; i++)
{
int salary = Convert.ToInt32(player["CYear" + i]);
if (salary == 0)
{
break;
}
curPlayer.Contract.ContractSalaryPerYear.Add(salary);
}
curPlayer.Height = Convert.ToDouble(player["Height"]);
curPlayer.Weight = Convert.ToDouble(player["Weight"]);
curPlayer.Injury = new PlayerInjury(Convert.ToInt32(player["InjType"]), Convert.ToInt32(player["InjDaysLeft"]));
if (plStats != null)
{
string teamReal = pTeam.ToString();
string team1 = plStats["TeamID2"];
string team2 = plStats["TeamID1"];
bool hasBeenTraded = (team1 != "-1");
if (teamReal != "-1" && player["IsFA"] != "1")
{
TeamStats ts = tst[pTeam];
}
if (hasBeenTraded)
{
Dictionary<string, string> teamS = teams.Find(delegate(Dictionary<string, string> s)
{
if (s["ID"] == team2)
{
return true;
}
return false;
});
}
PlayerStats ps = curPlayer;
ps.TeamF = pTeam;
ps.TeamS = Convert.ToInt32(team2);
ps.IsActive = (player["IsFA"] != "1" && teamReal != "-1");
ps.Totals[PAbbr.GP] = Convert.ToUInt16(plStats["GamesP"]);
ps.Totals[PAbbr.GS] = Convert.ToUInt16(plStats["GamesS"]);
ps.Totals[PAbbr.MINS] = Convert.ToUInt16(plStats["Minutes"]);
ps.Totals[PAbbr.PTS] = Convert.ToUInt16(plStats["Points"]);
ps.Totals[PAbbr.DREB] = Convert.ToUInt16(plStats["DRebs"]);
ps.Totals[PAbbr.OREB] = Convert.ToUInt16(plStats["ORebs"]);
ps.Totals[PAbbr.AST] = Convert.ToUInt16(plStats["Assists"]);
ps.Totals[PAbbr.STL] = Convert.ToUInt16(plStats["Steals"]);
ps.Totals[PAbbr.BLK] = Convert.ToUInt16(plStats["Blocks"]);
ps.Totals[PAbbr.TOS] = Convert.ToUInt16(plStats["TOs"]);
ps.Totals[PAbbr.FOUL] = Convert.ToUInt16(plStats["Fouls"]);
ps.Totals[PAbbr.FGM] = Convert.ToUInt16(plStats["FGMade"]);
ps.Totals[PAbbr.FGA] = Convert.ToUInt16(plStats["FGAtt"]);
ps.Totals[PAbbr.TPM] = Convert.ToUInt16(plStats["3PTMade"]);
ps.Totals[PAbbr.TPA] = Convert.ToUInt16(plStats["3PTAtt"]);
ps.Totals[PAbbr.FTM] = Convert.ToUInt16(plStats["FTMade"]);
ps.Totals[PAbbr.FTA] = Convert.ToUInt16(plStats["FTAtt"]);
ps.IsAllStar = Convert.ToBoolean(Convert.ToInt32(plStats["IsAStar"]));
ps.IsNBAChampion = Convert.ToBoolean(Convert.ToInt32(plStats["IsChamp"]));
ps.Injury = new PlayerInjury(Convert.ToInt32(player["InjType"]), Convert.ToInt32(player["InjDaysLeft"]));
ps.CalcAvg();
pst[playerID] = ps;
}
else
{
PlayerStats ps = curPlayer;
ps.TeamF = pTeam;
ps.IsActive = player["IsFA"] != "1";
ps.Injury = new PlayerInjury(Convert.ToInt32(player["InjType"]), Convert.ToInt32(player["InjDaysLeft"]));
ps.CalcAvg();
pst[playerID] = ps;
}
#region Import Messsages
string name = String.Format("{0} {1}", curPlayer.FirstName, curPlayer.LastName);
if (oldPlayer.TeamF != curPlayer.TeamF)
{
string msg;
if (curPlayer.IsActive && oldPlayer.IsActive)
{
msg = String.Format("{0} was traded from the {1} to the {2}.", name, tst[oldPlayer.TeamF].DisplayName,
tst[curPlayer.TeamF].DisplayName);
tradesList.Add(msg);
}
else if (oldPlayer.IsActive)
{
msg = String.Format("{0} was released from the {1}.", name, tst[oldPlayer.TeamF].DisplayName);
waiversList.Add(msg);
}
}
if (oldPlayer.Contract.GetYears() < curPlayer.Contract.GetYears() && curPlayer.IsActive)
{
string msg = name;
bool reSigned;
if (!oldPlayer.IsActive && curPlayer.IsActive)
{
reSigned = false;
msg += " signed ";
}
else
{
reSigned = true;
msg += " re-signed ";
}
msg += String.Format("with the {0} on a {1}/{2:C0} ({3:C0} per year) contract.",
tst[curPlayer.TeamF].DisplayName, curPlayer.Contract.GetYearsDesc(),
curPlayer.Contract.GetTotal(), curPlayer.Contract.GetAverage());
if (reSigned)
{
reSigningsList.Add(msg);
}
else
{
faSigningsList.Add(msg);
}
}
if (oldPlayer.Injury.InjuryName != curPlayer.Injury.InjuryName)
{
if (!oldPlayer.Injury.IsInjured)
{
injuredList.Add(name + " got injured. Status: " + curPlayer.Injury.Status);
}
else if (!curPlayer.Injury.IsInjured)
{
recoveredList.Add(name + " is no longer injured.");
}
else
{
reInjuredList.Add(name + " was injured with " + oldPlayer.Injury.InjuryName +
", is now injured again. Status: " + curPlayer.Injury.Status);
}
}
#endregion
}
}
if (duplicatePlayers.Count > 0)
{
string msg =
"The following names belong to two or more players in the database and the tool couldn't determine who to import to:\n\n";
duplicatePlayers.ForEach(item => msg += item + ", ");
msg = msg.TrimEnd(new[] {' ', ','});
msg += "\n\nImport will continue, but there will be some stats missing." + "\n\nTo avoid this problem, either\n" +
"1) disable the duplicate occurences via (Miscellaneous > Enable/Disable Players For This Season...), or\n" +
"2) transfer the correct instance of the player to their current team.";
MessageBox.Show(msg);
}
#endregion
#region Check for box-scores we can calculate
if (oldTST.Count == 30)
{
TeamsThatPlayedAGame = new List<int>();
foreach (var team in tst)
{
TeamStats newTeam = team.Value;
int teamID = team.Key;
TeamStats oldTeam = oldTST[teamID];
if (oldTeam.GetGames() + 1 == newTeam.GetGames() || oldTeam.GetPlayoffGames() + 1 == newTeam.GetPlayoffGames())
{
TeamsThatPlayedAGame.Add(team.Key);
}
}
if (TeamsThatPlayedAGame.Count >= 2)
{
PickedTeams = new List<int>();
var dlw = new PickGamesWindow(TeamsThatPlayedAGame);
if (dlw.ShowDialog() == true)
{
for (int i = 0; i <= PickedTeams.Count - 2; i += 2)
{
int t1 = PickedTeams[i];
int t2 = PickedTeams[i + 1];
BoxScoreEntry bse = prepareBoxScore(tst, oldTST, pst, oldPST, t1, t2);
TeamBoxScore teamBoxScore = bse.BS;
BoxScoreWindow.CalculateTeamsFromPlayers(ref teamBoxScore,
bse.PBSList.Where(pbs => pbs.TeamID == bse.BS.Team1ID),
bse.PBSList.Where(pbs => pbs.TeamID == bse.BS.Team2ID));
if (teamBoxScore.PTS1 != getDiff(tst, oldTST, t1, TAbbr.PF, teamBoxScore.IsPlayoff) ||
teamBoxScore.PTS2 != getDiff(tst, oldTST, t2, TAbbr.PF, teamBoxScore.IsPlayoff))
{
MessageBox.Show(
String.Format(
"{0} @ {1} won't have its box-score imported because it couldn't be properly calculated. A possible reason for this is that one or more players participating in that game has been since traded away from the teams.",
tst[t1].DisplayName, tst[t2].DisplayName), "NBA Stats Tracker", MessageBoxButton.OK,
MessageBoxImage.Exclamation);
continue;
}
bse.BS.GameDate = SelectedDate;
bse.Date = bse.BS.GameDate;
TeamStats.AddTeamStatsFromBoxScore(bse.BS, ref oldTST, ref oldtstOpp, t1, t2);
MainWindow.BSHist.Add(bse);
tst[t1] = oldTST[t1].Clone();
tst[t2] = oldTST[t2].Clone();
tstOpp[t1] = oldtstOpp[t1].Clone();
tstOpp[t2] = oldtstOpp[t2].Clone();
}
}
}
}
#endregion
if (tradesList.Count + faSigningsList.Count + reSigningsList.Count + waiversList.Count > 0)
{
importMessages.Add("League Transactions");
importMessages.Add("========================================");
importMessages.Add("");
if (tradesList.Count > 0)
{
importMessages.Add("Players traded");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(tradesList);
importMessages.Add("");
}
if (faSigningsList.Count > 0)
{
importMessages.Add("Players signed from free-agency");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(faSigningsList);
importMessages.Add("");
}
if (reSigningsList.Count > 0)
{
importMessages.Add("Players that signed an extension");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(reSigningsList);
importMessages.Add("");
}
if (waiversList.Count > 0)
{
importMessages.Add("Players waived");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(waiversList);
importMessages.Add("");
}
importMessages.Add("");
importMessages.Add("");
}
if (injuredList.Count + reInjuredList.Count + recoveredList.Count > 0)
{
importMessages.Add("Injury Updates");
importMessages.Add("========================================");
importMessages.Add("");
if (injuredList.Count > 0)
{
importMessages.Add("Players injured");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(injuredList);
importMessages.Add("");
}
if (reInjuredList.Count > 0)
{
importMessages.Add("Players that got injured again after recovery");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(reInjuredList);
importMessages.Add("");
}
if (recoveredList.Count > 0)
{
importMessages.Add("Players recovered");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(recoveredList);
importMessages.Add("");
}
}
if (importMessages.Count > 0)
{
importMessages.Add("");
var cmw = new CopyableMessageWindow(importMessages.Aggregate((m1, m2) => m1 + "\n" + m2), "League News",
TextAlignment.Left);
cmw.ShowDialog();
}
return 0;
}
/// <summary>
/// Handles the Click event of the mnuMiscEnableTeams control. Used to enable/disable (i.e. show/hide) teams for the current
/// season.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">
/// The <see cref="RoutedEventArgs" /> instance containing the event data.
/// </param>
private void mnuMiscEnableTeams_Click(object sender, RoutedEventArgs e)
{
AddInfo = "";
var etw = new DualListWindow(CurrentDB, CurSeason, SQLiteIO.GetMaxSeason(CurrentDB), DualListWindow.Mode.HiddenTeams);
etw.ShowDialog();
if (AddInfo == "$$TEAMSENABLED")
{
SQLiteIO.GetAllTeamStatsFromDatabase(CurrentDB, CurSeason, out TST, out TSTOpp);
UpdateStatus("Teams were enabled/disabled. Database saved.");
}
}
public static int ImportPrevious(ref Dictionary<int, TeamStats> tst, ref Dictionary<int, TeamStats> tstOpp,
ref Dictionary<int, PlayerStats> pst, string folder, bool teamsOnly = false)
{
List<Dictionary<string, string>> teams;
List<Dictionary<string, string>> players;
List<Dictionary<string, string>> teamStats;
List<Dictionary<string, string>> playerStats;
if (populateREDitorDictionaryLists(folder, out teams, out players, out teamStats, out playerStats) == -1)
{
return -1;
}
#region Import Teams & Team Stats
var legalTTypes = new List<string> {"0", "4"};
List<Dictionary<string, string>> validTeams = teams.FindAll(delegate(Dictionary<string, string> team)
{
if (legalTTypes.IndexOf(team["TType"]) != -1)
{
return true;
}
return false;
});
List<Dictionary<string, string>> activeTeams = validTeams.FindAll(delegate(Dictionary<string, string> team)
{
if (team["StatCurS"] != "-1")
{
return true;
}
return false;
});
/*
if (activeTeams.Count == 0)
{
MessageBox.Show("No Team Stats found in save.");
return -1;
}
*/
if (activeTeams.Count < 30)
{
var dlw = new DualListWindow(validTeams, activeTeams);
if (dlw.ShowDialog() == false)
{
return -1;
}
activeTeams = new List<Dictionary<string, string>>(MainWindow.SelectedTeams);
if (MainWindow.SelectedTeamsChanged)
{
CreateSettingsFile(activeTeams, folder);
}
}
bool madeNew = false;
if (tst.Count != activeTeams.Count)
{
tst = new Dictionary<int, TeamStats>();
tstOpp = new Dictionary<int, TeamStats>();
madeNew = true;
}
Dictionary<int, TeamStats> oldTST = tst.ToDictionary(ts => ts.Key, ts => ts.Value.Clone());
Dictionary<int, TeamStats> oldtstOpp = tstOpp.ToDictionary(ts => ts.Key, ts => ts.Value.Clone());
Dictionary<int, PlayerStats> oldPST = pst.ToDictionary(ps => ps.Key, ps => ps.Value.Clone());
CreateDivisions();
var activeTeamsIDs = new List<int>();
var rosters = new Dictionary<int, List<int>>();
foreach (var team in activeTeams)
{
int id = -1;
string name = team["Name"];
if (oldTST.All(pair => pair.Value.Name != name))
{
for (int i = 0; i < 30; i++)
{
if (!tst.ContainsKey(i))
{
id = i;
break;
}
}
}
else
{
id = oldTST.Single(pair => pair.Value.Name == name).Key;
}
activeTeamsIDs.Add(Convert.ToInt32(team["ID"]));
if (madeNew)
{
tst[id] = new TeamStats(id, name);
tstOpp[id] = new TeamStats(id, name);
}
int sStatsID = Convert.ToInt32(team["StatPrevS"]);
int pStatsID = Convert.ToInt32(team["StatPrevP"]);
Dictionary<string, string> sStats = teamStats.Find(delegate(Dictionary<string, string> s)
{
if (s["ID"] == sStatsID.ToString())
{
return true;
}
return false;
});
TeamStats curTeam = tst[id];
curTeam.ID = Convert.ToInt32(team["ID"]);
curTeam.Division = Convert.ToInt32(team["Division"]);
tstOpp[id].Division = Convert.ToInt32(team["Division"]);
if (sStats != null)
{
curTeam.Record[0] = Convert.ToByte(sStats["Wins"]);
curTeam.Record[1] = Convert.ToByte(sStats["Losses"]);
curTeam.Totals[TAbbr.MINS] = Convert.ToUInt16(sStats["Mins"]);
curTeam.Totals[TAbbr.PF] = Convert.ToUInt16(sStats["PtsFor"]);
curTeam.Totals[TAbbr.PA] = Convert.ToUInt16(sStats["PtsAg"]);
curTeam.Totals[TAbbr.FGM] = Convert.ToUInt16(sStats["FGMade"]);
curTeam.Totals[TAbbr.FGA] = Convert.ToUInt16(sStats["FGAtt"]);
curTeam.Totals[TAbbr.TPM] = Convert.ToUInt16(sStats["3PTMade"]);
curTeam.Totals[TAbbr.TPA] = Convert.ToUInt16(sStats["3PTAtt"]);
curTeam.Totals[TAbbr.FTM] = Convert.ToUInt16(sStats["FTMade"]);
curTeam.Totals[TAbbr.FTA] = Convert.ToUInt16(sStats["FTAtt"]);
curTeam.Totals[TAbbr.DREB] = Convert.ToUInt16(sStats["DRebs"]);
curTeam.Totals[TAbbr.OREB] = Convert.ToUInt16(sStats["ORebs"]);
curTeam.Totals[TAbbr.STL] = Convert.ToUInt16(sStats["Steals"]);
curTeam.Totals[TAbbr.BLK] = Convert.ToUInt16(sStats["Blocks"]);
curTeam.Totals[TAbbr.AST] = Convert.ToUInt16(sStats["Assists"]);
curTeam.Totals[TAbbr.FOUL] = Convert.ToUInt16(sStats["Fouls"]);
curTeam.Totals[TAbbr.TOS] = Convert.ToUInt16(sStats["TOs"]);
//tstOpp[id].stats[t.TO] = Convert.ToUInt16(sStats["TOsAg"]);
if (pStatsID != -1)
{
Dictionary<string, string> pStats = teamStats.Find(delegate(Dictionary<string, string> s)
{
if (s["ID"] == pStatsID.ToString())
{
return true;
}
return false;
});
curTeam.PlRecord[0] = Convert.ToByte(pStats["Wins"]);
curTeam.PlRecord[1] = Convert.ToByte(pStats["Losses"]);
curTeam.PlTotals[TAbbr.MINS] = Convert.ToUInt16(pStats["Mins"]);
curTeam.PlTotals[TAbbr.PF] = Convert.ToUInt16(pStats["PtsFor"]);
curTeam.PlTotals[TAbbr.PA] = Convert.ToUInt16(pStats["PtsAg"]);
curTeam.PlTotals[TAbbr.FGM] = Convert.ToUInt16(pStats["FGMade"]);
curTeam.PlTotals[TAbbr.FGA] = Convert.ToUInt16(pStats["FGAtt"]);
curTeam.PlTotals[TAbbr.TPM] = Convert.ToUInt16(pStats["3PTMade"]);
curTeam.PlTotals[TAbbr.TPA] = Convert.ToUInt16(pStats["3PTAtt"]);
curTeam.PlTotals[TAbbr.FTM] = Convert.ToUInt16(pStats["FTMade"]);
curTeam.PlTotals[TAbbr.FTA] = Convert.ToUInt16(pStats["FTAtt"]);
curTeam.PlTotals[TAbbr.DREB] = Convert.ToUInt16(pStats["DRebs"]);
curTeam.PlTotals[TAbbr.OREB] = Convert.ToUInt16(pStats["ORebs"]);
curTeam.PlTotals[TAbbr.STL] = Convert.ToUInt16(pStats["Steals"]);
curTeam.PlTotals[TAbbr.BLK] = Convert.ToUInt16(pStats["Blocks"]);
curTeam.PlTotals[TAbbr.AST] = Convert.ToUInt16(pStats["Assists"]);
curTeam.PlTotals[TAbbr.FOUL] = Convert.ToUInt16(pStats["Fouls"]);
curTeam.PlTotals[TAbbr.TOS] = Convert.ToUInt16(pStats["TOs"]);
//tstOpp[id].pl_stats[t.TO] = Convert.ToUInt16(pStats["TOsAg"]);
}
}
curTeam.CalcAvg();
rosters[id] = new List<int>
{
Convert.ToInt32(team["Ros_PG"]),
Convert.ToInt32(team["Ros_SG"]),
Convert.ToInt32(team["Ros_SF"]),
Convert.ToInt32(team["Ros_PF"]),
Convert.ToInt32(team["Ros_C"])
};
for (int i = 6; i <= 12; i++)
{
int cur = Convert.ToInt32(team["Ros_S" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
for (int i = 13; i <= 20; i++)
{
int cur = Convert.ToInt32(team["Ros_R" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
}
#endregion
#region Import Players & Player Stats
var duplicatePlayers = new List<string>();
if (!teamsOnly)
{
List<Dictionary<string, string>> validPlayers = players.FindAll(delegate(Dictionary<string, string> player)
{
if (player["PlType"] == "4" || player["PlType"] == "5" || player["PlType"] == "6")
{
if (((player["IsFA"] == "0" && player["TeamID1"] != "-1") || (player["IsFA"] == "1")) &&
player["YearsPro"] != "1")
{
return true;
}
}
return false;
});
foreach (var player in validPlayers)
{
int playerID = Convert.ToInt32(player["ID"]);
string lastName = player["Last_Name"];
string firstName = player["First_Name"];
//if (LastName == "Kemp") System.Diagnostics.Debugger.Break();
int pTeam;
try
{
pTeam = rosters.Single(r => r.Value.Contains(playerID)).Key;
}
catch (InvalidOperationException)
{
pTeam = -1;
}
PlayerStats curPlayer = pst[playerID];
if (!activeTeamsIDs.Contains(pTeam) && player["IsFA"] != "1")
{
if (pst.ContainsKey(playerID) && (curPlayer.LastName == lastName) && curPlayer.FirstName == firstName)
{
curPlayer.IsActive = false;
curPlayer.TeamF = -1;
curPlayer.IsHidden = true;
}
continue;
}
int playerStatsID = Convert.ToInt32(player["StatY1"]);
Dictionary<string, string> plStats = playerStats.Find(delegate(Dictionary<string, string> s)
{
if (s["ID"] == playerStatsID.ToString())
{
return true;
}
return false;
});
if (pst.ContainsKey(playerID) && (curPlayer.LastName != lastName || curPlayer.FirstName != firstName))
{
List<KeyValuePair<int, PlayerStats>> candidates =
pst.Where(
pair =>
pair.Value.LastName == lastName && pair.Value.FirstName == firstName && pair.Value.IsHidden == false)
.ToList();
if (candidates.Any())
{
Dictionary<int, TeamStats> temptst = tst;
List<KeyValuePair<int, PlayerStats>> c2 =
candidates.Where(pair => temptst.ContainsKey(pair.Value.TeamF)).ToList();
if (c2.Count() == 1)
{
playerID = c2.First().Value.ID;
}
else
{
if (pTeam != -1)
{
KeyValuePair<int, TeamStats> curTeam =
tst.Single(
team =>
team.Value.Name == activeTeams.Find(ateam => ateam["ID"] == pTeam.ToString())["Name"]);
List<KeyValuePair<int, PlayerStats>> c3 =
candidates.Where(pair => pair.Value.TeamF == curTeam.Value.ID).ToList();
if (c3.Count == 1)
{
playerID = c3.First().Value.ID;
}
else
{
duplicatePlayers.Add(firstName + " " + lastName);
continue;
}
}
}
}
else
{
playerID = createNewPlayer(ref pst, player);
}
}
else if (!pst.ContainsKey(playerID))
{
playerID = createNewPlayer(ref pst, player, playerID);
}
curPlayer.IsHidden = false;
curPlayer.YearsPro = Convert.ToInt32(player["YearsPro"]);
curPlayer.YearOfBirth = Convert.ToInt32(player["BirthYear"]);
curPlayer.Height = Convert.ToDouble(player["Height"]);
curPlayer.Weight = Convert.ToDouble(player["Weight"]);
if (plStats != null)
{
string team1 = plStats["TeamID2"];
string team2 = plStats["TeamID1"];
bool hasBeenTraded = (team1 != "-1");
if (!hasBeenTraded)
{
team1 = team2;
}
PlayerStats ps = curPlayer;
ps.TeamF = Convert.ToInt32(team1);
ps.TeamS = Convert.ToInt32(team2);
ps.IsActive = (player["IsFA"] != "1" && team1 != "-1");
ps.Totals[PAbbr.GP] = Convert.ToUInt16(plStats["GamesP"]);
ps.Totals[PAbbr.GS] = Convert.ToUInt16(plStats["GamesS"]);
ps.Totals[PAbbr.MINS] = Convert.ToUInt16(plStats["Minutes"]);
ps.Totals[PAbbr.PTS] = Convert.ToUInt16(plStats["Points"]);
ps.Totals[PAbbr.DREB] = Convert.ToUInt16(plStats["DRebs"]);
ps.Totals[PAbbr.OREB] = Convert.ToUInt16(plStats["ORebs"]);
ps.Totals[PAbbr.AST] = Convert.ToUInt16(plStats["Assists"]);
ps.Totals[PAbbr.STL] = Convert.ToUInt16(plStats["Steals"]);
ps.Totals[PAbbr.BLK] = Convert.ToUInt16(plStats["Blocks"]);
ps.Totals[PAbbr.TOS] = Convert.ToUInt16(plStats["TOs"]);
ps.Totals[PAbbr.FOUL] = Convert.ToUInt16(plStats["Fouls"]);
ps.Totals[PAbbr.FGM] = Convert.ToUInt16(plStats["FGMade"]);
ps.Totals[PAbbr.FGA] = Convert.ToUInt16(plStats["FGAtt"]);
ps.Totals[PAbbr.TPM] = Convert.ToUInt16(plStats["3PTMade"]);
ps.Totals[PAbbr.TPA] = Convert.ToUInt16(plStats["3PTAtt"]);
ps.Totals[PAbbr.FTM] = Convert.ToUInt16(plStats["FTMade"]);
ps.Totals[PAbbr.FTA] = Convert.ToUInt16(plStats["FTAtt"]);
ps.IsAllStar = Convert.ToBoolean(Convert.ToInt32(plStats["IsAStar"]));
ps.IsNBAChampion = Convert.ToBoolean(Convert.ToInt32(plStats["IsChamp"]));
ps.Injury = new PlayerInjury(Convert.ToInt32(player["InjType"]), Convert.ToInt32(player["InjDaysLeft"]));
ps.CalcAvg();
pst[playerID] = ps;
}
}
}
if (duplicatePlayers.Count > 0)
{
string msg =
"The following names belong to two or more players in the database and the tool couldn't determine who to import to:\n\n";
duplicatePlayers.ForEach(item => msg += item + ", ");
msg = msg.TrimEnd(new[] {' ', ','});
msg += "\n\nImport will continue, but there will be some stats missing." + "\n\nTo avoid this problem, either\n" +
"1) disable the duplicate occurences via (Miscellaneous > Enable/Disable Players For This Season...), or\n" +
"2) transfer the correct instance of the player to their current team.";
MessageBox.Show(msg);
}
#endregion
return 0;
}
public static void ImportOld(Dictionary<int, PlayerStats> pst, Dictionary<int, TeamStats> tst, string folder)
{
if (tst.Count != 30)
{
MessageBox.Show("Can't import previous player stats to a database that doesn't have 30 teams. Please import " +
"your NBA 2K save once to this database to populate it properly before trying to import previous " +
"player stats.");
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(-2);
return;
}
var list = new List<string> {"1 season ago"};
for (int i = 2; i <= 20; i++)
{
list.Add(i + " seasons ago");
}
int startAt;
var ccw = new ComboChoiceWindow("Add player stats staring from...", list);
if (ccw.ShowDialog() != true)
{
MainWindow.MWInstance.mainGrid.Visibility = Visibility.Visible;
return;
}
startAt = Convert.ToInt32(ComboChoiceWindow.UserChoice.Split(' ')[0]);
var ibw =
new InputBoxWindow(
"Enter the current season (e.g. 2011-2012 by default in NBA 2K12, 2012 for a season" +
" taking place only in that year, etc.):", "2011-2012");
if (ibw.ShowDialog() != true)
{
MainWindow.MWInstance.mainGrid.Visibility = Visibility.Visible;
return;
}
int year;
bool twoPartSeasonDesc = InputBoxWindow.UserInput.Contains("-");
try
{
year = Convert.ToInt32(twoPartSeasonDesc ? InputBoxWindow.UserInput.Split('-')[0] : InputBoxWindow.UserInput);
}
catch
{
MessageBox.Show("The year you entered (" + InputBoxWindow.UserInput +
") was not in a valid format.\nValid formats are:\n\t2012\n\t2011-2012");
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(-2);
return;
}
var seasonNames = new Dictionary<int, string>();
for (int i = startAt; i <= 20; i++)
{
seasonNames.Add(i, twoPartSeasonDesc ? string.Format("{0}-{1}", year - i, (year - i + 1)) : (year - i).ToString());
}
List<Dictionary<string, string>> teams;
List<Dictionary<string, string>> players;
List<Dictionary<string, string>> teamStats;
List<Dictionary<string, string>> playerStats;
if (populateREDitorDictionaryLists(folder, out teams, out players, out teamStats, out playerStats) == -1)
{
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(-1);
return;
}
var legalTTypes = new List<string> {"0", "4"};
List<Dictionary<string, string>> validTeams = teams.FindAll(delegate(Dictionary<string, string> team)
{
if (legalTTypes.IndexOf(team["TType"]) != -1)
{
return true;
}
return false;
});
List<Dictionary<string, string>> activeTeams = validTeams.FindAll(delegate(Dictionary<string, string> team)
{
if (team["StatCurS"] != "-1")
{
return true;
}
return false;
});
if (activeTeams.Count < 30)
{
var dlw = new DualListWindow(validTeams, activeTeams);
if (dlw.ShowDialog() == false)
{
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(-1);
return;
}
activeTeams = new List<Dictionary<string, string>>(MainWindow.SelectedTeams);
if (MainWindow.SelectedTeamsChanged)
{
CreateSettingsFile(activeTeams, folder);
}
}
var activeTeamsIDs = new List<int>();
var rosters = new Dictionary<int, List<int>>();
foreach (var team in activeTeams)
{
int id = -1;
string name = team["Name"];
if (tst.All(pair => pair.Value.Name != name))
{
for (int i = 0; i < 30; i++)
{
if (!tst.ContainsKey(i))
{
id = i;
break;
}
}
}
else
{
id = tst.Single(pair => pair.Value.Name == name).Key;
}
activeTeamsIDs.Add(Convert.ToInt32(team["ID"]));
rosters[id] = new List<int>
{
Convert.ToInt32(team["Ros_PG"]),
Convert.ToInt32(team["Ros_SG"]),
Convert.ToInt32(team["Ros_SF"]),
Convert.ToInt32(team["Ros_PF"]),
Convert.ToInt32(team["Ros_C"])
};
for (int i = 6; i <= 12; i++)
{
int cur = Convert.ToInt32(team["Ros_S" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
for (int i = 13; i <= 20; i++)
{
int cur = Convert.ToInt32(team["Ros_R" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
}
List<Dictionary<string, string>> validPlayers = players.FindAll(delegate(Dictionary<string, string> player)
{
if (player["PlType"] == "4" || player["PlType"] == "5" || player["PlType"] == "6")
{
if ((player["IsFA"] == "0" && player["TeamID1"] != "-1") || (player["IsFA"] == "1"))
{
return true;
}
}
return false;
});
var pw = new ProgressWindow("Please wait as player career stats are being imported...");
pw.Show();
var bw = new BackgroundWorker {WorkerReportsProgress = true};
bw.DoWork += delegate
{
int count = validPlayers.Count;
var ppsList = new List<PastPlayerStats>();
for (int i = 0; i < count; i++)
{
int percentProgress = i*100/count;
if (percentProgress%5 == 0)
{
bw.ReportProgress(percentProgress);
}
Dictionary<string, string> player = validPlayers[i];
int playerID = Convert.ToInt32(player["ID"]);
string lastName = player["Last_Name"];
string firstName = player["First_Name"];
int pTeam;
var curTeam = new TeamStats();
try
{
pTeam = rosters.Single(r => r.Value.Contains(playerID)).Key;
curTeam = tst[pTeam];
}
catch (InvalidOperationException)
{
pTeam = -1;
}
if (!activeTeamsIDs.Contains(pTeam) && player["IsFA"] != "1")
{
if (pst.ContainsKey(playerID) && pst[playerID].LastName == lastName && pst[playerID].FirstName == firstName)
{
pst[playerID].IsActive = false;
pst[playerID].TeamF = -1;
pst[playerID].IsHidden = true;
}
continue;
}
if (pst.ContainsKey(playerID) && (pst[playerID].LastName != lastName || pst[playerID].FirstName != firstName))
{
List<KeyValuePair<int, PlayerStats>> candidates =
pst.Where(
pair =>
pair.Value.LastName == lastName && pair.Value.FirstName == firstName &&
pair.Value.IsHidden == false).ToList();
if (candidates.Count > 0)
{
bool found = false;
List<KeyValuePair<int, PlayerStats>> c2 =
candidates.Where(pair => tst.ContainsKey(pair.Value.TeamF)).ToList();
if (c2.Count() == 1)
{
playerID = c2.First().Value.ID;
found = true;
}
else
{
List<KeyValuePair<int, PlayerStats>> c4 =
candidates.Where(pair => pair.Value.YearOfBirth.ToString() == player["BirthYear"]).ToList();
if (c4.Count == 1)
{
playerID = c4.First().Value.ID;
found = true;
}
else
{
if (pTeam != -1)
{
List<KeyValuePair<int, PlayerStats>> c3 =
candidates.Where(pair => pair.Value.TeamF == curTeam.ID).ToList();
if (c3.Count == 1)
{
playerID = c3.First().Value.ID;
found = true;
}
}
}
}
if (!found)
{
var choices = new List<string>();
foreach (var pair in candidates)
{
string choice = String.Format("{0}: {1} {2} (Born {3}", pair.Value.ID, pair.Value.FirstName,
pair.Value.LastName, pair.Value.YearOfBirth);
if (pair.Value.IsActive)
{
choice += String.Format(", plays in {0}", pair.Value.TeamF);
}
else
{
choice += ", free agent";
}
choice += ")";
choices.Add(choice);
}
string message = String.Format("{0}: {1} {2} (Born {3}", player["ID"], player["First_Name"],
player["Last_Name"], player["BirthYear"]);
if (pTeam != -1)
{
message += String.Format(", plays in {0}", curTeam.DisplayName);
}
else
{
message += ", free agent";
}
message += ")";
ccw = new ComboChoiceWindow(message, choices);
if (ccw.ShowDialog() != true)
{
continue;
}
else
{
playerID = Convert.ToInt32(ComboChoiceWindow.UserChoice.Split(':')[0]);
}
}
}
else
{
continue;
}
}
else if (!pst.ContainsKey(playerID))
{
continue;
}
PlayerStats curPlayer = pst[playerID];
string qr = "SELECT * FROM PastPlayerStats WHERE PlayerID = " + playerID + " ORDER BY \"SOrder\"";
DataTable dt = MainWindow.DB.GetDataTable(qr);
dt.Rows.Cast<DataRow>().ToList().ForEach(dr => ppsList.Add(new PastPlayerStats(dr)));
for (int j = startAt; j <= 20; j++)
{
string statEntryID = player["StatY" + j];
if (statEntryID == "-1")
{
break;
}
Dictionary<string, string> plStats = playerStats.Single(d => d["ID"] == statEntryID);
var prevStats = new PastPlayerStats();
string teamID2 = plStats["TeamID2"];
string teamID1 = plStats["TeamID1"];
if (teamID2 == "-1")
{
if (teamID1 != "-1")
{
prevStats.TeamFName = teams.Single(team => team["ID"] == teamID1)["Name"];
}
}
else
{
prevStats.TeamFName = teams.Single(team => team["ID"] == teamID2)["Name"];
if (teamID1 != "-1")
{
prevStats.TeamSName = teams.Single(team => team["ID"] == teamID1)["Name"];
}
}
prevStats.GP = Convert.ToUInt16(plStats["GamesP"]);
prevStats.GS = Convert.ToUInt16(plStats["GamesS"]);
prevStats.MINS = Convert.ToUInt16(plStats["Minutes"]);
prevStats.PTS = Convert.ToUInt16(plStats["Points"]);
prevStats.DREB = Convert.ToUInt16(plStats["DRebs"]);
prevStats.OREB = Convert.ToUInt16(plStats["ORebs"]);
prevStats.AST = Convert.ToUInt16(plStats["Assists"]);
prevStats.STL = Convert.ToUInt16(plStats["Steals"]);
prevStats.BLK = Convert.ToUInt16(plStats["Blocks"]);
prevStats.TOS = Convert.ToUInt16(plStats["TOs"]);
prevStats.FOUL = Convert.ToUInt16(plStats["Fouls"]);
prevStats.FGM = Convert.ToUInt16(plStats["FGMade"]);
prevStats.FGA = Convert.ToUInt16(plStats["FGAtt"]);
prevStats.TPM = Convert.ToUInt16(plStats["3PTMade"]);
prevStats.TPA = Convert.ToUInt16(plStats["3PTAtt"]);
prevStats.FTM = Convert.ToUInt16(plStats["FTMade"]);
prevStats.FTA = Convert.ToUInt16(plStats["FTAtt"]);
prevStats.PlayerID = playerID;
prevStats.SeasonName = seasonNames[j];
prevStats.IsPlayoff = false;
prevStats.Order = 20 - j;
prevStats.EndEdit();
ppsList.Add(prevStats);
}
}
bw.ReportProgress(99, "Please wait while the player career stats are being saved...");
SQLiteIO.SavePastPlayerStatsToDatabase(MainWindow.DB, ppsList);
};
bw.RunWorkerCompleted += delegate
{
pw.CanClose = true;
pw.Close();
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(0);
};
bw.ProgressChanged += delegate(object sender, ProgressChangedEventArgs args)
{
pw.SetProgressBarValue(args.ProgressPercentage);
if (args.UserState != null)
{
pw.SetMessage(args.UserState.ToString());
}
};
bw.RunWorkerAsync();
}
/// <summary>Imports all team (and optionally) player stats from an REDitor-exported set of CSV files.</summary>
/// <param name="tst">The team stats dictionary.</param>
/// <param name="tstOpp">The opposing team stats dictionary.</param>
/// <param name="pst">The player stats dictionary.</param>
/// <param name="folder">The folder containing the exported CSV files.</param>
/// <param name="teamsOnly">
/// if set to <c>true</c>, only team stats will be imported.
/// </param>
/// <returns></returns>
public static int ImportCurrentYear(
ref Dictionary<int, TeamStats> tst,
ref Dictionary<int, TeamStats> tstOpp,
ref Dictionary<int, PlayerStats> pst,
string folder,
bool teamsOnly = false)
{
List<Dictionary<string, string>> teams;
List<Dictionary<string, string>> players;
List<Dictionary<string, string>> teamStats;
List<Dictionary<string, string>> playerStats;
NBA2KVersion nba2KVersion;
if (populateREDitorDictionaryLists(folder, out teams, out players, out teamStats, out playerStats, out nba2KVersion) == -1)
{
return -1;
}
initializeLegalTeamTypes(nba2KVersion);
var importMessages = new List<string>();
var tradesList = new List<string>();
var faSigningsList = new List<string>();
var reSigningsList = new List<string>();
var waiversList = new List<string>();
var injuredList = new List<string>();
var reInjuredList = new List<string>();
var recoveredList = new List<string>();
var newRecordsList = new List<string>();
#region Import Teams & Team Stats
var validTeams = teams.FindAll(
delegate(Dictionary<string, string> team)
{
if (legalTTypes.IndexOf(team["TType"]) != -1)
{
return true;
}
return false;
});
var activeTeams = validTeams.FindAll(
delegate(Dictionary<string, string> team)
{
if (team["StatCurS"] != "-1")
{
return true;
}
return false;
}).ToList();
if (activeTeams.Count < 30)
{
bool? dialogResult = null;
Tools.AppInvoke(
() =>
{
var dlw = new DualListWindow(validTeams, activeTeams);
dialogResult = dlw.ShowDialog();
});
if (dialogResult != true)
{
return -1;
}
activeTeams = new List<Dictionary<string, string>>(MainWindow.SelectedTeams);
if (MainWindow.SelectedTeamsChanged)
{
createSettingsFile(activeTeams, folder);
}
}
var madeNew = false;
if (tst.Count != activeTeams.Count)
{
tst = new Dictionary<int, TeamStats>();
tstOpp = new Dictionary<int, TeamStats>();
madeNew = true;
}
var oldTST = tst.ToDictionary(ts => ts.Key, ts => ts.Value.BinarySerializationClone());
var oldtstOpp = tstOpp.ToDictionary(ts => ts.Key, ts => ts.Value.BinarySerializationClone());
var oldPST = pst.ToDictionary(ps => ps.Key, ps => ps.Value.BinarySerializationClone());
CreateDivisions();
var activeTeamsIDs = new List<int>();
var rosters = new Dictionary<int, List<int>>();
activeTeams.Sort((p1, p2) => Convert.ToInt32(p1["ID"]).CompareTo(Convert.ToInt32(p2["ID"])));
foreach (var team in activeTeams)
{
var name = team["Name"];
if (nba2KVersion != NBA2KVersion.NBA2K12)
{
name += (team["Year"] == "0" ? "" : team["Year"].PadLeft(2, '0'));
}
var redID = Convert.ToInt32(team["ID"]);
if (tst.Values.All(ts => ts.Name != name))
{
if (tst.Keys.Contains(redID))
{
var oldName = tst[redID].Name;
tst[redID].Name = name;
tstOpp[redID].Name = name;
if (oldName == tst[redID].DisplayName)
{
tst[redID].DisplayName = name;
tstOpp[redID].DisplayName = name;
}
}
else
{
tst.Add(redID, new TeamStats(redID, name));
tstOpp.Add(redID, new TeamStats(redID, name));
}
}
var id = tst.Values.Single(ts => ts.Name == name).ID;
activeTeamsIDs.Add(Convert.ToInt32(team["ID"]));
if (madeNew)
{
tst[id] = new TeamStats(id, name);
tstOpp[id] = new TeamStats(id, name);
}
var sStatsID = Convert.ToInt32(team["StatCurS"]);
var pStatsID = Convert.ToInt32(team["StatCurP"]);
var sStats = teamStats.Find(
delegate(Dictionary<string, string> s)
{
if (s["ID"] == sStatsID.ToString())
{
return true;
}
return false;
});
tst[id].ID = id;
tstOpp[id].ID = id;
tst[id].Division = Convert.ToInt32(team["Division"]);
tstOpp[id].Division = Convert.ToInt32(team["Division"]);
if (sStats != null)
{
tst[id].Record[0] = Convert.ToByte(sStats["Wins"]);
tst[id].Record[1] = Convert.ToByte(sStats["Losses"]);
tst[id].Totals[TAbbrT.MINS] = Convert.ToUInt16(sStats["Mins"]);
tst[id].Totals[TAbbrT.PF] = Convert.ToUInt16(sStats["PtsFor"]);
tst[id].Totals[TAbbrT.PA] = Convert.ToUInt16(sStats["PtsAg"]);
tst[id].Totals[TAbbrT.FGM] = Convert.ToUInt16(sStats["FGMade"]);
tst[id].Totals[TAbbrT.FGA] = Convert.ToUInt16(sStats["FGAtt"]);
try
{
tst[id].Totals[TAbbrT.TPM] = Convert.ToUInt16(sStats["3PTMade"]);
tst[id].Totals[TAbbrT.TPA] = Convert.ToUInt16(sStats["3PTAtt"]);
}
catch (KeyNotFoundException)
{
tst[id].Totals[TAbbrT.TPM] = Convert.ToUInt16(sStats["TPTMade"]);
tst[id].Totals[TAbbrT.TPA] = Convert.ToUInt16(sStats["TPTAtt"]);
}
tst[id].Totals[TAbbrT.FTM] = Convert.ToUInt16(sStats["FTMade"]);
tst[id].Totals[TAbbrT.FTA] = Convert.ToUInt16(sStats["FTAtt"]);
tst[id].Totals[TAbbrT.DREB] = Convert.ToUInt16(sStats["DRebs"]);
tst[id].Totals[TAbbrT.OREB] = Convert.ToUInt16(sStats["ORebs"]);
tst[id].Totals[TAbbrT.STL] = Convert.ToUInt16(sStats["Steals"]);
tst[id].Totals[TAbbrT.BLK] = Convert.ToUInt16(sStats["Blocks"]);
tst[id].Totals[TAbbrT.AST] = Convert.ToUInt16(sStats["Assists"]);
tst[id].Totals[TAbbrT.FOUL] = Convert.ToUInt16(sStats["Fouls"]);
tst[id].Totals[TAbbrT.TOS] = Convert.ToUInt16(sStats["TOs"]);
if (pStatsID != -1)
{
var pStats = teamStats.Single(s => s["ID"] == pStatsID.ToString());
tst[id].PlRecord[0] = Convert.ToByte(pStats["Wins"]);
tst[id].PlRecord[1] = Convert.ToByte(pStats["Losses"]);
tst[id].PlTotals[TAbbrT.MINS] = Convert.ToUInt16(pStats["Mins"]);
tst[id].PlTotals[TAbbrT.PF] = Convert.ToUInt16(pStats["PtsFor"]);
tst[id].PlTotals[TAbbrT.PA] = Convert.ToUInt16(pStats["PtsAg"]);
tst[id].PlTotals[TAbbrT.FGM] = Convert.ToUInt16(pStats["FGMade"]);
tst[id].PlTotals[TAbbrT.FGA] = Convert.ToUInt16(pStats["FGAtt"]);
try
{
tst[id].PlTotals[TAbbrT.TPM] = Convert.ToUInt16(sStats["3PTMade"]);
tst[id].PlTotals[TAbbrT.TPA] = Convert.ToUInt16(sStats["3PTAtt"]);
}
catch (KeyNotFoundException)
{
tst[id].PlTotals[TAbbrT.TPM] = Convert.ToUInt16(sStats["TPTMade"]);
tst[id].PlTotals[TAbbrT.TPA] = Convert.ToUInt16(sStats["TPTAtt"]);
}
tst[id].PlTotals[TAbbrT.FTM] = Convert.ToUInt16(pStats["FTMade"]);
tst[id].PlTotals[TAbbrT.FTA] = Convert.ToUInt16(pStats["FTAtt"]);
tst[id].PlTotals[TAbbrT.DREB] = Convert.ToUInt16(pStats["DRebs"]);
tst[id].PlTotals[TAbbrT.OREB] = Convert.ToUInt16(pStats["ORebs"]);
tst[id].PlTotals[TAbbrT.STL] = Convert.ToUInt16(pStats["Steals"]);
tst[id].PlTotals[TAbbrT.BLK] = Convert.ToUInt16(pStats["Blocks"]);
tst[id].PlTotals[TAbbrT.AST] = Convert.ToUInt16(pStats["Assists"]);
tst[id].PlTotals[TAbbrT.FOUL] = Convert.ToUInt16(pStats["Fouls"]);
tst[id].PlTotals[TAbbrT.TOS] = Convert.ToUInt16(pStats["TOs"]);
}
}
tst[id].CalcAvg();
rosters[id] = new List<int>
{
Convert.ToInt32(team["Ros_PG"]),
Convert.ToInt32(team["Ros_SG"]),
Convert.ToInt32(team["Ros_SF"]),
Convert.ToInt32(team["Ros_PF"]),
Convert.ToInt32(team["Ros_C"])
};
for (var i = 6; i <= 12; i++)
{
var cur = Convert.ToInt32(team["Ros_S" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
for (var i = 13; i <= 20; i++)
{
var cur = Convert.ToInt32(team["Ros_R" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
}
#endregion
#region Import Players & Player Stats
var duplicatePlayers = new List<string>();
if (!teamsOnly)
{
var validPlayers = players.FindAll(player => isValidPlayer(player, nba2KVersion));
foreach (var player in validPlayers)
{
var playerID = Convert.ToInt32(player["ID"]);
var lastName = player["Last_Name"];
var firstName = player["First_Name"];
int pTeam;
var curTeam = new TeamStats();
try
{
pTeam = rosters.Single(r => r.Value.Contains(playerID)).Key;
curTeam = tst[pTeam];
}
catch (InvalidOperationException)
{
pTeam = -1;
}
if (pTeam == -1 && player["IsFA"] != "1")
{
if (pst.ContainsKey(playerID) && pst[playerID].LastName == lastName && pst[playerID].FirstName == firstName)
{
pst[playerID].IsSigned = false;
pst[playerID].TeamF = -1;
pst[playerID].IsHidden = true;
}
continue;
}
var playerStatsID = Convert.ToInt32(player["StatY0"]);
Dictionary<string, string> playerSeasonStats;
try
{
playerSeasonStats = playerStats.Single(s => s["ID"] == playerStatsID.ToString());
}
catch
{
playerSeasonStats = null;
}
Dictionary<string, string> playerPlayoffStats = null;
if (nba2KVersion >= NBA2KVersion.NBA2K13)
{
var playerPlayoffStatsID = player["StatPOs"];
try
{
playerPlayoffStats = playerStats.Find(s => s["ID"] == playerPlayoffStatsID);
}
catch
{
playerPlayoffStats = null;
}
}
#region Match Player
if (pst.ContainsKey(playerID) && (pst[playerID].LastName != lastName || pst[playerID].FirstName != firstName))
{
var candidates =
pst.Where(
pair =>
pair.Value.LastName == lastName && pair.Value.FirstName == firstName && pair.Value.IsHidden == false)
.ToList();
if (candidates.Count > 0)
{
var found = false;
var temptst = tst;
var c2 = candidates.Where(pair => temptst.ContainsKey(pair.Value.TeamF)).ToList();
if (c2.Count() == 1)
{
playerID = c2.First().Value.ID;
found = true;
}
else
{
var c4 = candidates.Where(pair => pair.Value.YearOfBirth.ToString() == player["BirthYear"]).ToList();
if (c4.Count == 1)
{
playerID = c4.First().Value.ID;
found = true;
}
else
{
if (pTeam != -1)
{
var c3 = candidates.Where(pair => pair.Value.TeamF == curTeam.ID).ToList();
if (c3.Count == 1)
{
playerID = c3.First().Value.ID;
found = true;
}
}
}
}
if (!found)
{
var choices = new List<string>();
foreach (var pair in candidates)
{
var choice = String.Format(
"{0}: {1} {2} (Born {3}",
pair.Value.ID,
pair.Value.FirstName,
pair.Value.LastName,
pair.Value.YearOfBirth);
if (pair.Value.IsSigned)
{
choice += String.Format(", plays in {0}", tst[pair.Value.TeamF].DisplayName);
}
else
{
choice += ", free agent";
}
choice += ")";
choices.Add(choice);
}
var message = String.Format(
"{0}: {1} {2} (Born {3}",
player["ID"],
player["First_Name"],
player["Last_Name"],
player["BirthYear"]);
if (pTeam != -1)
{
message += String.Format(", plays in {0}", curTeam.DisplayName);
}
else
{
message += ", free agent";
}
message += ")";
var ccw = new ComboChoiceWindow(message, choices);
if (ccw.ShowDialog() != true)
{
duplicatePlayers.Add(firstName + " " + lastName);
continue;
}
else
{
playerID = Convert.ToInt32(ComboChoiceWindow.UserChoice.Split(':')[0]);
}
}
}
else
{
playerID = createNewPlayer(ref pst, player);
}
}
else if (!pst.ContainsKey(playerID))
{
playerID = createNewPlayer(ref pst, player, playerID);
}
#endregion Match Player
var curPlayer = pst[playerID];
var oldPlayer = curPlayer.BinarySerializationClone();
curPlayer.Position1 = (Position) Enum.Parse(typeof(Position), player["Pos"]);
curPlayer.Position2 = (Position) Enum.Parse(typeof(Position), player["SecondPos"]);
curPlayer.IsHidden = false;
curPlayer.YearsPro = Convert.ToInt32(player["YearsPro"]);
curPlayer.YearOfBirth = Convert.ToInt32(player["BirthYear"]);
curPlayer.Contract.Option = (PlayerContractOption) Enum.Parse(typeof(PlayerContractOption), player["COption"]);
curPlayer.Contract.ContractSalaryPerYear.Clear();
for (var i = 1; i < 7; i++)
{
var salary = Convert.ToInt32(player["CYear" + i]);
if (salary == 0)
{
break;
}
curPlayer.Contract.ContractSalaryPerYear.Add(salary);
}
curPlayer.Height = Convert.ToDouble(player["Height"]);
curPlayer.Weight = Convert.ToDouble(player["Weight"]);
curPlayer.Injury = new PlayerInjury(Convert.ToInt32(player["InjType"]), Convert.ToInt32(player["InjDaysLeft"]));
if (playerSeasonStats != null)
{
var teamReal = pTeam.ToString();
var team2 = playerSeasonStats["TeamID1"];
//bool hasBeenTraded = (team1 != "-1");
curPlayer.TeamF = pTeam;
curPlayer.TeamS = Convert.ToInt32(team2);
curPlayer.IsSigned = (player["IsFA"] != "1" && teamReal != "-1");
importPlayerStats(curPlayer, playerSeasonStats, nba2KVersion, false);
curPlayer.CalcAvg();
pst[playerID] = curPlayer;
}
else
{
curPlayer.TeamF = pTeam;
curPlayer.IsSigned = player["IsFA"] != "1";
curPlayer.CalcAvg();
}
if (playerPlayoffStats != null)
{
importPlayerStats(curPlayer, playerPlayoffStats, nba2KVersion, true);
curPlayer.CalcAvg();
}
if (nba2KVersion >= NBA2KVersion.NBA2K13)
{
importPlayerCareerHighs(curPlayer, player);
}
#region Import Messsages
var name = String.Format("{0} {1}", curPlayer.FirstName, curPlayer.LastName);
if (oldPlayer.TeamF != curPlayer.TeamF)
{
string msg;
if (curPlayer.IsSigned && oldPlayer.IsSigned)
{
msg = String.Format(
"{0} was traded from the {1} to the {2}.",
name,
tst[oldPlayer.TeamF].DisplayName,
tst[curPlayer.TeamF].DisplayName);
tradesList.Add(msg);
}
else if (oldPlayer.IsSigned)
{
msg = String.Format("{0} was released from the {1}.", name, tst[oldPlayer.TeamF].DisplayName);
waiversList.Add(msg);
}
}
if (oldPlayer.Contract.GetYears() < curPlayer.Contract.GetYears() && curPlayer.IsSigned)
{
var msg = name;
bool reSigned;
if (!oldPlayer.IsSigned && curPlayer.IsSigned)
{
reSigned = false;
msg += " signed ";
}
else
{
reSigned = true;
msg += " re-signed ";
}
msg += String.Format(
"with the {0} on a {1}/{2:C0} ({3:C0} per year) contract.",
tst[curPlayer.TeamF].DisplayName,
curPlayer.Contract.GetYearsDesc(),
curPlayer.Contract.GetTotal(),
curPlayer.Contract.GetAverage());
if (reSigned)
{
reSigningsList.Add(msg);
}
else
{
faSigningsList.Add(msg);
}
}
if (oldPlayer.Injury.InjuryName != curPlayer.Injury.InjuryName)
{
if (!oldPlayer.Injury.IsInjured)
{
injuredList.Add(
string.Format(
"{0} ({1}) got injured. Status: {2}",
name,
curPlayer.TeamF != -1 ? tst[curPlayer.TeamF].DisplayName : "Free Agent",
curPlayer.Injury.Status));
}
else if (!curPlayer.Injury.IsInjured)
{
recoveredList.Add(
string.Format(
"{1} ({0}) is no longer injured.",
curPlayer.TeamF != -1 ? tst[curPlayer.TeamF].DisplayName : "Free Agent",
name));
}
else
{
reInjuredList.Add(
string.Format(
"{0} ({3}) was being reported as having {1}, is now reported as: {2}",
name,
oldPlayer.Injury.InjuryName,
curPlayer.Injury.Status,
curPlayer.TeamF != -1 ? tst[curPlayer.TeamF].DisplayName : "Free Agent"));
}
}
var count = 0;
var recMsg = "";
for (var i = 0; i < curPlayer.CareerHighs.Count(); i++)
{
if (i == PAbbrT.MINS || i == PAbbrT.TOS || i == PAbbrT.FOUL)
{
continue;
}
if (oldPlayer.CareerHighs[i] != 0 && oldPlayer.CareerHighs[i] < curPlayer.CareerHighs[i])
{
if (count == 0)
{
recMsg = string.Format(
"{0} has a new career-high in {1} ({2})",
curPlayer.FullInfo(tst, true, false),
PlayerStatsHelper.CHTotals[i],
curPlayer.CareerHighs[i]);
}
else
{
recMsg += string.Format(", {0} ({1})", PlayerStatsHelper.CHTotals[i], curPlayer.CareerHighs[i]);
}
count++;
}
}
recMsg += ".";
if (count > 0)
{
newRecordsList.Add(recMsg);
}
#endregion
}
}
if (duplicatePlayers.Count > 0)
{
var msg =
"The following names belong to two or more players in the database and the tool couldn't determine who to import to:\n\n";
duplicatePlayers.ForEach(item => msg += item + ", ");
msg = msg.TrimEnd(new[] { ' ', ',' });
msg += "\n\nImport will continue, but there will be some stats missing." + "\n\nTo avoid this problem, either\n"
+ "1) disable the duplicate occurences via (Miscellaneous > Enable/Disable Players For This Season...), or\n"
+ "2) transfer the correct instance of the player to their current team.";
Tools.AppInvoke(() => MessageBox.Show(msg));
}
#endregion
#region Check for box-scores we can calculate
if (oldTST.Count == 30)
{
TeamsThatPlayedAGame = new List<int>();
foreach (var team in tst)
{
var newTeam = team.Value;
var teamID = team.Key;
var oldTeam = oldTST[teamID];
if (oldTeam.GetGames() + 1 == newTeam.GetGames() || oldTeam.GetPlayoffGames() + 1 == newTeam.GetPlayoffGames())
{
TeamsThatPlayedAGame.Add(team.Key);
}
}
if (TeamsThatPlayedAGame.Count >= 2)
{
bool? result = null;
PickedTeams = new List<int>();
Tools.AppInvoke(
() =>
{
var dlw = new PickGamesWindow(TeamsThatPlayedAGame);
result = dlw.ShowDialog();
});
if (result == true)
{
for (var i = 0; i <= PickedTeams.Count - 2; i += 2)
{
var t1 = PickedTeams[i];
var t2 = PickedTeams[i + 1];
var bse = prepareBoxScore(tst, oldTST, pst, oldPST, t1, t2);
var teamBoxScore = bse.BS;
BoxScoreWindow.CalculateTeamsFromPlayers(
ref teamBoxScore,
bse.PBSList.Where(pbs => pbs.TeamID == bse.BS.Team1ID),
bse.PBSList.Where(pbs => pbs.TeamID == bse.BS.Team2ID));
if (teamBoxScore.PTS1 != getDiff(tst, oldTST, t1, TAbbrT.PF, teamBoxScore.IsPlayoff)
|| teamBoxScore.PTS2 != getDiff(tst, oldTST, t2, TAbbrT.PF, teamBoxScore.IsPlayoff))
{
var localtst = tst;
Tools.AppInvoke(
() =>
MessageBox.Show(
String.Format(
"{0} @ {1} won't have its box-score imported because it couldn't be properly calculated. A possible reason for this is that one or more players participating in that game has been since traded away from the teams.",
localtst[t1].DisplayName,
localtst[t2].DisplayName),
"NBA Stats Tracker",
MessageBoxButton.OK,
MessageBoxImage.Exclamation));
continue;
}
bse.BS.GameDate = SelectedDate;
TeamStats.AddTeamStatsFromBoxScore(bse.BS, ref oldTST, ref oldtstOpp, t1, t2);
MainWindow.BSHist.Add(bse);
tst[t1] = oldTST[t1].BinarySerializationClone();
tst[t2] = oldTST[t2].BinarySerializationClone();
tstOpp[t1] = oldtstOpp[t1].BinarySerializationClone();
tstOpp[t2] = oldtstOpp[t2].BinarySerializationClone();
}
}
}
}
#endregion
if (tradesList.Count + faSigningsList.Count + reSigningsList.Count + waiversList.Count > 0)
{
importMessages.Add("League Transactions");
importMessages.Add("========================================");
importMessages.Add("");
if (tradesList.Count > 0)
{
importMessages.Add("Players traded");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(tradesList);
importMessages.Add("");
}
if (faSigningsList.Count > 0)
{
importMessages.Add("Players signed from free-agency");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(faSigningsList);
importMessages.Add("");
}
if (reSigningsList.Count > 0)
{
importMessages.Add("Players that signed an extension");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(reSigningsList);
importMessages.Add("");
}
if (waiversList.Count > 0)
{
importMessages.Add("Players waived");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(waiversList);
importMessages.Add("");
}
importMessages.Add("");
importMessages.Add("");
}
if (injuredList.Count + reInjuredList.Count + recoveredList.Count > 0)
{
importMessages.Add("Injury Updates");
importMessages.Add("========================================");
importMessages.Add("");
if (injuredList.Count > 0)
{
importMessages.Add("Players injured");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(injuredList);
importMessages.Add("");
}
if (reInjuredList.Count > 0)
{
importMessages.Add("Players whose injury status changed");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(reInjuredList);
importMessages.Add("");
}
if (recoveredList.Count > 0)
{
importMessages.Add("Players recovered");
importMessages.Add("=========================");
importMessages.Add("");
importMessages.AddRange(recoveredList);
importMessages.Add("");
}
importMessages.Add("");
importMessages.Add("");
}
if (newRecordsList.Count > 0)
{
importMessages.Add("New Career Highs");
importMessages.Add("========================================");
importMessages.Add("");
importMessages.AddRange(newRecordsList);
importMessages.Add("");
}
if (importMessages.Count > 0)
{
importMessages.Add("");
Tools.AppInvoke(
() =>
{
var cmw = new CopyableMessageWindow(importMessages.Aggregate((m1, m2) => m1 + "\n" + m2), "League News");
cmw.ShowDialog();
});
}
return 0;
}
public static int ImportLastYear(
ref Dictionary<int, TeamStats> tst,
ref Dictionary<int, TeamStats> tstOpp,
ref Dictionary<int, PlayerStats> pst,
string folder,
bool teamsOnly = false)
{
List<Dictionary<string, string>> teams;
List<Dictionary<string, string>> players;
List<Dictionary<string, string>> teamStats;
List<Dictionary<string, string>> playerStats;
NBA2KVersion nba2KVersion;
if (populateREDitorDictionaryLists(folder, out teams, out players, out teamStats, out playerStats, out nba2KVersion) == -1)
{
return -1;
}
#region Import Teams & Team Stats
initializeLegalTeamTypes(nba2KVersion);
var validTeams = teams.FindAll(
delegate(Dictionary<string, string> team)
{
if (legalTTypes.IndexOf(team["TType"]) != -1)
{
return true;
}
return false;
});
var activeTeams = validTeams.FindAll(
delegate(Dictionary<string, string> team)
{
if (team["StatCurS"] != "-1")
{
return true;
}
return false;
});
/*
if (activeTeams.Count == 0)
{
MessageBox.Show("No Team Stats found in save.");
return -1;
}
*/
if (activeTeams.Count < 30)
{
var dlw = new DualListWindow(validTeams, activeTeams);
if (dlw.ShowDialog() == false)
{
return -1;
}
activeTeams = new List<Dictionary<string, string>>(MainWindow.SelectedTeams);
if (MainWindow.SelectedTeamsChanged)
{
createSettingsFile(activeTeams, folder);
}
}
var madeNew = false;
if (tst.Count != activeTeams.Count)
{
tst = new Dictionary<int, TeamStats>();
tstOpp = new Dictionary<int, TeamStats>();
madeNew = true;
}
CreateDivisions();
var activeTeamsIDs = new List<int>();
var rosters = new Dictionary<int, List<int>>();
foreach (var team in activeTeams)
{
var name = team["Name"];
if (nba2KVersion != NBA2KVersion.NBA2K12)
{
name += (team["Year"] == "0" ? "" : team["Year"].PadLeft(2, '0'));
}
var redID = Convert.ToInt32(team["ID"]);
if (tst.Values.All(ts => ts.Name != name))
{
if (tst.Keys.Contains(redID))
{
var oldName = tst[redID].Name;
tst[redID].Name = name;
tstOpp[redID].Name = name;
if (oldName == tst[redID].DisplayName)
{
tst[redID].DisplayName = name;
tstOpp[redID].DisplayName = name;
}
}
else
{
tst.Add(redID, new TeamStats(redID, name));
tstOpp.Add(redID, new TeamStats(redID, name));
}
}
var id = tst.Values.Single(ts => ts.Name == name).ID;
activeTeamsIDs.Add(Convert.ToInt32(team["ID"]));
if (madeNew)
{
tst[id] = new TeamStats(id, name);
tstOpp[id] = new TeamStats(id, name);
}
var sStatsID = Convert.ToInt32(team["StatPrevS"]);
var pStatsID = Convert.ToInt32(team["StatPrevP"]);
var sStats = teamStats.Find(
delegate(Dictionary<string, string> s)
{
if (s["ID"] == sStatsID.ToString())
{
return true;
}
return false;
});
var curTeam = tst[id];
curTeam.ID = Convert.ToInt32(team["ID"]);
curTeam.Division = Convert.ToInt32(team["Division"]);
tstOpp[id].Division = Convert.ToInt32(team["Division"]);
if (sStats != null)
{
curTeam.Record[0] = Convert.ToByte(sStats["Wins"]);
curTeam.Record[1] = Convert.ToByte(sStats["Losses"]);
curTeam.Totals[TAbbrT.MINS] = Convert.ToUInt16(sStats["Mins"]);
curTeam.Totals[TAbbrT.PF] = Convert.ToUInt16(sStats["PtsFor"]);
curTeam.Totals[TAbbrT.PA] = Convert.ToUInt16(sStats["PtsAg"]);
curTeam.Totals[TAbbrT.FGM] = Convert.ToUInt16(sStats["FGMade"]);
curTeam.Totals[TAbbrT.FGA] = Convert.ToUInt16(sStats["FGAtt"]);
try
{
curTeam.Totals[TAbbrT.TPM] = Convert.ToUInt16(sStats["3PTMade"]);
curTeam.Totals[TAbbrT.TPA] = Convert.ToUInt16(sStats["3PTAtt"]);
}
catch (KeyNotFoundException)
{
curTeam.Totals[TAbbrT.TPM] = Convert.ToUInt16(sStats["TPTMade"]);
curTeam.Totals[TAbbrT.TPA] = Convert.ToUInt16(sStats["TPTAtt"]);
}
curTeam.Totals[TAbbrT.FTM] = Convert.ToUInt16(sStats["FTMade"]);
curTeam.Totals[TAbbrT.FTA] = Convert.ToUInt16(sStats["FTAtt"]);
curTeam.Totals[TAbbrT.DREB] = Convert.ToUInt16(sStats["DRebs"]);
curTeam.Totals[TAbbrT.OREB] = Convert.ToUInt16(sStats["ORebs"]);
curTeam.Totals[TAbbrT.STL] = Convert.ToUInt16(sStats["Steals"]);
curTeam.Totals[TAbbrT.BLK] = Convert.ToUInt16(sStats["Blocks"]);
curTeam.Totals[TAbbrT.AST] = Convert.ToUInt16(sStats["Assists"]);
curTeam.Totals[TAbbrT.FOUL] = Convert.ToUInt16(sStats["Fouls"]);
curTeam.Totals[TAbbrT.TOS] = Convert.ToUInt16(sStats["TOs"]);
//tstOpp[id].stats[t.TO] = Convert.ToUInt16(sStats["TOsAg"]);
if (pStatsID != -1)
{
var pStats = teamStats.Find(
delegate(Dictionary<string, string> s)
{
if (s["ID"] == pStatsID.ToString())
{
return true;
}
return false;
});
curTeam.PlRecord[0] = Convert.ToByte(pStats["Wins"]);
curTeam.PlRecord[1] = Convert.ToByte(pStats["Losses"]);
curTeam.PlTotals[TAbbrT.MINS] = Convert.ToUInt16(pStats["Mins"]);
curTeam.PlTotals[TAbbrT.PF] = Convert.ToUInt16(pStats["PtsFor"]);
curTeam.PlTotals[TAbbrT.PA] = Convert.ToUInt16(pStats["PtsAg"]);
curTeam.PlTotals[TAbbrT.FGM] = Convert.ToUInt16(pStats["FGMade"]);
curTeam.PlTotals[TAbbrT.FGA] = Convert.ToUInt16(pStats["FGAtt"]);
try
{
curTeam.PlTotals[TAbbrT.TPM] = Convert.ToUInt16(pStats["3PTMade"]);
curTeam.PlTotals[TAbbrT.TPA] = Convert.ToUInt16(pStats["3PTAtt"]);
}
catch (KeyNotFoundException)
{
curTeam.PlTotals[TAbbrT.TPM] = Convert.ToUInt16(pStats["TPTMade"]);
curTeam.PlTotals[TAbbrT.TPA] = Convert.ToUInt16(pStats["TPTAtt"]);
}
curTeam.PlTotals[TAbbrT.FTM] = Convert.ToUInt16(pStats["FTMade"]);
curTeam.PlTotals[TAbbrT.FTA] = Convert.ToUInt16(pStats["FTAtt"]);
curTeam.PlTotals[TAbbrT.DREB] = Convert.ToUInt16(pStats["DRebs"]);
curTeam.PlTotals[TAbbrT.OREB] = Convert.ToUInt16(pStats["ORebs"]);
curTeam.PlTotals[TAbbrT.STL] = Convert.ToUInt16(pStats["Steals"]);
curTeam.PlTotals[TAbbrT.BLK] = Convert.ToUInt16(pStats["Blocks"]);
curTeam.PlTotals[TAbbrT.AST] = Convert.ToUInt16(pStats["Assists"]);
curTeam.PlTotals[TAbbrT.FOUL] = Convert.ToUInt16(pStats["Fouls"]);
curTeam.PlTotals[TAbbrT.TOS] = Convert.ToUInt16(pStats["TOs"]);
//tstOpp[id].pl_stats[t.TO] = Convert.ToUInt16(pStats["TOsAg"]);
}
}
curTeam.CalcAvg();
rosters[id] = new List<int>
{
Convert.ToInt32(team["Ros_PG"]),
Convert.ToInt32(team["Ros_SG"]),
Convert.ToInt32(team["Ros_SF"]),
Convert.ToInt32(team["Ros_PF"]),
Convert.ToInt32(team["Ros_C"])
};
for (var i = 6; i <= 12; i++)
{
var cur = Convert.ToInt32(team["Ros_S" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
for (var i = 13; i <= 20; i++)
{
var cur = Convert.ToInt32(team["Ros_R" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
}
#endregion
#region Import Players & Player Stats
var duplicatePlayers = new List<string>();
if (!teamsOnly)
{
var validPlayers = players.FindAll(
delegate(Dictionary<string, string> player)
{
if (isValidPlayer(player, nba2KVersion) && player["YearsPro"] != "1")
{
return true;
}
return false;
});
foreach (var player in validPlayers)
{
var playerID = Convert.ToInt32(player["ID"]);
var lastName = player["Last_Name"];
var firstName = player["First_Name"];
#if DEBUG
//if (lastName == "Battie") System.Diagnostics.Debugger.Break();
#endif
var playerStatsID = player["StatY1"];
Dictionary<string, string> playerSeasonStats;
try
{
playerSeasonStats = playerStats.Single(s => s["ID"] == playerStatsID);
}
catch
{
playerSeasonStats = null;
}
string team1;
string team2;
if (playerSeasonStats != null)
{
team1 = playerSeasonStats["TeamID2"];
team2 = playerSeasonStats["TeamID1"];
var hasBeenTraded = (team1 != "-1");
if (!hasBeenTraded)
{
team1 = team2;
}
}
else
{
team1 = "-1";
team2 = "-1";
}
if (pst.ContainsKey(playerID) && (pst[playerID].LastName != lastName || pst[playerID].FirstName != firstName))
{
var candidates =
pst.Where(
pair =>
pair.Value.LastName == lastName && pair.Value.FirstName == firstName && pair.Value.IsHidden == false)
.ToList();
if (candidates.Any())
{
var temptst = tst;
var c2 = candidates.Where(pair => temptst.ContainsKey(pair.Value.TeamF)).ToList();
if (c2.Count == 1)
{
playerID = c2.First().Value.ID;
}
else
{
if (team1 != "-1" && activeTeamsIDs.Contains(team1.ToInt32()))
{
var curTeam =
tst.Single(team => team.Value.Name == activeTeams.Find(ateam => ateam["ID"] == team1)["Name"]);
var c3 = candidates.Where(pair => pair.Value.TeamF == curTeam.Value.ID).ToList();
if (c3.Count == 1)
{
playerID = c3.First().Value.ID;
}
else
{
duplicatePlayers.Add(firstName + " " + lastName);
continue;
}
}
else
{
duplicatePlayers.Add(firstName + " " + lastName);
continue;
}
}
}
else
{
playerID = createNewPlayer(ref pst, player);
}
}
else if (!pst.ContainsKey(playerID))
{
playerID = createNewPlayer(ref pst, player, playerID);
}
var ps = pst[playerID];
ps.IsHidden = false;
ps.YearsPro = Convert.ToInt32(player["YearsPro"]) - 1;
ps.YearOfBirth = Convert.ToInt32(player["BirthYear"]);
ps.Height = Convert.ToDouble(player["Height"]);
ps.Weight = Convert.ToDouble(player["Weight"]);
if (playerSeasonStats != null)
{
ps.TeamF = Convert.ToInt32(team1);
ps.TeamS = Convert.ToInt32(team2);
ps.IsSigned = team1 != "-1";
importPlayerStats(ps, playerSeasonStats, nba2KVersion, false);
ps.CalcAvg();
}
else
{
ps.TeamF = -1;
ps.IsSigned = false;
ps.CalcAvg();
}
if (nba2KVersion >= NBA2KVersion.NBA2K13)
{
importPlayerCareerHighs(ps, player);
}
}
}
if (duplicatePlayers.Count > 0)
{
var msg =
"The following names belong to two or more players in the database and the tool couldn't determine who to import to:\n\n";
duplicatePlayers.ForEach(item => msg += item + ", ");
msg = msg.TrimEnd(new[] { ' ', ',' });
msg += "\n\nImport will continue, but there will be some stats missing." + "\n\nTo avoid this problem, either\n"
+ "1) disable the duplicate occurences via (Miscellaneous > Enable/Disable Players For This Season...), or\n"
+ "2) transfer the correct instance of the player to their current team.";
MessageBox.Show(msg);
}
#endregion
return 0;
}
public static async Task ImportOldPlayerCareerStats(
Dictionary<int, PlayerStats> pst, Dictionary<int, TeamStats> tst, string folder)
{
if (tst.Count != 30)
{
MessageBox.Show(
"Can't import previous player stats to a database that doesn't have 30 teams. Please import "
+ "your NBA 2K save once to this database to populate it properly before trying to import previous "
+ "player stats.");
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(-2);
return;
}
List<Dictionary<string, string>> teams;
List<Dictionary<string, string>> players;
List<Dictionary<string, string>> teamStats;
List<Dictionary<string, string>> playerStats;
NBA2KVersion nba2KVersion;
if (populateREDitorDictionaryLists(folder, out teams, out players, out teamStats, out playerStats, out nba2KVersion) == -1)
{
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(-1);
return;
}
var list = new List<string> { "1 season ago" };
for (var i = 2; i <= 20; i++)
{
list.Add(i + " seasons ago");
}
var ccw = new ComboChoiceWindow("Add player stats starting from...", list);
if (ccw.ShowDialog() != true)
{
MainWindow.MWInstance.mainGrid.Visibility = Visibility.Visible;
return;
}
var startAt = Convert.ToInt32(ComboChoiceWindow.UserChoice.Split(' ')[0]);
var seasonNames = new Dictionary<int, string>();
if (nba2KVersion == NBA2KVersion.NBA2K12)
{
while (true)
{
var ibw =
new InputBoxWindow(
"Enter the season that describes the first season in this database (e.g. 2011-2012 by default in NBA 2K12, 2010-2011 if you "
+ "imported last year's stats first, 2012 for a season taking place only in that year, etc.):",
"2011-2012");
if (ibw.ShowDialog() != true)
{
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(-2);
return;
}
int year;
var twoPartSeasonDesc = InputBoxWindow.UserInput.Contains("-");
try
{
year = Convert.ToInt32(twoPartSeasonDesc ? InputBoxWindow.UserInput.Split('-')[0] : InputBoxWindow.UserInput);
}
catch
{
MessageBox.Show(
"The year you entered (" + InputBoxWindow.UserInput
+ ") was not in a valid format.\nValid formats are:\n\t2012\n\t2011-2012");
continue;
}
for (var i = startAt; i <= 20; i++)
{
seasonNames.Add(
i, twoPartSeasonDesc ? string.Format("{0}-{1}", year - i, (year - i + 1)) : (year - i).ToString());
}
break;
}
}
initializeLegalTeamTypes(nba2KVersion);
var validTeams = teams.FindAll(
delegate(Dictionary<string, string> team)
{
if (legalTTypes.IndexOf(team["TType"]) != -1)
{
return true;
}
return false;
});
var activeTeams = validTeams.FindAll(
delegate(Dictionary<string, string> team)
{
if (team["StatCurS"] != "-1")
{
return true;
}
return false;
});
if (activeTeams.Count < 30)
{
var dlw = new DualListWindow(validTeams, activeTeams);
if (dlw.ShowDialog() == false)
{
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(-1);
return;
}
activeTeams = new List<Dictionary<string, string>>(MainWindow.SelectedTeams);
if (MainWindow.SelectedTeamsChanged)
{
createSettingsFile(activeTeams, folder);
}
}
var activeTeamsIDs = new List<int>();
var rosters = new Dictionary<int, List<int>>();
foreach (var team in activeTeams)
{
var id = -1;
var name = team["Name"];
if (tst.All(pair => pair.Value.Name != name))
{
for (var i = 0; i < 30; i++)
{
if (!tst.ContainsKey(i))
{
id = i;
break;
}
}
}
else
{
id = tst.Single(pair => pair.Value.Name == name).Key;
}
activeTeamsIDs.Add(Convert.ToInt32(team["ID"]));
rosters[id] = new List<int>
{
Convert.ToInt32(team["Ros_PG"]),
Convert.ToInt32(team["Ros_SG"]),
Convert.ToInt32(team["Ros_SF"]),
Convert.ToInt32(team["Ros_PF"]),
Convert.ToInt32(team["Ros_C"])
};
for (var i = 6; i <= 12; i++)
{
var cur = Convert.ToInt32(team["Ros_S" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
for (var i = 13; i <= 20; i++)
{
var cur = Convert.ToInt32(team["Ros_R" + i.ToString()]);
if (cur != -1)
{
rosters[id].Add(cur);
}
else
{
break;
}
}
}
var validPlayers = players.FindAll(player => isValidPlayer(player, nba2KVersion));
var endAt = nba2KVersion >= NBA2KVersion.NBA2K13 ? 19 : 20;
var pw = new ProgressWindow("Please wait as player career stats are being imported...");
pw.Show();
await Task.Run(
() =>
{
var count = validPlayers.Count;
var ppsList = new List<PastPlayerStats>();
for (var i = 0; i < count; i++)
{
var percentProgress = i * 100 / count;
if (percentProgress % 5 == 0)
{
Tools.AppInvoke(() => pw.SetProgressBarValue(percentProgress));
}
var player = validPlayers[i];
var playerID = Convert.ToInt32(player["ID"]);
var lastName = player["Last_Name"];
var firstName = player["First_Name"];
int pTeam;
var curTeam = new TeamStats();
try
{
pTeam = rosters.Single(r => r.Value.Contains(playerID)).Key;
curTeam = tst[pTeam];
}
catch (InvalidOperationException)
{
pTeam = -1;
}
if (!activeTeamsIDs.Contains(pTeam) && player["IsFA"] != "1")
{
if (pst.ContainsKey(playerID) && pst[playerID].LastName == lastName
&& pst[playerID].FirstName == firstName)
{
pst[playerID].IsSigned = false;
pst[playerID].TeamF = -1;
pst[playerID].IsHidden = true;
}
continue;
}
#region Match Player
if (pst.ContainsKey(playerID)
&& (pst[playerID].LastName != lastName || pst[playerID].FirstName != firstName))
{
var candidates =
pst.Where(
pair =>
pair.Value.LastName == lastName && pair.Value.FirstName == firstName
&& pair.Value.IsHidden == false).ToList();
if (candidates.Count > 0)
{
var found = false;
var c2 = candidates.Where(pair => tst.ContainsKey(pair.Value.TeamF)).ToList();
if (c2.Count() == 1)
{
playerID = c2.First().Value.ID;
found = true;
}
else
{
var c4 =
candidates.Where(pair => pair.Value.YearOfBirth.ToString() == player["BirthYear"]).ToList();
if (c4.Count == 1)
{
playerID = c4.First().Value.ID;
found = true;
}
else
{
if (pTeam != -1)
{
var c3 = candidates.Where(pair => pair.Value.TeamF == curTeam.ID).ToList();
if (c3.Count == 1)
{
playerID = c3.First().Value.ID;
found = true;
}
}
}
}
if (!found)
{
var choices = new List<string>();
foreach (var pair in candidates)
{
var choice = String.Format(
"{0}: {1} {2} (Born {3}",
pair.Value.ID,
pair.Value.FirstName,
pair.Value.LastName,
pair.Value.YearOfBirth);
if (pair.Value.IsSigned)
{
choice += String.Format(", plays in {0}", pair.Value.TeamF);
}
else
{
choice += ", free agent";
}
choice += ")";
choices.Add(choice);
}
var message = String.Format(
"{0}: {1} {2} (Born {3}",
player["ID"],
player["First_Name"],
player["Last_Name"],
player["BirthYear"]);
if (pTeam != -1)
{
message += String.Format(", plays in {0}", curTeam.DisplayName);
}
else
{
message += ", free agent";
}
message += ")";
ccw = new ComboChoiceWindow(message, choices);
if (ccw.ShowDialog() != true)
{
continue;
}
else
{
playerID = Convert.ToInt32(ComboChoiceWindow.UserChoice.Split(':')[0]);
}
}
}
else
{
continue;
}
}
else if (!pst.ContainsKey(playerID))
{
continue;
}
#endregion Match Player
var qr = "SELECT * FROM PastPlayerStats WHERE PlayerID = " + playerID + " ORDER BY \"SOrder\"";
var dt = MainWindow.DB.GetDataTable(qr);
dt.Rows.Cast<DataRow>().ToList().ForEach(dr => ppsList.Add(new PastPlayerStats(dr)));
for (var j = startAt; j < endAt; j++)
{
var statEntryID = player["StatY" + j];
if (statEntryID == "-1")
{
continue;
}
var stats = playerStats.Single(d => d["ID"] == statEntryID);
var prevStats = new PastPlayerStats();
var teamID2 = stats["TeamID2"];
var teamID1 = stats["TeamID1"];
if (teamID2 == "-1")
{
if (teamID1 != "-1")
{
prevStats.TeamFName = teams.Single(team => team["ID"] == teamID1)["Name"];
}
}
else
{
prevStats.TeamFName = teams.Single(team => team["ID"] == teamID2)["Name"];
if (teamID1 != "-1")
{
prevStats.TeamSName = teams.Single(team => team["ID"] == teamID1)["Name"];
}
}
prevStats.GP = Convert.ToUInt16(stats["GamesP"]);
prevStats.GS = Convert.ToUInt16(stats["GamesS"]);
prevStats.MINS = Convert.ToUInt16(stats["Minutes"]);
prevStats.PTS = Convert.ToUInt16(stats["Points"]);
prevStats.DREB = Convert.ToUInt16(stats["DRebs"]);
prevStats.OREB = Convert.ToUInt16(stats["ORebs"]);
prevStats.AST = Convert.ToUInt16(stats["Assists"]);
prevStats.STL = Convert.ToUInt16(stats["Steals"]);
prevStats.BLK = Convert.ToUInt16(stats["Blocks"]);
prevStats.TOS = Convert.ToUInt16(stats["TOs"]);
prevStats.FOUL = Convert.ToUInt16(stats["Fouls"]);
prevStats.FGM = Convert.ToUInt16(stats["FGMade"]);
prevStats.FGA = Convert.ToUInt16(stats["FGAtt"]);
try
{
prevStats.TPM = Convert.ToUInt16(stats["3PTMade"]);
prevStats.TPA = Convert.ToUInt16(stats["3PTAtt"]);
}
catch (KeyNotFoundException)
{
prevStats.TPM = Convert.ToUInt16(stats["TPTMade"]);
prevStats.TPA = Convert.ToUInt16(stats["TPTAtt"]);
}
prevStats.FTM = Convert.ToUInt16(stats["FTMade"]);
prevStats.FTA = Convert.ToUInt16(stats["FTAtt"]);
prevStats.PlayerID = playerID;
var yearF = 0;
if (nba2KVersion != NBA2KVersion.NBA2K12)
{
yearF = Convert.ToInt32(stats["Year"]);
}
prevStats.SeasonName = nba2KVersion == NBA2KVersion.NBA2K12
? seasonNames[j]
: String.Format("{0}-{1}", yearF - 1, yearF);
prevStats.IsPlayoff = false;
prevStats.Order = nba2KVersion == NBA2KVersion.NBA2K12 ? 20 - j : yearF;
prevStats.EndEdit();
ppsList.Add(prevStats);
}
}
Tools.AppInvoke(
() =>
{
pw.SetProgressBarValue(99);
pw.SetMessage("Please wait while the player career stats are being saved...");
});
SQLiteIO.SavePastPlayerStatsToDatabase(MainWindow.DB, ppsList);
});
pw.CanClose = true;
pw.Close();
MainWindow.MWInstance.OnImportOldPlayerStatsCompleted(0);
}
