public void reading()
{
List <cmetier.Service> list_service = service_instance.sendReqInfo();
foreach (cmetier.Service serv in list_service)
{
combo_personnel_service.Items.Add(serv.Type_service);
combo_personnel_service.Text = serv.Type_service;
}
//List<cmetier.Vehicule> list_vehicule_marque = vehicule_instance.getDisctinctVehiculesMarque();
//foreach (cmetier.Vehicule vehicule in list_vehicule_marque)
//{
// combo_personnel_marque.Items.Add(vehicule.Marque);
// combo_personnel_marque.Text = vehicule.Marque;
//}
//List<cmetier.Vehicule> list_vehicule_modele = vehicule_instance.getDistinctVehiculesModele(marque);
//foreach (cmetier.Vehicule vehicule in list_vehicule_modele)
//{
// combo_personnel_modele.Items.Add(vehicule.Modele.ToString());
// combo_personnel_modele.Text = vehicule.Modele.ToString();
//}
//marque = combo_personnel_marque.Text;
list_vehicules = vehicule_instance.getVehiculesUsed();
foreach (cmetier.Vehicule vehicule in list_vehicules)
{
vehicule_used = vehicule_instance.getVehiculeById(vehicule.Id);
combo_personnel_vehicule.Items.Add(vehicule_used.Id + "-" + vehicule_used.Marque + "-" + vehicule_used.Modele + "-" + vehicule_used.Annee);
combo_personnel_vehicule.Text = vehicule_used.Id + "-" + vehicule_used.Marque + "-" + vehicule_used.Modele + "-" + vehicule_used.Annee;
}
}
public cmetier.Vehicule getVehiculeById(int id)
{
string req = "select * from marque_modele where id='" + id + "'";
MySqlCommand cmd = form_gestion.instance.CreateCommand();
cmd.CommandText = req;
MySqlDataReader reader;
reader = cmd.ExecuteReader();
cmetier.Vehicule vehicule;
int id_vehicule = 0;
int annee = 0;
string marque = "";
string modele = "";
while (reader.Read())
{
id_vehicule = reader.GetInt32(0);
annee = reader.GetInt32(1);
marque = reader.GetString(2);
modele = reader.GetString(3);
}
reader.Close();
vehicule = new cmetier.Vehicule(id, annee, 0, 0, marque, modele, "", "diesel");
return(vehicule);
}
public List <cmetier.Vehicule> getVehiculesUsed()
{
string req = "select * from vehicules";
MySqlCommand cmd = form_gestion.instance.CreateCommand();
cmd.CommandText = req;
MySqlDataReader reader;
reader = cmd.ExecuteReader();
cmetier.Vehicule vehicule;
List <cmetier.Vehicule> list_vehicule = new List <cmetier.Vehicule>();
while (reader.Read())
{
int id = reader.GetInt32(0);
string imma = reader.GetString(1);
int nbKmEnt = reader.GetInt32(4);
int nbKmDernierEnt = reader.GetInt32(8);
vehicule = new cmetier.Vehicule(id, 0, nbKmEnt, nbKmDernierEnt, "", "", imma, "diesel");
list_vehicule.Add(vehicule);
}
reader.Close();
return(list_vehicule);
}
public List <cmetier.Vehicule> sendReqInfo()
{
string req = "select * from marque_modele";
MySqlCommand cmd = form_gestion.instance.CreateCommand();
cmd.CommandText = req;
MySqlDataReader reader;
reader = cmd.ExecuteReader();
cmetier.Vehicule vehicule;
List <cmetier.Vehicule> list_vehicule = new List <cmetier.Vehicule>();
while (reader.Read())
{
int id = reader.GetInt32(0);
int annee = reader.GetInt32(1);
string marque = reader.GetString(2);
string modele = reader.GetString(3);
vehicule = new cmetier.Vehicule(id, annee, 0, 0, marque, modele, "", "diesel");
list_vehicule.Add(vehicule);
}
reader.Close();
return(list_vehicule);
}
private void button_entretien_rdv_Click(object sender, EventArgs e)
{
int id = int.Parse(this.dgv_entretien.CurrentRow.Cells[0].Value.ToString());
string immat = this.dgv_entretien.CurrentRow.Cells[1].Value.ToString();
cmetier.Vehicule unVehicule = vehiculeDb.getVehiculeById(id);
List <cmetier.EntretienType> listeEnTypes = new List <cmetier.EntretienType>();
try
{
listeEnTypes = dicoEntypeParVehicule[unVehicule];
}
catch (KeyNotFoundException ex)
{
foreach (KeyValuePair <string, string> item in ex.Data)
{
Console.WriteLine("Key not found (Key = {0} ; value = {1})",
item.Key, item.Value);
}
}
vRdv.formRendezvous fre = new vRdv.formRendezvous(listeEnTypes, immat);
fre.ShowDialog();
Close();
}
public List <cmetier.Vehicule> getDistinctVehiculesAnnee(string marque, string modele)
{
List <cmetier.Vehicule> list_vehicule = new List <cmetier.Vehicule>();
string req = "select annee from marque_modele where marque='" + marque + "' AND modele='" + modele + "'";
MySqlCommand cmd = form_gestion.instance.CreateCommand();
cmd.CommandText = req;
MySqlDataReader reader;
reader = cmd.ExecuteReader();
cmetier.Vehicule vehicule;
while (reader.Read())
{
int annee = reader.GetInt16(0);
vehicule = new cmetier.Vehicule(0, annee, 0, 0, "", "", "", "diesel");
list_vehicule.Add(vehicule);
}
reader.Close();
return(list_vehicule);
}
public List <cmetier.Vehicule> getDisctinctVehiculesMarque()
{
string req = "select DISTINCT(marque) from marque_modele";
MySqlCommand cmd = form_gestion.instance.CreateCommand();
cmd.CommandText = req;
MySqlDataReader reader;
reader = cmd.ExecuteReader();
cmetier.Vehicule vehicule;
List <cmetier.Vehicule> list_vehicule = new List <cmetier.Vehicule>();
while (reader.Read())
{
string marque = reader.GetString(0);
vehicule = new cmetier.Vehicule(0, 0, 0, 0, marque, "", "", "diesel");
list_vehicule.Add(vehicule);
}
reader.Close();
return(list_vehicule);
}
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();
}
