public ActionResult ReadBooksAdd(int ReaderId) { var brViewModel = new BRViewModel(); using (var booksListContext = new BooksListContext()) { var reader = booksListContext.Readers.SingleOrDefault(p => p.ReaderId == ReaderId); var readerViewModel = new ReaderViewModel() { ReaderId = ReaderId, Name = reader.Name, }; brViewModel.Readers = readerViewModel; var booksRead = booksListContext.BooksRead.Where(p => p.ReaderId == ReaderId).ToList(); var allbooks = booksListContext.Books.ToList(); var Result = allbooks.Where(item => !booksRead.Any(item2 => item2.BookId == item.BookId)); ViewBag.BooksRead = Result.Select(c => new SelectListItem { Value = c.BookId.ToString(), Text = c.Title }).ToList(); } return(View("AddEditBooksRead", brViewModel)); }
public ActionResult DeleteBookRead(BRViewModel brViewModel) { using (var booksListContext = new BooksListContext()) { var bookRead = booksListContext.BooksRead.SingleOrDefault(b => b.BRId == brViewModel.BRId); if (bookRead != null) { booksListContext.BooksRead.Remove(bookRead); booksListContext.SaveChanges(); return(RedirectToAction("ReadersBookList", new { Id = bookRead.ReaderId })); } } return(new HttpNotFoundResult()); }
public ActionResult AddReadBooks(BRViewModel brViewModel) { // Test if dropdown selector is empty and returns to Readers Book list if (brViewModel.Books == null) { return(RedirectToAction("ReadersBookList", new { Id = brViewModel.Readers.ReaderId.Value })); } using (var booksListContext = new BooksListContext()) { var bookRead = new BooksRead { ReaderId = brViewModel.Readers.ReaderId.Value, BookId = brViewModel.Books.BookId.Value }; booksListContext.BooksRead.Add(bookRead); booksListContext.SaveChanges(); } return(RedirectToAction("ReadersBookList", new { Id = brViewModel.Readers.ReaderId.Value })); }
// creates Readers List using reader Id passed in public ActionResult ReadersBookList(int Id) { var returnBookList = new BRListViewModel(); returnBookList.ReaderId = Id; using (var booksListContext = new BooksListContext()) { var booksRead = booksListContext.BooksRead.Where(p => p.ReaderId == Id).ToList(); if (booksRead != null) { foreach (var bookread in booksRead) { var brViewModel = new BRViewModel { BRId = bookread.BRId, Books = new BooksViewModel { BookId = bookread.BookId, Title = bookread.Books.Title, Author = bookread.Books.Author }, Readers = new ReaderViewModel { ReaderId = bookread.Reader.ReaderId, Name = bookread.Reader.Name } }; returnBookList.BooksRead.Add(brViewModel); returnBookList.TotalBR = booksRead.Count; } return(View(returnBookList)); } } return(new HttpNotFoundResult()); }