public static ObservableCollection <Avion> vratiAvione()
{
SqlConnection cnn = Konekcija.KreirajKoekciju();
SqlCommand komanda = new SqlCommand("SELECT * FROM Avion WHERE Deleted = 0", cnn);
ObservableCollection <Avion> avioni = new ObservableCollection <Avion>();
try
{
cnn.Open();
SqlDataReader dr = komanda.ExecuteReader();
while (dr.Read())
{
Avion a = new Avion();
a.Id = (int)dr["AvionId"];
int brRedovaEklase = (int)dr["BrojRedovaEkonomskeKlase"];
int brSedistaEklase = (int)dr["BrojSedistaUReduEkonomskeKlase"];
a.puniListuEkon(brRedovaEklase, brSedistaEklase);
int brRedovaBiznis = (int)dr["BrojRedovaBiznisKlase"];
int brSedistaBiznis = (int)dr["BrojSedistaUReduBiznisKlase"];
a.puniListuBiz(brRedovaBiznis, brSedistaBiznis);
a.AvioKompanija = AvioKompanijaDAO.vratiAvioKompaniju((int)dr["AvioKompanijaId"]);
a.Naziv = dr["Naziv"].ToString();
a.Deleted = Convert.ToBoolean(dr["Deleted"]);
if (a.AvioKompanija.Deleted || a.AvioKompanija.Naziv == null)
{
IzbirisAvio(a);
}
else
{
avioni.Add(a);
}
}
}
catch (Exception xcp)
{
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
MessageBox.Show(xcp.Message);
return(null);
}
return(avioni);
}
public static Avion vratiAvion(int id)
{
SqlConnection cnn = Konekcija.KreirajKoekciju();
SqlCommand komanda = new SqlCommand("SELECT * FROM Avion WHERE AvionId = @AvionId AND Deleted = 0", cnn);
komanda.Parameters.AddWithValue("AvionId", id);
Avion a = new Avion();
try
{
cnn.Open();
SqlDataReader dr = komanda.ExecuteReader();
while (dr.Read())
{
a.Id = (int)dr["AvionId"];
int brRedovaEklase = (int)dr["BrojRedovaEkonomskeKlase"];
int brSedistaEklase = (int)dr["BrojSedistaUReduEkonomskeKlase"];
a.puniListuEkon(brRedovaEklase, brSedistaEklase);
int brRedovaBiznis = (int)dr["BrojRedovaBiznisKlase"];
int brSedistaBiznis = (int)dr["BrojSedistaUReduBiznisKlase"];
a.puniListuBiz(brRedovaBiznis, brSedistaBiznis);
a.AvioKompanija = AvioKompanijaDAO.vratiAvioKompaniju((int)dr["AvioKompanijaId"]);
a.Naziv = dr["Naziv"].ToString();
a.Deleted = Convert.ToBoolean(dr["Deleted"]);
}
cnn.Close();
}
catch (Exception xcp)
{
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
MessageBox.Show(xcp.Message);
return(null);
}
return(a);
}