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);
}
