/// <summary> /// Retrieves the settings from the database /// </summary> /// <returns></returns> public static SettingsObject GetSettings() { DB database = null; try { database = new DB(); var settings = (from s in database.Settings select new SettingsObject { HostingOU = s.BaseOU, PrimaryDC = s.PrimaryDC, Username = s.Username, Password = s.Password, SuperAdmins = s.SuperAdmins, BillingAdmins = s.BillingAdmins, ExchangeServer = s.ExchangeFqdn, ExchangePublicFolderServer = s.ExchangePFServer, ExchangeVersion = s.ExchangeVersion, ExchangeSSLEnabled = s.ExchangeSSLEnabled, ExchangeConnectionType = s.ExchangeConnectionType, CitrixEnabled = s.CitrixEnabled, PublicFoldersEnabled = s.PublicFolderEnabled, LyncEnabled = s.LyncEnabled, ResellersEnabled = s.ResellersEnabled == null ? false : (bool)s.ResellersEnabled, HostersName = s.CompanysName, AllowCustomNameAttribute = s.AllowCustomNameAttrib == null ? false : (bool)s.AllowCustomNameAttrib, IPBlockingEnabled = s.IPBlockingEnabled == null ? false : (bool)s.IPBlockingEnabled, UsersOU = s.UsersOU, LoginLogo = s.BrandingLoginLogo, CornerLogo = s.BrandingCornerLogo, LockDownEnabled = s.LockdownEnabled == null ? false : (bool)s.LockdownEnabled }).FirstOrDefault(); return settings; } catch (Exception ex) { throw; } finally { if (database != null) database.Dispose(); } }
/// <summary> /// Gets information about a particular reseller /// </summary> /// <param name="resellerCode"></param> /// <returns></returns> public static ResellerObject GetReseller(string resellerCode) { DB database = null; try { database = new DB(); var resellers = (from r in database.Companies where r.IsReseller where r.CompanyCode == resellerCode select new ResellerObject { CompanyID = r.CompanyId, CompanyName = r.CompanyName, CompanyCode = r.CompanyCode, Street = r.Street, City = r.City, State = r.State, ZipCode = r.ZipCode, Country = r.Country, Telephone = r.PhoneNumber, AdminName = r.AdminName, AdminEmail = r.AdminEmail, DistinguishedName = r.DistinguishedName, Created = r.Created }).FirstOrDefault(); return resellers; } catch (Exception ex) { // TODO: LOG ERROR throw; } finally { if (database != null) database.Dispose(); } }
/// <summary> /// Gets a list of resellers /// </summary> /// <returns></returns> public static List<ResellerObject> GetResellers() { DB database = null; try { database = new DB(); var resellers = from r in database.Companies where r.IsReseller orderby r.CompanyName select new ResellerObject { CompanyID = r.CompanyId, CompanyName = r.CompanyName, CompanyCode = r.CompanyCode, Street = r.Street, City = r.City, State = r.State, ZipCode = r.ZipCode, Country = r.Country, Telephone = r.PhoneNumber, AdminName = r.AdminName, AdminEmail = r.AdminEmail, DistinguishedName = r.DistinguishedName, Created = r.Created }; return resellers.ToList(); } catch (Exception ex) { // TODO: LOG ERROR throw; } finally { if (database != null) database.Dispose(); } }
/// <summary> /// Finds the total number of companies for a particular reseller /// </summary> /// <param name="resellersCompanyCode"></param> /// <returns></returns> public static int GetResellersCompanyCount(string resellersCompanyCode) { DB database = null; try { database = new DB(); var companyCount = (from c in database.Companies where c.ResellerCode == resellersCompanyCode select c).Count(); return companyCount; } catch (Exception ex) { throw; } finally { if (database != null) database.Dispose(); } }