示例#1
0
        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);
        }
示例#2
0
 public CustomerService()
 {
     orderRepository = new OrderRepository();
 }
示例#3
0
        public IOrderService Create()
        {
            var orderRepository = new OrderRepository(_connectionStringBuilderProvider);

            return(new OrderService(orderRepository, _customerRepository, _orderValidator, _vatApplicator));
        }
示例#4
0
 private static void LoadCustomerOrders(Customer customer)
 {
     customer.Orders = OrderRepository.GetCustomerOrders(customer.CustomerId);
 }
示例#5
0
 public OrderRepositoryWrapper()
 {
     orderRepository = new OrderRepository();
 }
示例#6
0
        public OrderService(IDatabase customerDb, IDatabase orderDb)
        {
            _customerDb = customerDb;

            _orderRepository = new OrderRepository(orderDb);
        }
示例#7
0
 public OrderService(OrderRepository orderRepository)
 {
     this.orderRepository = orderRepository;
 }