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