protected void Page_Load(object sender, EventArgs e)
{
//stocker l'id de l'utilisateur connecté
IdUser = employeRep.GetByLogin(Session["user"].ToString());
if (!IsPostBack)
{
string connetionString = ConfigurationManager.ConnectionStrings["PPPConnectionString"].ConnectionString;
//charger les demandes de conges correspondantes à ce user
BindGrid();
//Specify the connectionString , insert, select cmd of the formView
SqlDSForm.SelectCommand = demandeCongeRep.Select();
SqlDSForm.ConnectionString = connetionString;
//configuration de la liste des types de conges
SqlDSList.ConnectionString = connetionString;
SqlDSList.SelectCommand = congeRep.Select();
//config de la list des colonnes de la gridView pour le filtrage
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM INFORMATION_SCHEMA.columns as name where table_name = 'DemandeConges'", connetionString);
DataTable dt = new DataTable();
da.Fill(dt);
DropDownListColumn.DataSource = dt;
DropDownListColumn.DataValueField = "COLUMN_NAME";
DropDownListColumn.DataTextField = "COLUMN_NAME";
DropDownListColumn.DataBind();
}
}
//remplir les donnees correspondantes à l'employe choisi
private void FillData(Employe emp)
{
this.GridViewDemande.DataSource = employeCongeRepository.GetByEmployeId(emp.Id);
this.GridViewDemande.DataBind();
//config de la list des colonnes de la gridView pour le filtrage
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM INFORMATION_SCHEMA.columns as name where table_name = 'DemandeConges'", connetionString);
DataTable dt = new DataTable();
da.Fill(dt);
DropDownListColumn.DataSource = dt;
DropDownListColumn.DataValueField = "COLUMN_NAME";
DropDownListColumn.DataTextField = "COLUMN_NAME";
DropDownListColumn.DataBind();
}
