private void BtnModifier_Click(object sender, RoutedEventArgs e) { if (ListViewSports.SelectedIndex == -1) { messageContent.Text = "Veuillez Sélectionner Une Ligne"; animateBorder(borderMessage); } else { if (SportName.Text == "" || SportPrix.Text == "" || SallesComboBox.SelectedIndex == -1) { messageContent.Text = "Merci De Remplir Tous Les Champs"; animateBorder(borderMessage); } else { try { int index = ListViewSports.SelectedIndex; DataRowView row = ListViewSports.Items.GetItemAt(index) as DataRowView; int id = int.Parse(row.Row[0].ToString()); cn.Open(); cmd.Connection = cn; cmd.CommandText = "update Type_Sport set nom_Type = '" + SportName.Text.Replace("'", "''") + "' where IdType ='" + id + "'"; cmd.ExecuteNonQuery(); cmd.CommandText = "update SportSalle set IdSalle ='" + SallesComboBox.SelectedValue + "', prix ='" + double.Parse(SportPrix.Text) + "' where IdType ='" + id + "'"; cmd.ExecuteNonQuery(); cn.Close(); BtnAjouter.Content = "Ajouter"; SportName.Text = null; SportPrix.Text = null; SallesComboBox.SelectedIndex = -1; ListViewSports.UnselectAll(); loaded(); messageContent.Text = "Sport Bien Modifié"; animateBorder(borderMessage); } catch (Exception ex) { string msg = ex.Message; MessageForm m = new MessageForm(msg); m.ShowDialog(); } } } }
private void BtnAjouter_Click(object sender, RoutedEventArgs e) { if (BtnAjouter.Content.ToString() == "Nouveau") { BtnAjouter.Content = "Ajouter"; SportName.Text = null; SportPrix.Text = null; SallesComboBox.SelectedIndex = -1; ListViewSports.UnselectAll(); } else if (BtnAjouter.Content.ToString() == "Ajouter") { if (SportName.Text == "" || SportPrix.Text == "" || SallesComboBox.SelectedIndex == -1) { messageContent.Text = "Merci De Remplir Tous Les Champs"; animateBorder(borderMessage); } else { try { cn.Open(); cmd.Connection = cn; cmd.CommandText = "insert into Type_Sport values ('" + SportName.Text.Replace("'", "''") + "')"; cmd.ExecuteNonQuery(); cmd.CommandText = "select MAX(IdType) from Type_Sport"; int id = int.Parse(cmd.ExecuteScalar().ToString()); cmd.CommandText = "insert into SportSalle values ('" + SallesComboBox.SelectedValue + "','" + id + "','" + double.Parse(SportPrix.Text) + "')"; cmd.ExecuteNonQuery(); cn.Close(); loaded(); SportName.Text = null; SportPrix.Text = null; SallesComboBox.SelectedIndex = -1; messageContent.Text = "Sport Bien Ajouté"; animateBorder(borderMessage); } catch (Exception ex) { string msg = ex.Message; MessageForm m = new MessageForm(msg); m.ShowDialog(); } } } }
private void Button_Click(object sender, RoutedEventArgs e) { var item = (sender as FrameworkElement).DataContext; int index = ListViewSports.Items.IndexOf(item); DataRowView row = ListViewSports.Items.GetItemAt(index) as DataRowView; ConfirmForm c = new ConfirmForm("Tout Utilisateur Ou Client Lié à Cet Sport Sera Supprimé, Voulez Vous Vraiment Continuer?"); c.Owner = dade; dade.Opacity = 0.5; dade.Effect = new BlurEffect(); if (ConnectedSport == row.Row[0].ToString()) { messageContent.Text = "Vous Ne Pouvez Pas Supprimer Le Sport De Salle Connecté"; animateBorder(borderMessage); } else { if ((bool)c.ShowDialog()) { cn.Open(); cmd.Connection = cn; cmd.CommandText = "delete from Utilisateur where IdUser in (select u.IdUser from Utilisateur u join UtilisateurSportSalle us on u.IdUser = us.IdUser where us.IdType = '" + row.Row[0].ToString() + "')"; cmd.ExecuteNonQuery(); cmd.CommandText = "delete from Type_Sport where IdType = '" + row.Row[0].ToString() + "'"; cmd.ExecuteNonQuery(); cn.Close(); messageContent.Text = "Bien supprimé"; animateBorder(borderMessage); BtnAjouter.Content = "Ajouter"; SportName.Text = null; SportPrix.Text = null; SallesComboBox.SelectedIndex = -1; ListViewSports.UnselectAll(); loaded(); } } dade.Opacity = 1; dade.Effect = null; }