public async Task<List<Region>> GetAllRegions()
{
using (var _db = new DomainContext())
{
return await _db.Regions.ToListAsync();
}
}
public async Task<List<Customer>> GetAllCustomerByName(string name)
{
using (var _db = new DomainContext())
{
return await _db.Customers.Where(customer => customer.LastName.Contains(name)).Include(customer => customer.Region).ToListAsync();
}
}
public async Task<List<Customer>> GetAllCustomers()
{
using (var _db = new DomainContext())
{
return await _db.Customers.Include(customer => customer.Region).ToListAsync();
}
}
public async Task AddCustomer(Customer customer)
{
using (var _db = new DomainContext())
{
_db.Customers.Add(customer);
await _db.SaveChangesAsync();
}
}
public async Task UpdateCustomer(Customer customer)
{
using (var _db = new DomainContext())
{
var entity = _db.Customers.Find(customer.Id);
_db.Entry(entity).CurrentValues.SetValues(customer);
await _db.SaveChangesAsync();
}
}
public async Task DeleteCustomer(Customer customer)
{
using (var _db = new DomainContext())
{
var entity = _db.Customers.Find(customer.Id);
_db.Customers.Remove(entity);
await _db.SaveChangesAsync();
}
}