/// <summary> /// Returns all available resource sets /// </summary> /// <returns></returns> public DataTable GetAllResourceSets(ResourceListingTypes Type) { wwSqlDataAccess Data = new wwSqlDataAccess(wwDbResourceConfiguration.Current.ConnectionString); DataTable dt = null; if (Type == ResourceListingTypes.AllResources) { dt = Data.ExecuteTable("TResourcesets", "select lower(ResourceSet) as ResourceSet from " + wwDbResourceConfiguration.Current.ResourceTableName + " group by ResourceSet"); } else if (Type == ResourceListingTypes.LocalResourcesOnly) { dt = Data.ExecuteTable("TResourcesets", "select lower(ResourceSet) as ResourceSet from " + wwDbResourceConfiguration.Current.ResourceTableName + " where resourceset like @ResourceSet group by ResourceSet", new SqlParameter("@ResourceSet", "%.%")); } else if (Type == ResourceListingTypes.GlobalResourcesOnly) { dt = Data.ExecuteTable("TResourcesets", "select lower(ResourceSet) as ResourceSet from " + wwDbResourceConfiguration.Current.ResourceTableName + " where resourceset not like @ResourceSet group by ResourceSet", new SqlParameter("@ResourceSet", "%.%")); } if (dt == null) { this.ErrorMessage = Data.ErrorMessage; } return(dt); }
/// <summary> /// Returns all available resource sets /// </summary> /// <returns></returns> public static IEnumerable <string> GetAllResourceSets(ResourceListingTypes Type) { IEnumerable <string> result = null; switch (Type) { case ResourceListingTypes.AllResources: result = from r in ctx.Localization orderby r.ResourceSet select r.ResourceSet.ToLower(); break; case ResourceListingTypes.LocalResourcesOnly: result = from r in ctx.Localization where r.ResourceSet.Contains(".") group r by r.ResourceSet into resourceSet select resourceSet.Key.ToLower(); break; case ResourceListingTypes.GlobalResourcesOnly: result = from r in ctx.Localization where !r.ResourceSet.Contains(".") group r by r.ResourceSet into resourceSet select resourceSet.Key.ToLower(); break; } if (!result.Any()) { ErrorMessage = "Error"; } return(result); }
/// <summary> /// Returns all available resource sets /// </summary> /// <returns></returns> public virtual List<string> GetAllResourceSets(ResourceListingTypes type) { using (var data = GetDb()) { DbDataReader dt = null; if (type == ResourceListingTypes.AllResources) dt = data.ExecuteReader("select ResourceSet as ResourceSet from " + Configuration.ResourceTableName + " group by ResourceSet"); else if (type == ResourceListingTypes.LocalResourcesOnly) dt = data.ExecuteReader( "select ResourceSet as ResourceSet from " + Configuration.ResourceTableName + " where resourceset like '%.aspx' or resourceset like '%.ascx' or resourceset like '%.master' or resourceset like '%.sitemap' group by ResourceSet", data.CreateParameter("@ResourceSet", "%.%")); else if (type == ResourceListingTypes.GlobalResourcesOnly) dt = data.ExecuteReader("select ResourceSet as ResourceSet from " + Configuration.ResourceTableName + " where resourceset not like '%.aspx' and resourceset not like '%.ascx' and resourceset not like '%.master' and resourceset not like '%.sitemap' group by ResourceSet"); if (dt == null) { ErrorMessage = data.ErrorMessage; return null; } var items = new List<string>(); while (dt.Read()) { string id = dt["ResourceSet"] as string; if (!string.IsNullOrEmpty(id)) items.Add(id); } return items; } }
/// <summary> /// Returns all available resource sets /// </summary> /// <returns></returns> public DataTable GetAllResourceSets(ResourceListingTypes Type) { SqlDataAccess Data = new SqlDataAccess(DbResourceConfiguration.Current.ConnectionString); DataTable dt = null; if (Type == ResourceListingTypes.AllResources) dt = Data.ExecuteTable("TResourcesets", "select ResourceSet as ResourceSet from " + DbResourceConfiguration.Current.ResourceTableName + " group by ResourceSet"); else if (Type == ResourceListingTypes.LocalResourcesOnly) dt = Data.ExecuteTable("TResourcesets", "select ResourceSet as ResourceSet from " + DbResourceConfiguration.Current.ResourceTableName + " where resourceset like @ResourceSet group by ResourceSet", Data.CreateParameter("@ResourceSet", "%.%")); else if (Type == ResourceListingTypes.GlobalResourcesOnly) dt = Data.ExecuteTable("TResourcesets", "select ResourceSet as ResourceSet from " + DbResourceConfiguration.Current.ResourceTableName + " where resourceset not like @ResourceSet group by ResourceSet", Data.CreateParameter("@ResourceSet", "%.%")); if (dt == null) ErrorMessage = Data.ErrorMessage; return dt; }