//GetEventCategoryDetailById public EventCategoryDetail GetEventCategoryDetail(long eventcategory_id) { DataCacheObject dco = new DataCacheObject(DataCacheType.REFERENCE, DataCacheRegions.CATEGORIES, "GETEVENTCATEGORYDETAIL", new object[] { eventcategory_id }, CachingExpirationTime.Hours_01); EventCategoryDetail ecd = CacheRepository.Get(dco) as EventCategoryDetail; if (ecd != null) { return(ecd); } ecd = (from p in dataContext.spCategory_View_EventCategoriesDetail(eventcategory_id) select new EventCategoryDetail { DateEnd = p.DateEnd, IsCurrent = p.IsCurrent, IsClickable = p.IsClickable, Step = p.CloseStep, LinkParams = new LinkParams { EventCategory_ID = p.EventCategory_ID, Event_ID = p.Event_ID, MainCategory_ID = p.MainCategory_ID, Category_ID = p.Category_ID, EventTitle = p.EventTitle, MainCategoryTitle = p.MainCategoryTitle, CategoryTitle = p.CategoryTitle }, }).SingleOrDefault(); if (ecd != null) { dco.Data = ecd; CacheRepository.Add(dco); } return(ecd); }