Hi. I am running into some difficulty in gaining the actual items within an OrderInfoProvider object. We do our orders somewhat differently in that we include previously paid for items as part of an ongoing membership. This means that the customer may only order two new items but there is a possibility of 4 items appearing. We need to 'override' the order prior to generate invoice so it will appear as the following

item 1 - already paid 0.00
item 2 4.00
item 3 - already paid 0.00

total price: 4.00

I do not actually want to alter the order rows in the database as we use those actual amounts for billing. (we don't want to send items 1,2,3 for only 4.00)

How can I achieve the following. I assumed that I would be able to run a foreach(OrderItemInfo item in Order) but that results in

foreach statement cannot operate on variables of type 'CMS.Ecommerce.OrderInfo' because 'CMS.Ecommerce.OrderInfo' does not contain a public definition for 'GetEnumerator'

public static void Invoice_Generate(int orderId, DataTable orderManifest)
		{
			DataRow[] alreadyPaying = orderManifest.Select("Already_Paying = true");
			OrderInfo order = null;
			order = OrderInfoProvider.GetOrderInfo(orderId);
			foreach(OrderItemInfo item in order)  //How do I manipulate each order item row here prior to invoice generation? 
			{
			
				Int32 ItemId = item.OrderItemID;
				foreach(DataRow Row in alreadyPaying) //91,93,95
				{
					foreach(DataRow Exists in orderManifest.Rows)
					{
						if(Convert.ToInt32(Exists["ID"]) == Convert.ToInt32(Row["ID"]) && Convert.ToInt32(Row["ID"]) == ItemId)
						{
							item.OrderItemUnitPrice = 0;
							item.OrderItemSKUName += " Subscribed";
							break;
						}
					}
				}
			}
			order.OrderInvoiceNumber = orderId.ToString();
			OrderInfoProvider.SetOrderInfo(order);
			if(CMSContext.CurrentSite != null)
			{

				string invoice = OrderInfoProvider.GetInvoice(orderId, CMSContext.CurrentSite.SiteID);
				order.OrderInvoice = invoice;
				OrderInfoProvider.SetOrderInfo(order);
			}
		}

Will this manipulate the physical rows in the database? is there a way to 'backup the rows", manipulate , restore?

thanks.