public Module(Guid id, string modLibele, Gamme modGamme, Matiere modMatiere, double prixBase) { this.modLibele = modLibele; this.modGamme = modGamme; this.modMatiere = modMatiere; this.prixBase = prixBase; this.modId = id; }
/// <summary> /// /// </summary> /// <param name="modLibele"></param> /// <param name="modGamme"></param> /// <param name="modMatiere"></param> /// <param name="prixBase"></param> /// <param name="modParametres"></param> public Module(Guid modId, string modLibele, Gamme modGamme, Matiere modMatiere, double prixBase, List <Parametre> modParametres, string uniteUsage) { this.modLibele = modLibele; this.modGamme = modGamme; this.modMatiere = modMatiere; this.prixBase = prixBase; this.modParametres = modParametres; this.modId = modId; this.uniteUsage = uniteUsage; }
public static Boolean AjouterMatiere(Matiere maMatiere) { try { NpgsqlConnection conn; conn = new NpgsqlConnection(chaineConnection); conn.Open(); NpgsqlCommand MyCmd = null; // id , nom , prenom, nomRue,codePostal,ville,tel,email,numRue string query = @"INSERT INTO ""Matiere"" VALUES ('" + maMatiere.matId + "','" + maMatiere.matLibelle + "','" + maMatiere.matFournisseur.fouId + "')"; Debug.WriteLine(query); MyCmd = new NpgsqlCommand(query, conn); MyCmd.ExecuteNonQuery(); //Exécution conn.Close(); return(true); } catch (Exception ex) { Debug.WriteLine(ex.Message); return(false); } }
public static Matiere GetMatiere(string id) { NpgsqlConnection conn; conn = new NpgsqlConnection(chaineConnection); conn.Open(); string query = @"SELECT id, nom, ""Fournisseur"" FROM ""Matiere"" where id = '" + id + "'"; Debug.WriteLine(query); NpgsqlCommand command = new NpgsqlCommand(query, conn); NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { Matiere OneMatiere = new Matiere(new Guid(dr[0].ToString()), dr[1].ToString(), BDDExterne.GetFournisseur(dr[2].ToString())); conn.Close(); return(OneMatiere); } conn.Close(); return(null); }
/// <summary> /// Changer la matière d'un module /// </summary> /// <param name="m">La matière</param> public void changerMatiere(Matiere m) { this.modMatiere = m; }
//public static Matiere afficherMatiere(Guid id) //{ // return listMatiere.Find(x => x.matId == id); //} /// <summary> /// /// </summary> /// <param name="m"></param> public static void modifierMatiere(Matiere m) { }