public ActionResult Search()
        {
            if (Session["userId"] == null)
            {
                return(RedirectToAction("Index", "Select"));
            }
            User userData = db.Users.Find(Session["userId"]);

            if (userData.CurrentRole.Name.ToLower() != "customer")
            {
                return(RedirectToAction("Index", "Select"));
            }
            var users = db.Users.Where(x => x.CurrentRole.Name == "Seller");
            List <BookUserVM> booksUsersVm = new List <BookUserVM>();

            foreach (User user in users)
            {
                foreach (Book book in user.Books)
                {
                    BookUserVM bookUserVM = new BookUserVM();
                    bookUserVM.idBook    = book.Id;
                    bookUserVM.idUser    = user.Id;
                    bookUserVM.lastname  = user.Lastname;
                    bookUserVM.firstname = user.Firstname;
                    bookUserVM.name      = book.Name;
                    bookUserVM.nbPage    = book.NbPage;
                    bookUserVM.price     = book.Price;
                    booksUsersVm.Add(bookUserVM);
                }
            }

            return(View(booksUsersVm.ToList()));
        }
        public ActionResult SearchWithParam()
        {
            if (Session["userId"] == null)
            {
                return(RedirectToAction("Index", "Select"));
            }
            User userData = db.Users.Find(Session["userId"]);

            if (userData.CurrentRole.Name.ToLower() != "customer")
            {
                return(RedirectToAction("Index", "Select"));
            }
            var users = db.Users.Where(x => x.CurrentRole.Name == "Seller");
            List <BookUserVM> booksUsersVm = new List <BookUserVM>();
            string            name         = Request.QueryString["name"];

            foreach (User user in users)
            {
                foreach (Book book in user.Books)
                {
                    if (string.IsNullOrEmpty(name))
                    {
                        BookUserVM bookUserVM = new BookUserVM();
                        bookUserVM.idBook    = book.Id;
                        bookUserVM.idUser    = user.Id;
                        bookUserVM.lastname  = user.Lastname;
                        bookUserVM.firstname = user.Firstname;
                        bookUserVM.name      = book.Name;
                        bookUserVM.nbPage    = book.NbPage;
                        bookUserVM.price     = book.Price;
                        booksUsersVm.Add(bookUserVM);
                    }
                    else if (book.Name.Contains(name))
                    {
                        BookUserVM bookUserVM = new BookUserVM();
                        bookUserVM.idBook    = book.Id;
                        bookUserVM.idUser    = user.Id;
                        bookUserVM.lastname  = user.Lastname;
                        bookUserVM.firstname = user.Firstname;
                        bookUserVM.name      = book.Name;
                        bookUserVM.nbPage    = book.NbPage;
                        bookUserVM.price     = book.Price;
                        booksUsersVm.Add(bookUserVM);
                    }
                }
            }
            return(View("Search", booksUsersVm.ToList()));
        }