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