private void CatAdd_Click(object sender, RoutedEventArgs e) { if (CategoryName.Text == "" || CategoryNumber.Text == "" || CategoryDescription.Text == "") { MessageBox.Show("All fields are required"); } else { dataAccess data = new dataAccess(); if (MessageBox.Show("Continue to add a new category ??", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No) { //do no stuff } else { if (CategoryNumber.IsEnabled == false && CategoryNumber.IsReadOnly == true) { MessageBox.Show("Category Number Field is Enabled now Enter the Category Number of a new Category"); CategoryNumber.IsEnabled = true; CategoryNumber.IsReadOnly = false; CategoryName.IsEnabled = false; CategoryName.IsReadOnly = true; CategoryDescription.IsEnabled = false; CategoryDescription.IsReadOnly = true; btnSearch.IsEnabled = false; CatDelete.IsEnabled = false; CatEdit.IsEnabled = false; } else if (CategoryNumber.IsEnabled == true && CategoryNumber.IsReadOnly == false) { string status = data.insertCategories(int.Parse(CategoryNumber.Text), CategoryName.Text, CategoryDescription.Text); if (status.Equals("Unsuccessful")) { MessageBox.Show("This category already exists, Try Inserting a new one"); CategoryNumber.IsEnabled = true; CategoryNumber.IsReadOnly = false; } else if (status.Equals("Successful")) { MessageBox.Show("New Category Inserted"); CategoryNumber.IsEnabled = false; CategoryNumber.IsReadOnly = true; CategoryName.IsReadOnly = false; CategoryName.IsEnabled = true; CategoryDescription.IsEnabled = true; CategoryDescription.IsReadOnly = false; btnSearch.IsEnabled = true; CatDelete.IsEnabled = true; CatEdit.IsEnabled = true; CategoryNumber.Text = ""; CategoryName.Text = ""; CategoryDescription.Text = ""; } else { MessageBox.Show("Exception Error"); } } } } }