public async Task<List<User>> GetAll()
{
using (var db = new UserContext())
{
var users = await db.Users.ToListAsync();
return users;
}
}
public async Task<User> GetByIdAsync(int id)
{
using (var db = new UserContext())
{
var user = await db.Users.FindAsync(id);
return user;
}
}
public async Task<int> CreateAsync(User user)
{
using (var db = new UserContext())
{
var addedUser = db.Users.Add(user);
db.SaveChanges();
return addedUser.UserId;
}
}
public async Task<bool> DeleteAsync(int id)
{
using (var db = new UserContext())
{
var user = await db.Users.FindAsync(id);
if (user != null)
{
db.Users.Remove(user);
db.SaveChanges();
return true;
}
return false;
}
}
public async Task<bool> UpdateAsync(User user)
{
using (var db = new UserContext())
{
var result = await db.Users.SingleOrDefaultAsync(e => e.UserId == user.UserId);
if (result != null)
{
result.Name = user.Name;
await db.SaveChangesAsync();
return true;
}
return false;
}
}
