private void ShowOrders()
{
ordersViewer.Children.Clear();
Orders = DBAccessHelper.GetOrders(CurrentOrder.User.ID);
if (Orders == null)
{
TextBlock tb = new TextBlock()
{
Text = "There are no orders to display!"
};
ordersViewer.Children.Add(tb);
return;
}
// iterate orders
foreach (var order in Orders)
{
//order
string output = "";
output += $"Order ID: {order.ID}\n";
output += $"Order Address: {order.Address}\n";
output += $"Order Date:\n{order.PlacedAt}\n";
string yesNo = (order.Complete) ? "Yes" : "No";
output += $"Complete: {yesNo} \n";
if (order.Complete)
{
output += $"{order.Basket.Count} items ordered";
}
else
{
output += $"{order.Basket.Count} items in this basket";
}
TextBlock tb = new TextBlock()
{
Text = output,
TextWrapping = TextWrapping.Wrap
};
var orderButton = new Button()
{
Content = tb,
Tag = order.ID
};
orderButton.Click += OrderButton_Click;
ordersViewer.Children.Add(orderButton);
}
}
private void OrderSetup()
{
pageName.Text = "Entity Editor - Order Records";
string query = @"SELECT
OrderItems.orderId,
Orders.userId,
Orders.address,
FORMAT (Orders.orderDate, 'dd-MM-yyy hh:mm:ss') as date,
OrderItems.productId,
OrderItems.quantity,
Payments.amount,
Payments.type
FROM Orders
LEFT JOIN OrderItems ON OrderItems.orderId = Orders.id
LEFT JOIN Payments ON Orders.id = Payments.orderId
ORDER BY Orders.id DESC";
dataSource = DBAccessHelper.GetOrders(query);
if (dataSource == null)
{
dataSource = new DataTable()
{
Columns =
{
{ "error" },
{ "no values found" }
}
}
}
;
resultDg.ItemsSource = dataSource.AsDataView();
saveFormChanges.Visibility = Visibility.Collapsed;
resultDg.Visibility = form.Visibility =
formOrderData.Visibility = Visibility.Visible;
deleteSelectedRecord.Visibility =
addNewRecord.Visibility = saveFormChanges.Visibility = Visibility.Collapsed;
}
