public void EditBook(int id, BookViewModel bookViewModel) { Book book = _context.Books.Where(x => x.Book_Id == id).FirstOrDefault(); book.Book_Title = bookViewModel.Book_Title; _context.Books.Update(book); _context.SaveChanges(); //add foreach (int authorId in bookViewModel.SelectedAuthor) { bool isPresent = _context.BooksAuthors.Where(x => x.BookId == id && x.AuthourId == authorId).Any(); if (isPresent == false) { BooksAuthor booksAuthor = new BooksAuthor() { AuthourId = authorId, BookId = book.Book_Id }; _context.SaveChanges(); } } //remove List <BooksAuthor> booksAuthors = _context.BooksAuthors.Where(x => x.BookId == id).ToList(); foreach (BooksAuthor bookAuth in booksAuthors) { bool isPresent = bookViewModel.SelectedAuthor.Where(x => x == bookAuth.AuthourId).Any(); if (isPresent == false) { _context.BooksAuthors.Remove(bookAuth); _context.SaveChanges(); } } }
public void AddBook(BookViewModel bookViewModel) { Book book = new Book() { Book_Title = bookViewModel.Book_Title }; _context.Books.Add(book); _context.SaveChanges(); foreach (int authorId in bookViewModel.SelectedAuthor) { BooksAuthor booksAuthor = new BooksAuthor() { AuthourId = authorId, BookId = book.Book_Id }; _context.SaveChanges(); } }