public static Module GetModule(string id)
{
NpgsqlConnection conn;
conn = new NpgsqlConnection(chaineConnection);
conn.Open();
string query = @"SELECT mod_id, mod_libelle, mod_prix_base, ""uniteUsage"",""matiere"",""gamme"",""uniteUsage"" FROM module where mod_id = '" + id + "'";
Debug.WriteLine(query);
NpgsqlCommand command = new NpgsqlCommand(query, conn);
NpgsqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
Module OneModule = new Module(Guid.Parse(dr[0].ToString()), dr[1].ToString(), BDDExterne.GetGamme(dr[5].ToString()), BDDExterne.GetMatiere(dr[4].ToString()), double.Parse(dr[2].ToString()), BDDExterne.GetAllParametreByModule(dr[0].ToString()), dr[6].ToString());
conn.Close();
return(OneModule);
}
conn.Close();
return(null);
}
public static List <Module> GetAllModules()
{
NpgsqlConnection conn;
conn = new NpgsqlConnection(chaineConnection);
conn.Open();
List <Module> ListeModules = new List <Module>();
string query = @"SELECT mod_id, mod_libelle, mod_prix_base, ""uniteUsage"", matiere, gamme FROM module";
Debug.WriteLine(query);
NpgsqlCommand command = new NpgsqlCommand(query, conn);
NpgsqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
ListeModules.Add(new Module(Guid.Parse(dr[0].ToString()), dr[1].ToString(), BDDExterne.GetGamme(dr[5].ToString()), BDDExterne.GetMatiere(dr[4].ToString()), double.Parse(dr[2].ToString()), BDDExterne.GetAllParametreByModule(dr[0].ToString()), dr[3].ToString()));
}
conn.Close();
return(ListeModules);
}
