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