private void Button_Click(object sender, RoutedEventArgs e) { var item = (sender as FrameworkElement).DataContext; int index = ListViewSalles.Items.IndexOf(item); DataRowView row = ListViewSalles.Items.GetItemAt(index) as DataRowView; int id = int.Parse(row.Row[0].ToString()); ConfirmForm c = new ConfirmForm("Tout Utilisateur Ou Client Ou Sport Lié à Cet Salle Sera Supprimé, Voulez Vous Vraiment Continuer?"); c.Owner = dade; dade.Opacity = 0.5; dade.Effect = new BlurEffect(); if (ConnectedSalle == row.Row[0].ToString()) { messageContent.Text = "Vous Ne Pouvez Pas Supprimer La 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.IdSalle = '" + id + "')"; cmd.ExecuteNonQuery(); cmd.CommandText = "delete from Salle where IdSalle = '" + id + "'"; cmd.ExecuteNonQuery(); cn.Close(); messageContent.Text = "Salle Bien Supprimée"; animateBorder(borderMessage); BtnAjouter.Content = "Ajouter"; SalleName.Text = null; ListViewSalles.UnselectAll(); LoadResoource(); } } dade.Opacity = 1; dade.Effect = null; }
private void BtnModifier_Click(object sender, RoutedEventArgs e) { if (ListViewSalles.SelectedIndex == -1) { messageContent.Text = "Veuillez Sélectionner Une Ligne"; animateBorder(borderMessage); } else { int index = ListViewSalles.SelectedIndex; DataRowView row = ListViewSalles.Items.GetItemAt(index) as DataRowView; int id = int.Parse(row.Row[0].ToString()); try { if (SalleName.Text == "") { messageContent.Text = "Merci De Remplir Tous Les Champs"; animateBorder(borderMessage); } else { cn.Open(); cmd.Connection = cn; cmd.CommandText = "update Salle set nom_Salle = '" + SalleName.Text.Replace("'", "''") + "' where IdSalle = '" + id + "'"; cmd.ExecuteNonQuery(); cn.Close(); messageContent.Text = "Salle Bien Modifiée"; animateBorder(borderMessage); BtnAjouter.Content = "Ajouter"; SalleName.Text = null; ListViewSalles.UnselectAll(); LoadResoource(); } } 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"; SalleName.Text = null; ListViewSalles.UnselectAll(); } else if (BtnAjouter.Content.ToString() == "Ajouter") { try { if (SalleName.Text == "") { messageContent.Text = "Merci De Remplir Tous Les Champs"; animateBorder(borderMessage); } else { cn.Open(); cmd.Connection = cn; cmd.CommandText = "insert into Salle values ('" + SalleName.Text.Replace("'", "''") + "')"; cmd.ExecuteNonQuery(); cn.Close(); messageContent.Text = "Salle Bien Ajoutée"; animateBorder(borderMessage); ListViewSalles.UnselectAll(); SalleName.Text = null; LoadResoource(); } } catch (Exception ex) { string msg = ex.Message; MessageForm m = new MessageForm(msg); m.ShowDialog(); } } }