//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()); }