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