diff options
Diffstat (limited to 'Aktywator/Tournament.cs')
| -rw-r--r-- | Aktywator/Tournament.cs | 160 |
1 files changed, 119 insertions, 41 deletions
diff --git a/Aktywator/Tournament.cs b/Aktywator/Tournament.cs index b46740b..117b1da 100644 --- a/Aktywator/Tournament.cs +++ b/Aktywator/Tournament.cs @@ -1,82 +1,160 @@ using System; using System.Collections.Generic; using System.Text; -using MySql.Data.MySqlClient; -using data = MySql.Data.MySqlClient.MySqlDataReader; +using System.Windows.Forms; +using System.Drawing; namespace Aktywator { - public class Tournament + abstract public class Tournament { - private string _name; + public const int TYPE_PARY = 1; + public const int TYPE_TEAMY = 2; + public const int TYPE_RRB = 3; + public const int TYPE_UNKNOWN = 0; + + protected string _name; public string name { get { return _name; } } - private int _type; // 0-unknown, 1-Pary, 2-Teamy + protected int _type = Tournament.TYPE_UNKNOWN; // 0-unknown, 1-Pary, 2-Teamy, 3-RRB public int type { get { return _type; } } - public MySQL mysql; + abstract internal void setup(); + + abstract internal string getName(); + + abstract public string getSectionsNum(); - public Tournament(string name) + abstract public string getTablesNum(); + + abstract internal string getTypeLabel(); + + virtual internal Dictionary<int, List<string>> getNameList() { - this._name = name; - mysql = new MySQL(name); - recognizeType(); + return new Dictionary<int, List<string>>(); } - private void recognizeType() + virtual public void displayNameList(DataGridView grid) { - if ((mysql.selectOne("SHOW TABLES LIKE 'admin'") == "admin") - && (mysql.selectOne("SHOW FIELDS IN admin LIKE 'dnazwa'") == "dnazwa") - && (mysql.selectOne("SHOW TABLES LIKE 'zawodnicy'") == "zawodnicy")) - _type = 1; - else if ((mysql.selectOne("SHOW TABLES LIKE 'admin'") == "admin") - && (mysql.selectOne("SHOW FIELDS IN admin LIKE 'teamcnt'") == "teamcnt") - && (mysql.selectOne("SHOW TABLES LIKE 'players'") == "players")) - _type = 2; - else _type = 0; + Dictionary<int, List<string>> names = this.getNameList(); + foreach (KeyValuePair<int, List<string>> item in names) { + if (!this.updateNameListRow(grid, item.Key, item.Value)) + { + this.addNameListRow(grid, item.Key, item.Value); + } + } + List<DataGridViewRow> toDelete = new List<DataGridViewRow>(); + foreach (DataGridViewRow row in grid.Rows) + { + if (!names.ContainsKey(Int32.Parse(row.Cells[0].Value.ToString()))) + { + toDelete.Add(row); + } + } + foreach (DataGridViewRow r in toDelete) + { + grid.Rows.Remove(r); + } + grid.Update(); + grid.Refresh(); } - public override string ToString() + virtual internal bool updateNameListRow(DataGridView grid, int pairNumber, List<string> names) { - return this.name + " [" + (this.type == 1 ? 'P' : 'T') + "]"; + foreach (DataGridViewRow row in grid.Rows) + { + if (Int32.Parse(row.Cells[0].Value.ToString()) == pairNumber) + { + for (int i = 1; i < 3; i++) + { + if (!(bool)row.Cells[i].Tag) + { + row.Cells[i].Value = names[i - 1]; + row.Cells[i].Tag = false; + row.Cells[i].Style.BackColor = Color.White; + } + } + return true; + } + } + return false; } - public static List<Tournament> getTournaments() + virtual internal void addNameListRow(DataGridView grid, int pairNumber, List<string> names) { - List<Tournament> list = new List<Tournament>(); - MySQL c = new MySQL(""); - data dbs = c.select("SHOW DATABASES;"); - while (dbs.Read()) + DataGridViewRow row = new DataGridViewRow(); + row.Cells.Add(new DataGridViewTextBoxCell()); + row.Cells[0].Value = pairNumber.ToString(); + foreach (string name in names) { - Tournament t = new Tournament(dbs.GetString(0)); - if (t.type > 0) - list.Add(t); - t.mysql.close(); + DataGridViewTextBoxCell cell = new DataGridViewTextBoxCell(); + cell.Value = name; + cell.Tag = false; + row.Cells.Add(cell); } - return list; + grid.Rows.Add(row); + grid.FirstDisplayedScrollingRowIndex = grid.RowCount - 1; } - public string getSectionsNum() + virtual internal void clearCellLocks(DataGridView grid) { - if (type == 1) - return mysql.selectOne("SELECT COUNT(DISTINCT seknum) FROM sektory;"); - else - return "1"; + foreach (DataGridViewRow row in grid.Rows) + { + for (int i = 1; i < 3; i++) + { + row.Cells[i].Tag = false; + row.Cells[i].Style.BackColor = Color.White; + } + } } - public string getTablesNum() + virtual internal string shortenNameToBWS(string name) { - if (type == 1) - return mysql.selectOne("SELECT COUNT(*) FROM sektory;"); + name = Common.bezOgonkow(name); + if ("pauza".Equals(name.Trim())) + { + return " "; + } else - return mysql.selectOne("SELECT teamcnt FROM admin;"); + { + if (this._type != Tournament.TYPE_TEAMY || MainForm.teamNames.arePlayerNamesDisplayed()) + { + string[] nameParts = name.Trim().Split(' '); + if (nameParts.Length > 0) + { + nameParts[0] = (nameParts[0].Length > 0) ? nameParts[0][0].ToString() : " "; + } + name = String.Join(" ", nameParts); + } + if (name.Length > 18) + { + name = name.Substring(0, 18); + } + return name; + } } + virtual public Dictionary<int, List<string>> getBWSNames(DataGridView grid) + { + Dictionary<int, List<string>> dict = new Dictionary<int, List<string>>(); + foreach (DataGridViewRow row in grid.Rows) + { + List<string> names = new List<string>(); + for (int i = 1; i < 3; i++) + { + names.Add(this.shortenNameToBWS(row.Cells[i].Value.ToString())); + } + dict.Add(Int32.Parse(row.Cells[0].Value.ToString()), names); + } + return dict; + } + + } } |