internal void reloadOrderList(ref List <ListOrderItem> orderList) { ListOrderItem li; List <ListOrderItem> loi = new List <ListOrderItem>(); String sql = "SELECT o.id, o.dateCreated, o.moveDate, o.moveTime, o.isPaid, o.orderStatus, c.name, c.phoneHome, c.phoneWork, a.addrLine, a.city " + "FROM easymove.orders AS o LEFT JOIN addresses AS a ON o.id = a.orderId LEFT JOIN clients AS c ON o.clientId=c.id " + "WHERE addrType='Actual' ORDER BY o.moveDate, o.moveTime;"; using (MySqlCommand command = new MySqlCommand(sql, conn)) using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { li = new ListOrderItem(); li.id = (int)reader["id"]; li.name = (string)reader["name"]; li.moveDate = (DateTime)reader["moveDate"]; li.dateCreated = (DateTime)reader["dateCreated"]; li.moveTime = (TimeSpan)reader["moveTime"]; li.isPaid = (bool)reader["isPaid"]; li.orderStatus = (OrderStatus)Enum.Parse(typeof(OrderStatus), reader["orderStatus"] + ""); li.phoneHome = (string)reader["phoneHome"]; li.phoneWork = (string)reader["phoneWork"]; li.addrLine = (string)reader["addrLine"]; li.city = (string)reader["city"]; loi.Add(li); } } if (loi.Count > 0) { orderList = loi; } }
private void miDelete_Click(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("Are you sure to delete?", "Alert", MessageBoxButton.YesNo); switch (result) { case MessageBoxResult.Yes: int index = lvOrders.SelectedIndex; if (index < 0) { return; } ListOrderItem i = (ListOrderItem)lvOrders.Items[index]; try { Globals.db.DeleteListOrderItemById((int)i.id); if (chbShowAll.IsChecked.Value) { Globals.db.reloadOrderList(ref orderList); lvOrders.ItemsSource = orderList; } else { Globals.db.reloadOrderListScheduled(ref orderList); lvOrders.ItemsSource = orderList; } lblStatus.Text = "Total number of orders: " + orderList.Count; } catch (SqlException ex) { Console.WriteLine(ex.StackTrace); MessageBox.Show("Database query error " + ex.Message); } break; case MessageBoxResult.No: break; } }
private void editCurrentOrder() { if (lvOrders.SelectedIndex == -1) { return; } ListOrderItem loi = (ListOrderItem)lvOrders.SelectedItem; Order o = new Order { id = loi.id }; OrderWindow dlg = new OrderWindow(o); if (dlg.ShowDialog() == true) { refreshOrderWindow(); } else { refreshOrderWindow(); } }