Customer information is not retained in order after adding new customer profile during booking creation in admin

Working on this today, hoping for some feedback regarding next steps.
During the "Create new profile" process, the "owned by" user association field is hidden.
This creates a new `commerce_customer_profile` record with uid = 0.
At this time a new `rooms_customers` record is created as well, referencing the profile id
The booking process resumes, the new "profile" is selected, and the booking is created.

At this point we have a new `commerce_order` record, with uid = [ADMIN_UID]
I believe this is the point where we need to step in. With no valid link to the customer profile, the order billing info is left empty.
Manually updating the `field_data_commerce_customer_billing` profile_id reference fixes the issue.

I believe if we get this value to the order creation process we should be ok.

Based on this post: http://www.drupalcommerce.org/discussions/2615/programatically-create-or...

Can we add the following to rooms_booking.admin.inc line #1132

$profile_object = array ( 
        'und' => array ( array ( 'profile_id' => $profile_id , ) , ) , ); 
    
$order->commerce_customer_billing = $profile_object;

This would require adding 6th argument to rooms_booking_create_order(), namely the $profile_id

patch attached as described in #2. Creating new booking, and editing existing booking worked fine.

Sorry, that last patch was backwards. Also updated to reflect comment #

ashgotti, you are welcome. Glad to have a potential solution in place and that it helped you out!
Ronald, my pleasure, glad to help!
Just finished updating the DB to add the relationships as needed.
Here's the PHP I used, potentially helpful for @ashgotti and others, also I could see this in an _update function for a future release?

 $orders_result = db_query("SELECT orders.order_id,orders.revision_id, profiles.profile_id
 FROM `main_commerce_order` `orders`
INNER JOIN `main_rooms_bookings` `bookings` ON bookings.order_id = orders.order_id
INNER JOIN `main_rooms_customers` `customers` ON bookings.customer_id = customers.id
INNER JOIN `main_commerce_customer_profile` `profiles` ON customers.commerce_customer_id = profiles.profile_id
WHERE 
orders.order_id not in (select entity_id from  main_field_data_commerce_customer_billing)
AND orders.status NOT IN ('cart' , 'canceled' , 'checkout_checkout')
ORDER BY `orders`.`order_id`  ASC");


	 if ($orders_result) {
    while ($row = $orders_result->fetchAssoc()) {
	
	$cur_order_id = $row['order_id'];
	$cur_rev_id = $row['revision_id'];
	$cur_cust_id = $row['profile_id'];
	
	
	$insert_sql = "INSERT INTO `main_field_data_commerce_customer_billing` (
					`entity_type` ,
					`bundle` ,
					`deleted` ,
					`entity_id` ,
					`revision_id` ,
					`language` ,
					`delta` ,
					`commerce_customer_billing_profile_id`
					)
					VALUES (
					'commerce_order', 'commerce_order', '0', '{$cur_order_id}', '{$cur_rev_id}', 'und', '0', '{$cur_cust_id}'
					)";
		
		db_query($insert_sql);
		
		//drupal_set_message('Updated order id '.$cur_order_id);
		
	}
  }