private string GetFirstFtpAccount(string domainName)
{
var ftpUserName = String.Empty;
using (SqlConnection _conn = new SqlConnection(connectionString))
{
_conn.Open();
using (SqlCommand _cmd = new SqlCommand(@"SELECT TOP 1 FTPAccount.FTPUserName
FROM FTPAccount INNER JOIN
HostDomain ON FTPAccount.DomainId = HostDomain.DomainId
WHERE (HostDomain.DomainName = @NAME)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (SqlDataReader _read = _cmd.ExecuteReader())
{
if (_read.Read())
{
ftpUserName = DataExtensions.GetColumnValue <String>(_read, "FTPUserName");
}
}
}
_conn.Close();
}
return(ftpUserName);
}
private string GetFirstFtpAccount(int domainId)
{
var ftpUserName = String.Empty;
using (SqlConnection _conn = new SqlConnection(connectionString))
{
_conn.Open();
using (SqlCommand _cmd = new SqlCommand(@"SELECT TOP 1 FTPPassword, FTPUserName FROM FTPAccount WHERE DomainId = @ID", _conn))
{
_cmd.Parameters.AddWithValue("@ID", domainId);
using (SqlDataReader _read = _cmd.ExecuteReader())
{
if (_read.Read())
{
ftpUserName = DataExtensions.GetColumnValue <String>(_read, "FTPUserName");
}
}
}
_conn.Close();
}
return(ftpUserName);
}
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));
}
private void ShoppingCartGrid_RentalsItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
{
var cartDetail = (CartDetail)e.Item.DataItem;
RadDatePicker startDatePicker = (RadDatePicker)e.Item.FindControl("startDatePicker");
RadDatePicker endDatePicker = (RadDatePicker)e.Item.FindControl("endDatePicker");
//Hide the date pickers if it's not a notebook
ProductType notebook = CatalogManager.GetProductTypes().Where(pt => pt.Title == "Notebook").SingleOrDefault();
Product product = CatalogManager.GetProduct(cartDetail.ProductId);
if (product.ClrType != notebook.ClrType)
{
startDatePicker.Visible = false;
endDatePicker.Visible = false;
}
else
{
DateTime startDate;
DateTime endDate;
if (DateTime.TryParse(DataExtensions.GetValue <string>(cartDetail, "startDate"), out startDate))
{
startDatePicker.SelectedDate = startDate;
}
if (DateTime.TryParse(DataExtensions.GetValue <string>(cartDetail, "endDate"), out endDate))
{
endDatePicker.SelectedDate = startDate;
}
}
}
}
public override List <Subdomain> GetSubdomains(string domainName)
{
var _tmp = new List <Subdomain>();
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT SubDomain.Name, SubDomain.Username, Domain.Name AS DomainName
FROM Domain INNER JOIN SubDomain ON Domain.DomainId = SubDomain.DomainId
WHERE (Domain.Name = @NAME)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var da = new Subdomain();
da.Domain = domainName;
da.Login = DataExtensions.GetColumnValue <String>(_read, "Username");
da.Name = DataExtensions.GetColumnValue <String>(_read, "Name");
da.Password = "";
_tmp.Add(da);
}
}
}
_conn.Close();
}
return(_tmp);
}
public override List <DomainAlias> GetDomainAliases(string domainName)
{
var _tmp = new List <DomainAlias>();
using (OdbcConnection _conn = new OdbcConnection(connectionString))
{
_conn.Open();
using (OdbcCommand _cmd = new OdbcCommand(@"SELECT Host_Accounts.Domain_Name, Alias_Details.Alias_Domainname
FROM (Host_Accounts INNER JOIN
Alias_Details ON Host_Accounts.Host_ID = Alias_Details.Host_ID)
WHERE (Host_Accounts.Domain_Name = ?)", _conn))
{
_cmd.CommandType = CommandType.Text;
_cmd.Parameters.AddWithValue("NAME", domainName);
using (OdbcDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DomainAlias();
_d.Domain = DataExtensions.GetColumnValue <String>(_read, "Domain_Name");
_d.Alias = DataExtensions.GetColumnValue <String>(_read, "Alias_Domainname");
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
public List <DatabaseUser> GetDatabaseUsersMySQL(int database_id)
{
var _tmp = new List <DatabaseUser>();
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT DomainMySQLUser.Username, DomainMySQLUser.Password, DomainMySQL.Id
FROM DomainMySQL
INNER JOIN DomainMySQLUser ON DomainMySQL.Id = DomainMySQLUser.DatabaseId
WHERE (DomainMySQL.Id = @ID)", _conn))
{
_cmd.Parameters.AddWithValue("@ID", database_id);
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var da = new DatabaseUser();
da.Password = DataExtensions.GetColumnValue <String>(_read, "Password");
da.Username = DataExtensions.GetColumnValue <String>(_read, "Username");
_tmp.Add(da);
}
}
}
_conn.Close();
}
return(_tmp);
}
public override List <Database> GetDatabases(string domainName)
{
var _tmp = new List <Database>();
using (SqlConnection _conn = new SqlConnection(connectionString))
{
_conn.Open();
using (SqlCommand _cmd = new SqlCommand(@"SELECT UserDatabase.DBName, UserDatabase.DataBaseId
FROM UserDatabase INNER JOIN HostDomain ON UserDatabase.DomainId = HostDomain.DomainId
WHERE (UserDatabase.DBType = 22) AND (HostDomain.DomainName = @NAME)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (SqlDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var da = new Database();
da.Id = DataExtensions.GetColumnValue <int>(_read, "DataBaseId");
da.Name = DataExtensions.GetColumnValue <String>(_read, "DBName");
da.Domain = domainName;
da.DbType = "mssql";
da.Users = GetDatabaseUsers(da.Id);
_tmp.Add(da);
}
}
}
}
return(_tmp);
}
public override Forwarding GetForwarding(string domainName)
{
var frw = new Forwarding();
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT DomainRedirection.Id, DomainRedirection.DomainId, DomainRedirection.Destination, DomainRedirection.Enabled,
DomainRedirection.childOnly, DomainRedirection.exactDestination,
DomainRedirection.httpResponseStatus
FROM DomainRedirection INNER JOIN
Domain ON DomainRedirection.DomainId = Domain.DomainId
WHERE (Domain.Name = @NAME)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (SQLiteDataReader _read = _cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow))
{
_read.Read();
frw.Name = domainName;
frw.ForwardUrl = DataExtensions.GetColumnValue <String>(_read, "Destination");
}
}
_conn.Close();
}
return(frw);
}
private void AddToCartRentalButton_Command(object sender, CommandEventArgs e)
{
var cartDetails = OrdersManager.GetCartDetails().Where(cd => cd.ProductId == ProductId);
Tuple <DateTime, DateTime> selectedRentalDates = GetRentalDateTimes();
foreach (CartDetail cartDetail in cartDetails)
{
DataExtensions.SetValue((IDynamicFieldsContainer)cartDetail, "startDate", selectedRentalDates.Item1);
DataExtensions.SetValue((IDynamicFieldsContainer)cartDetail, "endDate", selectedRentalDates.Item2);
TimeSpan?timeSpan = (selectedRentalDates.Item2 - selectedRentalDates.Item1);
var days = timeSpan.Value.Days;
if (days < 7)
{
//cartDetail.Variations.
}
if (days > 0)
{
cartDetail.Quantity = days;
}
}
OrdersManager.SaveChanges();
}
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 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");
//_d.Status = DataExtensions.GetColumnValue<long>(_read, "status");
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
public override List <DatabaseUser> GetDatabaseUsers(int database_id)
{
var _tmp = new List <DatabaseUser>();
var securePassword = SecurePasswords();
using (MySqlConnection _conn = new MySqlConnection(connectionString))
{
_conn.Open();
using (MySqlCommand _cmd = new MySqlCommand(@"SELECT db_users.login, accounts.password FROM db_users LEFT JOIN accounts ON db_users.account_id = accounts.id WHERE db_users.db_id = @ID", _conn))
{
_cmd.Parameters.AddWithValue("@ID", database_id);
using (MySqlDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DatabaseUser();
_d.Username = DataExtensions.GetColumnValue <string>(_read, "login");
_d.Password = securePassword ? DataHelper.GetPassword() : DataExtensions.GetColumnValue <string>(_read, "password");
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
public override Forwarding GetForwarding(string domainName)
{
var _tmp = new Forwarding();
using (OleDbConnection _conn = new OleDbConnection(connectionString))
{
_conn.Open();
using (OleDbCommand _cmd = new OleDbCommand(@"SELECT D.name, F.redirect
FROM (domains D INNER JOIN
forwarding F ON F.dom_id = D.id)
WHERE (D.name = ?)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (OleDbDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
_tmp.Name = DataExtensions.GetColumnValue <string>(_read, "name");
_tmp.ForwardUrl = DataExtensions.GetColumnValue <string>(_read, "redirect");
}
}
}
_conn.Close();
}
return(_tmp);
}
public override List <DatabaseUser> GetDatabaseUsers(int database_id)
{
var _tmp = new List <DatabaseUser>();
using (SqlConnection _conn = new SqlConnection(connectionString))
{
_conn.Open();
using (SqlCommand _cmd = new SqlCommand(@"SELECT Password, Username FROM DomainMsSQLUser WHERE (DatabaseId = @ID)", _conn))
{
_cmd.Parameters.AddWithValue("@ID", database_id);
using (SqlDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var da = new DatabaseUser();
da.Password = DataExtensions.GetColumnValue <String>(_read, "Password");
da.Username = DataExtensions.GetColumnValue <String>(_read, "Username");
_tmp.Add(da);
}
}
}
_conn.Close();
}
return(_tmp);
}
public override List <DomainAlias> GetDomainAliases(string domainName)
{
var _tmp = new List <DomainAlias>();
using (OleDbConnection _conn = new OleDbConnection(connectionString))
{
_conn.Open();
using (OleDbCommand _cmd = new OleDbCommand(@"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 (domains.name = ?) AND (domain_aliases.status = 0)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (OleDbDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DomainAlias();
_d.Domain = DataExtensions.GetColumnValue <String>(_read, "domain");
_d.Alias = DataExtensions.GetColumnValue <String>(_read, "alias");
_d.Status = Convert.ToInt64(DataExtensions.GetColumnValue <decimal>(_read, "status"));
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
public override List <DatabaseUser> GetDatabaseUsers(int database_id)
{
var _tmp = new List <DatabaseUser>();
using (OleDbConnection _conn = new OleDbConnection(connectionString))
{
_conn.Open();
using (OleDbCommand _cmd = new OleDbCommand(@"SELECT login, passwd FROM db_users WHERE (db_id = ?) AND (status = 'normal')", _conn))
{
_cmd.Parameters.AddWithValue("@ID", database_id);
using (OleDbDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new DatabaseUser();
_d.Username = DataExtensions.GetColumnValue <string>(_read, "login");
_d.Password = DataExtensions.GetColumnValue <string>(_read, "passwd");
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
public override List <Subdomain> GetSubdomains(string domainName)
{
var _tmp = new List <Subdomain>();
using (OdbcConnection _conn = new OdbcConnection(connectionString))
{
_conn.Open();
using (OdbcCommand _cmd = new OdbcCommand(@"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 (OdbcDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new Subdomain();
_d.Domain = DataExtensions.GetColumnValue <String>(_read, "Domain_Name");
_d.Login = DataExtensions.GetColumnValue <String>(_read, "Domain_Name");
_d.Name = DataExtensions.GetColumnValue <String>(_read, "Sub_Domain");
_d.UserType = "";
_d.Password = "";
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
private FtpAccount GetFirstFtpAccount(int domainId)
{
var account = new FtpAccount();
account.Username = String.Empty;
account.Password = String.Empty;
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT DomainMsFTPUser.Username, DomainMsFTPUser.Password, DomainMsFTP.DomainId
FROM DomainMsFTP INNER JOIN DomainMsFTPUser ON DomainMsFTP.Id = DomainMsFTPUser.FtpId
WHERE (DomainMsFTP.DomainId = @ID)", _conn))
{
_cmd.Parameters.AddWithValue("@ID", domainId);
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
if (_read.Read())
{
account.Username = DataExtensions.GetColumnValue <String>(_read, "Username");
account.Password = DataExtensions.GetColumnValue <String>(_read, "Password");
}
}
}
_conn.Close();
}
return(account);
}
public override List <DomainAlias> GetDomainAliases(string domainName)
{
var _tmp = new List <DomainAlias>();
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT DomainAlias.Hostname FROM Domain
INNER JOIN DomainAlias ON Domain.DomainId = DomainAlias.DomainId WHERE (Domain.Name = @NAME)", _conn))
{
_cmd.Parameters.AddWithValue("@NAME", domainName);
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var da = new DomainAlias();
da.Alias = DataExtensions.GetColumnValue <String>(_read, "Hostname");
da.Domain = domainName;
da.Status = 1;
_tmp.Add(da);
}
}
}
_conn.Close();
}
return(_tmp);
}
static void TestRadian()
{
CW(DataExtensions.LatLonToRadian(-180).ToString());
CW(DataExtensions.LatLonToRadian(-170).ToString());
CW(DataExtensions.LatLonToRadian(10).ToString());
CW(DataExtensions.LatLonToRadian(180).ToString());
CW(DataExtensions.LatLonToRadian(0).ToString());
}
static void TestDegree()
{
CW(DataExtensions.LatLonToDegree(-180).ToString());
CW(DataExtensions.LatLonToDegree(-170).ToString());
CW(DataExtensions.LatLonToDegree(10).ToString());
CW(DataExtensions.LatLonToDegree(180).ToString());
CW(DataExtensions.LatLonToDegree(0).ToString());
}
protected void ChangeCustomField_Click(object sender, EventArgs e)
{
NewslettersManager manager = NewslettersManager.GetManager();
Subscriber subscriber = manager.GetSubscriber(new Guid(SubscriberList.SelectedValue));
DataExtensions.SetValue((IDynamicFieldsContainer)subscriber, "Company", ComboBoxValueField.Text);
SubscriberField.Text = String.Format("User {0} now works for Company {1}", SubscriberList.SelectedItem.Text, DataExtensions.GetValue <String>(subscriber, "Company"));
}
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();
var pri = 0;
var options = DataExtensions.GetColumnValue <string>(_read, "opt");
if (int.TryParse(options, out pri))
{
_d.priority = pri;
}
else
{
_d.priority = 0;
}
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
public override List <Domain> GetDomains()
{
var _tmp = new List <Domain>();
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
_conn.Open();
using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT Domain.DomainId, Domain.Name, Domain.CreationDate, Domain.Status, Domain.OwnerLoginId, Domain.UserLoginId,
Domain.ExpirationDate, LoginAccount_1.UserName, LoginAccount_1.Password,
LoginAccount.UserName AS Owner FROM Domain LEFT OUTER JOIN
LoginAccount ON Domain.OwnerLoginId = LoginAccount.LoginId LEFT OUTER JOIN
LoginAccount AS LoginAccount_1 ON Domain.UserLoginId = LoginAccount_1.LoginId", _conn))
{
using (SQLiteDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new Domain();
_d.Id = Convert.ToInt32(DataExtensions.GetColumnValue <Int64>(_read, "DomainId"));
_d.Name = DataExtensions.GetColumnValue <String>(_read, "Name").ToLower();
_d.ClientName = DataExtensions.GetColumnValue <String>(_read, "Owner");
_d.DomainPassword = DataExtensions.GetColumnValue <String>(_read, "Password");
var ftpAccount = GetFirstFtpAccount(_d.Id);
_d.Username = ftpAccount.Username;
_d.Password = ftpAccount.Password;
_d.Status = DataExtensions.GetColumnValue <short>(_read, "Status");
_d.Expiration = DataExtensions.GetColumnValue <DateTime>(_read, "ExpirationDate");
_d.isForwarding = isForwarding(_d.Id);
if (_d.isForwarding)
{
var frw = GetForwarding(_d.Name);
_d.ForwardUrl = frw.ForwardUrl;
}
_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 DnsZone GetDnsZone(string domainName)
{
var _tmp = new DnsZone();
_tmp.Name = domainName;
using (SqlConnection _conn = new SqlConnection(connectionString))
{
_conn.Open();
using (SqlCommand _cmd = new SqlCommand(@"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 (SqlDataReader _read = _cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow))
{
if (_read.Read())
{
_tmp.Name = DataExtensions.GetColumnValue <string>(_read, "Name").ToLower();
_tmp.mininum = -1;
_tmp.refresh = DataExtensions.GetColumnValue <int>(_read, "RefreshInterval");
_tmp.retry = DataExtensions.GetColumnValue <int>(_read, "RetryInterval");
_tmp.expire = DataExtensions.GetColumnValue <int>(_read, "Expires");
var serial = DataExtensions.GetColumnValue <string>(_read, "SerialNumber");
if (!String.IsNullOrEmpty(serial))
{
int intSerial = 0;
if (int.TryParse(serial, out intSerial))
{
_tmp.serial = intSerial;
}
}
_tmp.ttl = DataExtensions.GetColumnValue <int>(_read, "TTL");
_tmp.Email = DataExtensions.GetColumnValue <string>(_read, "ResponsiblePerson");
}
}
}
_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");
//_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 static List <T> ToList <T>(this DataTable dt) where T : new()
{
List <T> list = new List <T>();
foreach (DataRow dr in (InternalDataCollectionBase)dt.Rows)
{
list.Add(DataExtensions.ToEntity <T>(dr));
}
return(list);
}
public IActionResult Profile()
{
SetSessionInfo();
int userId = int.Parse(ViewBag.id);
DataTable user = _serviceFactory.User.GetProfile(userId);
var model = DataExtensions.GetItem <ProfileViewModel>(user.Rows[0]);
return(View(model));
}
public void DataExtensions_CreatePassword_Passwords_Match()
{
string password1 = "password1";
string password2 = "password1";
DataExtensions.CreatePasswordHash(password1, out byte[] hash, out byte[] salt);
bool result = DataExtensions.IsPasswordCorrect(password2, hash, salt);
Assert.IsTrue(result);
}
