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();
}
}
}
