private void btnAddOrder_Click(object sender, RoutedEventArgs e) { object selectedObject = lbSelectCustomerList.SelectedItem; if (selectedObject == null) { MessageBox.Show(this, "Geen klant geselecteerd!", "Onvoldoende gegevens", MessageBoxButton.OK, MessageBoxImage.Error); return; } Customer customer = (Customer)selectedObject; DateTime dateTimeOrdered = DateTime.Now; DateTime dateTimePickup = dpPickupDate.SelectedDate.GetValueOrDefault(DateTime.Now); dateTimePickup = dateTimePickup.AddHours(timeHours); dateTimePickup = dateTimePickup.AddMinutes(timeMinutes); Employee employee = new Employee("iedereen", 1); string description = tbDescription.Text; Order order = new Order(customer, dateTimeOrdered, dateTimePickup, employee, description); if (access.AddOrder(order)) { MessageBox.Show(this, "Order succesvol toegevoegd!", "Succes", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBox.Show(this, "Order kon niet toegevoegd worden!", "Fout", MessageBoxButton.OK, MessageBoxImage.Error); } }
public Order(Customer customer, DateTime dateTimeOrdered, DateTime dateTimePickup, Employee employee, string description, int internalID) { this.customer = customer; this.dateTimeOrdered = dateTimeOrdered; this.dateTimePickup = dateTimePickup; this.employee = employee; this.description = description; this.internalID = internalID; }
public Order(Customer customer, DateTime dateTimeOrdered, DateTime dateTimePickup, Employee employee, string description, Order_Entry[] order_entries) { this.customer = customer; this.dateTimeOrdered = dateTimeOrdered; this.dateTimePickup = dateTimePickup; this.employee = employee; this.description = description; this.order_entries = order_entries; this.internalID = -1; }
public bool GetOrdersByEmployee(Employee employee, out Order[] orders) { try { using (IDbConnection connection = MySQLDAOFactory.GetDatabase().CreateOpenConnection()) { string query = "SELECT * FROM " + MySQLDAOFactory.DatabaseName + ".order WHERE order.employee_id = '" + employee.internalID.ToString() + "'"; using (IDbCommand command = MySQLDAOFactory.GetDatabase().CreateCommand(query, connection)) { using (IDataReader reader = command.ExecuteReader()) { List<Order> ordersList = new List<Order>(); while (reader.Read()) { DateTime ordered_datetime; DateTime pickup_datetime; if (DateTime.TryParseExact(reader["ordered_datetime"].ToString(), dateFormatReading, System.Globalization.CultureInfo.CurrentCulture, System.Globalization.DateTimeStyles.AssumeLocal, out ordered_datetime) && DateTime.TryParseExact(reader["pickup_datetime"].ToString(), dateFormatReading, System.Globalization.CultureInfo.CurrentCulture, System.Globalization.DateTimeStyles.AssumeLocal, out pickup_datetime)) { Order o = new Order( new Customer("", "", "", "", "", "", Convert.ToInt32(reader["customerid"])), ordered_datetime, pickup_datetime, employee, reader["description"].ToString(), Convert.ToInt32(reader["idorder"]) ); ordersList.Add(o); } else { throw new Exception("Couldn't cast to datetime!"); } } orders = ordersList.ToArray(); if (orders.Length > 0) { return true; } return false; } } } } catch (MySqlException ex) { throw new DatabaseException(ex.Message, ex); } catch (Exception ex) { throw ex; } }
public bool GetOrdersByEmployee(Employee employee, out Order[] orders) { OrderDAO dao = daoFactory.GetOrderDAO(); try { return dao.GetOrdersByEmployee(employee, out orders); } catch (DatabaseException ex) { throw ex; } catch (Exception ex) { throw ex; } }