public static int RemoveBooks(BookShopContext context) { var booksToDelete = context.Books.Where(x => x.Copies < 4200).ToList(); context.RemoveRange(booksToDelete); context.SaveChanges(); return(booksToDelete.Count()); }
public static int RemoveBooks(BookShopContext context) { var books = context.Books.Where(b => b.Copies < 4200).ToList(); var result = books.Count; context.RemoveRange(books); context.SaveChanges(); return(result); }
public static int RemoveBooks(BookShopContext context) { var toRemove = context.Books.Where(b => b.Copies < 4200); var count = toRemove.Count(); context.RemoveRange(toRemove); context.SaveChanges(); return(count); }
public static int RemoveBooks(BookShopContext context) { var books = context.Books.Where(x => x.Copies < 4200).ToArray(); var result = books.Length; context.RemoveRange(books); context.SaveChanges(); return(result); }
public static int RemoveBooks(BookShopContext db) { var removed = db.Books .Where(b => b.Copies < 4200) .ToArray();; db.RemoveRange(removed); db.SaveChanges(); return(removed.Length); }
public static int RemoveBooks(BookShopContext db) { var booksToUpdate = db.Books .Where(b => b.Copies < 4200) .ToList(); db.RemoveRange(booksToUpdate); db.SaveChanges(); return(booksToUpdate.Count()); }
//EXERCISE 15 - Remove Books public static int RemoveBooks(BookShopContext context) { var targetBooks = context.Books .Where(x => x.Copies < 4200) .ToList(); context.RemoveRange(targetBooks); context.SaveChanges(); return(targetBooks.Count); }
//16. Remove Books public static int RemoveBooks(BookShopContext context) { var booksForDelete = context.Books .Where(c => c.Copies < 4200) .ToArray(); context.RemoveRange(booksForDelete); context.SaveChanges(); return(booksForDelete.Count()); }
public static int RemoveBooks(BookShopContext context) { var books = context.Books .Where(b => b.Copies < 4200) .ToArray(); context.RemoveRange(books); context.SaveChanges(); return(books.Length); }
private static int RemoveBooks(BookShopContext context) { var booksForDelete = context.Books .Where(b => b.Copies < 4200) .ToList(); context.RemoveRange(booksForDelete); context.SaveChanges(); return(booksForDelete.Count); }
public static int RemoveBooks(BookShopContext context) { context .RemoveRange(context .Books .Where(b => b.Copies < 4200)); var removedCount = context.SaveChanges(); return(removedCount); }
public static int RemoveBooks(BookShopContext context) { var booksForRomove = context.Books .Where(b => b.Copies < 4200) .ToList(); context.RemoveRange(booksForRomove); context.SaveChanges(); return(booksForRomove.Count()); }
public static int RemoveBooks(BookShopContext db) { var books = db.Books.Where(x => x.Copies < 4200).ToArray(); var deletedBooks = books.Length; db.RemoveRange(books); db.SaveChanges(); return(deletedBooks); }
public static int RemoveBooks(BookShopContext context) { List <Book> books = context.Books .Where(b => b.Copies < 4200) .ToList(); context.RemoveRange(books); context.SaveChanges(); return(books.Count); }
public static int RemoveBooks(BookShopContext context) { //Write a method RemoveBooks(BookShopContext context) that removes from the database those books, which have less than 4200 copies. //Return an int -the number of books that were deleted from the database. var getBooksWihLessCopies = context.Books .Where(x => x.Copies < 4200).ToArray(); context.RemoveRange(getBooksWihLessCopies); context.SaveChanges(); return(getBooksWihLessCopies.Length); }
//15 public static int RemoveBooks(BookShopContext db) { var booksToDelete = db.Books.Where(b => b.Copies < 4200).ToArray(); int numDeletedBooks = booksToDelete.Length; db.RemoveRange(booksToDelete); db.SaveChanges(); return(numDeletedBooks); }
//15.Remove Books public static int RemoveBooks(BookShopContext db) { var books = db.Books .Where(b => b.Copies < 4200); int result = books.Count(); db.RemoveRange(books); db.SaveChanges(); return(result); }
public static int RemoveBooks(BookShopContext db) { var booksToRemove = db.Books .Where(x => x.Copies < 4200) .ToList(); int count = booksToRemove.Count(); db.RemoveRange(booksToRemove); db.SaveChanges(); return(count); }
public static int RemoveBooks(BookShopContext context) { var booksForRemoving = context.Books .Where(x => x.Copies < 4200); var removedCount = booksForRemoving.Count(); context.RemoveRange(booksForRemoving); context.SaveChanges(); return(removedCount); }
public static int RemoveBooks(BookShopContext context) { var books = context.Books .Where(x => x.Copies < 4200); int count = books.Count(); context.RemoveRange(books); context.SaveChanges(); return(count); }
public static int RemoveBooks(BookShopContext db) { var deletedBooks = db.Books.Where(x => x.Copies < 4200).ToList(); var bookCount = deletedBooks.Count; db.RemoveRange(deletedBooks); db.SaveChanges(); return(bookCount); }
public static int RemoveBooks(BookShopContext context) { var booksWithLessThan4200 = context .Books .Where(x => x.Copies < 4200) .ToArray(); context.RemoveRange(booksWithLessThan4200); context.SaveChanges(); return(booksWithLessThan4200.Count()); }
//15-Remove Books public static int RemoveBooks(BookShopContext context) { var books = context.Books .Where(b => b.Copies < 4200); var countOfBooksToRemove = books.Count(); context.RemoveRange(books); context.SaveChanges(); return(countOfBooksToRemove); }
public static int RemoveBooks(BookShopContext context) { var booksForDelete = context.Books .Where(b => b.Copies < 4200) .ToList(); context.RemoveRange(booksForDelete); context.SaveChanges(); //return context.SaveChanges(); not working in judge return(booksForDelete.Count); }
//15. Remove Books public static int RemoveBooks(BookShopContext context) { const int count = 4200; var booksToDelete = context .Books .Where(b => b.Copies < count) .ToList(); context.RemoveRange(booksToDelete); context.SaveChanges(); return(booksToDelete.Count); }
//15. Remove Books public static int RemoveBooks(BookShopContext context) { StringBuilder sb = new StringBuilder(); Book[] books = context.Books .Where(x => x.Copies < 4200) .ToArray(); int removeElements = books.Count(); context.RemoveRange(books); context.SaveChanges(); return(removeElements); }
public static int RemoveBooks(BookShopContext context) { var booksToRemove = context .Books .Where(x => x.Copies < 4200) .ToList(); int countOfRemovedBooks = booksToRemove.Count; context.RemoveRange(booksToRemove); context.SaveChanges(); return(countOfRemovedBooks); }
public async Task <IActionResult> Edit(BooksCreateEditViewModel ViewModel) { ViewBag.LanguageID = new SelectList(_context.Languages, "LanguageID", "LanguageName"); ViewBag.PublisherID = new SelectList(_context.Publishers, "PublisherID", "PublisherName"); if (ModelState.IsValid) { try { DateTime?PublishDate; if (ViewModel.IsPublish == true && ViewModel.RecentIsPublish == false) { PublishDate = DateTime.Now; } else if (ViewModel.RecentIsPublish == true && ViewModel.IsPublish == false) { PublishDate = null; } else { PublishDate = ViewModel.PublishDate; } Book book = new Book() { BookID = ViewModel.BookID, LanguageID = ViewModel.LanguageID, PublisherID = ViewModel.PublisherID, PublishYear = ViewModel.PublishYear, }; _context.Update(book); var RecentCategories = (from c in _context.Book_Categories where (c.BookID == ViewModel.BookID) select c.CategoryID).ToArray(); var DeletedCategories = RecentCategories.Except(ViewModel.CategoryID); var AddedCategories = ViewModel.CategoryID.Except(RecentCategories); if (DeletedCategories.Count() != 0) { _context.RemoveRange(DeletedCategories.Select(a => new Book_Category { CategoryID = a, BookID = ViewModel.BookID }).ToList()); } if (AddedCategories.Count() != 0) { _context.AddRange(AddedCategories.Select(a => new Book_Category { CategoryID = a, BookID = ViewModel.BookID }).ToList()); } await _context.SaveChangesAsync(); ViewBag.MsgSuccess = "ذخیره تغییرات با موفقیت انجام شد."; return(View(ViewModel)); } catch { ViewBag.MsgFailed = "در ذخیره تغییرات خطایی رخ داده است."; return(View(ViewModel)); } } else { ViewBag.MsgFailed = "اطلاعات فرم نامعتبر است."; return(View(ViewModel)); } }
public async Task <IActionResult> Edit(BooksCreateEditViewModel ViewModel) { ViewBag.LanguageID = new SelectList(_context.Languages, "LanguageID", "LanguageName"); ViewBag.PublisherID = new SelectList(_context.Publishers, "PublisherID", "PublisherName"); ViewBag.AuthorID = new SelectList(_context.Authors.Select(t => new AuthorList { AuthorID = t.AuthorID, NameFamily = t.FirstName + " " + t.LastName }), "AuthorID", "NameFamily"); ViewBag.TranslatorID = new SelectList(_context.Translator.Select(t => new TranslatorList { TranslatorID = t.TranslatorID, NameFamily = t.Name + " " + t.Family }), "TranslatorID", "NameFamily"); ViewModel.SubCategoriesVM = new BooksSubCategoriesViewModel(_repository.GetAllCategories(), ViewModel.CategoryID); if (ModelState.IsValid) { try { DateTime?PublishDate; if (ViewModel.IsPublish == true && ViewModel.RecentIsPublish == false) { PublishDate = DateTime.Now; } else if (ViewModel.RecentIsPublish == true && ViewModel.IsPublish == false) { PublishDate = null; } else { PublishDate = ViewModel.PublishDate; } Book book = new Book() { BookID = ViewModel.BookID, Title = ViewModel.Title, ISBN = ViewModel.ISBN, NumOfPages = ViewModel.NumOfPages, Price = ViewModel.Price, Stock = ViewModel.Stock, IsPublish = ViewModel.IsPublish, LanguageID = ViewModel.LanguageID, PublisherID = ViewModel.PublisherID, PublishYear = ViewModel.PublishYear, Summary = ViewModel.Summary, Weight = ViewModel.Weight, PublishDate = PublishDate, Delete = false, }; _context.Update(book); var RecentAuthors = (from a in _context.Author_Books where (a.BookID == ViewModel.BookID) select a.AuthorID).ToArray(); var RecentTranslators = (from a in _context.Book_Translators where (a.BookID == ViewModel.BookID) select a.TranslatorID).ToArray(); var RecentCategories = (from c in _context.Book_Categories where (c.BookID == ViewModel.BookID) select c.CategoryID).ToArray(); var DeletedAuthors = RecentAuthors.Except(ViewModel.AuthorID); var DeletedTranslators = RecentTranslators.Except(ViewModel.TranslatorID); var DeletedCategories = RecentCategories.Except(ViewModel.CategoryID); var AddedAuthors = ViewModel.AuthorID.Except(RecentAuthors); var AddedTranslators = ViewModel.TranslatorID.Except(RecentTranslators); var AddedCategories = ViewModel.CategoryID.Except(RecentCategories); if (DeletedAuthors.Count() != 0) { _context.RemoveRange(DeletedAuthors.Select(a => new Author_Book { AuthorID = a, BookID = ViewModel.BookID }).ToList()); } if (DeletedTranslators.Count() != 0) { _context.RemoveRange(DeletedTranslators.Select(a => new Book_Translator { TranslatorID = a, BookID = ViewModel.BookID }).ToList()); } if (DeletedCategories.Count() != 0) { _context.RemoveRange(DeletedCategories.Select(a => new Book_Category { CategoryID = a, BookID = ViewModel.BookID }).ToList()); } if (AddedAuthors.Count() != 0) { _context.AddRange(AddedAuthors.Select(a => new Author_Book { AuthorID = a, BookID = ViewModel.BookID }).ToList()); } if (AddedTranslators.Count() != 0) { _context.AddRange(AddedTranslators.Select(a => new Book_Translator { TranslatorID = a, BookID = ViewModel.BookID }).ToList()); } if (AddedCategories.Count() != 0) { _context.AddRange(AddedCategories.Select(a => new Book_Category { CategoryID = a, BookID = ViewModel.BookID }).ToList()); } await _context.SaveChangesAsync(); ViewBag.MsgSuccess = "ذخیره تغییرات با موفقیت انجام شد."; return(View(ViewModel)); } catch { ViewBag.MsgFailed = "در ذخیره تغییرات خطایی رخ داده است."; return(View(ViewModel)); } } else { ViewBag.MsgFailed = "اطلاعات فرم نامعتبر است."; return(View(ViewModel)); } }