public DodajKarnet(ZarzadzajKarnetami Zarzadzaj, bool IsEdit) { InitializeComponent(); this.Zarzadzaj = Zarzadzaj; this.isEdit = IsEdit; if (isEdit) { this.Title = "Edytuj"; btnOK.Content = "Aktualizuj"; DataRowView row = Zarzadzaj.lstKarnety.SelectedItem as DataRowView; Karnet.DataContext = row; editedRowId = (int)row["ID_Karnetu"]; } else { this.Title = "Dodaj"; btnOK.Content = "Dodaj"; } }
private void ZarzadzajKarnetami(object sender, RoutedEventArgs e) { ZarzadzajKarnetami dodaj1 = new ZarzadzajKarnetami(this.conn); dodaj1.Show(); }
private void btnPrzypisz_Click(object sender, RoutedEventArgs e) { try { if (lstKlienci.SelectedItems.Count != 0) { DataRowView row = this.lstKlienci.SelectedItem as DataRowView; this.editedRowId = (int)row["ID_Klienta"]; if (this.id_karnetu == 0) { ZarzadzajKarnetami wnd = new ZarzadzajKarnetami(this.editedRowId, this.conn); wnd.Show(); this.Close(); } else { //Przypisanie Karnetu this.conn.Close(); this.conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = this.conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PrzypiszKarnetKlient"; SqlParameter ID_Karnetu = new SqlParameter(); ID_Karnetu.ParameterName = "@ID_Karnetu"; ID_Karnetu.SqlDbType = SqlDbType.Int; ID_Karnetu.Direction = ParameterDirection.Input; ID_Karnetu.Value = this.id_karnetu; cmd.Parameters.Add(ID_Karnetu); SqlParameter ID_Klienta = new SqlParameter(); ID_Klienta.ParameterName = "@ID_Klienta"; ID_Klienta.SqlDbType = SqlDbType.Int; ID_Klienta.Direction = ParameterDirection.Input; ID_Klienta.Value = this.editedRowId; cmd.Parameters.Add(ID_Klienta); SqlParameter parm = new SqlParameter("@result", SqlDbType.Int); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); cmd.ExecuteNonQuery(); int retval = (int)parm.Value; if (retval == 0) { MessageBox.Show("Osoba ma już taki karnet!", "Uwaga!", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBox.Show("Pomyślnie przypisano!", "Uwaga!", MessageBoxButton.OK, MessageBoxImage.Information); } } } else { MessageBox.Show("Aby przypisać karnet do klienta nalezy wybrać klienta ", "UWAGA!", MessageBoxButton.OK, MessageBoxImage.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message, "UWAGA!", MessageBoxButton.OK, MessageBoxImage.Exclamation); } #endregion }