public async Task <IActionResult> PutPlaylist(int id, Playlist playlist) { if (id != playlist.PlaylistID) { return(BadRequest()); } _context.Entry(playlist).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PlaylistExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutUser(int id, User user) { if (id != user.UserID) { return(BadRequest()); } _context.Entry(user).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <bool> AddOrUpdateRecord(SaleDataModel saleData) { if (_database.Sales.Any(sale => sale.OrderId == saleData.OrderId)) { _database.Sales.Attach(saleData); _database.Entry(saleData).State = EntityState.Modified; } else { _database.Sales.Add(saleData); } var changes = await _database.SaveChangesAsync(); return(changes == 1); }
private void UpdateAuthor(Author toUpdate) { using (ApplicationDatabase _dbContext = new ApplicationDatabase()) { var entity = _dbContext.Authors.Where(c => c.Id == toUpdate.Id).AsQueryable().FirstOrDefault(); if (entity == null) { _dbContext.Authors.Add(toUpdate); } else { _dbContext.Entry(entity).CurrentValues.SetValues(toUpdate); } _dbContext.SaveChanges(); } }
public async Task <ActionResult> UpdateAccount(int id, Account account) { if (id != account.AccountID) { return(BadRequest()); } if (!_context.Account.Any(e => e.AccountID == id)) { return(BadRequest()); } var updateAccount = await _context.Account.FirstOrDefaultAsync(s => (s.AccountID == account.AccountID)); _context.Entry(updateAccount).State = EntityState.Modified; updateAccount.AccountType = account.AccountType; updateAccount.AccountLabel = account.AccountLabel; updateAccount.AccountDate = account.AccountDate; updateAccount.AccountAmount = account.AccountAmount; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!_context.Account.Any(e => e.AccountID == id)) { return(BadRequest()); } else { throw; } } return(NoContent()); }