/// <summary>
/// Exécuter la requête et Incrementation de la version de la base de données
/// </summary>
/// <param name="increment"></param>
public void ExecutInDataBase(IncrementationDB increment)
{
MyConnection.ExecuteNonQuery(increment.Increment);
string query = "Insert into VersionDB(Version) values('" + increment.Code + "');";
MyConnection.ExecuteNonQuery(query);
}
public void Update(Stagiaire s)
{
String Requete = "Update Stagiaires set Nom='" + s.Nom + "',Prenom='" + s.Prenom + "',DateNaissance='" + s.DateNaissance + "',Sexe=" + s.Sexe +
",Cin='" + s.Cin + "',Email='" + s.Email + "',Telephone ='" + s.Telephone + "',Adresse='" + s.Adresse + "',Images = '" + s.ProfilImage + "',IdGroupe=" + s.Groupe.Id + " where id=" + s.Id;
MyConnection.ExecuteNonQuery(Requete);
}
public int Add(Stagiaire s)
{
string Requete = "insert into stagiaires(Nom,Prenom,DateNaissance,sexe,Cin,Email,Telephone,Adress,ProfilImage,Etat,Filiere_id) values ('" +
s.Nom + "','" + s.Prenom + "','" + s.DateNaissance + "'," + 1 + ",'" + s.Cin + "','" + s.Email + "','" + s.Telephone + "','" + s.Adresse + "','" +
s.ProfilImage + "'," + s.Etat + "," + s.Filiere.Id + ")";
return(MyConnection.ExecuteNonQuery(Requete));
}
public void Add(Stagiaire s)
{
string Requete = "insert into stagiaires(Nom,Prenom,DateNaissance,sexe,Cin,Email,Telephone,Adresse,Images,Etat,idGroupe) values ('" +
s.Nom + "','" + s.Prenom + "','" + s.DateNaissance + "'," + 1 + ",'" + s.Cin + "','" + s.Email + "','" + s.Telephone + "','" + s.Adresse + "','" +
s.ProfilImage + "'," + s.Etat + "," + s.Groupe.Id + ")";
MyConnection.ExecuteNonQuery(Requete);
}
public void Add(Groupe g)
{
string Requete = "Insert into Groupes values ('" + g.Nom + "','" + g.Code + "','" + g.Description + "'," + g.Filiere.Id + ")";
MyConnection.ExecuteNonQuery(Requete);
}
public void Update(Precision o)
{
string req = "update Precisions set nom = '" + o.Nom + "', description = '" + o.Description + "', duree = " + o.Duree + ", ordre = " + o.Ordre + ", modules_id = " + o.Modules_id.ID + " where id = " + o.Id;
MyConnection.ExecuteNonQuery(req);
}
public void Update(Groupe g)
{
string Requete = "Update Filieres set Code ='" + g.Code + "',Nom ='" + g.Nom + "' where id =" + g.Id;
MyConnection.ExecuteNonQuery(Requete);
}
public int Delete(int id)
{
string Requete = "Delete From Groupes where id=" + id;
return(MyConnection.ExecuteNonQuery(Requete));
}
public int Add(Groupe g)
{
string Requete = "Insert into Groupes(Nom,Code,Description,idFiliere) values ('" + g.Nom + "','" + g.Code + "','" + g.Description + "'," + g.Filiere.Id + ")";
return(MyConnection.ExecuteNonQuery(Requete));
}
public void Add(Filiere f)
{
string Requete = "Insert into Filieres(Titre,Code,Description) values ('" + f.Titre + "','" + f.Code + "','" + f.Description + "')";
MyConnection.ExecuteNonQuery(Requete);
}
public void UpdateStat(int id)
{
String Requete = "Update Stagiaires set Etat= 1 where id =" + id;
MyConnection.ExecuteNonQuery(Requete);
}
public void Delete(int id)
{
string Requete = "Delete From SeancePlannings where id=" + id;
MyConnection.ExecuteNonQuery(Requete);
}
public void Update(Seanceplanning s)
{
string Requete = "Update SeancePlannings set jour ='" + s.Jour + ",heuredebut =" + s.Heuredebut + ",heurefin=" + s.Heurefin + " where id =" + s.Id;
MyConnection.ExecuteNonQuery(Requete);
}
public void Add(Seanceplanning s)
{//EmploisTemp_id
string Requete = "Insert into SeancePlannings(jour,heuredebut,heurefin,Formation_id) values ('" + s.Jour + "'," + s.Heuredebut + "," + s.Heurefin + "," + s.Formation.Id + ")";
MyConnection.ExecuteNonQuery(Requete);
}
public void Add(Filiere f)
{
string Requete = "Insert into Filieres values ('" + f.Code + "','" + f.Nom + "')";
MyConnection.ExecuteNonQuery(Requete);
}
public void Delete(int id)
{
string req = "Delete From Precisions where id = " + id;
MyConnection.ExecuteNonQuery(req);
}
public int Delete(int id)
{
String Requete = "Delete from Stagiaires where id =" + id;
return(MyConnection.ExecuteNonQuery(Requete));
}
public void Add(EmploisTemp e)
{
string Requete = "Insert into EmploisTemps (dateDebut,dateFin,Anneformationid) values ('" + e.DateDebut + "','" + e.DateFin + "','" + e.Anneeformation + ")";
MyConnection.ExecuteNonQuery(Requete);
}
public void Delete(int id)
{
String Requete = "Delete from Stagiaires where id =" + id;
MyConnection.ExecuteNonQuery(Requete);
}
public void Update(EmploisTemp e)
{
string Requete = "Update EmploisTemps set dateDebut='" + e.DateDebut + "',dateFin='" + e.DateFin + "',Anneformationid='" + e.Anneeformation + " where id=" + e.Id;
MyConnection.ExecuteNonQuery(Requete);
}
public void Update(Filiere f)
{
string Requete = "Update Filieres set Code ='" + f.Code + "',Titre ='" + f.Titre + "',Description='" + f.Description + "' where id =" + f.Id;
MyConnection.ExecuteNonQuery(Requete);
}
public int Add(Module o)
{
string req = "insert into [Modules](Filiere_id,nom,duree,strategieEnseignement,apprentisage,evaluation,materiel,equipement,competence,presentation,description,Code,Precision_id) values(" + o.Id_f.Id + ",'" + o.Nom + "'," + o.Duree + ",'" + o.StrategieEnseignement + "','" + o.Apprentisage + "','" + o.Evaluation + "','" + o.Materiel + "','" + o.Equipement + "','" + o.Competence + "','" + o.Presentation + "','" + o.Description + "','" + o.Code + "'," + 1 + ")";
return(MyConnection.ExecuteNonQuery(req));
}
public int Update(Groupe g)
{
string Requete = "Update Filieres set Code ='" + g.Code + "',Nom ='" + g.Nom + "',Description='" + g.Description + "',IdFiliere=" + g.Filiere.Id + " where id =" + g.Id;
return(MyConnection.ExecuteNonQuery(Requete));
}
public int Update(Module o)
{
string req = "update [Modules] set Filiere_id =" + o.Id_f.Id + ",nom = '" + o.Nom + "', duree = " + o.Duree + ",strategieEnseignement = '" + o.StrategieEnseignement + "',apprentisage = '" + o.Apprentisage + "', evaluation = '" + o.Evaluation + "',materiel = '" + o.Materiel + "',equipement = '" + o.Equipement + "',competence = '" + o.Competence + "',presentation = '" + o.Presentation + "',description = '" + o.Description + "',Code = '" + o.Code + "',Precision_id =" + 1 + " where id = " + o.ID;
return(MyConnection.ExecuteNonQuery(req));
}
public void Add(Groupe g)
{
string Requete = "Insert into Groupes values ('" + g.Code + "','" + g.Nom + "')";
MyConnection.ExecuteNonQuery(Requete);
}
public int Delete(int id)
{
string req = "delete from [Modules] where id = " + id;
return(MyConnection.ExecuteNonQuery(req));
}
public void Delete(int id)
{
string Requete = "Delete From Groupes where id=" + id;
MyConnection.ExecuteNonQuery(Requete);
}
public void Add(Precision o)
{
string req = "insert into [Precisions](nom,description,duree,ordre,modules_id) values('" + o.Nom + "','" + o.Description + "'," + o.Duree + "," + o.Ordre + "," + o.Modules_id.ID + ")";
MyConnection.ExecuteNonQuery(req);
}