private void connectionbtn_Click(object sender, EventArgs e)
{
/* Boolean accessg = false;
* Boolean accessc = false;
* string ss;
* try
* {
* string connexionString = (@"Data Source=C:\Users\pc\documents\visual studio 2010\Projects\gestion_café\gestion_café\base_café.sdf");
* SqlCeConnection connection = new SqlCeConnection(connexionString);
* connection.Open();
*
* SqlCeCommand cmd1 = new SqlCeCommand("select * from login where id=@id_log and mdp=@psw ", connection);
*
* string psw = mdp.Text;
* string id_log = Nom.Text;
*
* cmd1.Parameters.AddWithValue("@id_log", id_log);
* cmd1.Parameters.AddWithValue("@psw", psw);
* SqlCeDataReader rdr = null;
* rdr = cmd1.ExecuteReader();
*
* while (rdr.Read())
* {
* if (rdr.GetString(0) == id_log && rdr.GetString(1) == psw)
* {
* string s = "gerant";
* ss=rdr.GetString(2);
* name_c = ss;
* if (ss == s)
*
* { accessg = true; }
* else { accessc = true; }
*
*
* }
*
*
*
*
* }
* if (accessg == true)
* {
* interfacegerant m = new interfacegerant();
* m.Show();
* this.SetVisibleCore(false);
* }
* else if (accessc == true)
* {
* intcaissier n = new intcaissier();
* n.Show();
*
*
* this.SetVisibleCore(false);
*
*
* }
* else
* {
* MessageBox.Show("Connexion Echouer", "Connexion", MessageBoxButtons.OK, MessageBoxIcon.Error);
* Connexion n = new Connexion();
* }
* connection.Close();
* }
* catch (Exception exc) { Console.WriteLine(exc.Message); }*/
if ((mdp.Text) == "gerant" && (Nom.Text) == "gerant")
{
interfacegerant m = new interfacegerant();
m.Show();
this.SetVisibleCore(false);
}
else if ((mdp.Text) == "caissier" && (Nom.Text) == "caissier")
{
intcaissier n = new intcaissier();
n.Show();
this.SetVisibleCore(false);
}
else
{
MessageBox.Show("Connexion Echouer", "Connexion", MessageBoxButtons.OK, MessageBoxIcon.Error);
Connexion n = new Connexion();
}
}
private void Connecte_Load(object sender, EventArgs e)
{
Connexion connexion = new Connexion();
BonjourText.Text = "Bonjour " + this.id;
}