public void UcitajSveKarte() { using (SqlConnection conn = new SqlConnection()) { Karte.Clear(); conn.ConnectionString = CONNECTION_STRING; conn.Open(); SqlCommand command = conn.CreateCommand(); command.CommandText = @"SELECT * FROM Karte WHERE aktivan=1"; SqlDataAdapter daKarte = new SqlDataAdapter(); DataSet dsKarte = new DataSet(); daKarte.SelectCommand = command; daKarte.Fill(dsKarte, "Karte"); foreach (DataRow row in dsKarte.Tables["Karte"].Rows) { Karta karta = new Karta(); karta.Id = (int)row["Id"]; karta.BrojLeta = (int)row["BrojLeta"]; karta.BrojSedista = (string)row["BrojSedista"]; karta.NazivPutnika = (string)row["NazivPutnika"]; karta.KlasaSedista = (klasaenum)Enum.Parse(typeof(klasaenum), row["KlasaSedista"].ToString()); karta.Kapija = (int)row["Kapija"]; karta.Cena = (double)Convert.ToDouble(row["Cena"]); karta.Aktivna = (bool)row["Aktivan"]; Karte.Add(karta); } } }
public void UcitajKarte() { Karte.Clear(); foreach (Karta av in KartaDAO.vratiKarte()) { this.Karte.Add(av); } }
public void setKarta(Karta karta) { Karte.Clear(); Karte.Add(karta); Tip = TipPoteza.BacaKartu; }