public List <Order> Get(int customerId)
{
using (var context = new DemoContextFactory().Create())
{
_orders = context.Orders.ToList();
return(_orders.Where(c => c.Customer.CustomerId == customerId).ToList());
}
}
public List <Order> Get()
{
using (var context = new DemoContextFactory().Create())
{
_orders = context.Orders.Include(a => a.Customer).ToList();
}
return(_orders);
}
public Customer Get(int id)
{
using (var context = new DemoContextFactory().Create())
{
_customers = context.Customers.ToList();
}
return(_customers.Single(cust => cust.CustomerId == id));
}
public List <Customer> Get()
{
using (var context = new DemoContextFactory().Create())
{
_customers = context.Customers.ToList();
}
return(_customers);
}
public Customer Add(Customer customer)
{
using (var context = new DemoContextFactory().Create())
{
_customers.Add(customer);
context.SaveChanges();
}
//todo: add Id field
return(customer);
}
public Customer Delete(int id)
{
Customer itemToRemove;
using (var context = new DemoContextFactory().Create())
{
_customers = context.Customers.ToList();
itemToRemove = _customers.SingleOrDefault(c => c.CustomerId == id);
if (itemToRemove != null)
{
//_customers.Remove(itemToRemove);
context.Customers.Remove(itemToRemove);
context.SaveChanges();
}
}
return(itemToRemove);
}