//------------------------------------------------------
private void Page_Loaded(object sender, RoutedEventArgs e)
{
DateTimePicker.Language = System.Windows.Markup.XmlLanguage.GetLanguage("fr");
if (ConnectedSalle.ToString() == "" && ConnectedSport.ToString() == "")
{
BtnAjouter.IsEnabled = false;
BtnModifier.IsEnabled = false;
DepensesTextBox.IsEnabled = false;
DateTimePicker.IsEnabled = false;
PrixTextBox.IsEnabled = false;
BtnAjouter.Foreground = new SolidColorBrush(Color.FromRgb(128, 128, 128));
BtnModifier.Foreground = new SolidColorBrush(Color.FromRgb(128, 128, 128));
cn.Open();
cmd.Connection = cn;
cmd.CommandText = "select d.IdDep as IdDep, d.Depense as Depense,convert(varchar, d.date_dep, 103) as date_dep,d.prix as prix,u.UserName as UserName,s.nom_Salle as nom_Salle,t.nom_Type as nom_Type,d.IdSalle,d.IdType,d.IdUser from Depenses d join Utilisateur u on d.IdUser=u.IdUser join Salle s on d.IdSalle=s.IdSalle join Type_Sport t on d.IdType=t.IdType ";
dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
ListViewUtilisateurs.DataContext = dt;
cn.Close();
}
else
{
loaded();
}
}
private void loaded()
{
if (isPostBack == false)
{
ch1.IsChecked = true;
isPostBack = true;
}
if (ConnectedSalle.ToString() == "" && ConnectedSport.ToString() == "")
{
AjouterClientBtn.IsEnabled = false;
AjouterClientBtn.Foreground = new SolidColorBrush(Color.FromRgb(128, 128, 128));
PayementsClientModalBtn.IsEnabled = false;
ModifierClientModalBtn.IsEnabled = false;
PayementsClientModalBtn.Foreground = new SolidColorBrush(Color.FromRgb(128, 128, 128));
ModifierClientModalBtn.Foreground = new SolidColorBrush(Color.FromRgb(128, 128, 128));
cn.Open();
cmd.Connection = cn;
if (dt != null)
{
dt.Clear();
}
cmd.CommandText = "select c.IdClient as id,UPPER(c.nom) +' '+ UPPER(c.prenom) as Title,c.Tel as Tel,c.img as Photo,s.IdClient,s.IdType, c.Active as Active from Clients c join SportClients s on c.IdClient=s.IdClient order by c.IdClient DESC";
dr = cmd.ExecuteReader();
dt.Load(dr);
ListClient.DataContext = dt;
cn.Close();
}
else
{
cn.Open();
cmd.Connection = cn;
if (dt != null)
{
dt.Clear();
}
cmd.CommandText = "select c.IdClient as id,UPPER(c.nom) +' '+ UPPER(c.prenom) as Title,c.Tel as Tel,c.img as Photo,s.IdClient,s.IdType, c.Active as Active from Clients c join SportClients s on c.IdClient=s.IdClient where s.IdSalle='" + ConnectedSalle.ToString() + "' and s.IdType='" + ConnectedSport.ToString() + "' order by c.IdClient DESC";
dr = cmd.ExecuteReader();
dt.Load(dr);
ListClient.DataContext = dt;
cn.Close();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (ajouter.Content.ToString() == "Nouveau")
{
ajouter.Content = "Ajouter";
NomTextBox.Text = null;
PrixTextBox.Text = null;
ListPayments.UnselectAll();
}
else if (ajouter.Content.ToString() == "Ajouter")
{
if (PrixTextBox.Text == "" || NomTextBox.Text == "")
{
messageContent.Text = "Merci De Remplir tous Les Champs";
animateBorder(borderMessage);
}
else
{
try
{
if (ListPayments.SelectedIndex != -1)
{
DataRowView row1 = ListPayments.Items.GetItemAt(0) as DataRowView;
date = DateTime.Parse(row1.Row[4].ToString(), new System.Globalization.CultureInfo("fr"));
}
cn.Open();
cmd.Connection = cn;
cmd.Parameters.Clear();
cmd.CommandText = "insert into Payments values (@a,'" + id.ToString() + "','" + ConnectedSalle.ToString() + "','" + ConnectedSport.ToString() + "','" + double.Parse(PrixTextBox.Text) + "')";
cmd.Parameters.AddWithValue("@a", DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")));
cmd.ExecuteNonQuery();
messageContent.Text = "Paiement Bien Ajoutée";
animateBorder(borderMessage);
if (DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")) > date)
{
cmd.Parameters.Clear();
cmd.CommandText = "update Clients set LastPay = @b where IdClient = '" + id.ToString() + "'";
cmd.Parameters.AddWithValue("@b", DateTime.Parse(NomTextBox.Text.ToString(), new System.Globalization.CultureInfo("fr")));
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
string msg = ex.Message;
MessageForm m = new MessageForm(msg);
m.ShowDialog();
}
finally
{
cn.Close();
loaded();
NomTextBox.Text = null;
PrixTextBox.Text = null;
}
}
}
}
