public void PrintChat() { List <Parameter> parameters = new List <Parameter>(); if (_loggedIn) { const string sqlStatement = "CALL getChat()"; DataTable table = LanderSQLHelper.RequestTable(_mySqlConnection, sqlStatement, parameters); LanderSQLHelper.PrintTable(table); } else { throw new Exception("Session not logged in!"); } }
public void ListUsers() { if (_loggedIn) { if (_admin) { List <Parameter> parameters = new List <Parameter> { new Parameter("@username", _username, MySqlDbType.VarChar, 16), new Parameter("@password", _password, MySqlDbType.VarChar, 32) }; const string sqlStatement = "CALL listUsersAdmin(@username, @password)"; DataTable table = LanderSQLHelper.RequestTable(_mySqlConnection, sqlStatement, parameters); DataRow row = table.Rows[0]; string statusMessage = row["STATUS"].ToString(); if (statusMessage == "OK") { LanderSQLHelper.PrintTable(table); } else { throw new Exception("SQL ERROR: " + statusMessage); } } else { List <Parameter> parameters = new List <Parameter>(); const string sqlStatement = "CALL listUsers()"; DataTable table = LanderSQLHelper.RequestTable(_mySqlConnection, sqlStatement, parameters); DataRow row = table.Rows[0]; string statusMessage = row["STATUS"].ToString(); if (statusMessage == "OK") { LanderSQLHelper.PrintTable(table); } else { throw new Exception("SQL ERROR: " + statusMessage); } } } else { throw new Exception("Session not logged in!"); } }
public void PrintCurrentMap() { LanderSQLHelper.PrintTable(_match.Map); }