public override HostLimit ResellerLimits(string clientName)
{
var _tmp_limits = new List <LimitRow>();
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT LoginLimit.Value, LoginLimit.LoginId, LoginLimit.LimitName,
LoginLimit.isUnlimited, LoginLimit.Usage,
LoginLimit.LoginLimitId, LoginAccount.UserName
FROM LoginLimit INNER JOIN LoginAccount ON LoginLimit.LoginId = LoginAccount.LoginId
WHERE (LoginAccount.UserName = @NAME)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", clientName);
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var da = new LimitRow();
da.Name = DataExtensions.GetColumnValue <String>(_read, "LimitName");
da.Value = Convert.ToInt32(DataExtensions.GetColumnValue <Int64>(_read, "Value"));
_tmp_limits.Add(da);
}
}
}
_conn.Close();
}
return(new HostLimit(_tmp_limits, true));
}
public override HostLimit GetDomainLimits(string domainName)
{
var _tmp_limits = new List <LimitRow>();
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT DomainLimit.LimitName, DomainLimit.LimitValue,
DomainLimit.Usage, DomainLimit.isUnlimited, Domain.Name
FROM DomainLimit INNER JOIN Domain ON DomainLimit.DomainId = Domain.DomainId
WHERE (Domain.Name = @NAME)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new LimitRow();
_d.Name = DataExtensions.GetColumnValue <string>(_read, "LimitName");
_d.Value = Convert.ToInt32(DataExtensions.GetColumnValue <Int64>(_read, "LimitValue"));
_tmp_limits.Add(_d);
}
}
}
_conn.Close();
}
return(new HostLimit(_tmp_limits, true));
}
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");
//_d.Value = Convert.ToInt32(DataExtensions.GetColumnValue<Int64>(_read, "value"));
long LimitValue = -1;
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 == "total_mboxes_quota")
{
_d.Value = (int)((LimitValue / 1024) / 1024);
}
else
{
if (LimitValue > int.MaxValue)
{
_d.Value = -1;
}
else
{
_d.Value = Convert.ToInt32(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 (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 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 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 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);
}
