private List <DatabaseUser> GetDatabaseUsers(int databaseId)
{
var _tmp = new List <DatabaseUser>();
using (MySqlConnection _conn = new MySqlConnection(connectionString))
{
_conn.Open();
//using (MySqlCommand _cmd = new MySqlCommand(@"SELECT login, passwd FROM db_users WHERE (db_id = @ID) AND (status = 'normal')", _conn))
using (MySqlCommand _cmd = new MySqlCommand(@"SELECT login, accounts.password FROM db_users JOIN accounts ON db_users.account_id = accounts.Id
WHERE (db_id = @ID) AND (status = 'normal')", _conn))
{
_cmd.Parameters.AddWithValue("@ID", databaseId);
using (MySqlDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DatabaseUser();
_d.Username = _read["login"].ToString();
_d.Password = _read["password"].ToString();
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
private List <DatabaseUser> GetDatabaseUsers(int databaseId)
{
var _tmp = new List <DatabaseUser>();
using (OleDbConnection _conn = new OleDbConnection(connectionString))
{
_conn.Open();
using (OleDbCommand _cmd = new OleDbCommand(@"SELECT login, passwd FROM db_users WHERE (db_id = ?) AND (status = 'normal')", _conn))
{
_cmd.CommandType = CommandType.Text;
_cmd.Parameters.AddWithValue("ID", databaseId);
using (OleDbDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DatabaseUser();
_d.Username = _read["login"].ToString();
_d.Password = _read["passwd"].ToString();
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
private List <DatabaseUser> GetMsSqlDatabaseUsers(int databaseId)
{
var _tmp = new List <DatabaseUser>();
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT Username, Password FROM DomainMsSQLUser WHERE DatabaseId = $ID", _conn))
{
_cmd.Parameters.AddWithValue("$ID", databaseId);
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DatabaseUser();
_d.Username = _read["Username"].ToString();
_d.Password = _read["Password"].ToString();
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
