} // Orders_ListBox_SelectedIndexChanged
public void LoadOrderItems(string OrderID)
{
try
{
int ordercount = 0; // the number of order items to display
List <string>[] ManagerItemdata; // the order items that will be displayed
ArrayList ListBoxInfo = new ArrayList(); // Array list where formatted text will be stored
// connect to DB if it is not connected
if (!nsadb.Connected())
{
nsadb.OpenConnection();
}
//request the Records to display on the manager order litems list
ordercount = nsadb.ManagerOrderItemData(out ManagerItemdata, OrderID);
// If there is no data in the database skip attempting to load the List
// It will cause an error.
if (ordercount == 0)
{
return;
}
//loop over the records and format them in the Array List
for (int index = 0; index < ordercount; index++)
{
if (ManagerItemdata[2][index] == "0")
{
ListBoxInfo.Add(new BoxFormat(ManagerItemdata[1][index], ManagerItemdata[0][index]));
}
else
{
ListBoxInfo.Add(new BoxFormat(ManagerItemdata[1][index] + " - Refunded", ManagerItemdata[0][index]));
}
}
// Insert Array List into the List Box
OrderItems_Listbox.DataSource = ListBoxInfo;
// Define which information is actually displayed by the listbox and returned
OrderItems_Listbox.DisplayMember = "displayText";
OrderItems_Listbox.ValueMember = "databaseID";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error loading Order Items List", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
} // LoadOrderItems
