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