public Jalon GetJalonById(int p_id)
{
db_GestionProjetDataSet.JalonRow jr = new JalonTableAdapter().GetById(p_id)[0];
Jalon v_jalon = FEsimedServiceDA.CreateRowServiceDA().FromDBToBean <Jalon>(jr);
return(v_jalon);
}
public Jalon updateJalon(int id, string libelle, DateTime date_livraison, DateTime date_reelle, int id_projet, int id_responsable)
{
using (JalonTableAdapter jalonTableAdapter = new JalonTableAdapter())
{
jalonTableAdapter.updateJalon(id, libelle, date_livraison, date_reelle, id_projet, id_responsable);
Jalon jalon = new Jalon(id, libelle, date_livraison, id_projet, id_responsable);
return(jalon);
}
}
public Jalon getJalonById(int id)
{
JalonDataTable jalonDataTable = new JalonDataTable();
using (JalonTableAdapter jalonTableAdapter = new JalonTableAdapter())
{
jalonDataTable = jalonTableAdapter.getJalonById(id);
JalonRow row = jalonDataTable[0];
Jalon jalon = new Jalon(row.id, row.libelle, row.date_livraison, row.id_projet, row.id_responsable);
return(jalon);
}
}
public List <Jalon> getJalonsByResponsable(int id_responsable)
{
JalonDataTable jalonDataTable = new JalonDataTable();
List <Jalon> jalons = new List <Jalon>();
using (JalonTableAdapter jalonTableAdapter = new JalonTableAdapter())
{
jalonDataTable = jalonTableAdapter.getJalonsByResponsable(id_responsable);
foreach (JalonRow row in jalonDataTable)
{
jalons.Add(new Jalon(row.id, row.libelle, row.date_livraison, row.id_projet, row.id_responsable));
}
return(jalons);
}
}
public bool insertJalon(string libelle, DateTime date_livraison, int id_projet, int id_responsable)
{
using (JalonTableAdapter jalonTableAdapter = new JalonTableAdapter())
{
int id = (int)jalonTableAdapter.insertJalon(libelle, date_livraison, null, id_projet, id_responsable);
bool res;
if (id == 0)
{
res = false;
}
else
{
res = true;
}
return(res);
}
}
public bool deleteJalon(int id)
{
using (JalonTableAdapter jalonTableAdapter = new JalonTableAdapter())
{
int result = jalonTableAdapter.deleteJalon(id);
bool res;
if (result == 0)
{
res = false;
}
else
{
res = true;
}
return(res);
}
}
public List <Jalon> getJalonsByProjet(int id_projet)
{
JalonDataTable jalonDataTable = new JalonDataTable();
List <Jalon> jalons = new List <Jalon>();
using (JalonTableAdapter jalonTableAdapter = new JalonTableAdapter())
{
jalonDataTable = jalonTableAdapter.getJalonsByProjet(id_projet);
foreach (JalonRow row in jalonDataTable)
{
Jalon jalon = new Jalon(row.id, row.libelle, row.date_livraison, row.id_projet, row.id_responsable);
jalon.Etat = FactoryServicesDA.createTacheServices().getEtatTachesByJalon(row.id);
jalons.Add(jalon);
}
return(jalons);
}
}
//public int CountExigByCode(string p_code, int p_projet)
//{
// return (int)new ExigenceTableAdapter().CountExigByCode(p_code, p_projet);
//}
public string UpdateJalon(DateTime p_livrprevu, string p_libelle, int p_resp, int p_id)
{
int result = new JalonTableAdapter().UpdateJalon(p_livrprevu, p_libelle, p_resp, p_id);
return(result > 0 ? "Jalon modifé" : "Erreur : jalon non modifié");
}
public string InsertJalon(DateTime p_livrprev, string p_libelle, int p_resp, int p_projet, DateTime?p_livrreelle = null)
{
int result = new JalonTableAdapter().InsertJalon(p_livrprev, p_livrreelle, p_libelle, p_resp, p_projet);
return(result > 0 ? "Jalon ajouté" : "Erreur : Jalon non ajouté");
}
