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; }