private void button1_Click(object sender, EventArgs e)
{
DBconnect bdd = new DBconnect();
if (bdd.List_Client() == true)
{
cb_listClient.Items.Add(bdd.List_Client());
}
this.Close();
}
private void btn_SendComm_Click(object sender, EventArgs e)
{
string ncomM = tb_NumComm.Text;
string nclI = tb_nCli.Text;
string datE = tb_date.Text;
DBconnect bdd = new DBconnect();
if (bdd.Insert_Comm(ncomM, nclI, datE) == true)
{
tb_NumComm.Text = "NProduit";
tb_nCli.Text = "Libelle";
tb_date.Text = "Prix";
}
this.Close();
}
private void btn_SendItem_Click(object sender, EventArgs e)
{
string nproD = tb_Npro.Text;
string libellE = tb_Libelle.Text;
string priX = tb_Prix.Text;
string stocK = tb_Stock.Text;
DBconnect bdd = new DBconnect();
if (bdd.Insert_Item(nproD, libellE, priX, stocK) == true)
{
tb_Npro.Text = "NProduit";
tb_Libelle.Text = "Libelle";
tb_Prix.Text = "Prix";
tb_Stock.Text = "Stock";
}
this.Close();
}
private void btn_SendClient_Click(object sender, EventArgs e)
{
string nclI = tb_Ncli.Text;
string noM = tb_Nom.Text;
string localitE = tb_Localite.Text;
string comptE = tb_Compte.Text;
string caT = tb_Cat.Text;
string adressE = tb_Adresse.Text;
DBconnect bdd = new DBconnect();
if (bdd.Insert_Client(nclI, noM, localitE, adressE, caT, comptE) == true)
{
tb_Nom.Text = "Nom";
tb_Ncli.Text = "Nb client";
tb_Localite.Text = "Localite";
tb_Compte.Text = "Compte";
tb_Cat.Text = "Cat";
tb_Adresse.Text = "Adresse";
}
this.Close();
}
private void btn_serch_Click(object sender, EventArgs e)
{
DBconnect bdd = new DBconnect();
string resche = "";
if (rb_ncli.Checked == true)
{
resche = tb_serchCli.Text;
bdd.Recherche_Client(resche);
}
else if (rb_nom.Checked == true)
{
resche = tb_serchCli.Text;
}
else if (rb_adresse.Checked == true)
{
resche = tb_serchCli.Text;
}
else if (rb_localite.Checked == true)
{
resche = tb_serchCli.Text;
}
}
