public List <Order> GetOrders()
{
List <Order> orders = new List <Order>();
Customer tempCustomer = new Customer();
using (SqlConnection connection = new SqlConnection(Database.Instance.ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("ShowOrders", connection);
command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int orderID = int.Parse(reader["OrderID"].ToString());
Customer customer = tempCustomer.GetCustomer(int.Parse(reader["CustomerID"].ToString()));
DateTime dateOfPurchase = DateTime.Parse(reader["DateOfPurchase"].ToString());
double totalPrice = double.Parse(reader["TotalPrice"].ToString());
bool active = bool.Parse(reader["Active"].ToString());
orders.Add(new Order(orderID, customer, dateOfPurchase, totalPrice, active));
}
}
}
return(orders);
}
private void ButtonSearchOrdre_Click(object sender, RoutedEventArgs e)
{
Order order = new Order();
Domain.Customer customer = new Domain.Customer();
WindowShowDialog wsd = new WindowShowDialog();
if (double.TryParse(TextBoxOrderID.Text, out double resultOrderID) || (double.TryParse(TextBoxCustomer.Text, out double resultCustomer) || double.TryParse(TextBoxTotalPrice.Text, out double resultTotalPrice) || DatePickerDateOfPurchase.SelectedDate != null))
{
if (double.TryParse(TextBoxOrderID.Text, out resultOrderID) == false)
{
order.OrderID = 0;
}
else
{
order.OrderID = int.Parse(TextBoxOrderID.Text);
}
if (double.TryParse(TextBoxCustomer.Text, out resultCustomer) == false)
{
order.Customer = new Domain.Customer();
order.Customer.CustomerID = 0;
}
else
{
order.Customer = customer.GetCustomer(int.Parse(TextBoxCustomer.Text));
}
if (double.TryParse(TextBoxTotalPrice.Text, out resultTotalPrice) == false)
{
order.TotalPrice = 0;
}
else
{
order.TotalPrice = double.Parse(TextBoxTotalPrice.Text);
}
if (DatePickerDateOfPurchase.SelectedDate == null)
{
order.DateOfPurchase = new DateTime(1973, 1, 1, 12, 0, 0);
}
else
{
order.DateOfPurchase = DateTime.Parse(DatePickerDateOfPurchase.Text);
}
eventSendList(orderRepository.DisplaySpecificOrders(order));
this.Close();
}
else
{
wsd.LabelShowDialog.Content = "Der var en fejl i 'Order nummer', 'Kunde', 'Samlet pris' eller 'Pakke dato'";
wsd.ShowDialog();
}
}