private void ChangeText(object sender, RoutedEventArgs e) { var selectedIndex = DataGridRow.GetRowContainingElement (sender as FrameworkElement).GetIndex(); if (mode == 1) { Bron obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else if (mode == 2) { Amunicja obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else if (mode == 3) { Hurtowe obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else if (mode == 4) { Detaliczne obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else if (mode == 5) { Dostawa obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else if (mode == 6) { Kategoria obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else if (mode == 7) { Material obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else if (mode == 8) { Pracownik obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else if (mode == 9) { Produkcja obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } else { Zamowienie obiekt = DataFromDatabase.ElementAt(selectedIndex); ModifyForm mForm = new ModifyForm(obiekt, mode, this); mForm.Show(); } }
public ModifyForm(object toChange, int mode, ShowData lastWindow) { InitializeComponent(); class_mode = mode; sthToChange = toChange; lastData = lastWindow; _defaultBrush = Button1.BorderBrush; if (mode == 1) { Bron typeObject = (Bron)toChange; Label1.Content = "Numer_Seryjny"; Label2.Content = "Nazwa"; Label3.Content = "Cena"; Label4.Visibility = Visibility.Hidden; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.Numer_Seryjny.ToString(); Box2.Text = typeObject.Nazwa.ToString(); Box3.Text = typeObject.Cena.ToString(); Box4.Visibility = Visibility.Hidden; Box5.Visibility = Visibility.Hidden; } else if (mode == 2) { Amunicja typeObject = (Amunicja)toChange; Label1.Content = "Numer_Pudelka"; Label2.Content = "Kaliber"; Label3.Content = "Ilosc_Amunicji"; Label4.Content = "Cena"; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.Numer_Pudelka.ToString(); Box2.Text = typeObject.Kaliber.ToString(); Box3.Text = typeObject.Ilosc_Amunicji.ToString(); Box4.Text = typeObject.Cena.ToString(); Box5.Visibility = Visibility.Hidden; } else if (mode == 3) { Hurtowe typeObject = (Hurtowe)toChange; Label1.Content = "Numer_Zamowienia"; Label2.Content = "Zezwolenie_Na_Handel"; Label3.Visibility = Visibility.Hidden; Label4.Visibility = Visibility.Hidden; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.Numer_Zamowienia.ToString(); Box2.Text = typeObject.Zezwolenie_Na_Handel.ToString(); Box3.Visibility = Visibility.Hidden; Box4.Visibility = Visibility.Hidden; Box5.Visibility = Visibility.Hidden; } else if (mode == 4) { Detaliczne typeObject = (Detaliczne)toChange; Label1.Content = "Numer_Zamowienia"; Label2.Content = "Zezwolenie_Na_Bron"; Label3.Visibility = Visibility.Hidden; Label4.Visibility = Visibility.Hidden; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.Numer_Zamowienia.ToString(); Box2.Text = typeObject.Zezwolenie_Na_Bron.ToString(); Box3.Visibility = Visibility.Hidden; Box4.Visibility = Visibility.Hidden; Box5.Visibility = Visibility.Hidden; } else if (mode == 5) { Dostawa typeObject = (Dostawa)toChange; Label1.Content = "Nr_Dostawy"; Label2.Content = "Nazwa_dostawcy"; Label3.Content = "Ilosc_Amunicji"; Label4.Visibility = Visibility.Hidden; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.Nr_Dostawy.ToString(); Box2.Text = typeObject.Nazwa_dostawcy.ToString(); Box3.Text = typeObject.Koszt_Calkowity.ToString(); Box4.Visibility = Visibility.Hidden; Box5.Visibility = Visibility.Hidden; } else if (mode == 6) { Kategoria typeObject = (Kategoria)toChange; Label1.Content = "ID"; Label2.Content = "Nazwa"; Label3.Visibility = Visibility.Hidden; Label4.Visibility = Visibility.Hidden; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.ID.ToString(); Box2.Text = typeObject.Nazwa.ToString(); Box3.Visibility = Visibility.Hidden; Box4.Visibility = Visibility.Hidden; Box5.Visibility = Visibility.Hidden; } else if (mode == 7) { Material typeObject = (Material)toChange; Label1.Content = "ID"; Label2.Content = "Nazwa"; Label3.Content = "Ilosc"; Label4.Visibility = Visibility.Hidden; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.ID.ToString(); Box2.Text = typeObject.Nazwa.ToString(); Box3.Text = typeObject.Ilosc.ToString(); Box4.Visibility = Visibility.Hidden; Box5.Visibility = Visibility.Hidden; } else if (mode == 8) { Pracownik typeObject = (Pracownik)toChange; Label1.Content = "PESEL"; Label2.Content = "Imie"; Label3.Content = "Nazwisko"; Label4.Content = "Zaswiadczenie_O_Niekaralnosci"; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.PESEL.ToString(); Box2.Text = typeObject.Imie.ToString(); Box3.Text = typeObject.Nazwisko.ToString(); Box4.Text = typeObject.Zaswiadczenie_O_Niekaralnosci.ToString(); Box5.Visibility = Visibility.Hidden; } else if (mode == 9) { Produkcja typeObject = (Produkcja)toChange; Label1.Content = "Numer_Produkcyjny"; Label2.Content = "Nazwa_Produktu"; Label3.Content = "Ilosc_Produktu"; Label4.Visibility = Visibility.Hidden; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.Numer_Produkcyjny.ToString(); Box2.Text = typeObject.Nazwa_Produktu.ToString(); Box3.Text = typeObject.Ilosc_Produktu.ToString(); Box4.Visibility = Visibility.Hidden; Box5.Visibility = Visibility.Hidden; } else { Zamowienie typeObject = (Zamowienie)toChange; Label1.Content = "Numer_Zamowienia"; Label2.Content = "Data_Dostawy"; Label3.Content = "Data_Zamowienia"; Label4.Content = "Uwagi"; Label5.Visibility = Visibility.Hidden; Box1.Text = typeObject.Numer_Zamowienia.ToString(); Box2.Text = typeObject.Data_Dostawy.ToString(); Box3.Text = typeObject.Data_Zamowienia.ToString(); Box4.Text = typeObject.Uwagi.ToString(); Box5.Visibility = Visibility.Hidden; } }
private void Button2_Click(object sender, RoutedEventArgs e) { object toChange = sthToChange; int mode = class_mode; DatabaseModel DataModel = new DatabaseModel(); try { if (mode == 1) { Bron typeObject = (Bron)toChange; DataModel.Execute("DELETE FROM Bron WHERE Numer_Seryjny = " + typeObject.Numer_Seryjny.ToString()); } else if (mode == 2) { Amunicja typeObject = (Amunicja)toChange; DataModel.Execute("DELETE FROM Amunicja WHERE Numer_Pudelka = " + typeObject.Numer_Pudelka.ToString()); } else if (mode == 3) { Hurtowe typeObject = (Hurtowe)toChange; DataModel.Execute("DELETE FROM Hurtowe WHERE Numer_Zamowienia = " + typeObject.Numer_Zamowienia.ToString()); } else if (mode == 4) { Detaliczne typeObject = (Detaliczne)toChange; DataModel.Execute("DELETE FROM Detaliczne WHERE Numer_Zamowienia = " + typeObject.Numer_Zamowienia.ToString()); } else if (mode == 5) { Dostawa typeObject = (Dostawa)toChange; DataModel.Execute("DELETE FROM Dostawa WHERE Nr_Dostawy = " + typeObject.Nr_Dostawy.ToString()); } else if (mode == 6) { Kategoria typeObject = (Kategoria)toChange; DataModel.Execute("DELETE FROM Kategoria WHERE ID = " + typeObject.ID.ToString()); } else if (mode == 7) { Material typeObject = (Material)toChange; DataModel.Execute("DELETE FROM Material WHERE ID = " + typeObject.ID.ToString()); } else if (mode == 8) { Pracownik typeObject = (Pracownik)toChange; DataModel.Execute("DELETE FROM Pracownik WHERE PESEL = " + typeObject.PESEL.ToString()); } else if (mode == 9) { Produkcja typeObject = (Produkcja)toChange; DataModel.Execute("DELETE FROM Produkcja WHERE Numer_Produkcyjny = " + typeObject.Numer_Produkcyjny.ToString()); } else { Zamowienie typeObject = (Zamowienie)toChange; DataModel.Execute("DELETE FROM Zamowienie WHERE Numer_Zamowienia = " + typeObject.Numer_Zamowienia.ToString()); } lastData.Close(); this.Close(); } catch(Exception ex) { MessageBox.Show(ex.Message); } }
private void Button1_Click(object sender, RoutedEventArgs e) { object toChange = sthToChange; int mode = class_mode; DatabaseModel DataModel = new DatabaseModel(); try { if (mode == 1) { if (Box2.Text.Length > 0 && Decimal.TryParse(Box3.Text, out decimal r1)) { Bron typeObject = (Bron)toChange; DataModel.Execute("UPDATE Bron SET Nazwa = '" + Box2.Text + "', Cena = '" + Box3.Text.Replace(",", ".") + "' WHERE Numer_Seryjny = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else if (mode == 2) { if (Box2.Text.Length > 0 && int.TryParse(Box3.Text, out int r3) && float.TryParse(Box4.Text, out float r4)) { Amunicja typeObject = (Amunicja)toChange; DataModel.Execute("UPDATE Amunicja SET Kaliber = '" + Box2.Text + "', Ilosc_Amunicji = '" + Box3.Text + "', Cena = '" + Box4.Text.Replace(",", ".") + "' WHERE Numer_Pudelka = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else if (mode == 3) { if (Box2.Text.Length > 0) { Hurtowe typeObject = (Hurtowe)toChange; DataModel.Execute("UPDATE Hurtowe SET Zezwolenie_Na_Handel = '" + Box2.Text + "' WHERE Numer_Zamowienia = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else if (mode == 4) { if (Box2.Text.Length > 0) { Detaliczne typeObject = (Detaliczne)toChange; DataModel.Execute("UPDATE Detaliczne SET Zezwolenie_Na_Handel = '" + Box2.Text + "' WHERE Numer_Zamowienia = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else if (mode == 5) { if (Box2.Text.Length > 0 && Decimal.TryParse(Box3.Text, out Decimal r8)) { Dostawa typeObject = (Dostawa)toChange; DataModel.Execute("UPDATE Dostawa SET Nazwa_dostawcy = '" + Box2.Text + "', Koszt_Calkowity = '" + Box3.Text.Replace(",", ".") + "' WHERE Nr_Dostawy = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else if (mode == 6) { if (Box2.Text.Length > 0) { Kategoria typeObject = (Kategoria)toChange; DataModel.Execute("UPDATE Kategoria SET Nazwa = '" + Box2.Text + "' WHERE ID = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else if (mode == 7) { if (Box2.Text.Length > 0 && int.TryParse(Box3.Text, out int r9)) { Material typeObject = (Material)toChange; DataModel.Execute("UPDATE Material SET Nazwa = '" + Box2.Text + "', Ilosc = '" + Box3.Text + "' WHERE ID = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else if (mode == 8) { if (Box2.Text.Length > 0 && Box3.Text.Length > 0 && Box4.Text.Length > 0) { Pracownik typeObject = (Pracownik)toChange; DataModel.Execute("UPDATE Pracownik SET Imie = '" + Box2.Text + "', Nazwisko = '" + Box3.Text + "', Zaswiadczenie_O_Niekaralnosci = '" + Box4.Text + "' WHERE PESEL = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else if (mode == 9) { if (Box2.Text.Length > 0 && int.TryParse(Box3.Text, out int r10)) { Produkcja typeObject = (Produkcja)toChange; DataModel.Execute("UPDATE Produkcja SET Nazwa_Produktu = '" + Box2.Text + "', Ilosc_Produktu = '" + Box3.Text + "' WHERE Numer_Produkcyjny = '" + Box1.Text + "'"); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } else { if (DateTime.TryParse(Box2.Text, out DateTime r11) && DateTime.TryParse(Box3.Text, out DateTime r12) && int.TryParse(Box4.Text, out int r13)) { Zamowienie typeObject = (Zamowienie)toChange; DataModel.Execute("UPDATE Zamowienie SET Data_Dostawy = '" + Box2.Text + "', Data_Zamowienia = '" + Box3.Text + "', Uwagi = '" + Box4.Text + "' WHERE Numer_Zamowienia = '" + Box1.Text); lastData.Close(); this.Close(); } else { Button1.BorderBrush = Brushes.Red; } } } catch(Exception ex) { MessageBox.Show(ex.Message); } }