Пример #1
0
 // funkcja akceptacji zawartości textboxa, potrzebnej do wyszukiwania jej w bazie danych
 private void textBox10_KeyUp(object sender, KeyEventArgs e)
 {
     if (e.Key == Key.Return)
     {
         if (ifWorkersClicked == true && textBox10.Text != "")
         {
             DataTable tempDT = Workers.FilterWorkers(textBox10.Text);
             View_workers_database.ItemsSource = tempDT.DefaultView;
         }
         else if (ifWorkersClicked == true && textBox10.Text == "")
         {
             DataTable tempDT = Workers.ShowWorkers();
             View_workers_database.ItemsSource = tempDT.DefaultView;
         }
         if (ifClientsClicked == true && textBox10.Text != "")
         {
             DataTable tempDT = Clients.FilterClients(textBox10.Text);
             View_clients_database.ItemsSource = tempDT.DefaultView;
         }
         else if (ifClientsClicked == true && textBox10.Text == "")
         {
             DataTable tempDT = Clients.ShowClients();
             View_clients_database.ItemsSource = tempDT.DefaultView;
         }
         if (ifCarsClicked == true && textBox10.Text != "")
         {
             DataTable tempDT = Cars.FilterCars(textBox10.Text);
             View_cars_database.ItemsSource = tempDT.DefaultView;
         }
         else if (ifCarsClicked == true && textBox10.Text == "")
         {
             DataTable tempDT = Cars.ShowCars();
             View_cars_database.ItemsSource = tempDT.DefaultView;
         }
     }
 }
Пример #2
0
        // obsługa przycisku potwierdzającego wykonanie operacji i odpowiednie działanie na konkretnej bazie danych
        private void button_confirm_Click(object sender, RoutedEventArgs e)
        {
            int salary;
            int phoneNr;
            int id;
            int yearofprod;
            int miles;
            int horses;

            // dla pracowników
            if (ifAddClicked == true && ifWorkersClicked == true)
            {
                if (Int32.TryParse(textBox5.Text, out salary) && Int32.TryParse(textBox7.Text, out phoneNr))
                {
                    Workers.AddWorker(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, salary, textBox6.Text, phoneNr, textBox8.Text);
                }
                if (Workers.ifCorrect)
                {
                    MessageBox.Show("data inserted", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Workers.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }
            if (ifRemoveClicked == true && ifWorkersClicked == true)
            {
                if (Int32.TryParse(textBox1.Text, out id))
                {
                    Workers.RemoveWorker(id);
                }
                if (Workers.ifCorrect)
                {
                    MessageBox.Show("data removed", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Workers.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }
            if (ifEditClicked == true && ifWorkersClicked == true)
            {
                if (Int32.TryParse(textBox5.Text, out salary) && Int32.TryParse(textBox7.Text, out phoneNr) && Int32.TryParse(textBox9.Text, out id))
                {
                    Workers.EditWorker(id, textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, salary, textBox6.Text, phoneNr, textBox8.Text);
                }
                if (Workers.ifCorrect)
                {
                    MessageBox.Show("data edited", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Workers.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }

            //dla klientów
            if (ifAddClicked == true && ifClientsClicked == true)
            {
                if (Int32.TryParse(textBox7.Text, out phoneNr))
                {
                    Clients.AddClient(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text, phoneNr, textBox8.Text);
                }
                if (Clients.ifCorrect)
                {
                    MessageBox.Show("data inserted", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Clients.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }
            if (ifRemoveClicked == true && ifClientsClicked == true)
            {
                if (Int32.TryParse(textBox1.Text, out id))
                {
                    Clients.RemoveClient(id);
                }
                if (Clients.ifCorrect)
                {
                    MessageBox.Show("data removed", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Clients.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }
            if (ifEditClicked == true && ifClientsClicked == true)
            {
                if (Int32.TryParse(textBox7.Text, out phoneNr) && Int32.TryParse(textBox9.Text, out id))
                {
                    Clients.EditClient(id, textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text, phoneNr, textBox8.Text);
                }
                if (Clients.ifCorrect)
                {
                    MessageBox.Show("data edited", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Clients.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }

            // dla samochodów
            if (ifAddClicked == true && ifCarsClicked == true)
            {
                if (Int32.TryParse(textBox2.Text, out yearofprod) && Int32.TryParse(textBox5.Text, out miles) && Int32.TryParse(textBox7.Text, out horses))
                {
                    Cars.AddCar(textBox1.Text, yearofprod, textBox3.Text, textBox4.Text, miles, textBox6.Text, horses, textBox8.Text);
                }
                if (Cars.ifCorrect)
                {
                    MessageBox.Show("data inserted", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Cars.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }
            if (ifRemoveClicked == true && ifCarsClicked == true)
            {
                if (Int32.TryParse(textBox1.Text, out id))
                {
                    Cars.RemoveCar(Int32.Parse(textBox1.Text));
                }
                if (Cars.ifCorrect)
                {
                    MessageBox.Show("data removed", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Cars.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }
            if (ifEditClicked == true && ifCarsClicked == true)
            {
                if (Int32.TryParse(textBox9.Text, out id) && Int32.TryParse(textBox2.Text, out yearofprod) && Int32.TryParse(textBox5.Text, out miles) && Int32.TryParse(textBox7.Text, out horses))
                {
                    Cars.EditCar(id, textBox1.Text, yearofprod, textBox3.Text, textBox4.Text, miles, textBox6.Text, horses, textBox8.Text);
                }
                if (Cars.ifCorrect)
                {
                    MessageBox.Show("data edited", "", MessageBoxButton.OK, MessageBoxImage.Information);
                    Cars.ifCorrect = false;
                }
                else
                {
                    MessageBox.Show("something went wrong...", "", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
            }
            textBox1.Clear();
            textBox2.Clear();
            textBox3.Clear();
            textBox4.Clear();
            textBox5.Clear();
            textBox6.Clear();
            textBox7.Clear();
            textBox8.Clear();
            textBox9.Clear();
        }