public List <cmetier.Personnel> sendReqInfo()
{
string req = "select * from salarie";
MySqlCommand cmd = form_gestion.instance.CreateCommand();
cmd.CommandText = req;
MySqlDataReader reader;
reader = cmd.ExecuteReader();
cmetier.Personnel personnel;
List <cmetier.Personnel> list_personnel = new List <cmetier.Personnel>();
while (reader.Read())
{
int id = reader.GetInt32(0);
string nom = reader.GetString(1);
string prenom = reader.GetString(2);
int mobile = reader.GetInt32(3);
string type_service = reader.GetString(4);
string mail = reader.GetString(5);
int responsable = reader.GetInt32(6);
personnel = new cmetier.Personnel(id, nom, prenom, mobile, type_service, mail, responsable, 0, "");
list_personnel.Add(personnel);
}
reader.Close();
return(list_personnel);
}
public List <cmetier.Personnel> getAllSalarieVehicule()
{
string req = "SELECT * FROM salarie WHERE immatriculation!=''";
MySqlCommand cmd = form_gestion.instance.CreateCommand();
cmd.CommandText = req;
MySqlDataReader reader;
reader = cmd.ExecuteReader();
cmetier.Personnel salarie;
List <cmetier.Personnel> list_salarie = new List <cmetier.Personnel>();
while (reader.Read())
{
int id = reader.GetInt32(0);
string nom = reader.GetString(1);
string prenom = reader.GetString(2);
int mobile = reader.GetInt32(3);
string type_service = reader.GetString(4);
string mail = reader.GetString(5);
int responsable = reader.GetInt32(6);
int id_vehicule = reader.GetInt32(7);
string immatriculation = reader.GetString(8);
salarie = new cmetier.Personnel(id, nom, prenom, mobile, type_service, mail, responsable, id_vehicule, immatriculation);
list_salarie.Add(salarie);
}
reader.Close();
return(list_salarie);
}
public bool updateResponsableTypeService(cmetier.Personnel responsable, string new_responsable)
{
string req;
MySqlCommand cmd = form_gestion.instance.CreateCommand();
req = "UPDATE salarie SET responsable='0' WHERE id_salarie='" + responsable.Id_salarie + "'";
cmd.CommandText = req;
cmd.ExecuteNonQuery();
req = "UPDATE salarie SET responsable='1' WHERE id_salarie='" + new_responsable + "'";
cmd.CommandText = req;
cmd.ExecuteNonQuery();
return(true);
}
private void _combo_vehicule_affect_service_SelectedIndexChanged(object sender, EventArgs e)
{
List <cmetier.Personnel> list_personnels = new List <cmetier.Personnel>();
MySqlDataReader personnel_reader = personneldb.getInfoSalarieService(_combo_vehicule_affect_service.SelectedItem.ToString());
while (personnel_reader.Read())
{
string nom = personnel_reader.GetString(1);
string prenom = personnel_reader.GetString(1);
int id = personnel_reader.GetInt32(0);
cmetier.Personnel perso = new cmetier.Personnel(id, nom, prenom, 0, "", "", 0, 0, "");
list_personnels.Add(perso);
}
personnel_reader.Close();
}
public List <cmetier.Personnel> getSalarieTypeService(string type_service)
{
List <cmetier.Personnel> perso = new List <cmetier.Personnel>();
MySqlDataReader reader_nom;
MySqlCommand cmd = form_gestion.instance.CreateCommand();
string req = "SELECT DISTINCT id_salarie, nom, prenom FROM salarie WHERE type_service='" + type_service + "'";
cmd.CommandText = req;
reader_nom = cmd.ExecuteReader();
while (reader_nom.Read())
{
cmetier.Personnel infoperso = new cmetier.Personnel(reader_nom.GetInt32(0), reader_nom.GetString(1), reader_nom.GetString(2), 0, "", "", 0, 0, "");
perso.Add(infoperso);
}
reader_nom.Close();
return(perso);
}
public cmetier.Personnel getResponsableTypeService(string type_service)
{
cmetier.Personnel perso;
string nom = "";
string prenom = "";
int id_salarie = 0;
MySqlDataReader reader_nom;
MySqlCommand cmd = form_gestion.instance.CreateCommand();
string req = "SELECT id_salarie, prenom, nom FROM salarie WHERE type_service='" + type_service + "' AND responsable=1";
cmd.CommandText = req;
reader_nom = cmd.ExecuteReader();
while (reader_nom.Read())
{
nom = reader_nom.GetString(2);
prenom = reader_nom.GetString(1);
id_salarie = reader_nom.GetInt16(0);
}
reader_nom.Close();
perso = new cmetier.Personnel(id_salarie, nom, prenom, 0, "", "", 0, 0, "");
return(perso);
}
public void reading()
{
list_vehicules = vehicule_instance.getVehiculesUsed();
foreach (cmetier.Vehicule vehicule in list_vehicules)
{
vehicule_used = vehicule_instance.getVehiculeById(vehicule.Id);
dgv_vehicule.Rows.Add(vehicule_used.Id, vehicule.Imma, vehicule_used.Marque, vehicule_used.Modele, vehicule_used.Annee);
}
List <cmetier.Service> list_services = new List <cmetier.Service>();
list_services = servicedb.sendReqInfo();
foreach (cmetier.Service service in list_services)
{
_combo_vehicule_affect_service.Items.Add(service.Type_service);
}
_combo_vehicule_affect_service.SelectedIndex = 0;
List <cmetier.Personnel> list_personnels = new List <cmetier.Personnel>();
MySqlDataReader personnel_reader = personneldb.getInfoSalarieService(_combo_vehicule_affect_service.SelectedItem.ToString());
while (personnel_reader.Read())
{
string nom = personnel_reader.GetString(1);
string prenom = personnel_reader.GetString(1);
int id = personnel_reader.GetInt32(0);
cmetier.Personnel perso = new cmetier.Personnel(id, nom, prenom, 0, "", "", 0, 0, "");
list_personnels.Add(perso);
}
personnel_reader.Close();
}