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