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é"); }