public List <Customer> GetAllCustomers()
{
using (var context = new OrderSystemContext())
{
return(context.Customers.AsNoTracking().ToList());
}
}
public void RemoveCustomer(int id)
{
using (var context = new OrderSystemContext())
{
context.Customers.Remove(context.Customers.Find(id));
context.SaveChanges();
}
}
public void UpdateCustomer(Customer customer)
{
using (var context = new OrderSystemContext())
{
context.Entry(customer).State = EntityState.Modified;
context.SaveChanges();
}
}
public void AddCustomer(Customer customer)
{
using (var context = new OrderSystemContext())
{
context.Customers.Add(customer);
context.SaveChanges();
}
}
public Customer FindCustomer(int?id)
{
using (var context = new OrderSystemContext())
{
return(context.Customers
.AsNoTracking()
.SingleOrDefault(c => c.CustomerId == id));
}
}
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);
}
}
public UOWWrappingGenericRepos()
{
_context = new OrderSystemContext();
}
public UOW()
{
_context = new OrderSystemContext();
}
public CustomerWithOrdersData_DI(OrderSystemContext context)
{
_context = context;
}
