public List <CustomerViewModel> GetAllCustomers()
{
using (var context = new OrderSystemContext()) {
return(context.Customers.AsNoTracking()
.Select(c => new CustomerViewModel
{
CustomerId = c.CustomerId,
Name = c.FirstName + " " + c.LastName,
OrderCount = c.Orders.Count()
})
.ToList());
}
}
public CustomerViewModel FindCustomer(int?id)
{
using (var context = new OrderSystemContext()) {
var cust =
context.Customers.AsNoTracking()
.Select(c => new CustomerViewModel
{
CustomerId = c.CustomerId,
Name = c.FirstName + " " + c.LastName,
OrderCount = c.Orders.Count(),
Orders = c.Orders.Select(
o => new OrderViewModel
{
OrderSource = o.OrderSource,
CustomerId = o.CustomerId,
OrderDate = o.OrderDate
}).ToList()
})
.FirstOrDefault(c => c.CustomerId == id);
return(cust);
}
}