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