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 Print_Button_Click(object sender, ImageClickEventArgs e)
{
Class_Reports rap = new Class_Reports();
Response.Write("<script>alert('" + id_annee + " ," + annee + " ," + id_faculte + " ," + nom_faculte + " ," + has_depaartement + " ," + id_departement + " ," + nom_departement + " ," + id_classe + " ," + nom_classe + " ," + id_cours + " ," + nom_cours + "')</script>");
rap.prestations_history(id_annee, annee, id_faculte, nom_faculte, has_depaartement, id_departement, nom_departement, id_classe, nom_classe, id_cours, nom_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);
}
}
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);
}
}
protected void Button_etud_Click(object sender, EventArgs e)
{
Class_Reports rap = new Class_Reports();
rap.Rapport_Presence_par_etudiant(id_annee, id_faculte, id_departement, id_classe, nom_anne, nom_faculte, nom_departement, nom_classe, id_etudiant, nom_etudiant, date_text.Value);
}
protected void Enregistrer_Button_Click(object sender, EventArgs e)
{
//try
//{
conn.Open();
if (NomTextBox.Text != "" && PrenomTextBox.Text != "" && Region_ComboBox.SelectedValue != "-1" && PaysTextBox.Text != "" && Genre_ComboBox.SelectedValue != "-1" && EtatCivil_ComboBox.SelectedValue != "-1" && Identite_Type_ComboBox.SelectedValue != "-1" && IdentiteNumberTextBox.Text != "" && EmailTextBox.Text != "")
{
string req = "SELECT COUNT(*) FROM etudiant WHERE nom=@nom AND prenom=@prenom AND naissance_date=@naissance_date AND naissance_pays=@pays AND email=@email";
MySqlCommand cmd = new MySqlCommand(req, conn);
cmd.Parameters.AddWithValue("@nom", NomTextBox.Text);
cmd.Parameters.AddWithValue("@prenom", PrenomTextBox.Text);
cmd.Parameters.AddWithValue("@naissance_date", NaissanceDatePicker.Text);
cmd.Parameters.AddWithValue("@pays", PaysTextBox.Text);
cmd.Parameters.AddWithValue("@email", EmailTextBox.Text);
int nbre_etu = Convert.ToInt32(cmd.ExecuteScalar());
if (nbre_etu == 0)
{
Generate_Matricule();
string str = "INSERT INTO etudiant(code_inscri, matricule, nom, prenom, genre, naissance_date, naissance_region, naissance_pays, naissance_province, naissance_commune," +
" naissance_zone, etat_civil, identite, telephone, email, etablissement, section, promotion, note_classe, note_exetat, note_synthese, note_medecine,reussite_exetat, hebergement, boursier,etat_etudes,photo)" +
" VALUES (@code_inscri, @matricule, @nom, @prenom, @genre, @naissance_date, @naissance_region, @naissance_pays, @naissance_province, @naissance_commune, @naissance_zone," +
" @etat_civil, @identite, @telephone, @email, @etablissement, @section, @promotion, @note_classe, @note_exetat, @note_synthese, @note_medecine, @reussite_exetat,@hebergement, @boursier,@etat_etudes,@photo)";
MySqlCommand cmda = new MySqlCommand(str, conn);
cmda.Parameters.AddWithValue("@code_inscri", code_inscri);
cmda.Parameters.AddWithValue("@matricule", matricule);
cmda.Parameters.AddWithValue("@nom", NomTextBox.Text);
cmda.Parameters.AddWithValue("@prenom", PrenomTextBox.Text);
cmda.Parameters.AddWithValue("@genre", Genre_ComboBox.Text);
cmda.Parameters.AddWithValue("@naissance_date", NaissanceDatePicker.Text);
cmda.Parameters.AddWithValue("@naissance_region", Region_ComboBox.Text);
cmda.Parameters.AddWithValue("@naissance_pays", PaysTextBox.Text);
cmda.Parameters.AddWithValue("@naissance_province", ProvinceTextBox.Text);
cmda.Parameters.AddWithValue("@naissance_commune", CommuneTextBox.Text);
cmda.Parameters.AddWithValue("@naissance_zone", ZoneTextBox.Text);
cmda.Parameters.AddWithValue("@etat_civil", EtatCivil_ComboBox.Text);
cmda.Parameters.AddWithValue("@identite", Identite_Type_ComboBox.Text + "-" + IdentiteNumberTextBox.Text);
cmda.Parameters.AddWithValue("@telephone", PhoneTextBox.Text);
cmda.Parameters.AddWithValue("@email", EmailTextBox.Text);
cmda.Parameters.AddWithValue("@etablissement", EtablissementTextbox.Text);
cmda.Parameters.AddWithValue("@section", SectionTextBox.Text);
cmda.Parameters.AddWithValue("@promotion", PromotionTextbox.Text);
cmda.Parameters.AddWithValue("@note_classe", NoteClasseTextbox.Text);
cmda.Parameters.AddWithValue("@note_exetat", NoteExetatTextBox.Text);
cmda.Parameters.AddWithValue("@note_synthese", NoteSynthesetextBox.Text);
cmda.Parameters.AddWithValue("@note_medecine", NoteTestMedecineTextBox.Text);
cmda.Parameters.AddWithValue("@reussite_exetat", etat_exetat);
cmda.Parameters.AddWithValue("@hebergement", id_hebergement);
cmda.Parameters.AddWithValue("@boursier", id_boursier);
cmda.Parameters.AddWithValue("@etat_etudes", etat_etudes);
cmda.Parameters.AddWithValue("@photo", file_path);
cmda.ExecuteNonQuery();
Response.Write("<script>alert('Enregistrement reussie !')</script>");
MatriculeTextbox.Text = matricule;
Class_Reports rp = new Class_Reports();
rp.etudiant_matricule_Generate_pdf(NomTextBox.Text.ToString(), PrenomTextBox.Text.ToString(), MatriculeTextbox.Text);
ViderLesChamps();
Base.charger_GridView(sender, e, "SELECT id_etudiant, concat(nom,' ',prenom)as etudiant , matricule, telephone, naissance_pays, note_classe, note_exetat FROM etudiant ORDER BY id_etudiant DESC LIMIT 20", Gridetudiant);
}
else
{
Response.Write("<script>alert('Etudiant existe deja !')</script>");
ViderLesChamps();
}
}
else
{
Response.Write("<script>alert('Chargez toutes les informations necessaire svp!')</script>");
}
conn.Close();
cpt_etat_etudes = -1;
cpt_etat_exetat = -1;
//}
//catch (Exception ex)
//{
// Response.Write("<script>alert(' Echec, enregistrement echoué !')</script>");
// return;
//}
}
