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