public async void DeleteAuction(int id)
{
var auction = await db.Auctions.FirstOrDefaultAsync(a => a.ID == id);
db.Auctions.Remove(auction);
await db.SaveChangesAsync();
}
public async void DeleteCategory(int id)
{
var category = await db.Categories.FirstOrDefaultAsync(c => c.ID == id);
if (category != null)
{
db.Categories.Remove(category);
await db.SaveChangesAsync();
}
}
public async void DeleteBidAsync(int id)
{
var bid = await GetBid(id);
if (bid != null)
{
db.Bids.Remove(bid);
await db.SaveChangesAsync();
}
}
public async void DeleteProduct(int id)
{
var product = await db.Products
.Include(p => p.Category)
.FirstOrDefaultAsync(p => p.ID == id);
if (product != null)
{
db.Products.Remove(product);
await db.SaveChangesAsync();
}
}
public async Task <User> AddUser(User user)
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.Serializable))
{
if (user != null)
{
await db.Users.AddAsync(user);
await db.SaveChangesAsync();
await tran.CommitAsync();
return(user);
}
else
{
throw new ArgumentException("User must not be null!");
}
}
}
