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 void AddNewCustomer(Dictionary <string, MyTextBox> newCustomerTextboxes, DateTime birthDate,
RichTextBox comments_richTextbox, BindingNavigator bindingNavigatorCustomers, NewCustomer newCustomerForm)
{
if (!ValidateFields(newCustomerTextboxes, true))
{
return;
}
// Refresh the Binding Navigator if customer was added succesfully
try
{
int last_page = bindingNavigatorCustomers.BindingSource.Count;
NewCustomerDAO.AddNewCustomer(newCustomerTextboxes, birthDate, comments_richTextbox);
foreach (KeyValuePair <string, Label> entry in App.GetCustomerLabels())
{
entry.Value.DataBindings.Clear();
}
db.BindCustomerData(App.GetCustomerLabels(), App.getCommentsRichTextbox(), bindingNavigatorCustomers);
bindingNavigatorCustomers.BindingSource.Position = last_page;
// Added!
newCustomerForm.Close();
}
catch (SqlException e)
{
ViewMessages.ExceptionOccured(e);
}
}
public static void updateOrdersProducts(TextBox amountTextbox, BindingNavigator bindingNavigatorOrdersProducts,
UpdateOrdersProducts updateOrdersProductsForm, int idOrder, int idProduct)
{
float n;
if (!float.TryParse(amountTextbox.Text, out n))
{
ViewMessages.AmountNotValid();
return;
}
try
{
int currentPage = bindingNavigatorOrdersProducts.BindingSource.Position;
UpdateOrdersProductsDAO.updateOrdersProducts(float.Parse(amountTextbox.Text), idOrder, idProduct);
foreach (KeyValuePair <string, Label> entry in App.GetOrdersProductsLabels())
{
entry.Value.DataBindings.Clear();
}
db.BindOrdersProductsData(App.GetOrdersProductsLabels(), bindingNavigatorOrdersProducts);
bindingNavigatorOrdersProducts.BindingSource.Position = currentPage;
// Updated!
updateOrdersProductsForm.Close();
}
catch (SqlException e)
{
ViewMessages.ExceptionOccured(e);
}
}
public static void updateProduct(Dictionary <String, TextBox> productValueLabels, BindingNavigator bindingNavigatorProducts,
UpdateProduct updateProductForm, int productId)
{
if (!validateFields(productValueLabels))
{
return;
}
try
{
int currentPage = bindingNavigatorProducts.BindingSource.Position;
UpdateProductDAO.updateProduct(productValueLabels["LABEL"].Text, productValueLabels["CATEGORY"].Text, int.Parse(productValueLabels["RESERVE"].Text),
float.Parse(productValueLabels["SELLING_PRICE"].Text), productValueLabels["MANUFACTURER"].Text, productId);
foreach (KeyValuePair <string, Label> entry in App.GetProductLabels())
{
entry.Value.DataBindings.Clear();
}
db.BindProductsData(App.GetProductLabels(), bindingNavigatorProducts);
bindingNavigatorProducts.BindingSource.Position = currentPage;
// Updated!
updateProductForm.Close();
}
catch (SqlException e)
{
ViewMessages.ExceptionOccured(e);
}
}
public static void updateOrder(ComboBox customerId_combobox, ComboBox paymentMethod_combobox, TextBox location_Textbox, DateTimePicker orderDatePicker,
BindingNavigator bindingNavigatorOrders, UpdateOrder updateOrderForm, int orderId)
{
if (!validateFields(customerId_combobox, paymentMethod_combobox, location_Textbox))
{
return;
}
try
{
int currentPage = bindingNavigatorOrders.BindingSource.Position;
UpdateOrderDAO.updateOrder(orderDatePicker.Value.Date, Int32.Parse(customerId_combobox.GetItemText(customerId_combobox.SelectedItem)),
paymentMethod_combobox.GetItemText(paymentMethod_combobox.SelectedItem), location_Textbox.Text, orderId);
foreach (KeyValuePair <string, Label> entry in App.GetOrderLabels())
{
entry.Value.DataBindings.Clear();
}
db.BindOrderData(App.GetOrderLabels(), bindingNavigatorOrders);
bindingNavigatorOrders.BindingSource.Position = currentPage;
// Updated!
updateOrderForm.Close();
}
catch (SqlException e)
{
ViewMessages.ExceptionOccured(e);
}
}
public static void UpdateCustomer(PictureBox pictureBox, Dictionary <String, MyTextBox> updateCustomerTextboxes, Dictionary <String, Label> customerValueLabels,
PictureBox customerPictureBox, RichTextBox comments_richTextbox, DateTime birthDate, BindingNavigator bindingNavigatorCustomers, UpdateCustomer updateCustomerForm)
{
if (!NewCustomerController.ValidateFields(updateCustomerTextboxes, !updateCustomerTextboxes["AFM"].Text.Equals(customerValueLabels["AFM"].Text)))
{
return;
}
// Refresh the Binding Navigator if customer was updated succesfully
try
{
UpdateCustomerDAO.UpdateCustomer(pictureBox, comments_richTextbox, birthDate, updateCustomerTextboxes, Int32.Parse(customerValueLabels["CUSTOMER_ID"].Text));
int currentPage = bindingNavigatorCustomers.BindingSource.Position;
foreach (KeyValuePair <String, Label> entry in App.GetCustomerLabels())
{
entry.Value.DataBindings.Clear();
}
db.BindCustomerData(App.GetCustomerLabels(), App.getCommentsRichTextbox(), bindingNavigatorCustomers);
bindingNavigatorCustomers.BindingSource.Position = currentPage;
AppDAO.LoadCustomerPhoto(customerPictureBox, Int32.Parse(customerValueLabels["CUSTOMER_ID"].Text));
// Updated!
updateCustomerForm.Close();
}
catch (SqlException e)
{
ViewMessages.ExceptionOccured(e);
}
}
public static void addNewProduct(Dictionary <String, TextBox> newProductTextboxes, BindingNavigator productsBindingNavigator, NewProduct newProductForm)
{
if (!validateFields(newProductTextboxes))
{
return;
}
try
{
int last_page = productsBindingNavigator.BindingSource.Count;
NewProductDAO.addNewProduct(newProductTextboxes["LABEL"].Text, newProductTextboxes["CATEGORY"].Text, Int32.Parse(newProductTextboxes["RESERVE"].Text),
float.Parse(newProductTextboxes["SELLING_PRICE"].Text), newProductTextboxes["MANUFACTURER"].Text);
foreach (KeyValuePair <string, Label> entry in App.GetProductLabels())
{
entry.Value.DataBindings.Clear();
}
db.BindProductsData(App.GetProductLabels(), productsBindingNavigator);
productsBindingNavigator.BindingSource.Position = last_page;
// Added!
newProductForm.Close();
}
catch (SqlException e)
{
ViewMessages.ExceptionOccured(e);
}
}
public static bool validateFields(Dictionary <String, TextBox> newProductTextboxes)
{
if (newProductTextboxes["SELLING_PRICE"].Text.Equals("") || newProductTextboxes["LABEL"].Text.Equals("") ||
newProductTextboxes["RESERVE"].Text.Equals(""))
{
ViewMessages.FillRequiredFields();
return(false);
}
int n;
if (!int.TryParse(newProductTextboxes["RESERVE"].Text, out n))
{
ViewMessages.ReserveNotValid();
return(false);
}
float k;
if (!float.TryParse(newProductTextboxes["SELLING_PRICE"].Text, out k))
{
ViewMessages.SellingPriceNotValid();
return(false);
}
return(true);
}
public static bool validateFields(ComboBox customerId_combobox, ComboBox paymentMethod_combobox, TextBox deliveryLocation)
{
if (deliveryLocation.Text.Equals("") || paymentMethod_combobox.GetItemText(paymentMethod_combobox.SelectedItem).Equals("") ||
customerId_combobox.GetItemText(customerId_combobox.SelectedItem).Equals(""))
{
ViewMessages.FillRequiredFields();
return(false);
}
return(true);
}
public static bool validateFields(MyTextBox locationTextbox, ComboBox paymentMethod, ComboBox customerIdsComboBox)
{
if (locationTextbox.Text.Equals("") || paymentMethod.GetItemText(paymentMethod.SelectedItem).Equals("") ||
customerIdsComboBox.GetItemText(customerIdsComboBox.SelectedItem).Equals(""))
{
ViewMessages.FillRequiredFields();
return(false);
}
return(true);
}
public static void DeleteRelationship(Dictionary <string, Label> ordersProductsValueLabels, BindingNavigator bindingNavigatorOrdersProducts)
{
if (ViewMessages.DeleteRelationshipDialog() == DialogResult.No)
{
return;
}
AppDAO.DeleteRelationship(Int32.Parse(ordersProductsValueLabels["ORDER_ID_F"].Text));
foreach (KeyValuePair <string, Label> entry in ordersProductsValueLabels)
{
entry.Value.DataBindings.Clear();
}
db.BindOrdersProductsData(ordersProductsValueLabels, bindingNavigatorOrdersProducts);
}
public static bool ValidateFields(Dictionary <string, MyTextBox> newCustomerTextboxes, bool checkAfm)
{
// Check for AFM input
string afm = newCustomerTextboxes["AFM"].Text.Trim();
if (!Int32.TryParse(afm, out int n))
{
ViewMessages.NonIntegerAfm();
return(false);
}
if (afm.Length != 9)
{
ViewMessages.InvalidAfm();
return(false);
}
if (checkAfm)
{
if (NewCustomerDAO.afmExists(afm))
{
ViewMessages.AfmExists();
return(false);
}
}
//Validate Last Name
if (newCustomerTextboxes["LAST_NAME"].Text.Trim().Length < 3)
{
ViewMessages.LastNameTooSmall();
return(false);
}
//Validate First Name
if (newCustomerTextboxes["FIRST_NAME"].Text.Trim().Length < 3)
{
ViewMessages.FirstNameTooSmall();
return(false);
}
return(true);
}
public static void DeleteProduct(Dictionary <string, Label> productValueLabels, BindingNavigator bindingNavigatorProduct)
{
if (!productCanBeDeleted(productValueLabels["PRODUCT_ID"].Text))
{
ViewMessages.CannotDeleteProduct();
return;
}
if (ViewMessages.DeleteProductDialog() == DialogResult.No)
{
return;
}
AppDAO.DeleteProduct(Int32.Parse(productValueLabels["PRODUCT_ID"].Text));
foreach (KeyValuePair <string, Label> entry in productValueLabels)
{
entry.Value.DataBindings.Clear();
}
db.BindProductsData(productValueLabels, bindingNavigatorProduct);
}
public static void DeleteOrder(Dictionary <string, Label> orderValueLabels, BindingNavigator bindingNavigatorOrder)
{
if (!orderCanBeDeleted(orderValueLabels["ORDER_ID"].Text))
{
ViewMessages.CannotDeleteOrder();
return;
}
if (ViewMessages.DeleteOrderDialog() == DialogResult.No)
{
return;
}
AppDAO.DeleteOrder(Int32.Parse(orderValueLabels["ORDER_ID"].Text));
foreach (KeyValuePair <string, Label> entry in orderValueLabels)
{
entry.Value.DataBindings.Clear();
}
db.BindOrderData(orderValueLabels, bindingNavigatorOrder);
}
public static void DeleteCustomer(Dictionary <string, Label> customerValueLabels, RichTextBox commentsRichTextBox, BindingNavigator bindingNavigatorCustomer)
{
if (!customerCanBeDeleted(customerValueLabels["CUSTOMER_ID"].Text))
{
ViewMessages.CannotDeleteCustomer();
return;
}
if (ViewMessages.DeleteCustomerDialog() == DialogResult.No)
{
return;
}
AppDAO.DeleteCustomer(Int32.Parse(customerValueLabels["CUSTOMER_ID"].Text));
foreach (KeyValuePair <string, Label> entry in customerValueLabels)
{
entry.Value.DataBindings.Clear();
}
db.BindCustomerData(customerValueLabels, commentsRichTextBox, bindingNavigatorCustomer);
}
public static bool validateFields(TextBox amount, ComboBox orderIdComboBox, ComboBox productIdComboBox)
{
if (amount.Text.Equals("") || orderIdComboBox.GetItemText(orderIdComboBox.SelectedItem).Equals("") ||
productIdComboBox.GetItemText(productIdComboBox.SelectedItem).Equals(""))
{
ViewMessages.FillRequiredFields();
return(false);
}
float n;
if (!float.TryParse(amount.Text, out n))
{
ViewMessages.AmountNotValid();
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);
}
}