public static void fillcombobox(ComboBox productIdComboBox) { foreach (var orderId in NewOrdersProductsDAO.getOrdersIds()) { productIdComboBox.Items.Add(orderId); } }
public static bool productCanBeDeleted(string productId) { foreach (var id in NewOrdersProductsDAO.getProductIdsInOrdersProductsTable()) { if (id.Equals(productId)) { return(false); } } return(true); }
public static void addNewOrdersProducts(TextBox amountTextBox, ComboBox orderIdComboBox, ComboBox productIdComboBox, BindingNavigator bindingNavigatorOrdersProducts, NewOrdersProducts newOrderProductsForm) { if (!validateFields(amountTextBox, orderIdComboBox, productIdComboBox)) { return; } try { int last_page = bindingNavigatorOrdersProducts.BindingSource.Count; int orderId = Int32.Parse(orderIdComboBox.GetItemText(orderIdComboBox.SelectedItem)); int productId = Int32.Parse(productIdComboBox.GetItemText(productIdComboBox.SelectedItem)); float amount = float.Parse(amountTextBox.Text); // Check for DUPLICATE KEY if (NewOrdersProductsDAO.checkIfKeyAlreadyExists(orderId, productId)) { ViewMessages.DuplicateKeyError(); return; } NewOrdersProductsDAO.addNewOrdersProducts(orderId, productId, amount); foreach (KeyValuePair <string, Label> entry in App.GetOrdersProductsLabels()) { entry.Value.DataBindings.Clear(); } db.BindOrdersProductsData(App.GetOrdersProductsLabels(), bindingNavigatorOrdersProducts); bindingNavigatorOrdersProducts.BindingSource.Position = last_page; // Added! newOrderProductsForm.Close(); } catch (SqlException e) { ViewMessages.ExceptionOccured(e); } }