public AffichageFournisseur(PersistanceSQLServer persistanceSQLServer) { InitializeComponent(); this.persistanceSQLServer = persistanceSQLServer; buttonMAJ.Text = "Creer"; createMode = true; }
public AffichageFournisseur(PersistanceSQLServer persistanceSQLServer, int codeFournisseur) { InitializeComponent(); this.persistanceSQLServer = persistanceSQLServer; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@pid_contact", codeFournisseur); ArrayList list = persistanceSQLServer.ExecuteDataReader(parameters, "SearchAllContact"); textBoxNom.Text = list[3].ToString(); textBoxNumRue.Text = list[2].ToString(); textBoxRue.Text = list[1].ToString(); textBoxCP.Text = list[5].ToString(); textBoxVille.Text = list[4].ToString(); textBoxContact.Text = list[3].ToString(); textBoxSatisfaction.Text = list[7].ToString(); createMode = false; }
private void buttonConnexion_Click(object sender, EventArgs e) { string logs = ""; if (persistanceSQLServer.IsOpen()) { this.persistanceSQLServer.Deconnexion(); } try { if (textBoxServer.Text == "" && textBoxBDD.Text == "") { persistanceSQLServer = new PersistanceSQLServer(ConfigurationManager.ConnectionStrings["papyrus"].ConnectionString); } else { persistanceSQLServer = new PersistanceSQLServer(textBoxServer.Text, textBoxBDD.Text); } logs += persistanceSQLServer.Connexion(); } catch (Exception ex) { logs += ex.Message + Environment.NewLine; if (persistanceSQLServer.IsOpen()) { persistanceSQLServer.Deconnexion(); } } if (logs == "") { this.labelStateConnexion.Text = "Open"; textBoxLogs.Text = ""; this.textBoxLogs.Text = "Connexion réussie"; } else { this.labelStateConnexion.Text = "Close"; textBoxLogs.Text = logs; } }
public FormBDD() { InitializeComponent(); persistanceSQLServer = new PersistanceSQLServer(); }
public RechercheFournisseurs(PersistanceSQLServer persistanceSQLServer) { InitializeComponent(); this.persistanceSQLServer = persistanceSQLServer; }