Esempio n. 1
0
        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");
                        }
                    }
                }
            }
        }