private void ucitajOruzje(int rowId) { Classes.Oruzje oruzje = new Classes.Oruzje(); oruzje.asocirajPodatkeIzBaze(oruzjeGridView.Rows[rowId].Cells[0].Value.ToString()); OruzjeInfo forma = new OruzjeInfo(oruzje); forma.ShowDialog(); }
public void asocirajPodatkeIzBazeVlasnika(string oibParam) { this.oruzje = new Classes.Oruzje(); String izvor = "URI=file:evidencija.db"; SQLiteConnection conn = new SQLiteConnection(izvor); conn.Open(); SQLiteCommand naredba = conn.CreateCommand(); naredba.CommandText = "SELECT * FROM VLASNIK_ORUZJA WHERE OIB='" + oibParam + "';"; SQLiteDataReader reader = naredba.ExecuteReader(); while (reader.Read()) { this.oib = reader.GetString(0); this.jmbg = reader.GetString(1); this.ime = reader.GetString(2); this.prezime = reader.GetString(3); this.spol = pronadiSpol(reader.GetString(4)); this.rod = pronadiRod(reader.GetString(5)); this.drzavljanstvo = reader.GetString(6); this.mjestoRodenja = reader.GetString(7); this.drzavaRodenja = reader.GetString(8); this.datumRodenja = Convert.ToDateTime(reader.GetString(9)); this.adresaPrebivalista = reader.GetString(10); this.mjestoPrebivalista = reader.GetString(11); this.postanskiBrojPrebivalista = Convert.ToString(reader.GetInt32(12)); this.drzavaPrebivalista = reader.GetString(13); this.adresaBoravista = reader.GetString(14); this.mjestoBoravista = reader.GetString(15); this.postanskiBrojBoravista = Convert.ToString(reader.GetInt32(16)); this.drzavaBoravista = reader.GetString(17); this.oruzje.asocirajPodatkeIzBaze(reader.GetString(18)); this.datumZahtjevaZaIzdavanjeDozvole = Convert.ToDateTime(reader.GetString(19)); this.datumIstekaDozvole = Convert.ToDateTime(reader.GetString(20)); this.datumLijecnickog = Convert.ToDateTime(reader.GetString(21)); this.datumIstekaLijecnickog = Convert.ToDateTime(reader.GetString(22)); } reader.Close(); naredba.Dispose(); conn.Close(); }
public OruzjeInfo(Classes.Oruzje oruzjeParam) { this.oruzje = oruzjeParam; InitializeComponent(); }