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