private void BtnSearch_Click(object sender, RoutedEventArgs e) { //Search Supplier dataAccess data = new dataAccess(); table = new DataTable(); if (Search.Text.Equals("") || Search.Text.Equals(null)) { MessageBox.Show("Search Field is Empty , Enter the Search Field Value"); } else { table = data.getSupplier(int.Parse(Search.Text)); if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { SupplierID.Text = row["SupplierID"].ToString(); CompanyName.Text = row["CompanyName"].ToString(); Address.Text = row["Address"].ToString(); City.Text = row["City"].ToString(); Region.Text = row["Region"].ToString(); Postal.Text = row["PostalCode"].ToString(); Country.Text = row["Country"].ToString(); Email.Text = row["Email"].ToString(); Phone.Text = row["Phone"].ToString(); } } else { MessageBox.Show("Employee Not Found !!"); } } }
private void ProdAdd_Click(object sender, RoutedEventArgs e) { if (ProductID.Text == "" || ProductName.Text =="" || QuantityPerUnit.Text =="" || CategoryID.Text == "" || UnitPrice.Text =="" || UnitInStock.Text =="" || ReorderLevel.Text =="" || SupplierID.Text =="" || Discontinued.Text =="") { MessageBox.Show("All Fields are required to be filled"); } else { dataAccess data = new dataAccess(); if (MessageBox.Show("Continue to add a new Product ??", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No) { //do no stuff } else { if (ProductID.IsEnabled == false && ProductID.IsReadOnly == true) { MessageBox.Show("Product Barcode Number Field is Enabled now Enter the Barcode of a new Product"); ProductID.IsEnabled = true; ProductID.IsReadOnly = false; ProductName.IsEnabled = false; ProductName.IsReadOnly = true; SupplierID.IsEnabled = false; SupplierID.IsReadOnly = true; CategoryID.IsEnabled = false; CategoryID.IsReadOnly = true; QuantityPerUnit.IsEnabled = false; QuantityPerUnit.IsReadOnly = true; UnitPrice.IsEnabled = false; UnitPrice.IsReadOnly = true; UnitInStock.IsEnabled = false; UnitInStock.IsReadOnly = true; ReorderLevel.IsEnabled = false; ReorderLevel.IsReadOnly = true; Discontinued.IsEnabled = false; Discontinued.IsReadOnly = true; ProdEdit.IsEnabled = false; ProdDelete.IsEnabled = false; } else if (ProductID.IsEnabled == true && ProductID.IsReadOnly == false) { table = new DataTable(); categories cat = new categories(); cat.CategoryID = int.Parse(CategoryID.Text); table = data.getCategory(cat); for (int a = 0; a < table.Rows.Count; a++) { if (table.Rows[a]["CategoryID"].ToString().Equals(CategoryID.Text)) { //Exist good table = new DataTable(); table = data.getSupplier(int.Parse(SupplierID.Text)); for (int b = 0; b < table.Rows.Count; b++) { if (table.Rows[b]["SupplierID"].ToString().Equals(SupplierID.Text)) { // exist good string status = data.insertProduct(long.Parse(ProductID.Text), ProductName.Text, int.Parse(SupplierID.Text), Int32.Parse(CategoryID.Text), Int32.Parse(QuantityPerUnit.Text), double.Parse(UnitPrice.Text), Int32.Parse(UnitInStock.Text), Int32.Parse(ReorderLevel.Text), Discontinued.Text); if (status.Equals("Successful")) { MessageBox.Show("New Product Inserted"); ProductID.IsEnabled = false; ProductID.IsReadOnly = true; ProductName.IsEnabled = true; ProductName.IsReadOnly = false; SupplierID.IsEnabled = true; SupplierID.IsReadOnly = false; CategoryID.IsEnabled = true; CategoryID.IsReadOnly = false; QuantityPerUnit.IsEnabled = true; QuantityPerUnit.IsReadOnly = false; UnitPrice.IsEnabled = true; UnitPrice.IsReadOnly = false; UnitInStock.IsEnabled = true; UnitInStock.IsReadOnly = false; ReorderLevel.IsEnabled = true; ReorderLevel.IsReadOnly = false; Discontinued.IsEnabled = true; Discontinued.IsReadOnly = false; ProdEdit.IsEnabled = true; ProdDelete.IsEnabled = true; } else if (status.Equals("Unsuccessful")) { MessageBox.Show("The Product Already Exist"); } } else if (table.Rows[b]["SupplierID"].ToString() != (SupplierID.Text)) { MessageBox.Show("Entered Supplier ID does not Exist"); } } } else if (table.Rows[a]["CategoryID"].ToString() != (CategoryID.Text)) { MessageBox.Show("Entered Category ID does not exist"); } } } } } //data.insertProduct(Int32.Parse(ProductID.Text), ProductName.Text, int.Parse(SupplierID.Text), Int32.Parse(CategoryID.Text), // Int32.Parse(QuantityPerUnit.Text), double.Parse(UnitPrice.Text), Int32.Parse(UnitInStock.Text), Int32.Parse(ReorderLevel.Text), // Discontinued.Text); //MessageBox.Show("Products Inserted"); }