public Exigence GetExById(int p_id)
{
db_GestionProjetDataSet.ExigenceRow er = new ExigenceTableAdapter().GetExigById(p_id)[0];
Exigence v_exig = FEsimedServiceDA.CreateRowServiceDA().FromDBToBean <Exigence>(er);
return(v_exig);
}
public Exigence updateExigence(int id, string type, string libelle, int id_projet)
{
using (ExigenceTableAdapter exigenceTableAdapter = new ExigenceTableAdapter())
{
exigenceTableAdapter.updateExigence(id, type, libelle, id_projet);
Exigence exigence = new Exigence(id, type, libelle, id_projet);
return(exigence);
}
}
public Exigence getExigenceById(int id)
{
ExigenceDataTable exigenceDataTable = new ExigenceDataTable();
using (ExigenceTableAdapter exigenceTableAdapter = new ExigenceTableAdapter())
{
exigenceDataTable = exigenceTableAdapter.getExigenceById(id);
ExigenceRow row = exigenceDataTable[0];
Exigence jalon = new Exigence(row.id, row.type, row.libelle, row.id_projet);
return(jalon);
}
}
public List <Exigence> getExigencesByTache(int id_tache)
{
ExigenceDataTable exigenceDataTable = new ExigenceDataTable();
List <Exigence> exigences = new List <Exigence>();
using (ExigenceTableAdapter exigenceTableAdapter = new ExigenceTableAdapter())
{
exigenceDataTable = exigenceTableAdapter.getExigencesByTache(id_tache);
foreach (ExigenceRow row in exigenceDataTable)
{
exigences.Add(new Exigence(row.id, row.type, row.libelle, row.id_projet));
}
return(exigences);
}
}
public bool insertExigence(string type, string libelle, int id_projet)
{
using (ExigenceTableAdapter exigenceTableAdapter = new ExigenceTableAdapter())
{
int id = (int)exigenceTableAdapter.insertExigence(type, libelle, id_projet);
bool res;
if (id == 0)
{
res = false;
}
else
{
res = true;
}
return(res);
}
}
public bool deleteExigence(int id)
{
using (ExigenceTableAdapter exigenceTableAdapter = new ExigenceTableAdapter())
{
int result = exigenceTableAdapter.deleteExigence(id);
bool res;
if (result == 0)
{
res = false;
}
else
{
res = true;
}
return(res);
}
}
public string UpdateExig(string p_texte, string p_code, int p_fonction, int p_id)
{
int result = new ExigenceTableAdapter().UpdateExig(p_texte, p_code, p_fonction, p_id);
return(result > 0 ? "Exigence modifé" : "Erreur : exigence non modifié");
}
public string InsertExig(string p_texte, string p_code, int p_fonction, int p_projet)
{
int result = new ExigenceTableAdapter().InsertExig(p_texte, p_code, p_fonction, p_projet);
return(result > 0 ? "Exigence ajoutée" : "Erreur : exigence non ajoutée");
}
