public static bool modifierMedicament(Medicament unMedicament) { bool test = false; int id = unMedicament.getId(); string nom = unMedicament.getNom(); int stock = unMedicament.getStock(); int seuil = unMedicament.getSeuil(); seConnecter(); SqlCommand maCommande; String requete = "Update medicaments set nom ='" + nom + "',stock=" + stock + ",seuil=" + seuil + " where id=" + id; maCommande = new SqlCommand(requete, laConnection); maCommande.ExecuteNonQuery(); seDeconnecter(); test = true; return(test); }
public static bool ajoutMedicament(Medicament unMedicament) { bool test = false; int id = trouverId("Medicaments"); seConnecter(); SqlCommand maCommande; String requete = "Insert into medicaments values (" + unMedicament.getId() + ",'" + unMedicament.getNom() + "'," + unMedicament.getStock() + "," + unMedicament.getSeuil() + ")"; maCommande = new SqlCommand(requete, laConnection); maCommande.ExecuteNonQuery(); seDeconnecter(); test = true; return(test); }