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)
{
}
