public static Customer Load(int customerId) { Customer customer = new Customer(); OrderRepository ordersRepo = InvestecFactory.GetOrderRepository(); SqlConnection connection = default; try { connection = new SqlConnection(ConnectionString); connection.Open(); SqlCommand command = new SqlCommand(Constants.LoadCustomersQuery + customerId, connection); var reader = command.ExecuteReader(); while (reader.Read()) { customer.Name = reader["Name"].ToString(); customer.DateOfBirth = DateTime.Parse(reader["DateOfBirth"].ToString()); customer.Country = reader["Country"].ToString(); customer.Orders = ordersRepo.LoadOrdersForCustomer(customerId); } } catch (Exception ex) { throw new Exception($"Error loading customerId '{customerId}'. Error Message: {ex.Message}", ex); } finally { connection?.Close(); } return(customer); }
public CustomerService() { orderRepository = new OrderRepository(); }
public IOrderService Create() { var orderRepository = new OrderRepository(_connectionStringBuilderProvider); return(new OrderService(orderRepository, _customerRepository, _orderValidator, _vatApplicator)); }
private static void LoadCustomerOrders(Customer customer) { customer.Orders = OrderRepository.GetCustomerOrders(customer.CustomerId); }
public OrderRepositoryWrapper() { orderRepository = new OrderRepository(); }
public OrderService(IDatabase customerDb, IDatabase orderDb) { _customerDb = customerDb; _orderRepository = new OrderRepository(orderDb); }
public OrderService(OrderRepository orderRepository) { this.orderRepository = orderRepository; }