ArkaliaCore.Realm.Database.Tables.AccountTable.GetAccountFromSQL C# (CSharp) Method

GetAccountFromSQL() public static method

public static GetAccountFromSQL ( string username ) : Models.AccountModel
username string
return Models.AccountModel
        public static Models.AccountModel GetAccountFromSQL(string username)
        {
            lock (DatabaseManager.Locker)
            {
                Models.AccountModel account = null;
                var reader = DatabaseManager.Provider.ExecuteReader("SELECT * FROM accounts WHERE username='" + username + "'");
                if (reader.Read())
                {
                    account = new Models.AccountModel()
                    {
                        ID = reader.GetInt32("Id"),
                        Username = reader.GetString("Username"),
                        Password = reader.GetString("Password"),
                        Pseudo = reader.GetString("Pseudo"),
                        AdminLevel = reader.GetInt32("AdminLevel"),
                        Points = reader.GetInt32("Points"),
                        Vip = reader.GetInt32("Vip"),
                    };
                }
                reader.Close();
                return account;
            }
        }