// SELECT public static VenteDAO SelectVenteById(string id) { var venteDao = new VenteDAO(); // Selectionne la vente a partir de l'id var query = "SELECT * FROM public.vente a where a.\"idVente\"=:idVenteParam"; var cmd = new NpgsqlCommand(query, DALconnection.OpenConnection()); cmd.Parameters.AddWithValue("idVenteParam", id); var reader = cmd.ExecuteReader(); while (reader.Read()) { // récup les paramètres principaux var idVente = (string)reader["idVente"]; var lotId = (string)reader["lotId"]; var adresseId = (string)reader["adresseId"]; var dateDebut = (DateTime)reader["dateDebut"]; venteDao = new VenteDAO(idVente, lotId, adresseId, dateDebut); } reader.Close(); return(venteDao); }
// INSERT & Update public static void InsertOrAddNewVente(VenteDAO vente) { // Inserer vente dans la bdd var query = @"INSERT INTO public.vente (""idVente"",""lotId"",""adresseId"",""dateDebut"") values (:idVente,:lotId,:commissaireId,:dateVente,:prixVente) ON CONFLICT ON CONSTRAINT pk_vente DO UPDATE SET ""idVente""=:idVente, ""lotId""=:lotId, ""adresseId""=:adresseId, ""dateDebut""=:dateDebut, where vente.""idVente""=:idVente"; var cmd = new NpgsqlCommand(query, DALconnection.OpenConnection()); cmd.Parameters.AddWithValue("idVente", vente.IdVente); cmd.Parameters.AddWithValue("lotId", vente.LotId); cmd.Parameters.AddWithValue("adresseId", vente.AdresseId); cmd.Parameters.AddWithValue("dateDebut", vente.DateDebut); cmd.ExecuteNonQuery(); }