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