private void btnSearch_Click(object sender, EventArgs e) { if (txtSearch.Text == "") { MessageBox.Show("La boite de recherche est vide"); } else { dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { connection.Open(); //read from the data base SqlDataAdapter query = new SqlDataAdapter("Select quantiteproduit,prixvente,prixventemin from produit where idproduit='" + txtSearch.Text.Trim() + "'", connection); DataTable dataTable = new DataTable(); query.Fill(dataTable); DataGridView.Visible = true; DataGridView.DataSource = dataTable; } catch (SqlException expectation) { MessageBox.Show(expectation.ToString()); } finally { connection.Close(); } } }
//chack the bigest Id in the table achat private int bigerIdInTab() { int i = 0; int id = 0; dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { connection.Open(); SqlDataAdapter query = new SqlDataAdapter("select max(idachat) from achat", connection); DataTable dataTable = new DataTable(); query.Fill(dataTable); string idachat = dataTable.Rows[0][0].ToString(); i = Convert.ToInt32(idachat); id = i + 1; // MessageBox.Show(id.ToString()); } catch (SqlException expectation) { MessageBox.Show(expectation.ToString()); } finally { connection.Close(); } return(id); }
private void btnSearch_Click(object sender, EventArgs e) { if (txtSearch.Text == "") { MessageBox.Show("La boite de recherche est vide"); } else { dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { connection.Open(); //read from the data base SqlDataAdapter query = new SqlDataAdapter("Select nomfornissur,active,numero,adresse,ville,gouvernement from fornisseur where idfornisseur='" + txtSearch.Text.Trim() + "'", connection); DataTable dataTable = new DataTable(); query.Fill(dataTable); DataGridView.Visible = true; DataGridView.DataSource = dataTable; } catch (SqlException expectation) { MessageBox.Show(expectation.ToString()); } finally { connection.Close(); } } }
//connecion pour la page User d admin et password public SqlDataAdapter select(SqlConnection connection, string text1, string text2) { dataBase data = new dataBase(); connection = data.connectiondata(); connection.Open(); SqlDataAdapter query = new SqlDataAdapter("Select * from utilisateur where login='******' and password='******'", connection); return(query); }
private void button1_Click(object sender, EventArgs e) { int num; if (iDTextBox.Text == "" || nameTextBox.Text == "" || numerotextbox.Text == "" || adressebox.Text == "" || villetextbox.Text == "" || governmenttextBox.Text == "") { MessageBox.Show("Tu as oublie un espace vide"); } else if (int.TryParse(numerotextbox.Text.Trim(), out num) == false) { MessageBox.Show("vous voulez -vous vérifier le numero de telephone "); } else { string active = Active(); dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { connection.Open(); SqlCommand query = new SqlCommand("Insert into fornisseur Values(@idfornisseur,@nomfornissur,@active,@numero,@adresse,@ville,@gouvernement)", connection); query.Parameters.AddWithValue("@idfornisseur", iDTextBox.Text.Trim().ToLower()); query.Parameters.AddWithValue("@nomfornissur", nameTextBox.Text.Trim().ToLower()); query.Parameters.AddWithValue("@active", active); query.Parameters.AddWithValue("@numero", num); query.Parameters.AddWithValue("@adresse", adressebox.Text.Trim().ToLower()); query.Parameters.AddWithValue("@ville", villetextbox.Text.Trim().ToLower()); query.Parameters.AddWithValue("@gouvernement", governmenttextBox.Text.Trim().ToLower()); query.ExecuteNonQuery(); if (MessageBox.Show("Est ce que vous voulez ajouter un autre Fornisseur ?", "Add to db", MessageBoxButtons.YesNo) == DialogResult.Yes) { this.Show(); } else { new Formfornisseur().Show(); this.Hide(); } } catch (SqlException expectation) { MessageBox.Show("voulez verifier votre Cle primaire et vos Informations", expectation.ToString()); } finally { connection.Close(); vider(); } } }
private void updatedata(string text) { dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { SqlCommand query = new SqlCommand(text, connection); connection.Open(); query.ExecuteNonQuery(); } catch (SqlException expectation) { MessageBox.Show(expectation.ToString()); } finally { connection.Close(); } }
private void button1_Click(object sender, EventArgs e) { string active = Active(); dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { SqlCommand query = new SqlCommand("Update fornisseur set active = '" + active + "' where idfornisseur='" + txtSearch.Text.Trim().ToLower() + "'", connection); connection.Open(); query.ExecuteNonQuery(); MessageBox.Show("Le type de fornisseur a ete mise a jours"); } catch (SqlException expectation) { MessageBox.Show(expectation.ToString()); } finally { connection.Close(); } }
//fonction pour la select et recherche private void getdata(string text) { dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { connection.Open(); //read from the data base SqlDataAdapter query = new SqlDataAdapter(text, connection); DataTable dataTable = new DataTable(); query.Fill(dataTable); DataGridView.Visible = true; DataGridView.DataSource = dataTable; } catch (SqlException expectation) { MessageBox.Show(expectation.ToString()); } finally { connection.Close(); } }
private void Login_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("Login ou mot de passe sont Vide", "Login/Pass"); } else { dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { SqlDataAdapter query = data.select(connection, textBox1.Text, textBox2.Text); DataTable dataTable = new DataTable(); this.Check(dataTable, query); } catch (SqlException expectation) { MessageBox.Show("Error,check login or password", expectation.ToString()); } finally { connection.Close(); } } }
private void button1_Click(object sender, EventArgs e) { int quantite; double PUHT; int remise; int tva; if (iDTextBox.Text == "" || nomTextBox.Text == "" || quantiteBox.Text == "" || categorietextBox.Text == "" || PUHTtextBox.Text == "" || RemisetextBox.Text == "" || TVAtextBox.Text == "") { MessageBox.Show("Tu as oublie un espace vide"); } else if (int.TryParse(quantiteBox.Text, out quantite) == false) { MessageBox.Show("vous voulez -vous vérifier la quantite ", "Quantite"); } else if (double.TryParse(PUHTtextBox.Text, out PUHT) == false) { MessageBox.Show("vous voulez -vous vérifier le PUHT ", "PUHT"); } else if (PUHTtextBox.Text.Trim() == "0") { MessageBox.Show("vous voulez -vous changer le PUHT(pas egal zero)", "PUHT"); } else if (int.TryParse(RemisetextBox.Text, out remise) == false) { MessageBox.Show("vous voulez -vous vérifier la Remise ", "Remise"); } else if (RemisetextBox.Text.Trim() == "0") { MessageBox.Show("vous voulez -vous changer le Remise(pas egal zero) ", "PUHT"); } else if (int.TryParse(TVAtextBox.Text, out tva) == false) { MessageBox.Show("vous voulez -vous vérifier le TVA", "TVA"); } else if (TVAtextBox.Text.Trim() == "0") { MessageBox.Show("vous voulez -vous changer le TVA (pas egal zero)", "PUHT"); } else { string unite; double montantH = 0; double PUTT = 0; double PUTTTtotal = 0; double prixvente = 0; double pritventmin = 0; int id = bigerIdInTab(); //see wich radio button is chcked if (radioButton1.Checked == true) { unite = "PC"; } else { unite = "CT"; } //calculate montantH = quantite * (PUHT - ((PUHT / 100) * remise)); PUTTTtotal = montantH + ((montantH / 100) * Convert.ToDouble(tva)); PUTT = PUTTTtotal / quantite; prixvente = PUTT + ((PUTT / 100) * 15); pritventmin = PUTT + ((PUTT / 100) * 10); dataBase data = new dataBase(); SqlConnection connection = data.connectiondata(); try { connection.Open(); SqlCommand query = new SqlCommand("Insert into produit Values(@idproduit,@nomproduit,@unite,@Quantiteproduit,@prixvente,@prixventemin,@categorie)", connection); query.Parameters.AddWithValue("@idproduit", iDTextBox.Text.Trim().ToLower()); query.Parameters.AddWithValue("@nomproduit", nomTextBox.Text.Trim().ToLower()); query.Parameters.AddWithValue("@unite", unite); query.Parameters.AddWithValue("@Quantiteproduit", quantite); query.Parameters.AddWithValue("@prixvente", prixvente); query.Parameters.AddWithValue("@prixventemin", pritventmin); query.Parameters.AddWithValue("@categorie", categorietextBox.Text.Trim().ToLower()); query.ExecuteNonQuery(); //second command to add in achat SqlCommand query2 = new SqlCommand("Insert into achat Values(@idachat,@Dataachat,@PUHT,@Remise,@TVA,@montantH,@PUTT,@login,@idproduit)", connection); query2.Parameters.AddWithValue("@idachat", id); query2.Parameters.AddWithValue("@Dataachat", DateTime.Today); query2.Parameters.AddWithValue("@PUHT", PUHT); query2.Parameters.AddWithValue("@Remise", remise); query2.Parameters.AddWithValue("@TVA", tva); query2.Parameters.AddWithValue("@montantH", montantH); query2.Parameters.AddWithValue("@PUTT", PUTT); query2.Parameters.AddWithValue("@Login", Form1.pass.ToString().ToLower()); query2.Parameters.AddWithValue("@idproduit", iDTextBox.Text.Trim().ToLower()); query2.ExecuteNonQuery(); if (MessageBox.Show("Est ce que vous voulez ajouter un autre Produit ?", "Add to db", MessageBoxButtons.YesNo) == DialogResult.Yes) { this.Show(); } else { new Formproduit().Show(); this.Hide(); } } catch (SqlException expectation) { //"voulez verifier votre Cle primaire et vos Informations", MessageBox.Show("Will you check your information", "General Exception :" + expectation.ToString()); } catch (ArithmeticException mathExc) { MessageBox.Show("Some wrong Number", "Arithmetic Exception " + mathExc.ToString()); } finally { connection.Close(); // vider(); } } }