public PartialViewResult _Watched()
        {
            AgfMembershipProvider membership  = new AgfMembershipProvider();
            MovieAccess           movieAccess = new MovieAccess();
            bool check;

            if (check = System.Web.HttpContext.Current.User.Identity.IsAuthenticated)
            {
                var  user   = User.Identity.Name.ToString();
                Guid?userId = membership.GetUserIdByEmail(user);
                var  res    = movieAccess.GetUserWatchedMovies(userId).OrderByDescending(s => s.DateAdded);
                ViewBag.ListTitle = "Watched";
                var Tcount = res.Count();
                ViewBag.Wcount = Tcount;
                return(PartialView("_UserListContainer", res));
            }

            else
            {
                var res = movieAccess.GetHomeList().OrderByDescending(s => s.DateAdded);
                return(PartialView("_UserListContainer", res));
            }
        }
        // GET: Users/UserProfile
        public ActionResult UserProfile()
        {
            AgfMembershipProvider membership  = new AgfMembershipProvider();
            MovieAccess           movieAccess = new MovieAccess();
            bool check;

            if (check = System.Web.HttpContext.Current.User.Identity.IsAuthenticated)
            {
                var  user       = User.Identity.Name.ToString();
                Guid?userId     = membership.GetUserIdByEmail(user);
                var  res        = movieAccess.GetUserToWatchMovies(userId).OrderByDescending(s => s.DateAdded);
                var  resWatched = movieAccess.GetUserWatchedMovies(userId).OrderByDescending(s => s.DateAdded);
                var  resFav     = movieAccess.GetUserFavMovies(userId).OrderByDescending(s => s.DateAdded);


                var Tcount = res.Count();
                var Wcount = resWatched.Count();
                var Fcount = resFav.Count();


                ViewBag.count  = Tcount;
                ViewBag.Wcount = Wcount;
                ViewBag.Fcount = Fcount;



                ViewBag.ListTitle = "To-Watch";

                return(View(res));
            }

            else
            {
                var res = movieAccess.GetHomeList().OrderByDescending(s => s.DateAdded);
                return(View(res));
            }
        }