public List <Photographer> getPhotographers() { List <Photographer> photographerList = new List <Photographer>(); NpgsqlConnection db = DBConnection.Instance.initialize(); NpgsqlCommand cmd_photo = new NpgsqlCommand("Select * from fotograf", db); try { cmd_photo.Prepare(); } catch { Console.WriteLine("Invalid query"); } NpgsqlDataReader reader_photo = cmd_photo.ExecuteReader(); cmd_photo.Dispose(); while (reader_photo.Read()) { Photographer temp_photo = new Photographer(); temp_photo.setId(reader_photo.GetInt32(0)); temp_photo.setVorname(reader_photo.GetString(1)); temp_photo.setNachname(reader_photo.GetString(2)); temp_photo.setDate(reader_photo.GetDateTime(3)); if (!reader_photo.IsDBNull(4)) { temp_photo.setNotiz(reader_photo.GetString(4)); } photographerList.Add(temp_photo); } reader_photo.Close(); return(photographerList); }
public Photographer getPhotographerById(int Id) { Photographer temp_photo = new Photographer(); NpgsqlConnection db = DBConnection.Instance.initialize(); NpgsqlCommand cmd_getphoto = new NpgsqlCommand("Select * from fotograf WHERE pk_fotograf_id = @p;", db); cmd_getphoto.Parameters.AddWithValue("p", Id); try { cmd_getphoto.Prepare(); } catch { Console.WriteLine("Invalid query"); } NpgsqlDataReader reader_getphoto = cmd_getphoto.ExecuteReader(); cmd_getphoto.Dispose(); while (reader_getphoto.Read()) { temp_photo.setId(reader_getphoto.GetInt32(0)); temp_photo.setVorname(reader_getphoto.GetString(1)); temp_photo.setNachname(reader_getphoto.GetString(2)); temp_photo.setDate(reader_getphoto.GetDateTime(3)); if (!reader_getphoto.IsDBNull(4)) { temp_photo.setNotiz(reader_getphoto.GetString(4)); } } reader_getphoto.Close(); return(temp_photo); }