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