// 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();
}
