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