public static Billet GetBillet(int id) { bdd.OpenConnection(); string query = "SELECT * FROM billet WHERE id = @id;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); Billet Billet = new Billet(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3)); reader.Close(); bdd.CloseConnection(); return(Billet); }
public static ObservableCollection <Billet> SelectBillets() { ObservableCollection <Billet> Billets = new ObservableCollection <Billet>(); bdd.OpenConnection(); string query = "SELECT * FROM billet;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Billet Billet = new Billet(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3)); Billets.Add(Billet); } reader.Close(); bdd.CloseConnection(); return(Billets); }
public static ObservableCollection <Billet> SelectBilletsByClient(int client) { ObservableCollection <Billet> billets = new ObservableCollection <Billet>(); bdd.OpenConnection(); string query = "SELECT * FROM billet Where user_id = @client;"; MySqlCommand cmd = new MySqlCommand(query, bdd.GetConnection()); cmd.Parameters.AddWithValue("@client", client); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Billet billet = new Billet(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3)); billets.Add(billet); } reader.Close(); bdd.CloseConnection(); return(billets); }