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