public override List<DomainAlias> GetDomainAliases(string domainName)
{
var _tmp = new List<DomainAlias>();
using (OleDbConnection _conn = new OleDbConnection(Settings.Default.connectionString))
{
_conn.Open();
using (OleDbCommand _cmd = new OleDbCommand(@"SELECT domain_aliases.name AS alias, domains.name AS [domain], domain_aliases.status
FROM (domain_aliases INNER JOIN
domains ON domain_aliases.dom_id = domains.id)
WHERE (domain_aliases.status = 0) AND (domains.name = ?)", _conn))
{
_cmd.CommandType = CommandType.Text;
_cmd.Parameters.AddWithValue("NAME", domainName);
using (OleDbDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DomainAlias();
_d.Domain = _read["domain"].ToString();
_d.Alias = _read["alias"].ToString();
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return _tmp;
}
public override List<DomainAlias> GetDomainAliases(string domainName)
{
var _tmp = new List<DomainAlias>();
using (SQLiteConnection _conn = new SQLiteConnection(Settings.Default.connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT D.Name as domain, DA.Hostname as name FROM DomainAlias As DA
LEFT JOIN Domain As D ON D.DomainId = Da.DomainId WHERE D.Name = $NAME", _conn))
{
_cmd.Parameters.AddWithValue("$NAME", domainName);
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DomainAlias();
_d.Domain = _read["domain"].ToString();
_d.Alias = _read["alias"].ToString();
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return _tmp;
}
public override List<DomainAlias> GetDomainAliases(string domainName)
{
var _tmp = new List<DomainAlias>();
using (OleDbConnection _conn = new OleDbConnection(Settings.Default.connectionString))
{
_conn.Open();
using (OleDbCommand _cmd = new OleDbCommand(@"SELECT Host_Accounts.Domain_Name, Alias_Details.Alias_Domainname
FROM (Host_Accounts INNER JOIN
Alias_Details ON Host_Accounts.Host_ID = Alias_Details.Host_ID)
WHERE (Host_Accounts.Domain_Name = ?)", _conn))
{
_cmd.CommandType = CommandType.Text;
_cmd.Parameters.AddWithValue("NAME", domainName);
using (OleDbDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DomainAlias();
_d.Domain = _read["Domain_Name"].ToString();
_d.Alias = _read["Alias_Domainname"].ToString();
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return _tmp;
}
public override List<DomainAlias> GetDomainAliases(string domainName)
{
var _tmp = new List<DomainAlias>();
using (SqlConnection _conn = new SqlConnection(Settings.Default.connectionString))
{
_conn.Open();
using (SqlCommand _cmd = new SqlCommand(@"SELECT domain_aliases.name as alias, domains.name AS domain, domain_aliases.status
FROM domain_aliases
INNER JOIN domains ON domain_aliases.dom_id = domains.id
WHERE domain_aliases.status = 0 AND domains.name = @NAME", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (SqlDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DomainAlias();
_d.Domain = _read["domain"].ToString();
_d.Alias = _read["alias"].ToString();
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return _tmp;
}