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); }