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