public IActionResult WaitedList()
        {
            DiziListViewModel diziLVM = new DiziListViewModel()
            {
                Diziler = new List <Dizi>()
            };

            diziLVM.Diziler = _db.Diziler.Where(m => m.Approved == false).ToList();
            return(View(diziLVM));
        }
        public IActionResult Index(string category, int page = 1)
        {
            DiziListViewModel diziLVM = new DiziListViewModel()
            {
                Diziler = new List <Dizi>()
            };
            var count = 0;

            if (category == "puan")
            {
                diziLVM.Diziler = _db.Diziler
                                  .Where(a => a.Approved == true)
                                  .OrderByDescending(m => m.IMDBScore)
                                  .Skip((page - 1) * PageSize)
                                  .Take(PageSize).ToList();

                count = _db.Diziler
                        .Where(m => m.Approved == true).Count();
            }
            else
            {
                diziLVM.Diziler = _db.Diziler
                                  .Where(a => a.Approved == true)
                                  .Where(m => category == null || m.Genre.Contains(category) == true || m.Name.Contains(category) == true || m.Year.Year.ToString().Contains(category) == true)
                                  .OrderByDescending(m => m.Id)
                                  .Skip((page - 1) * PageSize)
                                  .Take(PageSize).ToList();

                count = _db.Diziler
                        .Where(m => m.Approved == true)
                        .Where(m => category == null || m.Genre.Contains(category) == true || m.Name.Contains(category) == true || m.Year.Year.ToString().Contains(category) == true).Count();
            }


            diziLVM.PagingInfo = new PagingInfo
            {
                CurrentPage  = page,
                ItemsPerPage = PageSize,
                TotalItems   = count
            };

            if (category == null)
            {
                ViewBag.CategoryIs = "";
            }
            else
            {
                ViewBag.CategoryIs = category;
            }

            return(View(diziLVM));
        }
        public IActionResult AdminIndex(int page = 1)
        {
            DiziListViewModel diziLVM = new DiziListViewModel()
            {
                Diziler = new List <Dizi>()
            };

            diziLVM.Diziler = _db.Diziler.
                              OrderByDescending(m => m.Id)
                              .Skip((page - 1) * 7)
                              .Take(7).ToList();

            var count = _db.Diziler.Count();

            diziLVM.PagingInfo = new PagingInfo
            {
                CurrentPage  = page,
                ItemsPerPage = 7,
                TotalItems   = count
            };

            return(View(diziLVM));
        }