private void button1_Click(object sender, EventArgs e)
{
con = new SqlConnection(connectionString);
da = new SqlDataAdapter("SELECT * FROM login WHERE CIN = '" + cin.Text + "' AND password = '******'", con);
ds = new DataSet();
try
{
da.Fill(ds, "Login");
if (ds.Tables["Login"].Rows.Count != 0)
{
switch (ds.Tables["Login"].Rows[0][2].ToString())
{
case "Etudiant":
Etd = FillEtd();
Etudiant etudiant = new Etudiant(Etd);
this.Hide();
etudiant.Show();
break;
case "Enseignant":
Ens = FillEns();
Enseignant_UI.Enseignant enseignant = new Enseignant_UI.Enseignant(Ens);
this.Hide();
enseignant.Show();
break;
case "Administrateur":
admn = FillAdmin();
AdminPanel adm = new AdminPanel(admn);
this.Hide();
adm.Show();
break;
}
}
else
{
incorrect.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Erreur ! \nPlus de détials : " + ex.ToString());
}
}
_Etudiant FillEtd()
{
_Etudiant Etd;
con = new SqlConnection(connectionString);
dt.Clear();
da = new SqlDataAdapter("select * from etudiant where CIN = '" + cin.Text + "'", con);
cmdb = new SqlCommandBuilder(da);
da.Fill(dt);
string date = dt.Rows[0][4].ToString().Substring(0, 10);
string day = date.Substring(0, 2);
string month = date.Substring(3, 2);
string year = date.Substring(6, 4);
DateTime dateNai = new DateTime(Convert.ToInt32(year), Convert.ToInt32(month), Convert.ToInt32(day));
Etd = new _Etudiant(dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dt.Rows[0][3].ToString(), dateNai, dt.Rows[0][5].ToString(), dt.Rows[0][6].ToString(), dt.Rows[0][7].ToString(), dt.Rows[0][8].ToString(), "GI", dt.Rows[0][0].ToString());
return(Etd);
}
public Etudiant(_Etudiant etd)
{
InitializeComponent();
/*Disable hover - background color*/
//button1.FlatAppearance.MouseOverBackColor = button1.BackColor;
// button1.BackColorChanged += (s, e) => {
// button1.FlatAppearance.MouseOverBackColor = button1.BackColor;
//};
/*Disable hover - background color*/
//button2.FlatAppearance.MouseOverBackColor = button2.BackColor;
//button2.BackColorChanged += (s, e) => {
// button2.FlatAppearance.MouseOverBackColor = button2.BackColor;
//};
/*Disable hover - background color*/
// button3.FlatAppearance.MouseOverBackColor = button3.BackColor;
// button3.BackColorChanged += (s, e) => {
// button3.FlatAppearance.MouseOverBackColor = button3.BackColor;
//};
Etd = etd;
profile1.Etd = this.Etd;
etudiant_parcours1.Etd = etd;
etudiant_Notes1.Etd = etd;
etudiant_abscence1.Etd = etd;
}
