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