public void comare(DateTime date, out String erreur, out List <Personel_class> list, out Boolean exist)
{
erreur = null;
list = new List <Personel_class>();
Personel_class per = new Personel_class();
exist = false;
rsql = "select * from employe where DATENAISSENCE <'" + date.ToShortDateString() + "' ";
cnx.select(rsql, out erreur, out dr);
if (erreur == null)
{
if (dr.HasRows == true)
{
exist = true;
while (dr.Read())
{
per = new Personel_class();
per.Nom = dr.GetString(2);
list.Add(per);
}
}
dr.Close();
}
}
public void modifier_Personel(Personel_class per, out String erreur)
{
erreur = null;
rsql = "update employe set nom='" + per.Nom + "',prenom='" + per.Prenom + "',DATENAISSENCE='" + per.datenais.ToShortDateString() + "',sexe='" + per.sexxe + "',ROLE='" + per.Role + "',etat_civil='" + per.etatcivil + "',adresse='" + per.Adresse + "',date_recrutement='" + per.daterecrutement.ToShortDateString() + "',TELEPHONESOCEITE='" + per.telephonesociete + "',ville='" + per.villes + "',LIEUNAISSENCE='" + per.lieux + "',id_ent=" + per.id_entr + ",TELEPHONEPRIVE='" + per.Telephone_prive + "',DEPARTEMENT='" + per.Departements + "',SERVICE='" + per.Services + "',EMAIL='" + per.EMAIL + "',LOGIN='******',MOTPASS='******' where MATRICULE='" + per.Matricule + "' ";
cnx.maj(rsql, out erreur);
}
public void ajouter_Per(Personel_class per, out String erreur)
{
// dr.Close();
erreur = null;
rsql = "insert into employe (MATRICULE, CIN, NOM, PRENOM, DATENAISSENCE, LIEUNAISSENCE, SEXE, ROLE, ETAT_CIVIL, ADRESSE, DATE_RECRUTEMENT, TELEPHONESOCEITE, TELEPHONEPRIVE, VILLE, ID_ENT,DEPARTEMENT,SERVICE,EMAIL,LOGIN,MOTPASS) values('" + per.Matricule + "','" + per.cin + "','" + per.Nom + "','" + per.Prenom + "','" + per.datenais.ToShortDateString() + "','" + per.lieux + "','" + per.sexxe + "','" + per.Role + "','" + per.etatcivil + "','" + per.Adresse + "','" + per.daterecrutement.ToShortDateString() + "','" + per.telephonesociete + "','" + per.Telephone_prive + "','" + per.villes + "'," + per.id_entr + ",'" + per.Departements + "','" + per.Services + "','" + per.EMAIL + "','" + per.LOGIN + "','" + per.Pass + "')";
cnx.maj(rsql, out erreur);
}
/*
* public void ajouter_Personal_dataTable(Personel_class pr)
* {
*
* cnx.Read("employe");
* DataTable datatable = new DataTable();
* DataRow drToAdd = datatable.NewRow();
*
* drToAdd["Cin"] = pr.cin;
* drToAdd["nom"] = pr.Nom;
* drToAdd["prenom"] = pr.Prenom;
* drToAdd["datenais"] = pr.datenais;
* drToAdd["sexe"] = pr.sexxe;
* drToAdd["fonction"] = pr.Fonction;
* drToAdd["nb_enfant"] = pr.nbenfant;
* drToAdd["etat_civil"] = pr.etatcivil;
* drToAdd["adresse"] = pr.Adresse;
* drToAdd["date_recrutement"] = pr.daterecrutement;
* drToAdd["echlon"] = pr.echlons;
* drToAdd["telephone"] = pr.telephonesociete;
* drToAdd["ville"] = pr.villes;
* drToAdd["nationalite"] = pr.natio;
* drToAdd["num_CNSS"] = pr.num_cnss;
* drToAdd["salaire_base"] = pr.salaire_bases;
* drToAdd["date_sortie"] = pr.date_sorti;
* drToAdd["lieu"] = pr.lieux;
* /* drToAdd["ARRIERE_CONGE"] = pr.Arrier_conge;
* drToAdd["DROIT_ANNER_COURANT"] = pr.Droit_annner_courant;
* drToAdd["PRIS_ANNER_COURANT"] = pr.Pris_anner_courant;
*
* datatable.Rows.Add(drToAdd);
*
* }
*/
public void chercher_ListePersonelSelon_Matricule(String mat, out String erreur, out List <Personel_class> list, out Boolean exist)
{
erreur = null;
list = new List <Personel_class>();
Personel_class per = new Personel_class();
exist = false;
rsql = "select * from employe where employe.MATRICULE='" + mat + "' ";
cnx.select(rsql, out erreur, out dr);
if (erreur == null)
{
if (dr.HasRows == true)
{
exist = true;
while (dr.Read())
{
per = new Personel_class();
per.Matricule = dr.GetString(0);
per.cin = dr.GetString(1);
per.Nom = dr.GetString(2);
per.Prenom = dr.GetString(3);
per.datenais = dr.GetDateTime(4);
per.lieux = dr.GetString(5);
per.sexxe = dr.GetString(6);
per.Role = dr.GetString(7);
per.etatcivil = dr.GetString(8);
per.Adresse = dr.GetString(9);
per.daterecrutement = dr.GetDateTime(10);
per.telephonesociete = dr.GetString(11);
per.Telephone_prive = dr.GetString(12);
per.villes = dr.GetString(13);
per.id_entr = dr.GetInt32(14);
per.Departements = dr.GetString(15);
per.Services = dr.GetString(16);
per.EMAIL = dr.GetString(17);
per.LOGIN = dr.GetString(18);
per.Pass = dr.GetString(19);
list.Add(per);
}
}
dr.Close();
}
}
public void supprimer_Employer(Personel_class pers, out String erreur)
{
erreur = null;
rsql = "delete from employe where employe.Matricule='" + pers.Matricule + "' ";
cnx.maj(rsql, out erreur);
}
