/// <summary>Determines whether the team is hidden for the current season.</summary>
/// <param name="file">The file.</param>
/// <param name="id">The name of the team.</param>
/// <param name="season">The season ID.</param>
/// <returns>
/// <c>true</c> if the team is hidden; otherwise, <c>false</c>.
/// </returns>
public static bool IsTeamHiddenInSeason(string file, int id, int season)
{
var db = new SQLiteDatabase(file);
var maxSeason = SQLiteIO.GetMaxSeason(file);
var teamsT = "Teams";
if (season != maxSeason)
{
teamsT += "S" + season;
}
var q = "select isHidden from " + teamsT + " where ID = " + id + "";
var isHidden = ParseCell.GetBoolean(db.GetDataTable(q).Rows[0], "isHidden");
return isHidden;
}
/// <summary>Checks for teams in divisions that don't exist anymore, and reassings them to the first available division.</summary>
public static void CheckForInvalidDivisions()
{
var db = new SQLiteDatabase(MainWindow.CurrentDB);
var usedIDs = new List<int>();
db.GetDataTable("SELECT ID FROM Divisions")
.Rows.Cast<DataRow>()
.ToList()
.ForEach(row => usedIDs.Add(ParseCell.GetInt32(row, "ID")));
var teamsChanged = new List<string>();
var maxSeason = SQLiteIO.GetMaxSeason(MainWindow.CurrentDB);
for (var i = maxSeason; i >= 1; i--)
{
var teamsT = "Teams";
var plTeamsT = "PlayoffTeams";
var oppT = "Opponents";
var plOppT = "PlayoffOpponents";
if (i != maxSeason)
{
var toAdd = "S" + i;
teamsT += toAdd;
plTeamsT += toAdd;
oppT += toAdd;
plOppT += toAdd;
}
var tables = new List<string> { teamsT, plTeamsT, oppT, plOppT };
foreach (var table in tables)
{
var q = "SELECT ID, Name, Division FROM " + table;
var res = db.GetDataTable(q);
foreach (DataRow r in res.Rows)
{
if (usedIDs.Contains(ParseCell.GetInt32(r, "Division")) == false)
{
db.Update(
table,
new Dictionary<string, string> { { "Division", MainWindow.Divisions.First().ID.ToString() } },
"ID = " + ParseCell.GetString(r, "ID"));
var teamid = MainWindow.TST.Values.Single(ts => ts.Name == ParseCell.GetString(r, "Name")).ID;
MainWindow.TST[teamid].Division = MainWindow.Divisions.First().ID;
if (teamsChanged.Contains(MainWindow.TST[teamid].DisplayName) == false)
{
teamsChanged.Add(MainWindow.TST[teamid].DisplayName);
}
}
}
}
}
if (teamsChanged.Count > 0)
{
teamsChanged.Sort();
var s = "Some teams were in divisions that were deleted and have been reset to the "
+ MainWindow.Divisions.First().Name + " division.\n\n";
teamsChanged.ForEach(s1 => s += s1 + "\n");
s = s.TrimEnd(new[] { '\n' });
SQLiteIO.SaveSeasonToDatabase();
MessageBox.Show(s);
}
}
/// <summary>
/// Handles the Click event of the btnOK control. The conference is renamed, the divisions are deleted and recreated, and if any
/// teams are left in division IDs that no longer exist, they get reassigned.
/// </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 btnOK_Click(object sender, RoutedEventArgs e)
{
var db = new SQLiteDatabase(MainWindow.CurrentDB);
if (String.IsNullOrWhiteSpace(txtName.Text))
{
txtName.Text = "League";
}
MainWindow.Conferences.Single(conference => conference.ID == _curConf.ID).Name = txtName.Text;
db.Update("Conferences", new Dictionary<string, string> { { "Name", txtName.Text } }, "ID = " + _curConf.ID);
MainWindow.Divisions.RemoveAll(division => division.ConferenceID == _curConf.ID);
db.Delete("Divisions", "Conference = " + _curConf.ID);
var usedIDs = new List<int>();
db.GetDataTable("SELECT ID FROM Divisions")
.Rows.Cast<DataRow>()
.ToList()
.ForEach(row => usedIDs.Add(ParseCell.GetInt32(row, "ID")));
var list = Tools.SplitLinesToList(txtDivisions.Text, false);
foreach (var newDiv in list)
{
var newName = newDiv.Replace(':', '-');
var i = 0;
while (usedIDs.Contains(i))
{
i++;
}
MainWindow.Divisions.Add(new Division { ID = i, Name = newName, ConferenceID = _curConf.ID });
usedIDs.Add(i);
}
if (MainWindow.Divisions.Any(division => division.ConferenceID == _curConf.ID) == false)
{
var i = 0;
while (usedIDs.Contains(i))
{
i++;
}
MainWindow.Divisions.Add(new Division { ID = i, Name = txtName.Text, ConferenceID = _curConf.ID });
usedIDs.Add(i);
}
foreach (var div in MainWindow.Divisions.Where(division => division.ConferenceID == _curConf.ID))
{
db.Insert(
"Divisions",
new Dictionary<string, string>
{
{ "ID", div.ID.ToString() },
{ "Name", div.Name },
{ "Conference", div.ConferenceID.ToString() }
});
}
TeamStats.CheckForInvalidDivisions();
ListWindow.MustUpdate = true;
Close();
}
private void btnOK_Click(object sender, RoutedEventArgs e)
{
if (_mode == Mode.HiddenTeams)
{
var db = new SQLiteDatabase(_currentDB);
var teamsT = "Teams";
var plTeamsT = "PlayoffTeams";
var oppT = "Opponents";
var plOppT = "PlayoffOpponents";
if (_curSeason != _maxSeason)
{
var s = "S" + _curSeason;
teamsT += s;
plTeamsT += s;
oppT += s;
plOppT += s;
}
foreach (string name in lstEnabled.Items)
{
var dict = new Dictionary<string, string> { { "isHidden", "False" } };
db.Update(teamsT, dict, "DisplayName LIKE \"" + name + "\"");
db.Update(plTeamsT, dict, "DisplayName LIKE \"" + name + "\"");
db.Update(oppT, dict, "DisplayName LIKE \"" + name + "\"");
db.Update(plOppT, dict, "DisplayName LIKE \"" + name + "\"");
}
foreach (string name in lstDisabled.Items)
{
var q = "select * from GameResults where SeasonNum = " + _curSeason + " AND (Team1ID = "
+ getTeamIDFromDisplayName(name) + " OR Team2ID = " + getTeamIDFromDisplayName(name) + ")";
var res = db.GetDataTable(q);
if (res.Rows.Count > 0)
{
var r = MessageBox.Show(
name + " have box scores this season. Are you sure you want to disable this team?",
"NBA Stats Tracker",
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (r == MessageBoxResult.No)
{
continue;
}
}
var dict = new Dictionary<string, string> { { "isHidden", "True" } };
db.Update(teamsT, dict, "DisplayName LIKE \"" + name + "\"");
db.Update(plTeamsT, dict, "DisplayName LIKE \"" + name + "\"");
db.Update(oppT, dict, "DisplayName LIKE \"" + name + "\"");
db.Update(plOppT, dict, "DisplayName LIKE \"" + name + "\"");
}
MainWindow.AddInfo = "$$TEAMSENABLED";
Close();
}
else if (_mode == Mode.HiddenPlayers)
{
var db = new SQLiteDatabase(_currentDB);
var dataList = new List<Dictionary<string, string>>();
var whereList = new List<string>();
foreach (KeyValuePair<int, string> item in lstEnabled.Items)
{
var dict = new Dictionary<string, string> { { "isHidden", "False" } };
dataList.Add(dict);
whereList.Add("ID = " + item.Key);
}
db.UpdateManyTransaction(_playersT, dataList, whereList);
dataList = new List<Dictionary<string, string>>();
whereList = new List<string>();
foreach (KeyValuePair<int, string> item in lstDisabled.Items)
{
var q =
"select * from PlayerResults INNER JOIN GameResults ON GameResults.GameID = PlayerResults.GameID where SeasonNum = "
+ _curSeason + " AND PlayerID = " + item.Key;
var res = db.GetDataTable(q, true);
if (res.Rows.Count > 0)
{
var r = MessageBox.Show(
item.Value + " has box scores this season. Are you sure you want to disable them?",
"NBA Stats Tracker",
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (r == MessageBoxResult.No)
{
continue;
}
}
var dict = new Dictionary<string, string> { { "isHidden", "True" }, { "isActive", "False" }, { "TeamFin", "" } };
dataList.Add(dict);
whereList.Add("ID = " + item.Key);
}
db.UpdateManyTransaction(_playersT, dataList, whereList);
MainWindow.AddInfo = "$$PLAYERSENABLED";
Close();
}
else if (_mode == Mode.REDitor)
{
if (lstEnabled.Items.Count != 30)
{
MessageBox.Show(
"You can't have less or more than 30 teams enabled. You currently have " + lstEnabled.Items.Count + ".");
return;
}
//MainWindow.selectedTeams = new List<Dictionary<string, string>>(_activeTeams);
MainWindow.SelectedTeams = new List<Dictionary<string, string>>();
foreach (string team in lstEnabled.Items)
{
var teamName = team.Split(new[] { " (ID: " }, StringSplitOptions.None)[0];
MainWindow.SelectedTeams.Add(
_validTeams.Find(
delegate(Dictionary<string, string> t)
{
if (t["Name"] == teamName)
{
return true;
}
return false;
}));
}
MainWindow.SelectedTeamsChanged = _changed;
DialogResult = true;
Close();
}
else if (_mode == Mode.TradePlayers)
{
foreach (var pair in _rosters)
{
var newTeam = pair.Key;
foreach (var pID in pair.Value)
{
var oldTeam = MainWindow.PST[pID].TeamF;
var oldTeamS = MainWindow.PST[pID].TeamS;
if (newTeam != oldTeam)
{
if (oldTeamS == -1)
{
MainWindow.PST[pID].TeamS = MainWindow.PST[pID].TeamF;
}
MainWindow.PST[pID].TeamF = newTeam;
MainWindow.PST[pID].IsSigned = newTeam != -1;
}
}
}
DialogResult = true;
Close();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="DualListWindow" /> class. Used to enable/disable players/teams for the season.
/// </summary>
/// <param name="currentDB">The current DB.</param>
/// <param name="curSeason">The cur season.</param>
/// <param name="maxSeason">The max season.</param>
/// <param name="mode">The mode.</param>
public DualListWindow(string currentDB, int curSeason, int maxSeason, Mode mode)
: this()
{
_mode = mode;
_currentDB = currentDB;
_curSeason = curSeason;
_maxSeason = maxSeason;
txbDescription.Text = "Current Season: " + _curSeason + "/" + _maxSeason;
var db = new SQLiteDatabase(_currentDB);
var teamsT = "Teams";
_playersT = "Players";
if (_curSeason != _maxSeason)
{
var s = "S" + _curSeason;
teamsT += s;
_playersT += s;
}
if (mode == Mode.HiddenTeams)
{
var q = "select DisplayName, isHidden from " + teamsT + " ORDER BY DisplayName ASC";
var res = db.GetDataTable(q);
foreach (DataRow r in res.Rows)
{
if (!ParseCell.GetBoolean(r, "isHidden"))
{
lstEnabled.Items.Add(ParseCell.GetString(r, "DisplayName"));
}
else
{
lstDisabled.Items.Add(ParseCell.GetString(r, "DisplayName"));
}
}
btnLoadList.Visibility = Visibility.Hidden;
}
else if (mode == Mode.HiddenPlayers)
{
Title = "Enable/Disable Players for Season";
lblEnabled.Content = "Enabled Players";
lblDisabled.Content = "Disabled Players";
var q = "SELECT (LastName || ', ' || FirstName || ' (' || TeamFin || ')') AS Name, ID, isHidden FROM " + _playersT
+ " ORDER BY LastName";
var res = db.GetDataTable(q);
foreach (DataRow r in res.Rows)
{
var s = ParseCell.GetString(r, "Name");
if (!ParseCell.GetBoolean(r, "isHidden"))
{
_shownPlayers.Add(new KeyValuePair<int, string>(ParseCell.GetInt32(r, "ID"), s));
}
else
{
_hiddenPlayers.Add(new KeyValuePair<int, string>(ParseCell.GetInt32(r, "ID"), s));
}
}
_shownPlayers.RaiseListChangedEvents = true;
lstEnabled.DisplayMemberPath = "Value";
lstEnabled.SelectedValuePath = "Key";
lstEnabled.ItemsSource = _shownPlayers;
_hiddenPlayers.RaiseListChangedEvents = true;
lstDisabled.DisplayMemberPath = "Value";
lstDisabled.SelectedValuePath = "Key";
lstDisabled.ItemsSource = _hiddenPlayers;
btnLoadList.Visibility = Visibility.Hidden;
}
}
/// <summary>
/// Updates the box score data grid.
/// </summary>
/// <param name="teamID">Name of the team.</param>
/// <param name="playersList">The players list.</param>
/// <param name="pbsList">The player box score list.</param>
/// <param name="playersT">The players' SQLite table name.</param>
/// <param name="loading">
/// if set to <c>true</c>, it is assumed that a pre-existing box score is being loaded.
/// </param>
private static void updateBoxScoreDataGrid(int teamID, out ObservableCollection<KeyValuePair<int, string>> playersList,
ref SortableBindingList<PlayerBoxScore> pbsList, string playersT, bool loading)
{
var db = new SQLiteDatabase(MainWindow.CurrentDB);
string q = "select * from " + playersT + " where TeamFin = " + teamID + "";
q += " ORDER BY LastName ASC";
DataTable res = db.GetDataTable(q);
playersList = new ObservableCollection<KeyValuePair<int, string>>();
if (!loading)
{
pbsList = new SortableBindingList<PlayerBoxScore>();
}
foreach (DataRow r in res.Rows)
{
var ps = new PlayerStats(r, MainWindow.TST);
playersList.Add(new KeyValuePair<int, string>(ps.ID, ps.LastName + ", " + ps.FirstName));
if (!loading)
{
var pbs = new PlayerBoxScore {PlayerID = ps.ID, TeamID = teamID};
pbsList.Add(pbs);
}
}
for (int i = 0; i < pbsList.Count; i++)
{
PlayerBoxScore cur = pbsList[i];
string name = MainWindow.PST[cur.PlayerID].LastName + ", " + MainWindow.PST[cur.PlayerID].FirstName;
var player = new KeyValuePair<int, string>(cur.PlayerID, name);
cur.Name = name;
if (!playersList.Contains(player))
{
playersList.Add(player);
}
pbsList[i] = cur;
}
playersList = new ObservableCollection<KeyValuePair<int, string>>(playersList.OrderBy(item => item.Value));
}