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