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);
}
