public async Task PribaviInfo()
{
ListaEntiteta = new string[] { "Let", "Putnik", "Kargo" };
ListaOpisa = new string[] {
"Upravljajte sa velikom lakocom svim vrstama letova na razlicitm lokacijama",
"Uprvaljajte putnicima i njihovim podacima",
"Upravljajte robom koja ce se prevoziti na odredjenom letu",
};
ListaSlika = new string[] {
"https://www.researchgate.net/profile/Muhammet_Deveci/publication/341042975/figure/fig2/AS:885942185365505@1588236485608/Turkish-Airlines-route-map.jpg",
"https://i.insider.com/5b311c575e48ec1b008b45ed?width=1100&format=jpeg&auto=webp",
"https://www.shiplilly.com/wp-content/uploads/2013/07/Air-cargo.jpg",
};
LinkoviZaStranice = ListaEntiteta;
Letovi = await DataProvider.getSveLetove();
KargoLetovi = Letovi.Where(x => x.Putnicki == false).ToList();
for (int i = 0; i < Letovi.Count; i++)
{
Letovi[i].LetiNa = await DataProvider.getLetAerodrom(Letovi[i].ID, false);
Letovi[i].LetiSa = await DataProvider.getLetAerodrom(Letovi[i].ID, true);
}
for (int i = 0; i < KargoLetovi.Count; i++)
{
KargoLetovi[i].LetiNa = await DataProvider.getLetAerodrom(KargoLetovi[i].ID, false);
KargoLetovi[i].LetiSa = await DataProvider.getLetAerodrom(KargoLetovi[i].ID, true);
}
Putnici = await DataProvider.getSvePutnike();
RobaKargo = await DataProvider.getSveRobaKargo();
}
public void UcitajSveLetove()
{
using (SqlConnection conn = new SqlConnection())
{
Letovi.Clear();
conn.ConnectionString = CONNECTION_STRING;
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandText = @"SELECT * FROM Letovi WHERE aktivan=1";
SqlDataAdapter daLetovi = new SqlDataAdapter();
DataSet dsLetovi = new DataSet();
daLetovi.SelectCommand = command;
daLetovi.Fill(dsLetovi, "Letovi");
foreach (DataRow row in dsLetovi.Tables["Letovi"].Rows)
{
Let let = new Let();
let.Id = (int)row["Id"];
let.Sifra = (string)row["Sifra"];
let.Pilot = (string)row["Pilot"];
let.BrojLeta = (int)row["BrojLeta"];
let.Odrediste = (string)row["Odrediste"];
let.Destinacija = (string)row["Destinacija"];
let.VremePolaska = (DateTime)Convert.ToDateTime(row["VremePolaska"]);
let.VremeDolaska = (DateTime)Convert.ToDateTime(row["VremeDolaska"]);
let.Cena = (double)Convert.ToDouble(row["Cena"]);
let.Aktivan = (bool)row["Aktivan"];
Letovi.Add(let);
}
}
}
public void UcitajLetove()
{
Letovi.Clear();
foreach (Let l in LetDAO.VratiLetove())
{
this.Letovi.Add(l);
}
}
public ActionResult LetoviTrazi(string polazniLet, string dolazniLet, string datumPolaska, string datumDolaska, int brojPutnika, string valuta, string gView)
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;
var result = new List <Let>();
Letovi letData = new Letovi();
List <Let> letGrid = letData.DohvatiLetove(conn, polazniLet, dolazniLet, datumPolaska, datumDolaska, brojPutnika, valuta);
letGrid.Sort(0, 0, null);
result = letGrid;
ViewBag.TotalRows = result.Count();
return(PartialView(gView, result));
}
