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 generer_btn_Click(object sender, EventArgs e)
{
Class_Reports rap = new Class_Reports();
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);
}
}
