protected void generer_btn_Click(object sender, EventArgs e)
{
Class_Reports rap = new Class_Reports();
if (type == 0)
{
conn = new MySqlConnection(LoginForm.MyString);
conn.Open();
string rqt0 = "select count(DISTINCT semestre) from semestre INNER JOIN unite ON unite.id_semestre=semestre.id_semestre"
+ " WHERE unite.id_annee=@anne AND unite.id_faculte=@faculte AND unite.id_departement=@departement AND unite.id_classe=@classe";
MySqlCommand cmd0 = new MySqlCommand(rqt0, conn);
cmd0.Parameters.AddWithValue("@anne", id_annee);
cmd0.Parameters.AddWithValue("@faculte", id_faculte);
cmd0.Parameters.AddWithValue("@departement", id_departement);
cmd0.Parameters.AddWithValue("@classe", id_classe);
int nb_Semestre = Convert.ToInt32(cmd0.ExecuteScalar());
conn.Close();
if (nb_Semestre != 0)
{
rap.Etudiant_Rapport_Presence_par_Classe(id_annee, id_faculte, id_departement, id_classe, nom_anne, nom_faculte, nom_departement, nom_classe, has_departement, nbr_cours);
}
else
{
Response.Write("<script>alert('Echec, la classe ne contient pas des Semestres')</script>");
}
}
else if (type == 1)
{
rap.Etudiant_Rapport_Presence_par_Cours(id_annee, id_faculte, id_departement, id_classe, nom_anne, nom_faculte, nom_departement, nom_classe, has_departement, nbr_cours, nom_cours, credit_cour, id_cours);
}
}
protected void ClasseCombo_SelectedIndexChanged(object sender, EventArgs e)
{
id_classe = Convert.ToInt32(ClasseCombo.SelectedValue);
nom_classe = ClasseCombo.SelectedItem.Text;
Load_Cours();
Load_etudiant();
conn = new MySqlConnection(Authentification.MyString);
conn.Open();
//MessageBox.Show(id_annee + " " + id_faculte);
string sql0 = "SELECT COUNT(*) FROM cours WHERE id_annee = @id_annee AND id_faculte = @id_faculte AND id_departement = @id_departement AND id_classe = @id_classe;";
MySqlCommand cmd0 = new MySqlCommand(sql0, conn);
cmd0.Parameters.AddWithValue("@id_annee", id_annee);
cmd0.Parameters.AddWithValue("@id_faculte", id_faculte);
cmd0.Parameters.AddWithValue("@id_departement", id_departement);
cmd0.Parameters.AddWithValue("@id_classe", id_classe);
nbr_cours = Convert.ToInt32(cmd0.ExecuteScalar());
conn.Close();
Class_Reports rap = new Class_Reports();
if (type == 0)
{
conn = new MySqlConnection(Authentification.MyString);
conn.Open();
string rqt0 = "select count(DISTINCT semestre) from semestre INNER JOIN unite ON unite.id_semestre=semestre.id_semestre"
+ " WHERE unite.id_annee=@anne AND unite.id_faculte=@faculte AND unite.id_departement=@departement AND unite.id_classe=@classe";
MySqlCommand cmd = new MySqlCommand(rqt0, conn);
cmd.Parameters.AddWithValue("@anne", id_annee);
cmd.Parameters.AddWithValue("@faculte", id_faculte);
cmd.Parameters.AddWithValue("@departement", id_departement);
cmd.Parameters.AddWithValue("@classe", id_classe);
int nb_Semestre = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
if (nb_Semestre != 0)
{
rap.Etudiant_Rapport_Presence_par_Classe(id_annee, id_faculte, id_departement, id_classe, nom_anne, nom_faculte, nom_departement, nom_classe, has_departement, nbr_cours);
}
else
{
Response.Write("<script>alert('Echec, la classe ne contient pas des Semestres')</script>");
}
}
else if (type == 3)
{
// Response.Write("Echec de chargement des etudiants");
rap.rapprochement_presence_reussite(id_annee, id_faculte, id_departement, id_classe, nom_anne, nom_faculte, nom_departement, nom_classe, has_departement);
}
}
