protected void GDV_Etat_Avancement_PageIndexChanging(object sender, GridViewPageEventArgs e)
 {
     clear_meassage();
     GDV_Etat_Avancement.PageIndex = e.NewPageIndex;
     GDV_Etat_Avancement.DataBind();
     Load_Etats();
 }
 public void Load_Etats()
 {
     try
     {
         MySqlConnection conn = new MySqlConnection(Authentification.MyString);
         conn.Open();
         string req = "SELECT DISTINCT attribution_cours.id_cours, cours.cours, cours.credits,cours.code_cours, attribution_cours.etat" +
                      " FROM (unite INNER JOIN cours ON unite.id_unite = cours.id_unite) INNER JOIN attribution_cours ON cours.id_cours = attribution_cours.id_cours" +
                      " WHERE unite.id_classe=@idcl AND unite.id_departement=@id_departement AND unite.id_faculte=@id_faculte AND unite.id_annee=@id_annee";
         MySqlCommand cmc = new MySqlCommand(req, conn);
         cmc.Parameters.AddWithValue("@idcl", id_classe);
         cmc.Parameters.AddWithValue("@id_departement", id_departement);
         cmc.Parameters.AddWithValue("@id_faculte", id_faculte);
         cmc.Parameters.AddWithValue("@id_annee", id_annee);
         MySqlDataAdapter da     = new MySqlDataAdapter(cmc);
         DataTable        dtable = new DataTable();
         da.Fill(dtable);
         GDV_Etat_Avancement.Columns[1].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
         GDV_Etat_Avancement.Columns[2].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
         GDV_Etat_Avancement.Columns[3].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
         GDV_Etat_Avancement.Columns[4].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
         if (dtable.Rows.Count > 0)
         {
             GDV_Etat_Avancement.DataSource = dtable;
             GDV_Etat_Avancement.DataBind();
         }
         else
         {
             dtable.Rows.Add(dtable.NewRow());
             GDV_Etat_Avancement.DataSource = dtable;
             GDV_Etat_Avancement.DataBind();
             GDV_Etat_Avancement.Rows[0].Cells.Clear();
             GDV_Etat_Avancement.Rows[0].Cells.Add(new TableCell());
             GDV_Etat_Avancement.Rows[0].Cells[0].ColumnSpan      = dtable.Columns.Count;
             GDV_Etat_Avancement.Rows[0].Cells[0].Text            = "Aucune année académique n’a été créée à cette date";
             GDV_Etat_Avancement.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
         }
         conn.Close();
     }
     catch (Exception ex)
     {
     }
 }
Exemple #3
0
        private void Classes_par_Departement(int id_annee, int id_faculte, int id_departement, int operation)
        {
            id_annee_combo       = id_annee;
            id_faculte_combo     = id_faculte;
            id_departement_combo = id_departement;
            int id_operation = operation;

            MySqlConnection conn = new MySqlConnection(Authentification.MyString);

            conn.Open();
            string req = "SELECT classe_par_departement.id_classe, classe.classe,classe_par_departement.etat_avancement " +
                         " FROM classe_par_departement INNER JOIN classe ON classe_par_departement.id_classe = classe.id_classe" +
                         " WHERE classe_par_departement.id_annee=@id_annee AND classe_par_departement.id_faculte=@id_faculte AND classe_par_departement.id_departement=@id_departement";
            MySqlCommand cmd = new MySqlCommand(req, conn);

            cmd.Parameters.AddWithValue("@id_annee", id_annee);
            cmd.Parameters.AddWithValue("@id_faculte", id_faculte);
            cmd.Parameters.AddWithValue("@id_departement", id_departement);
            MySqlDataAdapter da     = new MySqlDataAdapter(cmd);
            DataTable        dtable = new DataTable();

            da.Fill(dtable);

            switch (id_operation)
            {
            case 1:
                GDV_Gestion.Columns[0].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
                GDV_Gestion.Columns[1].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
                GDV_Gestion.Columns[2].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
                if (dtable.Rows.Count > 0)
                {
                    GDV_Gestion.DataSource = dtable;
                    GDV_Gestion.DataBind();
                }
                else
                {
                    dtable.Rows.Add(dtable.NewRow());
                    GDV_Gestion.DataSource = dtable;
                    GDV_Gestion.DataBind();

                    GDV_Gestion.Rows[0].Cells.Clear();
                    GDV_Gestion.Rows[0].Cells.Add(new TableCell());
                    GDV_Gestion.Rows[0].Cells[0].ColumnSpan      = dtable.Columns.Count;
                    GDV_Gestion.Rows[0].Cells[0].Text            = "Aucune classe dans ce départemnt";
                    GDV_Gestion.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
                }
                break;

            case 2:
                GDV_Etat_Avancement.Columns[0].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
                GDV_Etat_Avancement.Columns[1].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
                GDV_Etat_Avancement.Columns[2].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
                if (dtable.Rows.Count > 0)
                {
                    GDV_Etat_Avancement.DataSource = dtable;
                    GDV_Etat_Avancement.DataBind();
                }
                else
                {
                    dtable.Rows.Add(dtable.NewRow());
                    GDV_Etat_Avancement.DataSource = dtable;
                    GDV_Etat_Avancement.DataBind();

                    GDV_Etat_Avancement.Rows[0].Cells.Clear();
                    GDV_Etat_Avancement.Rows[0].Cells.Add(new TableCell());
                    GDV_Etat_Avancement.Rows[0].Cells[0].ColumnSpan      = dtable.Columns.Count;
                    GDV_Etat_Avancement.Rows[0].Cells[0].Text            = "Aucune classe dans ce départemnt";
                    GDV_Etat_Avancement.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
                }
                break;
            }
            conn.Close();
        }