public async Task <List <Order> > GetOrdersForCustomersAsync(Guid customerId)
{
using (var context = new CustomersServiceDbContext())
{
return(await context.Orders.Where(o => o.CustomerId == customerId).ToListAsync());
}
}
public async Task <User> GetUserAsync(string name)
{
using (var context = new CustomersServiceDbContext())
{
return(await context.Users.FirstOrDefaultAsync(x => x.Name == name));
}
}
public async Task <List <Order> > GetOrdersAsync()
{
using (var context = new CustomersServiceDbContext())
{
return(await context.Orders.ToListAsync());
}
}
public async Task <Customer> UpdateCustomerAsync(Customer customer)
{
using (var context = new CustomersServiceDbContext())
{
var cust = await context.Customers.FirstOrDefaultAsync(c => c.Id == customer.Id);
if (cust != null)
{
cust.FirstName = customer.FirstName;
cust.LastName = customer.LastName;
cust.Address = customer.Address;
cust.Phone = customer.Phone;
cust.Email = customer.Email;
context.Entry(cust).State = EntityState.Modified;
}
else
{
context.Customers.Attach(customer);
}
await context.SaveChangesAsync();
}
return(customer);
}
public async Task <Customer> GetCustomerAsync(Guid id)
{
using (var context = new CustomersServiceDbContext())
{
return(await context.Customers.FirstOrDefaultAsync(c => c.Id == id));
}
}
public async Task <Order> AddOrderAsync(Order order)
{
using (var context = new CustomersServiceDbContext())
{
context.Orders.Add(order);
await context.SaveChangesAsync();
}
return(order);
}
public async Task <List <Order> > GetCustomerOrdersPerPeriod(Guid customerId, DateTime startTime, DateTime endTime)
{
using (var context = new CustomersServiceDbContext())
{
return(await
context.Orders.Where(
o => o.CustomerId == customerId && (o.OrderDate >= startTime && o.OrderDate <= endTime))
.ToListAsync());
}
}
public async Task <bool> AddCustomerAsync(Customer customer)
{
bool retValue = true;
using (var context = new CustomersServiceDbContext())
{
context.Customers.Add(customer);
retValue = await context.SaveChangesAsync() >= 1;
}
return(retValue);
}
public async Task <Order> UpdateOrderAsync(Order order)
{
using (var context = new CustomersServiceDbContext())
{
if (!context.Orders.Local.Any(o => o.Id == order.Id))
{
context.Orders.Attach(order);
}
context.Entry(order).State = EntityState.Modified;
await context.SaveChangesAsync();
}
return(order);
}