public User GetUser(string username) { User user = null; DataTable table = new DataTable(); MySqlConnection conn = new MySqlConnection(connStr); try { conn.Open(); string statement = "SELECT * FROM ajjusers WHERE username=@username LIMIT 1;"; MySqlCommand cmd = new MySqlCommand(statement, conn); cmd.Parameters.AddWithValue("@username", username); MySqlDataAdapter myAdapter = new MySqlDataAdapter(cmd); myAdapter.Fill(table); myAdapter.Dispose(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } conn.Close(); foreach (DataRow row in table.Rows) { string fullName = row["fullName"].ToString(); User.Rank rank = (User.Rank)(int) row["rank"]; user = new User(fullName, username, rank); } table.Dispose(); return(user); }
private User[] GetAllUsers() { List <User> users = new List <User>(); DataTable table = new DataTable(); MySqlConnection conn = new MySqlConnection(connStr); try { conn.Open(); string statement = "SELECT * FROM ajjusers WHERE rank != 2"; MySqlCommand cmd = new MySqlCommand(statement, conn); MySqlDataAdapter myAdapter = new MySqlDataAdapter(cmd); myAdapter.Fill(table); myAdapter.Dispose(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } conn.Close(); foreach (DataRow row in table.Rows) { string fullName = row["fullName"].ToString(); string username = row["username"].ToString(); User.Rank rank = (User.Rank)(int) row["rank"]; User user = new User(fullName, username, rank); users.Add(user); } table.Dispose(); return(users.ToArray()); }