public override HostLimit GetDomainLimits(string domainName) { var _tmp_limits = new List <LimitRow>(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT L.limit_name, L.value FROM domains D LEFT JOIN limits L ON L.id = D.limits_id WHERE D.name = @NAME", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (SqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new LimitRow(); _d.Name = DataExtensions.GetColumnValue <string>(_read, "limit_name"); var LimitValue = 0L; if (_read["value"] is System.Int64) { LimitValue = DataExtensions.GetColumnValue <Int64>(_read, "value"); } else { LimitValue = Convert.ToInt64(DataExtensions.GetColumnValue <string>(_read, "value")); } if (_d.Name == "disk_space" || _d.Name == "max_traffic" || _d.Name == "mbox_quota" || _d.Name == "mssql_dbase_space" || _d.Name == "mysql_dbase_space" || _d.Name == "total_mboxes_quota") { _d.Value = (int)((LimitValue / 1024) / 1024); } else { _d.Value = Convert.ToInt32(LimitValue); } _tmp_limits.Add(_d); } } } _conn.Close(); } return(new HostLimit(_tmp_limits)); }
public override List <DnsZoneRecord> GetZoneRecords(string domainName) { var _tmp = new List <DnsZoneRecord>(); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT dns_recs.id, dns_recs.dns_zone_id, dns_recs.type, dns_recs.host, dns_recs.displayHost, dns_recs.val, dns_recs.displayVal, dns_recs.opt, dns_recs.time_stamp FROM (dns_zone LEFT OUTER JOIN dns_recs ON dns_recs.dns_zone_id = dns_zone.id) WHERE (dns_zone.name = ?) AND (dns_recs.type <> 'PTR')", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new DnsZoneRecord(); var hostName = DataExtensions.GetColumnValue <string>(_read, "host"); if (hostName == domainName || hostName == String.Format("{0}.", domainName)) { _d.name = "@"; } else { _d.name = hostName.Split('.').FirstOrDefault().ToLower(); } _d.type = DataExtensions.GetColumnValue <string>(_read, "type"); _d.value = DataExtensions.GetColumnValue <string>(_read, "val").ToLower(); var options = DataExtensions.GetColumnValue <string>(_read, "opt"); if (!String.IsNullOrEmpty(options)) { _d.priority = Convert.ToInt32(options); } else { _d.priority = 0; } _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
public override List <DnsZoneRecord> GetZoneRecords(string domainName) { var _tmp = new List <DnsZoneRecord>(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT dns_recs.* FROM dns_zone LEFT JOIN dns_recs ON dns_recs.dns_zone_id = dns_zone.id WHERE dns_zone.name = @NAME AND dns_recs.type <> 'PTR'", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new DnsZoneRecord(); var hostName = DataExtensions.GetColumnValue <string>(_read, "host"); if (hostName == domainName || hostName == String.Format("{0}.", domainName)) { _d.name = "@"; } else { _d.name = hostName.Split('.').FirstOrDefault().ToLower(); } _d.type = DataExtensions.GetColumnValue <string>(_read, "type"); _d.value = DataExtensions.GetColumnValue <string>(_read, "val").ToLower(); _d.priority = 0; var options = DataExtensions.GetColumnValue <string>(_read, "opt"); var options_int = 0; if (int.TryParse(options, out options_int)) { _d.priority = options_int; } _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
public override List <Email> GetEmails(string domainName) { var securePassword = SecurePasswords(); var _tmp = new List <Email>(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT mail.mail_name, domains.name, accounts.password, domains.status, mail.redirect, mail.redir_addr, mail.mbox_quota FROM domains LEFT OUTER JOIN mail ON mail.dom_id = domains.id LEFT OUTER JOIN accounts ON accounts.id = mail.account_id WHERE (mail.mail_name <> '') AND (domains.name = @NAME)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Email(); _d.Name = DataExtensions.GetColumnValue <String>(_read, "mail_name").ToLower(); _d.DomainName = DataExtensions.GetColumnValue <String>(_read, "name").ToLower(); _d.Password = securePassword ? DataHelper.GetPassword() : DataExtensions.GetColumnValue <String>(_read, "password"); _d.Redirect = DataExtensions.GetColumnValue <String>(_read, "redirect"); _d.RedirectedEmail = DataExtensions.GetColumnValue <String>(_read, "redir_addr"); var mboxQuota = Convert.ToDouble(DataExtensions.GetColumnValue <Int64>(_read, "mbox_quota")); if (mboxQuota > 0) { _d.Quota = Math.Round(((mboxQuota / 1024) / 1024), 0); } else { _d.Quota = -1; } _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
public override List <Reseller> GetResellers() { var _tmp = new List <Reseller>(); using (SQLiteConnection _conn = new SQLiteConnection(connectionString)) { _conn.Open(); using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT LoginAccount.LoginId, LoginAccount.UserName, LoginAccount.Password, LoginAccount.UserType, LoginAccount.ProfileId, LoginAccount.ExpirationDate, LoginAccount.ApiKey, LoginAccount.Status, LoginAccount.ApiAccess, Profile.FirstName, Profile.LastName, Profile.Email, Profile.Country, Profile.Organization, Profile.Address1, Profile.Address2, Profile.City, Profile.Province, Profile.PostalCode, Profile.Phone, Profile.Fax FROM LoginAccount LEFT OUTER JOIN Profile ON LoginAccount.ProfileId = Profile.ProfileId WHERE (LoginAccount.UserType = 1)", _conn)) { using (SQLiteDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var da = new Reseller(); da.Id = Convert.ToInt32(DataExtensions.GetColumnValue <Int64>(_read, "LoginId")); da.Username = DataExtensions.GetColumnValue <String>(_read, "UserName"); da.Password = DataExtensions.GetColumnValue <String>(_read, "Password"); da.Address1 = DataExtensions.GetColumnValue <String>(_read, "Address1"); da.Address2 = DataExtensions.GetColumnValue <String>(_read, "Address2"); da.City = DataExtensions.GetColumnValue <String>(_read, "City"); da.Country = DataExtensions.GetColumnValue <String>(_read, "Country"); da.Email = DataExtensions.GetColumnValue <String>(_read, "Email"); da.fax = DataExtensions.GetColumnValue <String>(_read, "Fax"); da.FirstName = DataExtensions.GetColumnValue <String>(_read, "FirstName"); da.LastName = DataExtensions.GetColumnValue <String>(_read, "LastName"); da.Organization = DataExtensions.GetColumnValue <String>(_read, "Organization"); da.Phone = DataExtensions.GetColumnValue <String>(_read, "Phone"); da.PostalCode = DataExtensions.GetColumnValue <String>(_read, "PostalCode"); da.Province = DataExtensions.GetColumnValue <String>(_read, "Province"); da.Limits = ResellerLimits(da.Username); _tmp.Add(da); } } } _conn.Close(); } return(_tmp); }
public override List <Domain> GetDomains() { var _tmp = new List <Domain>(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT HostDomain.DomainName, Account.AccountNumber, HostDomain.DomainId, HostDomain.DomainStatus, HostDomain.SubDomainId, HostDomain.DomainAliasId FROM Account INNER JOIN Package ON Account.AccountNumber = Package.AccountNumber RIGHT OUTER JOIN HostDomain ON Package.PackageId = HostDomain.PackageId WHERE (HostDomain.SubDomainId = 0) AND (HostDomain.DomainAliasId = 0)", _conn)) { using (SqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Domain(); _d.Id = DataExtensions.GetColumnValue <int>(_read, "DomainId"); _d.Name = DataExtensions.GetColumnValue <String>(_read, "DomainName").ToLower(); _d.ClientName = DataExtensions.GetColumnValue <String>(_read, "AccountNumber"); _d.DomainPassword = DataHelper.GetPassword(); var currentFtpUser = GetFirstFtpAccount(_d.Id); _d.Username = String.IsNullOrEmpty(currentFtpUser) ? _d.Name : currentFtpUser; _d.Password = _d.DomainPassword; _d.Status = DataExtensions.GetColumnValue <int>(_read, "DomainStatus"); _d.Expiration = DateTime.Now.AddYears(1); _d.isForwarding = false; _d.Aliases = GetDomainAliases(_d.Name); _d.Databases = GetDatabases(_d.Name); _d.Limits = GetDomainLimits(_d.Name); _d.Subdomains = GetSubdomains(_d.Name); _d.Zone = GetDnsZone(_d.Name); _d.Emails = GetEmails(_d.Name); _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
public override List <MpMigrate.Data.Entity.Domain> GetDomains() { var tmp = new List <MpMigrate.Data.Entity.Domain>(); using (OdbcConnection _conn = new OdbcConnection(connectionString)) { _conn.Open(); using (OdbcCommand _cmd = new OdbcCommand(@"SELECT Host_ID, Reseller_Username, Domain_Name, [Password], AcountDisabled, Limit_WebSpace, Limit_Traffic, Limit_Stats, Limit_MailAccounts, Limit_MySQL, Limit_DomainAlias, Active_Date, Limit_SubDomain FROM Host_Accounts", _conn)) { using (OdbcDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new MpMigrate.Data.Entity.Domain(); _d.Id = DataExtensions.GetColumnValue <int>(_read, "Host_ID"); _d.Name = DataExtensions.GetColumnValue <String>(_read, "Domain_Name").ToLower(); _d.ClientName = DataExtensions.GetColumnValue <String>(_read, "Reseller_Username"); _d.DomainPassword = DataExtensions.GetColumnValue <String>(_read, "Password"); _d.Username = DataExtensions.GetColumnValue <String>(_read, "Domain_Name"); _d.Password = DataExtensions.GetColumnValue <String>(_read, "Password"); if (String.IsNullOrEmpty(_d.Password)) { _d.Password = DataHelper.GetPassword(); } _d.Status = 1; _d.Expiration = DateTime.Now.AddYears(1); //Expiration Date Entrenix'de tutulmuyor. _d.isForwarding = false; _d.Aliases = GetDomainAliases(_d.Name); _d.Databases = GetDatabases(_d.Name); _d.Limits = GetDomainLimits(_d.Name); _d.Subdomains = GetSubdomains(_d.Name); _d.Zone = GetDnsZone(_d.Name); _d.Emails = GetEmails(_d.Name); tmp.Add(_d); } } } _conn.Close(); } return(tmp); }
public override List <Email> GetEmails(string domainName) { var _tmp = new List <Email>(); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT mail.mail_name, domains.name, accounts.[password], domains.status, mail.redirect, mail.redir_addr, mail.mbox_quota FROM ((domains LEFT OUTER JOIN mail ON mail.dom_id = domains.id) LEFT OUTER JOIN accounts ON accounts.id = mail.account_id) WHERE (domains.name = ?) AND (mail.mail_name <> '')", _conn)) { _cmd.CommandType = CommandType.Text; _cmd.Parameters.AddWithValue("NAME", domainName); using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Email(); _d.Name = DataExtensions.GetColumnValue <String>(_read, "mail_name").ToLower(); _d.DomainName = DataExtensions.GetColumnValue <String>(_read, "name").ToLower(); _d.Password = DataExtensions.GetColumnValue <String>(_read, "password"); _d.Redirect = DataExtensions.GetColumnValue <String>(_read, "redirect"); _d.RedirectedEmail = DataExtensions.GetColumnValue <String>(_read, "redir_addr"); var mboxQuota = DataExtensions.GetColumnValue <decimal>(_read, "mbox_quota"); if (mboxQuota > 0) { _d.Quota = Convert.ToDouble(Math.Round(((mboxQuota / 1024) / 1024), 0)); } else { _d.Quota = -1; } _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
public override HostLimit GetDomainLimits(string domainName) { var _tmp_limits = new List <LimitRow>(); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT L.limit_name, L.[value] FROM (domains D LEFT OUTER JOIN limits L ON L.id = D.limits_id) WHERE (D.name = ?) AND (L.limit_name <> NULL)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new LimitRow(); _d.Name = DataExtensions.GetColumnValue <string>(_read, "limit_name"); var LimitValue = DataExtensions.GetColumnValue <decimal>(_read, "value"); if (_d.Name == "disk_space" || _d.Name == "max_traffic" || _d.Name == "mbox_quota" || _d.Name == "mssql_dbase_space" || _d.Name == "mysql_dbase_space" || _d.Name == "total_mboxes_quota") { _d.Value = (int)((LimitValue / 1024) / 1024); } else { if (LimitValue <= int.MaxValue) { _d.Value = Convert.ToInt32(LimitValue); } else { throw new Exception(String.Format("Value too large or too small for an Int32 {0}: {1}", _d.Name, LimitValue)); } } _tmp_limits.Add(_d); } } } _conn.Close(); } return(new HostLimit(_tmp_limits)); }
public override HostLimit GetDomainLimits(string domainName) { var _tmp_limits = new List <LimitRow>(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT L.limit_name, L.value FROM domains D LEFT JOIN Limits L ON L.id = D.limits_id WHERE D.name = @NAME", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new LimitRow(); _d.Name = DataExtensions.GetColumnValue <string>(_read, "limit_name"); var arrayValue = DataExtensions.GetColumnValue <Byte[]>(_read, "value"); var LimitValue = arrayValue != null?Convert.ToInt64(Encoding.ASCII.GetString(arrayValue)) : -1; if (_d.Name == "disk_space" || _d.Name == "max_traffic" || _d.Name == "mbox_quota" || _d.Name == "mssql_dbase_space" || _d.Name == "mysql_dbase_space" || _d.Name == "max_traffic_soft" || _d.Name == "disk_space_soft") { _d.Value = (int)((LimitValue / 1024) / 1024); } else if (_d.Name == "expiration") { } else { if (LimitValue > int.MaxValue) { throw new InvalidCastException(_d.Name + ": " + LimitValue.ToString()); } _d.Value = Convert.ToInt32(LimitValue); } _tmp_limits.Add(_d); } } } _conn.Close(); } return(new HostLimit(_tmp_limits)); }
public override HostLimit ResellerLimits(string clientName) { var _tmp_limits = new List <LimitRow>(); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT L.limit_name, L.[value] FROM (clients C LEFT OUTER JOIN limits L ON L.id = C.limits_id) WHERE (C.login = ?)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", clientName); using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new LimitRow(); _d.Name = DataExtensions.GetColumnValue <string>(_read, "limit_name"); var LimitValue = Convert.ToInt64(DataExtensions.GetColumnValue <decimal>(_read, "value")); if (_d.Name == "disk_space" || _d.Name == "max_traffic" || _d.Name == "mbox_quota" || _d.Name == "total_mboxes_quota") { _d.Value = (int)((LimitValue / 1024) / 1024); } else { if (LimitValue <= int.MaxValue) { _d.Value = Convert.ToInt32(LimitValue); } else { _d.Value = (int)((LimitValue / 1024) / 1024); } } _tmp_limits.Add(_d); } } } _conn.Close(); } return(new HostLimit(_tmp_limits)); }
public override DnsZone GetDnsZone(string domainName) { var _tmp = new DnsZone(); _tmp.Name = domainName; using (SQLiteConnection _conn = new SQLiteConnection(connectionString)) { _conn.Open(); using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT Domain.Name, DomainZone.Id, DomainZone.ZoneType, DomainZone.AllowZoneTransfers, DomainZone.SecondaryServers, DomainZone.SerialNumber, DomainZone.PrimaryServer, DomainZone.ResponsiblePerson, DomainZone.RefreshInterval, DomainZone.RetryInterval, DomainZone.Expires, DomainZone.TTL FROM DomainZone INNER JOIN Domain ON DomainZone.DomainId = Domain.DomainId WHERE (Domain.Name = @NAME)" , _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (SQLiteDataReader _read = _cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow)) { if (_read.Read()) { _tmp.Name = DataExtensions.GetColumnValue <string>(_read, "Name").ToLower(); _tmp.mininum = -1; _tmp.refresh = Convert.ToInt32(DataExtensions.GetColumnValue <Int64>(_read, "RefreshInterval")); _tmp.retry = Convert.ToInt32(DataExtensions.GetColumnValue <Int64>(_read, "RetryInterval")); _tmp.expire = Convert.ToInt32(DataExtensions.GetColumnValue <Int64>(_read, "Expires")); var serial = DataExtensions.GetColumnValue <string>(_read, "SerialNumber"); _tmp.serial = Convert.ToInt32(serial); _tmp.ttl = Convert.ToInt32(DataExtensions.GetColumnValue <Int64>(_read, "TTL")); _tmp.Email = DataExtensions.GetColumnValue <string>(_read, "ResponsiblePerson"); } } } _conn.Close(); } _tmp.Records = GetZoneRecords(domainName); return(_tmp); }
public override List <Email> GetEmails(string domainName) { var _tmp = new List <Email>(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT DomainPostofficeUser.Username, DomainPostofficeUser.Password, DomainPostofficeUser.AutoResponderSubject, DomainPostofficeUser.AutoResponderMessage, DomainPostofficeUser.Quota, DomainPostofficeUser.Status, DomainPostofficeUser.RedirectionStatus, DomainPostofficeUser.RedirectionCopyStatus, DomainPostofficeUser.AutoResponderStatus, DomainPostofficeUser.UsageValue, Domain.Name AS DomainName FROM Domain INNER JOIN DomainPostoffice ON Domain.DomainId = DomainPostoffice.DomainId INNER JOIN DomainPostofficeUser ON DomainPostoffice.Id = DomainPostofficeUser.PostOfficeId WHERE (Domain.Name = @NAME)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (SqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var da = new Email(); da.DomainName = domainName; da.Name = DataExtensions.GetColumnValue <string>(_read, "Username"); da.Password = DataExtensions.GetColumnValue <string>(_read, "Password"); da.Quota = DataExtensions.GetColumnValue <long>(_read, "Quota"); da.Redirect = String.Empty; da.RedirectedEmail = String.Empty; _tmp.Add(da); } } } _conn.Close(); } return(_tmp); }
public override DnsZone GetDnsZone(string domainName) { var _tmp = new DnsZone(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT dns_zone.* FROM dns_zone LEFT JOIN domains ON dns_zone.name = domains.name WHERE domains.name = @NAME", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { _tmp.Name = DataExtensions.GetColumnValue <string>(_read, "name").ToLower(); _tmp.mininum = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "minimum")); _tmp.refresh = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "refresh")); _tmp.retry = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "retry")); _tmp.expire = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "expire")); var serial_number = 0; var serial = DataExtensions.GetColumnValue <string>(_read, "serial"); _tmp.serial = 0; if (int.TryParse(serial, out serial_number)) { _tmp.serial = serial_number; } _tmp.ttl = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "ttl")); _tmp.Email = DataExtensions.GetColumnValue <string>(_read, "email"); } } } _conn.Close(); } _tmp.Records = GetZoneRecords(domainName); return(_tmp); }
public override List <Reseller> GetResellers() { var _tmp = new List <Reseller>(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT AccountNumber, AccountStatus, FirstName, LastName, CompanyName, AccountPassword, PrimaryEmail, SecondaryEmail, Address1, Address2, Town, County, CountryCode, PostCode, Address3, AccountType, HomePhone, WorkPhone, MobilePhone, FaxNumber FROM Account WHERE (AccountType <> 0)", _conn)) { using (SqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var da = new Reseller(); da.Id = 0; da.Username = DataExtensions.GetColumnValue <String>(_read, "AccountNumber"); da.Password = DataHelper.GetPassword(); da.Address1 = DataExtensions.GetColumnValue <String>(_read, "Address1"); da.Address2 = DataExtensions.GetColumnValue <String>(_read, "Address2"); da.City = DataExtensions.GetColumnValue <String>(_read, "Town"); da.Country = DataExtensions.GetColumnValue <String>(_read, "CountryCode"); da.Email = DataExtensions.GetColumnValue <String>(_read, "PrimaryEmail"); da.fax = DataExtensions.GetColumnValue <String>(_read, "FaxNumber"); da.FirstName = DataExtensions.GetColumnValue <String>(_read, "FirstName"); da.LastName = DataExtensions.GetColumnValue <String>(_read, "LastName"); da.Organization = DataExtensions.GetColumnValue <String>(_read, "CompanyName"); da.Phone = DataExtensions.GetColumnValue <String>(_read, "HomePhone"); da.PostalCode = DataExtensions.GetColumnValue <String>(_read, "PostCode"); da.Limits = ResellerLimits(da.Username); _tmp.Add(da); } } } _conn.Close(); } return(_tmp); }
public override List <Reseller> GetResellers() { var tmp = new List <Reseller>(); var securePassword = SecurePasswords(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT C.id, cname, pname, login, A.password, phone, fax, email, address, city, state, pcode, country FROM clients C LEFT JOIN accounts A ON C.account_id = A.id WHERE C.`type`='reseller' OR C.`type`='client'", _conn)) { using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var res = new Reseller(); res.Id = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "id")); res.Address1 = DataExtensions.GetColumnValue <string>(_read, "address"); res.City = DataExtensions.GetColumnValue <string>(_read, "city"); res.Country = DataExtensions.GetColumnValue <string>(_read, "country"); res.fax = DataExtensions.GetColumnValue <string>(_read, "fax"); res.Phone = DataExtensions.GetColumnValue <string>(_read, "phone"); res.PostalCode = DataExtensions.GetColumnValue <string>(_read, "pcode"); res.Province = DataExtensions.GetColumnValue <string>(_read, "country"); res.FirstName = DataExtensions.GetColumnValue <string>(_read, "pname"); res.Password = securePassword ? DataHelper.GetPassword() : DataExtensions.GetColumnValue <string>(_read, "password"); res.Username = DataExtensions.GetColumnValue <string>(_read, "login"); res.Email = DataExtensions.GetColumnValue <string>(_read, "email"); res.Organization = DataExtensions.GetColumnValue <string>(_read, "cname"); res.Limits = ResellerLimits(res.Username); tmp.Add(res); } } } _conn.Close(); } return(tmp); }
public override HostLimit GetDomainLimits(string domainName) { var _tmp = new HostLimit(); using (OdbcConnection _conn = new OdbcConnection(connectionString)) { _conn.Open(); using (OdbcCommand _cmd = new OdbcCommand(@"SELECT Limit_WebSpace, Limit_Traffic, Limit_Stats, Limit_FrontPage, Limit_MailAccounts, Limit_ODBCDSN, Limit_MySQL, Limit_DomainAlias, Limit_SubDomain, Domain_Name FROM Host_Accounts WHERE (Domain_Name = ?)", _conn)) { _cmd.CommandType = CommandType.Text; _cmd.Parameters.AddWithValue("NAME", domainName); using (OdbcDataReader _read = _cmd.ExecuteReader(CommandBehavior.SingleRow)) { if (_read.Read()) { _tmp.DiskSpace = DataExtensions.GetColumnValue <int>(_read, "Limit_WebSpace"); _tmp.MaxDomainAlias = DataExtensions.GetColumnValue <int>(_read, "Limit_DomainAlias"); _tmp.MaxFtpTraffic = -1; _tmp.MaxFtpUser = 1; _tmp.MaxMailBox = DataExtensions.GetColumnValue <int>(_read, "Limit_MailAccounts"); _tmp.MaxMailTraffic = -1; _tmp.MaxMsSqlDb = 0; _tmp.MaxMsSqlDbSpace = 0; _tmp.MaxMsSqlDbUser = 0; _tmp.MaxMySqlDb = DataExtensions.GetColumnValue <int>(_read, "Limit_MySQL"); _tmp.MaxMySqlDbSpace = -1; _tmp.MaxMySqlUser = DataExtensions.GetColumnValue <int>(_read, "Limit_MySQL"); _tmp.MaxSubDomain = DataExtensions.GetColumnValue <int>(_read, "Limit_SubDomain"); _tmp.MaxWebTraffic = -1; _tmp.TotalMailBoxQuota = -1; _tmp.Expiration = DateTime.Now.AddYears(1); } } } _conn.Close(); } return(_tmp); }
private T StatsItem <T>(string sqltxt) { var result = default(T); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(sqltxt, _conn)) { result = DataExtensions.GetColumnValue <T>(_cmd.ExecuteScalar(), sqltxt); } _conn.Close(); } return(result); }
public override List <Reseller> GetResellers() { var tmp = new List <Reseller>(); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT id, cr_date, cname, pname, login, passwd, status, phone, fax, email, address, city, state, pcode, country, locale, limits_id, params_id, perm_id, pool_id, logo_id, tmpl_id, sapp_pool_id, uid, ownership, [guid] FROM clients", _conn)) { using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var res = new Reseller(); res.Id = Convert.ToInt32(DataExtensions.GetColumnValue <int>(_read, "id")); res.Address1 = DataExtensions.GetColumnValue <string>(_read, "address"); res.City = DataExtensions.GetColumnValue <string>(_read, "city"); res.Country = DataExtensions.GetColumnValue <string>(_read, "country"); res.fax = DataExtensions.GetColumnValue <string>(_read, "fax"); res.Phone = DataExtensions.GetColumnValue <string>(_read, "phone"); res.PostalCode = DataExtensions.GetColumnValue <string>(_read, "pcode"); res.Province = DataExtensions.GetColumnValue <string>(_read, "country"); res.FirstName = DataExtensions.GetColumnValue <string>(_read, "pname"); res.Password = DataExtensions.GetColumnValue <string>(_read, "passwd"); res.Username = DataExtensions.GetColumnValue <string>(_read, "login"); res.Email = DataExtensions.GetColumnValue <string>(_read, "email"); res.Organization = DataExtensions.GetColumnValue <string>(_read, "cname"); res.Limits = ResellerLimits(res.Username); tmp.Add(res); } } } _conn.Close(); } return(tmp); }
public override List <Database> GetDatabases(string domainName) { var _tmp = new List <Database>(); using (OdbcConnection _conn = new OdbcConnection(connectionString)) { _conn.Open(); using (OdbcCommand _cmd = new OdbcCommand(@"SELECT DatabaseName, Username, [Password], Host_ID, DomainName FROM MySQL_Details WHERE (DomainName = ?)", _conn)) { _cmd.CommandType = CommandType.Text; _cmd.Parameters.AddWithValue("NAME", domainName); using (OdbcDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Database(); _d.Id = DataExtensions.GetColumnValue <int>(_read, "Host_ID"); _d.Name = DataExtensions.GetColumnValue <String>(_read, "DatabaseName"); _d.Domain = DataExtensions.GetColumnValue <String>(_read, "DomainName"); _d.DbType = "mysql"; //Her DB'ye tek user. var userList = new List <DatabaseUser>(); userList.Add(new DatabaseUser() { Username = DataExtensions.GetColumnValue <String>(_read, "Username"), Password = DataExtensions.GetColumnValue <String>(_read, "Password") }); _d.Users = userList; _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
public override DnsZone GetDnsZone(string domainName) { var _tmp = new DnsZone(); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); using (OleDbCommand _cmd = new OleDbCommand(@"SELECT dns_zone.id, dns_zone.name, dns_zone.displayName, dns_zone.email, dns_zone.status, dns_zone.type, dns_zone.ttl, dns_zone.ttl_unit, dns_zone.refresh, dns_zone.refresh_unit, dns_zone.retry, dns_zone.retry_unit, dns_zone.expire, dns_zone.expire_unit, dns_zone.minimum, dns_zone.minimum_unit, dns_zone.serial_format, dns_zone.serial FROM (dns_zone LEFT OUTER JOIN domains ON dns_zone.name = domains.name) WHERE (domains.name = ?)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { _tmp.Name = DataExtensions.GetColumnValue <string>(_read, "name").ToLower(); _tmp.mininum = DataExtensions.GetColumnValue <int>(_read, "minimum"); _tmp.refresh = DataExtensions.GetColumnValue <int>(_read, "refresh"); _tmp.retry = DataExtensions.GetColumnValue <int>(_read, "retry"); _tmp.expire = DataExtensions.GetColumnValue <int>(_read, "expire"); var serial = DataExtensions.GetColumnValue <string>(_read, "serial"); _tmp.serial = Convert.ToInt32(serial); _tmp.ttl = DataExtensions.GetColumnValue <int>(_read, "ttl"); _tmp.Email = DataExtensions.GetColumnValue <string>(_read, "email"); } } } _conn.Close(); } _tmp.Records = GetZoneRecords(domainName); return(_tmp); }
public override HostLimit ResellerLimits(string clientName) { var _tmp_limits = new List <LimitRow>(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT L.limit_name, L.value FROM clients C LEFT JOIN Limits L ON L.id = C.limits_id WHERE C.login = @NAME", _conn)) { _cmd.Parameters.AddWithValue("@NAME", clientName); using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new LimitRow(); _d.Name = DataExtensions.GetColumnValue <string>(_read, "limit_name"); var limitObj = DataExtensions.GetColumnValue <Byte[]>(_read, "value"); var LimitValue = limitObj != null?Convert.ToInt64(Encoding.ASCII.GetString(limitObj)) : -1; if (_d.Name == "disk_space" || _d.Name == "max_traffic" || _d.Name == "mbox_quota" || _d.Name == "mssql_dbase_space" || _d.Name == "mysql_dbase_space" || _d.Name == "max_traffic_soft" || _d.Name == "disk_space_soft") { _d.Value = (int)((LimitValue / 1024) / 1024); } else { _d.Value = Convert.ToInt32(LimitValue); } _tmp_limits.Add(_d); } } } _conn.Close(); } return(new HostLimit(_tmp_limits)); }
public override List <Subdomain> GetSubdomains(string domainName) { var _tmp = new List <Subdomain>(); var securePassword = SecurePasswords(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT subdomains.name, domains.name AS domain, sys_users.login, accounts.password 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 = @NAME", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Subdomain(); _d.Domain = DataExtensions.GetColumnValue <string>(_read, "domain"); _d.Login = DataExtensions.GetColumnValue <string>(_read, "login"); _d.Password = securePassword ? DataHelper.GetPassword() : DataExtensions.GetColumnValue <string>(_read, "password"); _d.Name = DataExtensions.GetColumnValue <string>(_read, "name"); _d.UserType = ""; _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
public override List <DomainAlias> GetDomainAliases(string domainName) { var _tmp = new List <DomainAlias>(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"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 (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new DomainAlias(); _d.Domain = DataExtensions.GetColumnValue <String>(_read, "domain"); _d.Alias = DataExtensions.GetColumnValue <String>(_read, "alias"); if (_read["status"] is System.UInt64) { _d.Status = Convert.ToInt64(DataExtensions.GetColumnValue <UInt64>(_read, "status")); } else { _d.Status = DataExtensions.GetColumnValue <long>(_read, "status"); } _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }
public override List <Email> GetEmails(string domainName) { var _tmp = new List <Email>(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT POP3Account.POP3UserName, POP3Account.ForwardsTo, HostDomain.DomainName FROM POP3Account INNER JOIN HostDomain ON POP3Account.DomainId = HostDomain.DomainId WHERE (HostDomain.DomainName = @NAME)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (SqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var da = new Email(); da.DomainName = domainName; da.Name = DataExtensions.GetColumnValue <string>(_read, "POP3UserName"); da.Password = DataHelper.GetPassword(); da.Quota = -1; var forwardEmail = DataExtensions.GetColumnValue <string>(_read, "ForwardsTo"); da.Redirect = String.IsNullOrEmpty(forwardEmail) ? "false" : "true"; da.RedirectedEmail = forwardEmail; _tmp.Add(da); } } } _conn.Close(); } return(_tmp); }
public override List <DnsZoneRecord> GetZoneRecords(string domainName) { var _tmp = new List <DnsZoneRecord>(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT HostDomain.DomainName, CASE WHEN DNSRecord.RecordType = 3 THEN 'A' WHEN DNSRecord.RecordType = 5 THEN 'CNAME' WHEN DNSRecord.RecordType = 4 THEN 'MX' WHEN DNSRecord.RecordType = 6 THEN 'CNAME'END AS RecordType, DNSRecord.RecordName, DNSRecord.RecordData, DNSRecord.RecordPreference FROM DNSRecord INNER JOIN HostDomain ON DNSRecord.DomainId = HostDomain.DomainId WHERE (HostDomain.DomainName = @NAME)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (SqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var da = new DnsZoneRecord(); da.name = DataExtensions.GetColumnValue <string>(_read, "RecordName"); da.type = DataExtensions.GetColumnValue <string>(_read, "RecordType"); da.value = DataExtensions.GetColumnValue <string>(_read, "RecordData"); da.priority = DataExtensions.GetColumnValue <int>(_read, "RecordPreference"); _tmp.Add(da); } } } _conn.Close(); } return(_tmp); }
public override List <Reseller> GetResellers() { var tmp = new List <Reseller>(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT * FROM clients", _conn)) { using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var res = new Reseller(); res.Id = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "id")); res.Address1 = DataExtensions.GetColumnValue <string>(_read, "address"); res.City = DataExtensions.GetColumnValue <string>(_read, "city"); res.Country = DataExtensions.GetColumnValue <string>(_read, "country"); res.fax = DataExtensions.GetColumnValue <string>(_read, "fax"); res.Phone = DataExtensions.GetColumnValue <string>(_read, "phone"); res.PostalCode = DataExtensions.GetColumnValue <string>(_read, "pcode"); res.Province = DataExtensions.GetColumnValue <string>(_read, "country"); res.FirstName = DataExtensions.GetColumnValue <string>(_read, "pname"); res.Password = DataExtensions.GetColumnValue <string>(_read, "passwd"); res.Username = DataExtensions.GetColumnValue <string>(_read, "login"); res.Email = DataExtensions.GetColumnValue <string>(_read, "email"); res.Organization = DataExtensions.GetColumnValue <string>(_read, "cname"); res.Limits = ResellerLimits(res.Username); tmp.Add(res); } } } _conn.Close(); } return(tmp); }
public override HostLimit GetDomainLimits(string domainName) { var _tmp_limits = new List <LimitRow>(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT LimitProperty.LimitPropertyName, Limit.LimitValue, Limit.LimitId, Limit.LevelId, Limit.ItemId, HostDomain.DomainName FROM Limit INNER JOIN LimitProperty ON Limit.LimitPropertyId = LimitProperty.LimitPropertyId INNER JOIN Package ON Limit.ItemId = Package.PackageTypeId INNER JOIN HostDomain ON Package.PackageId = HostDomain.PackageId WHERE (HostDomain.DomainName = @NAME)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (SqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new LimitRow(); _d.Name = DataExtensions.GetColumnValue <String>(_read, "LimitPropertyName"); _d.Value = DataExtensions.GetColumnValue <int>(_read, "LimitValue"); _tmp_limits.Add(_d); } } } _conn.Close(); } var hostLimits = new HostLimit(); hostLimits.LoadHelmLimits(_tmp_limits); return(hostLimits); }
public override List <Subdomain> GetSubdomains(string domainName) { var _tmp = new List <Subdomain>(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT HostDomain_1.DomainName AS Name FROM HostDomain INNER JOIN HostDomain AS HostDomain_1 ON HostDomain.DomainId = HostDomain_1.SubDomainId WHERE (HostDomain.DomainName = @NAME)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (SqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var currentFtpUser = GetFirstFtpAccount(domainName); var da = new Subdomain(); da.Domain = domainName; da.Login = String.IsNullOrEmpty(currentFtpUser) ? domainName : currentFtpUser; da.Name = DataExtensions.GetColumnValue <String>(_read, "Name"); da.Password = ""; _tmp.Add(da); } } } _conn.Close(); } return(_tmp); }
public override List <Database> GetDatabases(string domainName) { var _tmp = new List <Database>(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); using (MySqlCommand _cmd = new MySqlCommand(@"SELECT data_bases.id as db_id, domains.name AS domain, data_bases.name, data_bases.type, data_bases.db_server_id FROM data_bases LEFT OUTER JOIN domains ON domains.id = data_bases.dom_id LEFT OUTER JOIN db_users ON db_users.id = data_bases.default_user_id WHERE (domains.name = @NAME)", _conn)) { _cmd.Parameters.AddWithValue("@NAME", domainName); using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Database(); _d.Id = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "db_id")); _d.Name = DataExtensions.GetColumnValue <string>(_read, "name"); _d.Domain = DataExtensions.GetColumnValue <string>(_read, "domain"); _d.DbType = DataExtensions.GetColumnValue <string>(_read, "type"); _d.ServerId = Convert.ToInt32(DataExtensions.GetColumnValue <uint>(_read, "db_server_id")); _d.Users = GetDatabaseUsers(_d.Id); _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }