public override List<Subdomain> GetSubdomains(string domainName) { var _tmp = new List<Subdomain>(); using (OleDbConnection _conn = new OleDbConnection(Settings.Default.connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT Domain_Name, Sub_Domain, Host_ID, Reseller_Username FROM SubDomain_List WHERE (Domain_Name = ?)", _conn)) { _cmd.CommandType = CommandType.Text; _cmd.Parameters.AddWithValue("NAME", domainName); using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Subdomain(); _d.Domain = _read["Domain_Name"].ToString(); _d.Login = _read["Domain_Name"].ToString(); _d.Password = ""; _d.Name = _read["Sub_Domain"].ToString(); _d.UserType = ""; _tmp.Add(_d); } } } _conn.Close(); } return _tmp; }
public override List<Subdomain> GetSubdomains(string domainName) { var _tmp = new List<Subdomain>(); using (OleDbConnection _conn = new OleDbConnection(Settings.Default.connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT subdomains.name, domains.name AS [domain], sys_users.login, accounts.[password], subdomains.sys_user_type FROM (((accounts RIGHT OUTER JOIN sys_users ON accounts.id = sys_users.account_id) RIGHT OUTER JOIN subdomains ON sys_users.id = subdomains.sys_user_id) LEFT OUTER JOIN domains ON subdomains.dom_id = domains.id) WHERE (domains.name = ?)", _conn)) { _cmd.CommandType = CommandType.Text; _cmd.Parameters.AddWithValue("NAME", domainName); using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Subdomain(); _d.Domain = _read["domain"].ToString(); _d.Login = _read["login"].ToString(); _d.Password = _read["password"].ToString(); _d.Name = _read["name"].ToString(); _d.UserType = _read["sys_user_type"].ToString(); _tmp.Add(_d); } } } _conn.Close(); } return _tmp; }
public override List<Subdomain> GetSubdomains(string domainName) { var _tmp = new List<Subdomain>(); using (SQLiteConnection _conn = new SQLiteConnection(Settings.Default.connectionString)) { _conn.Open(); using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT SD.Name as name, D.Name as domain, SD.Username as login, FU.Password as password FROM SubDomain As SD LEFT JOIN Domain As D ON D.DomainId = SD.DomainId LEFT JOIN DomainMsFTP As Ftp ON Ftp.DomainId = D.DomainId LEFT JOIN DomainMsFTPUser As FU ON FU.FtpId = Ftp.Id AND FU.Username = SD.Username WHERE D.Name = $NAME", _conn)) { _cmd.Parameters.AddWithValue("$NAME", domainName); using (SQLiteDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Subdomain(); _d.Domain = _read["domain"].ToString(); _d.Login = _read["login"].ToString(); _d.Password = _read["password"].ToString(); _d.Name = _read["name"].ToString(); _d.UserType = ""; _tmp.Add(_d); } } } _conn.Close(); } return _tmp; }