> Post([FromBody] AddBorrowing borrowing) { var newBorrowing = new Borrowing { BookId = borrowing.BookId, AuthorId = borrowing.AuthorId }; var book = _BooksDbContext.Books.FirstOrDefault(b => b.Id == borrowing.BookId); if (book == null || book.Copies <= 3) { return(NotFound("El libro no existe o no hay suficientes copias disponibles.")); } var bookTmp = _BooksDbContext.Books.FirstOrDefault(b => b.Id == book.Id); if (bookTmp == null) { return(NotFound("El libro no existe o no hay suficientes copias disponibles.")); } else { bookTmp.Copies -= 1; _BooksDbContext.Entry(bookTmp).CurrentValues.SetValues(bookTmp); } _BooksDbContext.Borrowings.Add(newBorrowing); _BooksDbContext.SaveChanges(); return(newBorrowing); }
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,PhoneNumber,Title,Author,Genre,ISBN,Fullfilled")] Request request) { if (ModelState.IsValid) { db.Entry(request).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(request)); }
public ActionResult Edit([Bind(Include = "ID,Title,Author,Genre,ISBN,Available,Taken")] Books books) { if (ModelState.IsValid) { db.Entry(books).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(books)); }
public ActionResult Edit([Bind(Include = "Id,Name,Price,Author,Publisher,RowVersion")] Book book) { if (ModelState.IsValid) { db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(book)); }
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,PhoneNumber,Email")] Reserve reserve) { if (ModelState.IsValid) { db.Entry(reserve).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(reserve)); }
public IActionResult UpdateBook(Book newBook) { Book oldBook = _context.Books.Find(newBook.Id); if (ModelState.IsValid) { oldBook.Title = newBook.Title; oldBook.Author = newBook.Author; _context.Entry(oldBook).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.Update(oldBook); _context.SaveChanges(); } return(RedirectToAction("BooksList")); }
public void UpdateBulkData() { var res = _dbContext.BookDetails.Select(b => b); foreach (var item in res) { item.Price++; _dbContext.Attach(item); _dbContext.Entry(item).Property("Price").IsModified = true; } Console.WriteLine("Begin Update: {0}", DateTime.Now); //_dbContext.SaveChanges(); _dbContext.BulkUpdate(res); Console.WriteLine("End Update: {0}", DateTime.Now); }
public async Task <IActionResult> PutBook(long id, Book book) { if (id != book.Id) { return(BadRequest()); } if (!BookExists(id)) { return(NotFound()); } _context.Entry(book).State = EntityState.Modified; await _context.SaveChangesAsync(); return(Ok(book)); }
public async Task <IActionResult> PutReview(long id, Review review) { if (id != review.Id) { return(BadRequest()); } if (!ReviewExists(id)) { return(NotFound()); } _context.Entry(review).State = EntityState.Modified; await _context.SaveChangesAsync(); return(Ok(review)); }
public void UpdateBook(Book book) { context.Entry(book).State = EntityState.Modified; }
public void ModifyBookState(Book book) { _context.Entry(book).State = EntityState.Modified; }