public static List <Machine> GetsMachinesBDD(PosteDeCharge pdc) { if (VerifConnection()) { _conn.Open(); SqlCommand cmd = new SqlCommand { Connection = _conn, CommandText = "SELECT * FROM MACHINES WHERE POSTE_CHARGE = @pdc" }; cmd.Parameters.AddWithValue("@pdc", pdc.Code); SqlDataReader dataReader = cmd.ExecuteReader(); List <Machine> listPoste = new List <Machine>(); while (dataReader.Read()) { listPoste.Add(new Machine(dataReader[0].ToString(), dataReader[1].ToString(), new List <Indisponibilité>(), new List <Exception>(), "", 0)); } _conn.Close(); // Close the connection return(listPoste); } return(new List <Machine>()); }
public PosteDeChargeVM(PosteDeCharge pdc, SecteurVM parent) : base(parent, true) { _pdc = pdc; }