Administrateur FillAdmin()
{
Administrateur Admin;
con = new SqlConnection(connectionString);
dt.Clear();
da = new SqlDataAdapter("select * from Administrateur where CIN = '" + cin.Text + "'", con);
cmdb = new SqlCommandBuilder(da);
da.Fill(dt);
string date = dt.Rows[0][3].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));
Admin = new Administrateur(dt.Rows[0][0].ToString(), dt.Rows[0][1].ToString(), dt.Rows[0][2].ToString(), dateNai, dt.Rows[0][4].ToString(), dt.Rows[0][5].ToString(), dt.Rows[0][6].ToString(), dt.Rows[0][7].ToString(), "filiere");
return(Admin);
}
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());
}
}
public AdminPanel(Administrateur adm)
{
InitializeComponent();
adminProfile1.admin = adm;
}