public async Task <ActionResult <Publisher> > GetPublisherDetails(string PublisherId) { //Eager Loading //var publisher = await _context.Publishers // .Include(pub => pub.Users) // .Include(pub => pub.Books) // .ThenInclude(book => book.Sales) // .Where(pub => pub.PubId == id) // .FirstOrDefaultAsync(); //Explicit Loading var publisher = await _context.Publishers.SingleAsync(pub => pub.PubId == Convert.ToInt32(PublisherId)); _context.Entry(publisher) .Collection(pub => pub.Users) .Query() .Where(usr => usr.EmailAddress.Contains("karin")) .Load(); _context.Entry(publisher) .Collection(pub => pub.Books) .Query() .Include(book => book.Sales) .Load(); if (publisher == null) { return(NotFound()); } return(publisher); }
public bool Edit(Guid id, Company item) { var company = Detail(id); if (company != null) { company.IsActive = item.IsActive; _context.Entry(company).State = EntityState.Modified; return _context.SaveChanges() > 0; } return false; }
public async Task <IActionResult> PutUsers(int id, Users users) { if (id != users.Id) { return(BadRequest()); } _dbContext.Entry(users).State = EntityState.Modified; try { await _dbContext.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UsersExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutAuthor(int id, Author author) { if (id != author.Id) { return(BadRequest()); } _context.Entry(author).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AuthorExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutSale(int id, Sale sale) { if (id != sale.SaleId) { return(BadRequest()); } _context.Entry(sale).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SaleExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult Edit([Bind(Include = "Id,Name")] Author author) { if (ModelState.IsValid) { db.Entry(author).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(author)); }
public ActionResult Edit([Bind(Include = "Id,Title,Year,AuthorId")] Book book) { if (ModelState.IsValid) { db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AuthorId = new SelectList(db.Authors, "Id", "Id", book.AuthorId); return(View(book)); }
public async Task <IActionResult> PutBook(int id, Book book) { if (id != book.Id) { return(BadRequest()); } _context.Entry(book).State = EntityState.Modified; await _context.SaveChangesAsync(); return(NoContent()); }
public IActionResult Update(int id, string phonenumber) { try { var author = new Author() { AuthorId = id, Phone = phonenumber }; _context.Author.Attach(author); _context.Entry(author).Property(a => a.Phone).IsModified = true; _context.SaveChanges(); } catch (Exception ex) { _logger.LogInformation($"HELLO FROM api/authos/{id}/update/{phonenumber}"); return(BadRequest(ex.Message)); } return(Ok()); }
public bool UpdateUserToken(int id, string token, DateTime expiredDate) { if (id > 0 && string.IsNullOrEmpty(token)) { return(false); } var getUser = _context.Users.SingleOrDefault(x => x.Id == id); if (getUser == null) { return(false); } getUser.Token = token; getUser.ExpiredDate = expiredDate; _context.Entry(getUser).State = EntityState.Modified; return(_context.SaveChanges() > 0); }
public ActionResult Edit(order order) { BookStoreDB.Entry(order).State = System.Data.Entity.EntityState.Modified; BookStoreDB.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <int> Update(int?id, Books books) { _dbContext.Entry(books).State = EntityState.Modified; return(await _dbContext.SaveChangesAsync()); }