public PartialViewResult BuildTVEContentList(Category category, int ctr = 0)
        {
            List<TVEContentListObj> list = null;
            string jsonString = String.Empty;
            try
            {
                DateTime registDt = DateTime.Now;
                var context = new IPTV2Entities();
                var CountryCode = MyUtility.GetCountryCodeViaIpAddressWithoutProxy();

                var cache = DataCache.Cache;
                string cacheKey = "BTVECL:O:" + category.CategoryId.ToString() + ";C:" + CountryCode;
                try { jsonString = (string)cache[cacheKey]; }
                catch (Exception) { }
                if (String.IsNullOrEmpty(jsonString))
                {
                    if (category != null)
                    {
                        if (category is Category)
                        {
                            var parent = (Category)category;
                            var subCategoryies = parent.SubCategories;
                            if (subCategoryies.Count() > 0)
                            {
                                list = new List<TVEContentListObj>();
                                var service = context.Offerings.Find(GlobalConfig.offeringId).Services.FirstOrDefault(s => s.StatusId == GlobalConfig.Visible);
                                try
                                {
                                    foreach (var subCategory in subCategoryies)
                                    {
                                        try
                                        {
                                            if (subCategory is Category)
                                            {
                                                var obj = new TVEContentListObj()
                                                {
                                                    MainCategory = subCategory.Description,
                                                    MainCategoryId = subCategory.CategoryId,
                                                    shows = new List<ShowD>()
                                                };
                                                var showIds = service.GetAllOnlineShowIds(CountryCode, subCategory);
                                                if (showIds.Count() > 0)
                                                {
                                                    var shows = context.CategoryClasses.Where(c => showIds.Contains(c.CategoryId) && c.StatusId == GlobalConfig.Visible);
                                                    foreach (var item in shows)
                                                    {
                                                        if (item is Show && item.StartDate < registDt && item.EndDate > registDt)
                                                        {
                                                            var show = (Show)item;
                                                            obj.shows.Add(new ShowD() { id = show.CategoryId, name = show.Description });
                                                        }
                                                    }
                                                    if (obj.shows.Count() > 0)
                                                        list.Add(obj);
                                                }
                                            }
                                        }
                                        catch (Exception) { }
                                    }
                                }
                                catch (Exception) { }
                            }
                        }
                    }
                    jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(list);
                    cache.Put(cacheKey, jsonString, DataCache.CacheDuration);
                }
                else
                    list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<TVEContentListObj>>(jsonString);
            }
            catch (Exception e) { MyUtility.LogException(e); }
            ViewBag.Category = category;
            ViewBag.IsActive = ctr == 0 ? true : false;
            return PartialView(list);
        }
Esempio n. 2
0
        public ActionResult SubmitTicket()
        {
            var context = new IPTV2Entities();
            var faq = (Category)context.CategoryClasses.FirstOrDefault(c => c.CategoryId == GlobalConfig.FAQ && c.StatusId == GlobalConfig.Visible);
            var categories = faq.CategoryClassSubCategories.Where(c => c.SubCategory.StatusId == GlobalConfig.Visible).ToList();
            List<CategoryClass> list = new List<CategoryClass>();
            foreach (var item in categories)
            {
                list.Add(item.SubCategory);
            }

            Category other = new Category()
            {
                Description = "Others"
            };
            list.Add((CategoryClass)other);
            ViewBag.CategoryList = list;
            if (MyUtility.isUserLoggedIn())
            {
                User user = context.Users.FirstOrDefault(u => u.UserId == new System.Guid(User.Identity.Name));
                ViewBag.Email = user.EMail;
            }
            return PartialView("_SubmitTicket");
        }
Esempio n. 3
0
 public static IEnumerable<int> GetAllShowsBasedOnCountryCode(IPTV2Entities context, string CountryCode, bool addExclusion = false, Offering offering = null, Service service = null, Category category = null)
 {
     SortedSet<int> list = null;
     try
     {
         if (offering == null)
             offering = context.Offerings.Find(GlobalConfig.offeringId);
         if (service == null)
             service = offering.Services.FirstOrDefault(s => s.PackageId == GlobalConfig.serviceId);
         if (category != null)
             list = service.GetAllOnlineShowIds(CountryCode, category);
         else
             list = service.GetAllOnlineShowIds(CountryCode);
         if (addExclusion)
         {
             if (list != null)
             {
                 var excludedCategoryIds = MyUtility.StringToIntList(GlobalConfig.ExcludedCategoryIdsForDisplay);
                 var result = list.Except(excludedCategoryIds);
                 return result;
             }
         }
         if (list != null)
             return list.ToList();
     }
     catch (Exception) { }
     return null;
 }