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