private void Button_Click(object sender, RoutedEventArgs e)
{
PageAccueil page = new PageAccueil();
page.Show();
this.Hide();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
String connString = "datasource=localhost;port=3306;username=root;password= "******"truncate table tierspayant.prestation";
cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Suppréssion réussie");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
PageAccueil pageAccueil = new PageAccueil();
pageAccueil.Show();
this.Hide();
}
private void Retour(object sender, RoutedEventArgs e)
{
PageAccueil page = new PageAccueil();
page.Show();
this.Hide();
}
//permet de modifier un champ
private void Modifier(object sender, RoutedEventArgs e)
{
String connString = "datasource=localhost;port=3306;username=root;password= "******"Update tierspayant.prestation set typePrestation = '" + this.type.Text + "',souscripteur='" + this.souscripteur.Text + "'," +
" echeance ='" + this.echeance.Text + "',Assure='" + this.assure.Text + "',Matricule ='" + this.matricule.Text + "'," +
"patient ='" + this.patient.Text + "',centreDeSoins='" + this.centre.Text + "' ,date='" + this.date.Text + "' Where idPrestation = '" + this.idprestation.Text + "' ";
cmd = new MySqlCommand(sql, connection);
cmd.ExecuteNonQuery();
MessageBox.Show("Modification réussie");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
PageAccueil pageAccueil = new PageAccueil();
pageAccueil.Show();
this.Hide();
}
//permet de retourner à la page d'accueil
private void Button_Click_1(object sender, RoutedEventArgs e)
{
PageAccueil accueil = new PageAccueil();
accueil.Show();
this.Hide();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
//string query = "Select count(1) From";
PageAccueil pageAccueil = new PageAccueil();
pageAccueil.Show();
this.Hide();
}