public static void fillCustomerIdCombobox(ComboBox customerIdComboBox)
 {
     foreach (var customerId in NewOrderDAO.getCustomerIds())
     {
         customerIdComboBox.Items.Add(customerId);
     }
 }
        public static void addNewOrder(MyTextBox locationTextbox, ComboBox paymentMethod, DateTimePicker orderDatePicker,
                                       ComboBox customerIdsComboBox, BindingNavigator bindingNavigatorOrders, NewOrder newOrderForm)
        {
            if (!validateFields(locationTextbox, paymentMethod, customerIdsComboBox))
            {
                return;
            }

            try
            {
                int last_page = bindingNavigatorOrders.BindingSource.Count;

                NewOrderDAO.addNewOrder(locationTextbox.Text, paymentMethod.GetItemText(paymentMethod.SelectedItem),
                                        orderDatePicker.Value.Date, customerIdsComboBox.GetItemText(customerIdsComboBox.SelectedItem));


                foreach (KeyValuePair <string, Label> entry in App.GetOrderLabels())
                {
                    entry.Value.DataBindings.Clear();
                }

                db.BindOrderData(App.GetOrderLabels(), bindingNavigatorOrders);

                bindingNavigatorOrders.BindingSource.Position = last_page;

                // Added!
                newOrderForm.Close();
            }
            catch (SqlException e)
            {
                ViewMessages.ExceptionOccured(e);
            }
        }
 public static bool customerCanBeDeleted(string customerId)
 {
     foreach (var id in NewOrderDAO.getCustomerIdsInOrdersProductsTable())
     {
         if (id.Equals(customerId))
         {
             return(false);
         }
     }
     return(true);
 }