private void reading()
{
cmetier.Service service = new cmetier.Service();
MySqlDataReader reader_typeService = service.sendReqInfo();
while (reader_typeService.Read())
{
type_service.Add(reader_typeService.GetString(0));
//dgv_service.Rows.Add(reader.GetString(0), reader.GetString(1), reader.GetString(2));
}
reader_typeService.Close();
MySqlDataReader reader_nom;
MySqlCommand cmd = form_gestion.instance.CreateCommand();
for (int i = 0; i < type_service.Count(); i++)
{
string req = "SELECT DISTINCT id_salarie, nom, prenom FROM salarie WHERE type_service='" + type_service[i] + "'";
cmd.CommandText = req;
reader_nom = cmd.ExecuteReader();
while (reader_nom.Read())
{
nom_responsables.Add(reader_nom.GetString(1));
id_responsables.Add(reader_nom.GetString(0));
}
reader_nom.Close();
}
MySqlDataReader reader = service.sendReqInfo();
int cpt = 0;
int cpt_resp = nom_responsables.Count();
while (reader.Read())
{
dgv_service.Rows.Add(reader.GetString(0), reader.GetString(1));
if (cpt < cpt_resp)
{
//nom_responsable.Items.Add(nom_responsables[cpt]);
}
cpt++;
}
reader.Close();
}
public List <cmetier.Service> sendReqInfo()
{
string req = "select * from service";
MySqlCommand cmd = form_gestion.instance.CreateCommand();
cmd.CommandText = req;
MySqlDataReader reader;
reader = cmd.ExecuteReader();
cmetier.Service service;
List <cmetier.Service> list_service = new List <cmetier.Service>();
while (reader.Read())
{
String type_service = reader.GetString(0);
String libelle_service = reader.GetString(1);
service = new cmetier.Service(type_service, libelle_service);
list_service.Add(service);
}
reader.Close();
return(list_service);
}
