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