public void editPhotographer(Photographer photogr)
{
NpgsqlConnection db = DBConnection.Instance.initialize();
NpgsqlCommand cmd_editp = new NpgsqlCommand("UPDATE fotograf SET vorname = @p , nachname = @q , geburtsdatum = @r , notiz = @s WHERE pk_fotograf_id = @t", db);
cmd_editp.Parameters.AddWithValue("p", photogr.getVorname());
cmd_editp.Parameters.AddWithValue("q", photogr.getNachname());
cmd_editp.Parameters.AddWithValue("r", photogr.getDate());
cmd_editp.Parameters.AddWithValue("s", photogr.getNotiz());
cmd_editp.Parameters.AddWithValue("t", photogr.getId());
cmd_editp.ExecuteNonQuery();
cmd_editp.Dispose();
}
