public List <C_T_Liaison_C> Lire(string Index)
{
CreerCommande("SelectionnerT_Liaison_C");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_T_Liaison_C> res = new List <C_T_Liaison_C>();
while (dr.Read())
{
C_T_Liaison_C tmp = new C_T_Liaison_C();
tmp.Id_Liaison_C = int.Parse(dr["Id_Liaison_C"].ToString());
if (dr["Id_Activite"] != DBNull.Value)
{
tmp.Id_Activite = int.Parse(dr["Id_Activite"].ToString());
}
if (dr["Id_Chef1"] != DBNull.Value)
{
tmp.Id_Chef1 = int.Parse(dr["Id_Chef1"].ToString());
}
if (dr["Id_Chef2"] != DBNull.Value)
{
tmp.Id_Chef2 = int.Parse(dr["Id_Chef2"].ToString());
}
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public C_T_Liaison_C Lire_ID(int Id_Liaison_C)
{
CreerCommande("SelectionnerT_Liaison_C_ID");
Commande.Parameters.AddWithValue("@Id_Liaison_C", Id_Liaison_C);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_T_Liaison_C res = new C_T_Liaison_C();
while (dr.Read())
{
res.Id_Liaison_C = int.Parse(dr["Id_Liaison_C"].ToString());
if (dr["Id_Activite"] != DBNull.Value)
{
res.Id_Activite = int.Parse(dr["Id_Activite"].ToString());
}
if (dr["Id_Chef1"] != DBNull.Value)
{
res.Id_Chef1 = int.Parse(dr["Id_Chef1"].ToString());
}
if (dr["Id_Chef2"] != DBNull.Value)
{
res.Id_Chef2 = int.Parse(dr["Id_Chef2"].ToString());
}
}
dr.Close();
Commande.Connection.Close();
return(res);
}
