public void izpis()
{
lekarna lek = baza.IzpisLekarne(idl);
imetext.Text = lek.Ime_lekarne;
teltext.Text = lek.Telefon;
dcastext.Text = lek.DelovniCas;
nastext.Text = lek.Naslov;
krajcombo.Text = lek.Ime_kraja;
pictureBox1.Image = Image.FromFile(lek.Pot_slike);
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
urlslike = lek.Pot_slike;
opistext.Text = lek.Opis_slike;
stdelavcev.Text = lek.Stevilo_Delavcev.ToString();
}
public static lekarna IzpisLekarne(int id)
{
string connection = connect();
using (NpgsqlConnection con = new NpgsqlConnection(connection))
{
con.Open();
NpgsqlCommand com = new NpgsqlCommand("SELECT * FROM izplekarne(" + id + ");", con);
NpgsqlDataReader reader = com.ExecuteReader();
reader.Read();
lekarna lek = new lekarna(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetInt32(7));
con.Close();
return(lek);
}
}
