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