public ActionResult Delete(int id) { LibraryDataBase db = new LibraryDataBase(); Book book = db.Books.Find(id); book.Author.QuantityBooks--; book.Publisher.QuantityBooks--; db.Books.Remove(book); db.SaveChanges(); FreeUnusedMemory(db); return(RedirectToAction("ViewAll")); }
public ActionResult Edit(SimpleBook sBook) { LibraryDataBase db = new LibraryDataBase(); Book book = db.Books.Find(sBook.BookRef); ModifyAuthor(book, sBook, db); ModifyGenre(book, sBook, db); ModifyPublisher(book, sBook, db); ModifyTitle(book, sBook); db.Entry(book).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); FreeUnusedMemory(db); return(RedirectToAction("ViewAll")); }
private void FreeUnusedMemory(LibraryDataBase db) { foreach (Author a in db.Authors) { if (a.QuantityBooks == 0) { db.Authors.Remove(a); } } foreach (Publisher p in db.Publishers) { if (p.QuantityBooks == 0) { db.Publishers.Remove(p); } } db.SaveChanges(); }
public ActionResult AddNew(SimpleBook sBook) { LibraryDataBase db = new LibraryDataBase(); Book book = new Book(); book.Author = new Author { AuthorName = "" }; book.Publisher = new Publisher { PublisherName = "" }; ModifyAuthor(book, sBook, db); ModifyGenre(book, sBook, db); ModifyPublisher(book, sBook, db); ModifyTitle(book, sBook); db.Books.Add(book); db.SaveChanges(); FreeUnusedMemory(db); return(RedirectToAction("ViewAll")); }