예제 #1
0
        public ActionResult Search(Cart cart, string value)
        {
            var cartViewModel = new CartBookViewModel();

            cartViewModel.SerchWord = value;
            using (var dbContext = new MvclibraryEntities())
            {
                List <Books> books = null;
                if (value != null)
                {
                    books = dbContext.Books.Where(b => b.ISBN.Contains(value) || b.Title.Contains(value) || b.Author.Contains(value)).ToList();
                }
                else
                {
                    books = dbContext.Books.ToList();
                }

                var bookvm = new List <BookViewModel>();
                foreach (var item in books)
                {
                    cartViewModel.BookViewModels.Add(new BookViewModel
                    {
                        Author       = item.Author,
                        ISBN         = item.ISBN,
                        status       = item.Status,
                        NameCategory = dbContext.category.Where(c => c.Id == item.CategoryId).FirstOrDefault().Name,
                        Title        = item.Title,
                        Id           = item.Id
                    });
                }
                cartViewModel.cart = cart;
                return(View("Index", cartViewModel));
            }
        }
예제 #2
0
        public CartBookViewModel GetBookViewModel(Cart cart)
        {
            var cartBookViewModel = new CartBookViewModel();

            cartBookViewModel.cart = cart;
            try
            {
                var books = _bookRepository.GetAllBoks();
                if (books == null)
                {
                    return(cartBookViewModel);
                }

                foreach (var item in books)
                {
                    cartBookViewModel.BookViewModels.Add(
                        new BookViewModel
                    {
                        Id        = item.Id,
                        Author    = item.Author,
                        Title     = item.Title,
                        ISBN      = item.ISBN,
                        Available = item.Available
                    }
                        );
                }
                return(cartBookViewModel);
            }
            catch
            {
                return(cartBookViewModel);
            }
        }
예제 #3
0
        public ActionResult History(Cart cart, string value)
        {
            try
            {
                var cartViewModel = new CartBookViewModel();
                cartViewModel.SerchWord = value;
                using (var dbContext = new MvclibraryEntities())
                {
                    var userEmail = User.Identity.Name;
                    var user      = dbContext.User.Where(u => u.Email == userEmail).FirstOrDefault();

                    var history = new History
                    {
                        Word   = value,
                        UserID = user.Id
                    };
                    dbContext.Entry(history).State = EntityState.Added;
                    TempData["Message"]            = "Zostało zapisane do bazy";
                    TempData["Status"]             = "true";
                    List <Books> books = null;
                    if (value != null)
                    {
                        books = dbContext.Books.Where(b => b.ISBN.Contains(value) || b.Title.Contains(value) || b.Author.Contains(value)).ToList();
                    }
                    else
                    {
                        books = dbContext.Books.ToList();
                    }

                    var bookvm = new List <BookViewModel>();
                    foreach (var item in books)
                    {
                        cartViewModel.BookViewModels.Add(new BookViewModel
                        {
                            Author       = item.Author,
                            ISBN         = item.ISBN,
                            status       = item.Status,
                            NameCategory = dbContext.category.Where(c => c.Id == item.CategoryId).FirstOrDefault().Name,
                            Title        = item.Title,
                            Id           = item.Id
                        });
                    }
                    dbContext.SaveChanges();
                    cartViewModel.cart = cart;
                    return(View("Index", cartViewModel));
                }
            }
            catch
            {
                return(View());
            }
        }
예제 #4
0
        public ActionResult Index(Cart cart)
        {
            using (var dbContext = new MvclibraryEntities())
            {
                var histroy = dbContext.History.ToList();

                var user        = dbContext.User.Where(u => u.Email == User.Identity.Name).FirstOrDefault();
                var userHistory = histroy.Where(h => h.UserID == user.Id).ToList();

                var bookvm = new List <BookViewModel>();
                var bookse = dbContext.Books.ToList();

                var cartBookViewModel = new CartBookViewModel();
                cartBookViewModel.cart = cart;

                foreach (var h in userHistory)
                {
                    if (h.Word == null)
                    {
                        h.Word = "";
                    }
                    var books = bookse.Where(b => b.ISBN.Contains(h.Word) || b.Title.Contains(h.Word) || b.Author.Contains(h.Word)).ToList();
                    foreach (var item in books)
                    {
                        cartBookViewModel.BookViewModels.Add(new BookViewModel
                        {
                            Author       = item.Author,
                            ISBN         = item.ISBN,
                            status       = item.Status,
                            NameCategory = dbContext.category.Where(c => c.Id == item.CategoryId).FirstOrDefault().Name,
                            Title        = item.Title,
                            Id           = item.Id
                        });
                    }
                }

                return(View(cartBookViewModel));
            }
        }
예제 #5
0
        public CartBookViewModel GetCartViewModel()
        {
            var cartBookViewModel = new CartBookViewModel();

            using (var dbContext = new MvclibraryEntities())
            {
                var books  = dbContext.Books.ToList();
                var bookvm = new List <BookViewModel>();
                foreach (var item in books)
                {
                    cartBookViewModel.BookViewModels.Add(new BookViewModel
                    {
                        Author       = item.Author,
                        ISBN         = item.ISBN,
                        status       = item.Status,
                        NameCategory = dbContext.category.Where(c => c.Id == item.CategoryId).FirstOrDefault().Name,
                        Title        = item.Title,
                        Id           = item.Id
                    });
                }
            }
            return(cartBookViewModel);
        }