protected void GDV_Attribution_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
clear_meassage();
GDV_Attribution.PageIndex = e.NewPageIndex;
GDV_Attribution.DataBind();
Load_Attributions();
}
public void Load_Attributions()
{
try
{
MySqlConnection conn = new MySqlConnection(Authentification.MyString);
conn.Open();
string req = " SELECT cours.id_cours, cours.cours, personnel.nom,personnel.prenom,personnel_diplome.sigle, cours.credits,personnel.id_personnel" +
" FROM (personnel INNER JOIN (cours INNER JOIN attribution_cours ON cours.id_cours = attribution_cours.id_cours) ON personnel.id_personnel = attribution_cours.id_personnel) INNER JOIN personnel_diplome ON personnel.id_diplome = personnel_diplome.id_diplome" +
" WHERE cours.id_classe=@id_classe AND cours.id_departement=@id_departement AND cours.id_faculte=@id_faculte AND cours.id_annee=@id_annee" +
" ORDER BY cours.cours";
MySqlCommand cmd = new MySqlCommand(req, conn);
cmd.Parameters.AddWithValue("@id_classe", id_classe);
cmd.Parameters.AddWithValue("@id_departement", id_departement);
cmd.Parameters.AddWithValue("@id_faculte", id_faculte);
cmd.Parameters.AddWithValue("@id_annee", id_annee);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable dtable = new DataTable();
da.Fill(dtable);
GDV_Attribution.Columns[2].ItemStyle.HorizontalAlign = HorizontalAlign.Center;
if (dtable.Rows.Count > 0)
{
GDV_Attribution.DataSource = dtable;
GDV_Attribution.DataBind();
}
else
{
dtable.Rows.Add(dtable.NewRow());
GDV_Attribution.DataSource = dtable;
GDV_Attribution.DataBind();
GDV_Attribution.Rows[0].Cells.Clear();
GDV_Attribution.Rows[0].Cells.Add(new TableCell());
GDV_Attribution.Rows[0].Cells[0].ColumnSpan = dtable.Columns.Count;
GDV_Attribution.Rows[0].Cells[0].Text = "Aucune année académique n’a été créée à cette date";
GDV_Attribution.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
conn.Close();
}
catch (Exception ex)
{
}
}
