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); } }