} //O(1) private void deleteAllOrders(ref LinkedList <Order> orders, DBhandler DBUse) //deletes all orders from DB { while (orders.Count != 0) { DBUse.deleteOrder(orders.ElementAt(0).getOrderID()); orders.RemoveFirst(); } } //O(N)
} //O(1) //Orders related: private void fillOrders() { listViewOrders.Items.Clear(); DBhandler DBUse = new DBhandler(); LinkedList <Order> orders = new LinkedList <Order>(); DBUse.checkOrders(ref orders); for (int run = 0; run < orders.Count; run -= -1) { listViewOrders.Items.Add(new ListViewItem(orders.ElementAt(run).arrayString())); } DBUse = null; orders = null; } //O(N)
} //O(N) //Customer related: private void fillCustomers() { listViewCustomers.Items.Clear(); DBhandler DBUse = new DBhandler(); LinkedList <Customer> customers = new LinkedList <Customer>(); DBUse.checkCustomers(ref customers); for (int run = 0; run < customers.Count; run -= -1) { listViewCustomers.Items.Add(new ListViewItem(customers.ElementAt(run).arrayString())); } DBUse = null; customers = null; } //O(N)
} //O(1) private void orderBtnSave_Click(object sender, EventArgs e) //saves in excel file and deleted all orders from DB { DBhandler DBUse = new DBhandler(); SaveOrders orders2save = new SaveOrders(); LinkedList <Order> orders = new LinkedList <Order>(); DBUse.checkOrders(ref orders); orders2save.Save(orders); deleteAllOrders(ref orders, DBUse); //add auto fill because this is a project DBUse = null; orders = null; orders2save = null; } //O(1)
} //O(1) //Suppliers related: private void fillSuppliers() { listViewSuppliers.Items.Clear(); DBhandler DBUse = new DBhandler(); LinkedList <Supply> suppliers = new LinkedList <Supply>(); DBUse.checkSuppliers(ref suppliers); for (int run = 0; run < suppliers.Count; run -= -1) { listViewSuppliers.Items.Add(new ListViewItem(suppliers.ElementAt(run).arrayString())); } DBUse = null; suppliers = null; } //O(N)
} //O(1) private void fillSupplierItems(int someone) { listViewSupplierItems.Items.Clear(); DBhandler DBUse = new DBhandler(); LinkedList <AllSupplierItems> allSupplierItems = new LinkedList <AllSupplierItems>(); DBUse.allSupplierItems(ref allSupplierItems, someone); for (int run = 0; run < allSupplierItems.Count; run -= -1) { listViewSupplierItems.Items.Add(new ListViewItem(allSupplierItems.ElementAt(run).arrayString())); } DBUse = null; allSupplierItems = null; } //O(N)
} //O(1) //Products related: private void fillListProducts() //cleans & fills from DB the list view { listViewProducts.Items.Clear(); DBhandler DBUse = new DBhandler(); LinkedList <Product> products = new LinkedList <Product>(); DBUse.checkProducts(ref products); for (int run = 0; run < products.Count; run -= -1) { listViewProducts.Items.Add(new ListViewItem(products.ElementAt(run).arrayString())); } DBUse = null; products = null; } //O(N)
} //O(1) private void fillCusOrder(int id) { listViewCusOrder.Items.Clear(); DBhandler DBUse = new DBhandler(); LinkedList <CustomerOrder> allCustomerOrder = new LinkedList <CustomerOrder>(); DBUse.customerOrder(ref allCustomerOrder, id); for (int run = 0; run < allCustomerOrder.Count; run -= -1) { listViewCusOrder.Items.Add(new ListViewItem(allCustomerOrder.ElementAt(run).arrayString())); } DBUse = null; allCustomerOrder = null; } //O(N)
} //O(1) private void orderBtnDel_Click(object sender, EventArgs e) { orderStatusMsglbl.Text = ""; DBhandler DBUse = new DBhandler(); int product = 0; orderStatusMsglbl.Text += orderIDtxt.Text.Trim().Length == 0 ? "Missing Order ID.\n" : ""; orderStatusMsglbl.Text += !int.TryParse(orderIDtxt.Text, out product) && orderIDtxt.Text.Trim().Length != 0 ? "Not a number for Order ID.\n" : ""; if (orderStatusMsglbl.Text.Length == 0) { DBUse.deleteOrder(product); fillOrders(); } ordersClearTxt(); DBUse = null; } //O(1)
} //O(1) private void proBtnDel_Click(object sender, EventArgs e) //deleted a products, if product doesn't exsits does { proStatusMsglbl.Text = ""; DBhandler DBUse = new DBhandler(); int product = 0; proStatusMsglbl.Text += proNumtxt.Text.Trim().Length == 0 ? "Missing Product Number.\n" : ""; proStatusMsglbl.Text += !int.TryParse(proNumtxt.Text, out product) && proNumtxt.Text.Trim().Length != 0 ? "Not a number for Product number.\n" : ""; proStatusMsglbl.Text += product != 0 && DBUse.isProductOrderd(product) ? "Product is ordered.\nNeed to delivere or cancel order first." : ""; if (proStatusMsglbl.Text.Length == 0) { DBUse.deleteProduct(product); fillListProducts(); } productClearTxt(); DBUse = null; } //O(1)
private void supBtnDel_Click(object sender, EventArgs e) { supStatusMsglbl.Text = ""; DBhandler DBUse = new DBhandler(); int id = 0; supStatusMsglbl.Text += supIDtxt.Text.Trim().Length == 0 ? "Missing Supplier ID.\n" : ""; supStatusMsglbl.Text += !int.TryParse(supIDtxt.Text, out id) && supIDtxt.Text.Trim().Length != 0 ? "Not a number for ID.\n" : ""; supStatusMsglbl.Text += id != 0 && DBUse.isSupplierGotItems(id) ? "Supplier got items can't.\nBe deleted.\n" : ""; if (supStatusMsglbl.Text.Length == 0) { DBUse.deleteSupplier(id); fillSuppliers(); } DBUse = null; supplierClearTxt(); } //O(1)
} //O(1) private void cusBtnDel_Click(object sender, EventArgs e) { cusStatusMsglbl.Text = ""; DBhandler DBUse = new DBhandler(); int id = 0; cusStatusMsglbl.Text += cusIDtxt.Text.Trim().Length == 0 ? "Missing Customer ID.\n" : ""; cusStatusMsglbl.Text += !int.TryParse(cusIDtxt.Text, out id) && cusIDtxt.Text.Trim().Length != 0 ? "Not a number for ID.\n" : ""; cusStatusMsglbl.Text += id != 0 && DBUse.isCustomerOrdered(id) ? "Customer can't be deleted.\nCustomer got order/s.\n" : ""; if (cusStatusMsglbl.Text.Length == 0) { DBUse.deleteCustomer(id); fillCustomers(); } DBUse = null; customerClearTxt(); } //O(1)
} //O(1) private void orderBtnUp_Click(object sender, EventArgs e) { orderStatusMsglbl.Text = ""; DBhandler DBUse = new DBhandler(); int order = 0, amount = 0; orderStatusMsglbl.Text += orderIDtxt.Text.Trim().Length == 0 ? "Missing Order Number.\n" : ""; orderStatusMsglbl.Text += orderAmounttxt.Text.Trim().Length == 0 ? "Missing Quantity.\n" : ""; orderStatusMsglbl.Text += !int.TryParse(orderIDtxt.Text, out order) && orderIDtxt.Text.Trim().Length != 0 ? "Not a number for Order ID.\n" : ""; orderStatusMsglbl.Text += !int.TryParse(orderAmounttxt.Text, out amount) && orderAmounttxt.Text.Trim().Length != 0 ? "Not a number for Quantity.\n" : ""; if (orderStatusMsglbl.Text.Length == 0) { DBUse.updateOrder(order, amount); //if there is no order for the input number nothing happenes fillOrders(); } ordersClearTxt(); DBUse = null; } //O(1)
} //O(1) private void supBtnAdd_Click(object sender, EventArgs e) { supStatusMsglbl.Text = ""; DBhandler DBUse = new DBhandler(); int id = 0; supStatusMsglbl.Text += supIDtxt.Text.Trim().Length == 0 ? "Missing Supplier ID.\n" : ""; supStatusMsglbl.Text += supFNametxt.Text.Trim().Length == 0 ? "Missing First name.\n" : ""; supStatusMsglbl.Text += supLNametxt.Text.Trim().Length == 0 ? "Missing Last name.\n" : ""; supStatusMsglbl.Text += supMailtxt.Text.Trim().Length == 0 ? "Missing Mail.\n" : ""; supStatusMsglbl.Text += !int.TryParse(supIDtxt.Text, out id) && supIDtxt.Text.Trim().Length != 0 ? "Not a number for ID.\n" : ""; if (supStatusMsglbl.Text.Length == 0) { DBUse.addSupplier(id, supFNametxt.Text.Trim(), supLNametxt.Text.Trim(), supMailtxt.Text.Trim()); fillSuppliers(); } DBUse = null; supplierClearTxt(); } //O(1)
private void cusBtnAdd_Click(object sender, EventArgs e) { cusStatusMsglbl.Text = ""; DBhandler DBUse = new DBhandler(); int id = 0; cusStatusMsglbl.Text += cusIDtxt.Text.Trim().Length == 0 ? "Missing Customer ID.\n" : ""; cusStatusMsglbl.Text += cusFNametxt.Text.Trim().Length == 0 ? "Missing First name.\n" : ""; cusStatusMsglbl.Text += cusLNametxt.Text.Trim().Length == 0 ? "Missing Last name.\n" : ""; cusStatusMsglbl.Text += cusPhonetxt.Text.Trim().Length == 0 ? "Missing Phone number.\n" : ""; cusStatusMsglbl.Text += cusCitytxt.Text.Trim().Length == 0 ? "Missing City name.\n" : ""; cusStatusMsglbl.Text += !int.TryParse(cusIDtxt.Text, out id) && cusIDtxt.Text.Trim().Length != 0 ? "Not a number for ID.\n" : ""; if (cusStatusMsglbl.Text.Length == 0) { DBUse.addCustomer(id, cusFNametxt.Text.Trim(), cusLNametxt.Text.Trim(), cusPhonetxt.Text.Trim(), cusCitytxt.Text.Trim()); fillCustomers(); } DBUse = null; customerClearTxt(); } //O(1)
} //O(1) private void proBtnAdd_Click(object sender, EventArgs e) //add/update a product, changed after submition { proStatusMsglbl.Text = string.Empty; DBhandler DBUse = new DBhandler(); int product = 0, supplier = 0; //making sure all values are correct proStatusMsglbl.Text += proNumtxt.Text.Trim().Length == 0 ? "Missing Product Number.\n" : ""; proStatusMsglbl.Text += proNametxt.Text.Trim().Length == 0 ? "Missing Product Name.\n" : ""; proStatusMsglbl.Text += proSupIDtxt.Text.Trim().Length == 0 ? "Missing Supplier ID.\n" : ""; proStatusMsglbl.Text += !int.TryParse(proNumtxt.Text, out product) && proNumtxt.Text.Trim().Length != 0 ? "Not a number for Product number.\n" : ""; proStatusMsglbl.Text += !int.TryParse(proSupIDtxt.Text, out supplier) && proSupIDtxt.Text.Trim().Length != 0 ? "Not a number for Supplier ID.\n" : ""; proStatusMsglbl.Text += DBUse.supplierExists(supplier) && supplier != 0 ? "Supplier doesn't exits\n" : ""; proStatusMsglbl.Text += product != 0 && DBUse.isProductOrderd(product) ? "Product is ordered.\nNeed to delivere or cancel order first." : ""; //change added after submition date if (proStatusMsglbl.Text.Length == 0) { DBUse.addProduct(product, proNametxt.Text.Trim(), supplier); fillListProducts(); //Clears and refill the listview after added/updated } productClearTxt(); DBUse = null; } //O(1)
} //O(1) private void orderBtnAdd_Click(object sender, EventArgs e) { orderStatusMsglbl.Text = ""; DBhandler DBUse = new DBhandler(); int product = 0, customer = 0, amount = 0; orderStatusMsglbl.Text += orderProNumtxt.Text.Trim().Length == 0 ? "Missing Product Number.\n" : ""; orderStatusMsglbl.Text += orderCusIDtxt.Text.Trim().Length == 0 ? "Missing Customer ID.\n" : ""; orderStatusMsglbl.Text += orderAmounttxt.Text.Trim().Length == 0 ? "Missing Quantity.\n" : ""; orderStatusMsglbl.Text += !int.TryParse(orderProNumtxt.Text, out product) && orderProNumtxt.Text.Trim().Length != 0 ? "Not a number for Product number.\n" : ""; orderStatusMsglbl.Text += !int.TryParse(orderCusIDtxt.Text, out customer) && orderCusIDtxt.Text.Trim().Length != 0 ? "Not a number for Customer ID.\n" : ""; orderStatusMsglbl.Text += !int.TryParse(orderAmounttxt.Text, out amount) && orderAmounttxt.Text.Trim().Length != 0 ? "Not a number for Quantity.\n" : ""; orderStatusMsglbl.Text += customer != 0 && DBUse.isCustomerExists(customer) ? "Customer doesn't exsits.\n" : ""; orderStatusMsglbl.Text += product != 0 && DBUse.isProductExists(product) ? "Product doesn't exsits.\n" : ""; if (orderStatusMsglbl.Text.Length == 0) { DBUse.addOrder(product, customer, amount); fillOrders(); } ordersClearTxt(); DBUse = null; } //O(1)