public override List<Domain> GetDomains()
{
var _tmp = new List<Domain>();
using (OleDbConnection _conn = new OleDbConnection(Settings.Default.connectionString))
{
_conn.Open();
using (OleDbCommand _cmd = new OleDbCommand(@"SELECT
domains.id,
domains.name,
hosting.fp_adm,
accounts.[password],
clients.login,
clients.passwd,
dom_level_usrs.passwd AS DomainPass,
domains.status AS Status,
NULL AS expiration
FROM (((((domains LEFT OUTER JOIN
hosting ON hosting.dom_id = domains.id)
LEFT OUTER JOIN
sys_users ON hosting.sys_user_id = sys_users.id) LEFT OUTER JOIN
accounts ON accounts.id = sys_users.account_id) LEFT OUTER JOIN
clients ON clients.id = domains.cl_id) LEFT OUTER JOIN
dom_level_usrs ON dom_level_usrs.dom_id = domains.id)
WHERE
(domains.htype = 'vrt_hst')
ORDER BY domains.id", _conn))
{
using (OleDbDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new Domain();
_d.Id = (int)_read["Id"];
_d.Name = _read["name"].ToString();
_d.Username = _read["fp_adm"].ToString();
_d.Password = _read["password"].ToString();
_d.ClientName = _read["login"].ToString();
_d.Status = Convert.ToInt32(_read["Status"]);
if (!_read.IsDBNull(6))
_d.DomainPassword = _read["DomainPass"].ToString();
if (!_read.IsDBNull(8))
_d.Expiration = _d.FromUnixTime(_read["expiration"].ToString());
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return _tmp;
}
public override List<Domain> GetDomains()
{
var _tmp = new List<Domain>();
using (SqlConnection _conn = new SqlConnection(Settings.Default.connectionString))
{
_conn.Open();
using (SqlCommand _cmd = new SqlCommand(@"SELECT domains.id, domains.name, hosting.fp_adm, accounts.password, clients.login, clients.passwd,
dom_level_usrs.passwd As DomainPass, domains.status As Status, limits.value as expiration
FROM domains
LEFT JOIN hosting ON hosting.dom_id = domains.id
LEFT JOIN sys_users ON hosting.sys_user_id = sys_users.id
LEFT JOIN accounts ON accounts.id = sys_users.account_id
LEFT JOIN clients ON clients.id = domains.cl_id
LEFT JOIN dom_level_usrs ON dom_level_usrs.dom_id = domains.id
LEFT JOIN limits ON limits.id = domains.limits_id AND limits.limit_name = 'expiration'
WHERE
domains.htype = 'vrt_hst'", _conn))
{
using (SqlDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new Domain();
_d.Id = (int)_read["id"];
_d.Name = _read["name"].ToString();
_d.Username = _read["fp_adm"].ToString();
_d.Password = _read["password"].ToString();
_d.ClientName = _read["login"].ToString();
_d.Status = (long)_read["Status"];
System.Console.WriteLine("Check 1");
if (!_read.IsDBNull(6))
_d.DomainPassword = _read["DomainPass"].ToString();
if (!_read.IsDBNull(8))
_d.Expiration = _d.FromUnixTime(_read["expiration"].ToString());
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return _tmp;
}