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();
}
}
