//GetAllowedCategoriesForTheEvent public List <EventCategoryDetail> GetAllowedCategoriesForTheEvent(long event_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.EVENTS, "GETALLOWEDCATEGORIESFORTHEEVENT", new object[] { event_id }, CachingExpirationTime.Days_01); List <EventCategoryDetail> result = CacheRepository.Get(dco) as List <EventCategoryDetail>; if (result != null && result.Any()) { return(result); } result = (from p in dataContext.spEventCategory_ListForEvent(event_id) select new EventCategoryDetail { EventCategory_ID = p.EventCategory_ID, Category_ID = p.Category_ID, CategoryDescription = p.CategoryDescription, CategoryTitle = p.CategoryTitle, CategoryMap_ID = p.CategoryMap_ID, IsActive = p.IsActive, Event_ID = p.Event_ID, IsTaxable = p.IsTaxable }).ToList(); if (result.Any()) { dco.Data = result; CacheRepository.Add(dco); } return(result); }