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(); }
public void addPhotographer(Photographer newPhotographer) { NpgsqlConnection db = DBConnection.Instance.initialize(); NpgsqlCommand cmd_addphoto = new NpgsqlCommand("INSERT INTO fotograf(vorname, nachname, geburtsdatum, notiz) values (@p, @q, @r, @s)", db); // beim Prepare statement werden die übermittelten Parameter für die query so gesetzt. cmd_addphoto.Parameters.AddWithValue("p", newPhotographer.getVorname()); cmd_addphoto.Parameters.AddWithValue("q", newPhotographer.getNachname()); cmd_addphoto.Parameters.AddWithValue("r", newPhotographer.getDate()); cmd_addphoto.Parameters.AddWithValue("s", newPhotographer.getNotiz()); try { cmd_addphoto.Prepare(); } catch { Console.WriteLine("Invalid query"); } cmd_addphoto.ExecuteNonQuery(); cmd_addphoto.Dispose(); }