static void Main(string[] args)
{
String connectionString = ConfigurationManager.ConnectionStrings["MyHomeServerConnection"].ConnectionString;
PersistanceFournisseur p = new PersistanceFournisseur(connectionString);
sFournisseur s = new sFournisseur();
//p.Addfournisseur(s);
}
private void butRechercher_Click(object sender, EventArgs e)
{
String connectionString = ConfigurationManager.ConnectionStrings["MyHomeServerConnection"].ConnectionString;
PersistanceFournisseur p = new PersistanceFournisseur(connectionString);
int id = int.Parse(txtBoxNumFourni.Text);
sFournisseur sFourni = p.GetFournisseur(id);
txtBoxNomFourni.Text = sFourni.nom;
txtBoxRue.Text = sFourni.rue;
txtBoxCP.Text = sFourni.code_postal.ToString();
txtBoxVille.Text = sFourni.ville;
txtBoxContact.Text = sFourni.personne_contact;
txtBoxSatisfaction.Text = sFourni.satisfaction.ToString();
}
private void butCreer_Click(object sender, EventArgs e)
{
String connectionString = ConfigurationManager.ConnectionStrings["MyHomeServerConnection"].ConnectionString;
PersistanceFournisseur p = new PersistanceFournisseur(connectionString);
// setEntrerFournisseur(int.Parse(txtBoxNumFourni.Text), txtBoxNomFourni.Text, txtBoxRue.Text, txtBoxVille.Text,
// int.Parse(txtBoxCP.Text), txtBoxContact.Text, int.Parse(txtBoxSatisfaction.Text));
//(int id, string nom, string rue, string ville, int code_postal, string personne_contact, int satisfaction)
//sFournisseur s = new sFournisseur(getNumF(), getNomF(), getRueF(), getVilleF(), getCpF(), getContactF(), getSatisfactionF());
sFournisseur s = new sFournisseur(int.Parse(txtBoxNumFourni.Text), txtBoxNomFourni.Text, txtBoxRue.Text, txtBoxVille.Text,
int.Parse(txtBoxCP.Text), txtBoxContact.Text, int.Parse(txtBoxSatisfaction.Text));
//(id, nom, rue, ville, code_postal, personne_contact, satisfaction);
p.AddFournisseur(s);
}
