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); }
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 <Reseller> GetResellers() { var _tmp = new List <Reseller>(); using (OdbcConnection _conn = new OdbcConnection(connectionString)) { _conn.Open(); using (OdbcCommand _cmd = new OdbcCommand(@"SELECT Username AS uname, [Password] AS pass, Name_Sirname, Company_Name, Contact_Name, EMail, Phone, Fax, WUrl, Msn, ICQ, Address, City, State, PostCode, Country, Account_Disable, Limit_Host, Limit_WebSpace, Limit_Traffic, Limit_Stats, Limit_FrontPage, Limit_MailAccounts, Limit_ODBCDSN, Limit_MySQL, Limit_DomainAlias, HostAccountsDisable, Limit_SubDomain FROM Reseller_Accounts", _conn)) { using (OdbcDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { var _d = new Reseller(); _d.Address1 = DataExtensions.GetColumnValue <String>(_read, "Address"); _d.City = DataExtensions.GetColumnValue <String>(_read, "City"); _d.Country = DataExtensions.GetColumnValue <String>(_read, "Country"); _d.Email = DataExtensions.GetColumnValue <String>(_read, "EMail"); _d.fax = DataExtensions.GetColumnValue <String>(_read, "Fax"); _d.FirstName = DataExtensions.GetColumnValue <String>(_read, "Name_Sirname"); _d.Organization = DataExtensions.GetColumnValue <String>(_read, "Company_Name"); _d.Phone = DataExtensions.GetColumnValue <String>(_read, "Phone"); _d.PostalCode = DataExtensions.GetColumnValue <String>(_read, "PostCode"); _d.Province = DataExtensions.GetColumnValue <String>(_read, "State"); _d.Password = DataExtensions.GetColumnValue <String>(_read, "pass"); _d.Username = DataExtensions.GetColumnValue <String>(_read, "uname"); var limits = new HostLimit(); limits.DiskSpace = DataExtensions.GetColumnValue <int>(_read, "Limit_WebSpace"); limits.MaxDomain = DataExtensions.GetColumnValue <int>(_read, "Limit_Host"); limits.MaxDomainAlias = DataExtensions.GetColumnValue <int>(_read, "Limit_DomainAlias"); limits.MaxFtpTraffic = -1; limits.MaxFtpUser = 1; limits.MaxMailBox = DataExtensions.GetColumnValue <int>(_read, "Limit_MailAccounts"); limits.MaxMailTraffic = -1; limits.MaxMsSqlDb = 0; limits.MaxMsSqlDbSpace = 0; limits.MaxMsSqlDbUser = 0; limits.MaxMySqlDb = DataExtensions.GetColumnValue <int>(_read, "Limit_MySQL"); limits.MaxMySqlDbSpace = -1; limits.MaxMySqlUser = DataExtensions.GetColumnValue <int>(_read, "Limit_MySQL"); limits.MaxSubDomain = DataExtensions.GetColumnValue <int>(_read, "Limit_SubDomain"); limits.MaxWebTraffic = -1; limits.TotalMailBoxQuota = -1; _d.Limits = limits; _tmp.Add(_d); } } } _conn.Close(); } return(_tmp); }