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