private void Ajouter(object sender, RoutedEventArgs e) { string connString; SqlConnection con; string SafaeServer = "DESKTOP-SL2AUNJ"; connString = "Data Source =" + SafaeServer + "; Initial Catalog = Gestion_Etudiant ; Integrated Security = true;"; con = new SqlConnection(); con.ConnectionString = connString; con.Open(); SqlTransaction tr = con.BeginTransaction(); SqlCommand cmd = con.CreateCommand(); cmd.Transaction = tr; cmd.CommandType = CommandType.Text; try { cmd.CommandText = " INSERT INTO Filiere(Nom_filiere,Responsable) VALUES('" + TextName.Text + "','" + TextRespo.Text + "')"; cmd.ExecuteNonQuery(); tr.Commit(); MenuWindow.currentWindow.MyCarousel.ItemsSource = null; MenuWindow.currentWindow.MyCarousel.ItemsSource = FiliereService.GetEmployees(); MenuWindow.currentWindow.MyCarousel.FindCarouselPanel().MoveBy(2); } catch (Exception ex) { MessageBox.Show(ex.Message); tr.Rollback(); } finally { con.Close(); this.Close(); } }
private void Supprimer(object sender, RoutedEventArgs e) { string connString; SqlConnection con; string SafaeServer = "DESKTOP-SL2AUNJ"; connString = "Data Source =" + SafaeServer + "; Initial Catalog = Gestion_Etudiant ; Integrated Security = true;"; con = new SqlConnection(); con.ConnectionString = connString; con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "delete from Filiere where Id_filiere ='" + TextId.Content + "'"; cmd.ExecuteNonQuery(); cmd.CommandText = "delete from Etudiant where id_fil = '" + TextId.Content + "'"; cmd.ExecuteNonQuery(); MenuWindow.currentWindow.MyCarousel.ItemsSource = null; MenuWindow.currentWindow.MyCarousel.ItemsSource = FiliereService.GetEmployees(); MenuWindow.currentWindow.MyCarousel.FindCarouselPanel().MoveBy(-2); con.Close(); this.Close(); }