public static IEnumerable<fn_Producer_GetLabelFilterResult> GetLabelsForFilterDropDown(DataAccessDataContext context)
{
IEnumerable<fn_Producer_GetLabelFilterResult> labels;
string sCacheItemKey = "LabelsForFilterDropDown";
if (HttpContext.Current.Cache[sCacheItemKey] == null)
{
labels = context.fn_Producer_GetLabelFilter().OrderBy(row => row.SortID).ThenBy(row => row.Text);
HttpContext.Current.Cache.Add(sCacheItemKey, labels, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(20), CacheItemPriority.Normal, null);
}
else
{
labels = (IEnumerable<fn_Producer_GetLabelFilterResult>)HttpContext.Current.Cache[sCacheItemKey];
}
return labels;
}
