public List <InterventionType> GetListOfInterventionType() { if (connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } List <InterventionType> listInterventionTypes = new List <InterventionType>(); InterventionType interventionType; string selectCommand = $@"SELECT InterventionTypeName FROM interventiontype;"; command = new MySqlCommand(selectCommand, connection); var reader = command.ExecuteReader(); if (reader.HasRows) { int counter = 0; while (reader.Read()) { interventionType = new InterventionType(); interventionType.Type = reader.GetString(0); listInterventionTypes.Add(interventionType); counter++; } } reader.Close(); connection.Close(); return(listInterventionTypes); }
public Intervention(Client client, Intervenant intervenant, InterventionType interventionType) { this.client = client; this.intervenant = intervenant; this.interventionType = interventionType; }