//Trae - Crashing because of open connection on "newItem.getComponents(this, getComponents());"
public NSAOrder getPastOrderItems(NSAOrder order)
{
MySqlDataReader menuItemReader = CustomQuery("SELECT name, price, menuitemid FROM orderitems WHERE orderid = " + order.Id + ";");
List <NSAHistoryItem> itemList = new List <NSAHistoryItem>();
if (menuItemReader != null)
{
while (menuItemReader.Read())
{
NSAHistoryItem newItem = new NSAHistoryItem();
newItem.Name = (string)menuItemReader["name"];
newItem.Id = (int)menuItemReader["menuitemid"];
newItem.Price = (float)menuItemReader["price"];
itemList.Add(newItem);
}
}
menuItemReader.Close();
foreach (NSAMenuItem nmi in itemList)
{
nmi.getComponents(this, getComponents());
}
foreach (NSAHistoryItem i in itemList)
{
order.Items.Add(i);
}
return(order);
}
private void HistoryView_SelectedIndexChanged(object sender, EventArgs e)
{
foreach (ListViewItem t in FavOrdersView.SelectedItems)
{
currentOrder = (NSAOrder)t.Tag;
}
UpdateOrderView();
}
//constructor called when logging in as guest
public KioskWindow(CultureInfo language)
{
ci = language; //set the language
a = Assembly.Load("CustomerInterface"); //load the assembly and resourcemanager
rm = new ResourceManager("CustomerInterface.Lang.lang", a);
InitializeComponent();
db = new NSADatabase();
db.OpenConnection();
componentsList = db.getComponents();
menu = db.getMenu();
updateMenu();
currentOrder = new NSAOrder();
setLang(ci);
}
//constructor called when logging in with a loyalty account
public KioskWindow(CultureInfo language, List <string>[] accountNumber)
{
ci = language; //set the language
a = Assembly.Load("CustomerInterface"); //load the assembly and resourcemanager
rm = new ResourceManager("CustomerInterface.Lang.lang", a);
account = new NSALoyaltyAccount(accountNumber[0][0], accountNumber[1][0], accountNumber[2][0], accountNumber[3][0]);
InitializeComponent();
db = new NSADatabase();
db.OpenConnection();
componentsList = db.getComponents();
menu = db.getMenu();
account.FavoriteItems = db.getFavoriteItems(account.getAccountNumber().ToString());
foreach (NSAFavoriteItem it in account.FavoriteItems)
{
ListViewItem lvi = new ListViewItem(it.Name);
lvi.Tag = it;
favItemsListView.Items.Add(lvi);
}
account.FavoriteOrders = db.getFavoriteOrders(account.getAccountNumber());
foreach (NSAOrder order in account.FavoriteOrders)
{
ListViewItem lvi = new ListViewItem(order.Id.ToString());
lvi.Tag = order;
FavOrdersView.Items.Add(lvi);
}
setAccountTab();
updateMenu();
currentOrder = new NSAOrder();
setLang(ci);
}
public NSAOrder[] getPastOrders(long loyaltyid)
{
MySqlDataReader menuItemReader = CustomQuery("SELECT orderid FROM orders WHERE loyaltyid = " + loyaltyid + ";");
List <NSAOrder> orderList = new List <NSAOrder>();
if (menuItemReader != null)
{
while (menuItemReader.Read())
{
NSAOrder newOrder = new NSAOrder();
newOrder.Id = (int)menuItemReader["orderid"];
orderList.Add(newOrder);
}
}
menuItemReader.Close();
for (int i = 0; i < orderList.Count; i++)
{
orderList[i] = getPastOrderItems(orderList[i]);
}
menuItemReader.Close();
return(orderList.ToArray());
}
