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