private void button1_Click(object sender, EventArgs e)
{
if (textBox2.Text == string.Empty)
{
textBox2.Focus();
errorProvider1.SetError(textBox2, "Ne peut pas etre vide");
}
if (textBox1.Text == string.Empty)
{
textBox1.Focus();
errorProvider2.SetError(textBox1, "Ne peut pas etre vide");
}
if (textBox1.Text != string.Empty)
{
errorProvider2.Clear();
}
if (textBox2.Text != string.Empty)
{
errorProvider1.Clear();
}
if ((textBox1.Text != string.Empty) && (textBox2.Text != string.Empty))
{
using (SqlConnection con = Get_Connection())
{
con.Open();
String req = "Select nom, prenom from employes where login='******'and password='******'";
using (SqlCommand cmd = new SqlCommand(req, con))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
string nom = reader.GetString(0);
string prenom = reader.GetString(1);
// int id = reader.Get;
Accueil ss = new Accueil(nom, prenom);
ss.Show();
this.Hide();
}
else
{
MessageBox.Show("Login ou mot de passe incorrecte", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox6.Text == string.Empty)
{
textBox6.Focus();
errorProvider1.SetError(textBox6, "Ne peut pas etre vide");
}
if (textBox6.Text != string.Empty)
{
errorProvider1.Clear();
}
if (textBox2.Text == string.Empty)
{
textBox2.Focus();
errorProvider2.SetError(textBox2, "Ne peut pas etre vide");
}
if (textBox2.Text != string.Empty)
{
errorProvider2.Clear();
}
if (textBox3.Text == string.Empty)
{
textBox3.Focus();
errorProvider3.SetError(textBox3, "Ne peut pas etre vide");
}
if (textBox3.Text != string.Empty)
{
errorProvider3.Clear();
}
if (textBox4.Text == string.Empty)
{
textBox4.Focus();
errorProvider4.SetError(textBox4, "Ne peut pas etre vide");
}
if ((!(textBox4.Text.Contains("@"))) || (!(textBox4.Text.Contains("."))))
{
textBox4.Focus();
errorProvider4.SetError(textBox4, "Email n'est pas valide");
}
if ((textBox4.Text != string.Empty) && (textBox4.Text.Contains("@")) && (textBox4.Text.Contains(".")))
{
errorProvider4.Clear();
}
if (textBox5.Text == string.Empty)
{
textBox5.Focus();
errorProvider5.SetError(textBox5, "Ne peut pas etre vide");
}
if (textBox5.Text != string.Empty)
{
errorProvider5.Clear();
}
if (textBox7.Text == string.Empty)
{
textBox7.Focus();
errorProvider6.SetError(textBox7, "Ne peut pas etre vide");
}
if (textBox7.Text != string.Empty)
{
errorProvider6.Clear();
}
if ((textBox7.Text != string.Empty) && (textBox2.Text != string.Empty) && (textBox3.Text != string.Empty) && (textBox4.Text != string.Empty) && (textBox5.Text != string.Empty) && (textBox6.Text != string.Empty) && (textBox4.Text.Contains("@")) && (textBox4.Text.Contains(".")))
{
using (SqlConnection conn = Get_Connection())
{
conn.Open();
String req = "INSERT INTO employes (login, password,nom,prenom,mail,tel) VALUES ('" + textBox6.Text + "','" + textBox7.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
String req2 = "select * from employes where login ='******'";
using (SqlCommand cmd = new SqlCommand(req2, conn))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
MessageBox.Show("Le login existe deja", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
else
{
reader.Close();
using (SqlCommand cmd2 = new SqlCommand(req, conn))
{
cmd2.ExecuteNonQuery();
}
MessageBox.Show("L'inscription a été effectuée avec succés", "Inscription", MessageBoxButtons.OKCancel);
Accueil ss = new Accueil(textBox2.Text, textBox3.Text);
ss.Show();
this.Hide();
}
}
}
}
}
}
