private void btnDelete_Click(object sender, RoutedEventArgs e) { while (SelektovaniAerodrom()) { return; } if (MessageBox.Show("Da li ste sigurni?", "Potvrda", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { Aerodrom selektovaniAerodrom = DGAerodromi.SelectedItem as Aerodrom; int id = selektovaniAerodrom.Id; using (SqlConnection conn = new SqlConnection(CONNECTION_STRING)) { sql = "update Aerodromi set aktivan=0 where id=@id"; conn.Open(); using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); } } Data.Instance.Aerodromi.Remove(selektovaniAerodrom); DGAerodromi.Items.Refresh(); } }
private void pretraziLetoveButton_Click(object sender, EventArgs e) { Aerodrom odabraniPolazisniAerodrom = polazisniAerodromComboBox.SelectedItem as Aerodrom; Aerodrom odabraniOdredisniAerodrom = odredisniAerodromComboBox.SelectedItem as Aerodrom; DateTime datumVrijemePolaska = datumPolaskaDateTimePicker.Value; if (odabraniPolazisniAerodrom.AerodromId == odabraniOdredisniAerodrom.AerodromId) { MessageBox.Show("Polazišni i odredišni aerodrom ne smiju biti isti."); return; } if (pretraziPremaDatumuCheckBox.Checked == true) { if (datumVrijemePolaska.Date < DateTime.Now.Date) { DateTime datum = DateTime.Now; MessageBox.Show($"Datum polaska ne može biti manji od datuma {datum.ToString("dd/MM/yyyy")}."); return; } List <Let> letovi = RepozitorijSkyFlyReservation.DohvatiLetove(odabraniPolazisniAerodrom, odabraniOdredisniAerodrom, datumVrijemePolaska.ToString("yyyy-MM-dd")); OsvjeziDGV(letovi); } else { List <Let> letovi = RepozitorijSkyFlyReservation.DohvatiLetove(odabraniPolazisniAerodrom, odabraniOdredisniAerodrom); OsvjeziDGV(letovi); } }
//static private string GetConnectionString() //{ // return "Data Source=MSSQL1;Initial Catalog=AdventureWorks;" // + "Integrated Security=true;"; //} //string connectionString = GetConnectionString(); public void UcitajSveAerodrome() { using (SqlConnection conn = new SqlConnection()) { Aerodromi.Clear(); conn.ConnectionString = CONNECTION_STRING; conn.Open(); SqlCommand command = conn.CreateCommand(); command.CommandText = @"SELECT * FROM Aerodromi WHERE aktivan=1"; SqlDataAdapter daAerodromi = new SqlDataAdapter(); DataSet dsAerodromi = new DataSet(); daAerodromi.SelectCommand = command; daAerodromi.Fill(dsAerodromi, "Aerodromi"); foreach (DataRow row in dsAerodromi.Tables["Aerodromi"].Rows) { Aerodrom aerodrom = new Aerodrom(); aerodrom.Id = (int)row["Id"]; aerodrom.Sifra = (string)row["Sifra"]; aerodrom.Naziv = (string)row["Naziv"]; aerodrom.Grad = (string)row["Grad"]; aerodrom.Aktivan = (bool)row["Aktivan"]; Aerodromi.Add(aerodrom); } } }
private bool ProvjeriPodatke(Aerodrom polazisniAerodrom, Aerodrom odredisniAerodrom, DateTime datumVrijemePolaska, DateTime datumVrijemeDolaska) { if (polazisniAerodrom.AerodromId == odredisniAerodrom.AerodromId) { MessageBox.Show("Polazišni i odredišni aerodrom ne smiju biti isti."); return(false); } else if (datumVrijemeDolaska < datumVrijemePolaska) { MessageBox.Show("Datum dolaska ne smije biti manji od datuma polaska."); return(false); } else if (datumVrijemePolaska < DateTime.Now) { MessageBox.Show($"Datum polaska ne može biti manji od datuma {DateTime.Now.Date.ToString("dd/MM/yyyy")}."); return(false); } else if (datumVrijemeDolaska < DateTime.Now) { MessageBox.Show($"Datum dolaska ne može biti manji od datuma {DateTime.Now.Date.ToString("dd/MM/yyyy")}."); return(false); } else if (cijenaKarteTextBox.Text == "") { MessageBox.Show("Cijena karte mora biti unesena."); return(false); } return(true); }
private static void BrisanjeAerodroma() { Console.WriteLine("Uneti sifru aerodroma koji zelite da obrisete:"); String sifra = Console.ReadLine(); Aerodrom obrisiAerodrom = null; bool tacnost = false; foreach (var aerodrom in Aplikacija.Instance.Aerodromi) { if (aerodrom.Sifra.Equals(sifra)) { obrisiAerodrom = aerodrom; Aplikacija.Instance.Aerodromi.Remove(obrisiAerodrom); Console.WriteLine("Uspesno obrisan aerodrom!"); Aplikacija.Instance.SacuvajSveAerodrome(); tacnost = true; break; } } if (!tacnost) { Console.WriteLine("Nepostojeca sifra aerodroma! "); Console.WriteLine(""); return; } }
public async Task <ActionResult <Aerodrom> > AddAerodrom(Aerodrom aerodrom) { _context.Aerodromi.Add(aerodrom); await _context.SaveChangesAsync(); return(CreatedAtAction("GetAerodrom", new { id = aerodrom.Id }, aerodrom)); }
private void btnDodadiDesti_Click(object sender, EventArgs e) { Aerodrom aero = null; List <Destinacii> listDestinacii = new List <Destinacii>(); if (lsAerodromi.SelectedIndex != -1) { Додади_дестинација dodadiDest = new Додади_дестинација(); DialogResult rezultat = dodadiDest.ShowDialog(); aero = (Aerodrom)(lsAerodromi.SelectedItem); if (rezultat == System.Windows.Forms.DialogResult.OK) { if (aero.destinacii != null) { listDestinacii = aero.destinacii; } listDestinacii.Add(dodadiDest.dest); aero.destinacii = listDestinacii; } } else { MessageBox.Show("Изберете аеродром за кој што сакате да додадете дестинации!"); } }
public static int napraviAerodrom(Aerodrom aerodrom) { SqlConnection cnn = Konekcija.KreirajKoekciju(); StringBuilder sb = new StringBuilder(); sb.AppendLine("INSERT INTO Aerodrom VALUES "); sb.AppendLine("(@Sifra,@Naziv, @Grad , 0)"); SqlCommand komanda = new SqlCommand(sb.ToString(), cnn); komanda.Parameters.AddWithValue("@Sifra", aerodrom.Sifra); komanda.Parameters.AddWithValue("@Naziv", aerodrom.Naziv); komanda.Parameters.AddWithValue("@Grad", aerodrom.Grad); try { cnn.Open(); komanda.ExecuteNonQuery(); return(0); } catch (Exception xcp) { MessageBox.Show(xcp.Message); return(-1); } finally { cnn.Close(); } }
public static int izbrisiAerdrom(Aerodrom aerodrom) { SqlConnection cnn = Konekcija.KreirajKoekciju(); StringBuilder sb = new StringBuilder(); sb.AppendLine("UPDATE Aerodrom SET "); sb.AppendLine("Deleted = 1 WHERE AerodromId = @Id"); SqlCommand komanda = new SqlCommand(sb.ToString(), cnn); komanda.Parameters.AddWithValue("@Id", aerodrom.Id); try { cnn.Open(); komanda.ExecuteNonQuery(); return(0); } catch (Exception xcp) { MessageBox.Show(xcp.Message); return(-1); } finally { cnn.Close(); } }
private void button1_Click(object sender, EventArgs e) { if (validacija()) { if (listView1.SelectedItems.Count == 0) { return; } avion.marka = textBoxMarka.Text; avion.godinaproizvodnje = textBoxGodinaProizvodnje.Text; avion.brojsedista = Int32.Parse(textBoxBrojSedista.Text); int id = Int32.Parse(listView1.SelectedItems[0].SubItems[0].Text); Aerodrom aer = DataManager.GetAerodrom(id); avion.aerodrom = aer; if (Tip == 0)//dodaj { DataManager.DodajAvion(avion); } else if (Tip == 1)//azuriraj { DataManager.AzurirajAvion(avion); } this.Close(); DialogResult = DialogResult.OK; } }
public async Task <IActionResult> Edit(int id, [Bind("Id,Naziv,Grad,Drzava")] Aerodrom aerodrom) { if (id != aerodrom.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(aerodrom); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AerodromExists(aerodrom.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(aerodrom)); }
private void btnZacuvaj_Click(object sender, EventArgs e) { aero = new Aerodrom(); aero.grad = txtGrad.Text; aero.ime = txtIme.Text; aero.kratenka = txtKratenka.Text; DialogResult = System.Windows.Forms.DialogResult.OK; }
private void btnAdd_Click(object sender, RoutedEventArgs e) { Aerodrom noviAerodrom = new Aerodrom(); AddNEditWindow few = new AddNEditWindow(noviAerodrom); bool? rez = few.ShowDialog(); DGAerodromi.Items.Refresh(); }
public static void VezaLetAerodromOdredisni(Let let, Aerodrom destinacija) { var veza = new Neo4jClient.Cypher.CypherQuery("MATCH (l:Let), (a:Aerodrom) " + "WHERE l.id = '" + let.id + "' AND a.id = '" + destinacija.id + "' " + "CREATE (a)<-[r:SLECE_NA]-(l) return a", new Dictionary <string, object>(), CypherResultMode.Set); List <Aerodrom> tmp = ((IRawGraphClient)client).ExecuteGetCypherResults <Aerodrom>(veza).ToList(); }
public static void AzurirajAerodrom(Aerodrom a) { var query = new Neo4jClient.Cypher.CypherQuery("start n=node(*) where (n:Aerodrom) and exists(n.id) and n.id = '" + a.id + "'" + " set n.mesto = '" + a.mesto + "'," + " n.kapacitet = '" + a.kapacitet + "'" + " return n", new Dictionary <string, object>(), CypherResultMode.Set); List <Aerodrom> aerodromi = ((IRawGraphClient)client).ExecuteGetCypherResults <Aerodrom>(query).ToList(); }
public static Aerodrom VratiDestinacijuLeta(Let let) { var veza = new Neo4jClient.Cypher.CypherQuery("match (l)-[:SLECE_NA]-(a)" + "where l.id = '" + let.id + "'return a", new Dictionary <string, object>(), CypherResultMode.Set); Aerodrom tmp = ((IRawGraphClient)client).ExecuteGetCypherResults <Aerodrom>(veza).Single(); return(tmp); }
public static Aerodrom VratiPolazniAerodromLeta(Let let) { var veza = new Neo4jClient.Cypher.CypherQuery("match (l)-[:POLAZI_OD]-(a)" + "where l.id = '" + let.id + "'return a", new Dictionary <string, object>(), CypherResultMode.Set); Aerodrom tmp = ((IRawGraphClient)client).ExecuteGetCypherResults <Aerodrom>(veza).FirstOrDefault(); return(tmp); }
public AddNEditWindow(Aerodrom aerodrom, EOpcija opcija = EOpcija.DODAVANJE) { InitializeComponent(); this.aerodrom = aerodrom; this.opcija = opcija; this.DataContext = aerodrom; //TxtSifra.Text = aerodrom.Sifra; //TxtGrad.Text = aerodrom.Grad; //TxtNaziv.Text = aerodrom.Naziv; }
public async Task <IActionResult> Create([Bind("Id,Naziv,Grad,Drzava")] Aerodrom aerodrom) { if (ModelState.IsValid) { _context.Add(aerodrom); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(aerodrom)); }
private bool Aerodromi() { Aerodrom a = (Aerodrom)comboBoxPolazniAerodrom.SelectedItem; Aerodrom b = (Aerodrom)comboBoxDolazniAerodrom.SelectedItem; if (a == b) { MessageBox.Show("Morate izabrati razlicite aerodrome!"); return(false); } return(true); }
public EditAerodromWindow(Aerodrom aerodrom, Stanje stanje) { InitializeComponent(); this.stanje = stanje; this.aerodromG = aerodrom; this.DataContext = aerodromG; if (stanje == Stanje.Izmena) { textBoxSifra.IsReadOnly = true; } }
private void lsAerodromi_SelectedIndexChanged(object sender, EventArgs e) { lsDestinacii.Items.Clear(); Aerodrom aero = (Aerodrom)(lsAerodromi.SelectedItem); if (aero.destinacii != null) { foreach (var d in aero.destinacii) { lsDestinacii.Items.Add((Destinacii)d); } } }
private int VratiIndex(Aerodrom av) { int index = -1; for (int i = 0; i < Aplikacija.Instance.Aerodromi.Count; i++) { if (av.Id == Aplikacija.Instance.Aerodromi[i].Id) { index = i; } } return(index); }
private bool CustomFilter(object obj) { Aerodrom ar = (Aerodrom)obj; if (textBoxPretraga.Text.Equals(string.Empty)) { return(ar.Deleted == false); } else { return(ar.Naziv.Contains(textBoxPretraga.Text) && ar.Deleted == false); } }
private void button1_Click(object sender, EventArgs e) { if (validacija()) { if (listView1.SelectedItems.Count == 0 || listView2.SelectedItems.Count == 0 || listView3.SelectedItems.Count == 0) { //return; } DateTime dateTime = dateTimePicker1.Value; String dan = dateTime.Day.ToString(); String mesec = dateTime.Month.ToString(); String godina = dateTime.Year.ToString(); String datumPolaska = dan + "." + mesec + "." + godina; let.datumpolaska = datumPolaska; let.vremepolaska = textBoxVremePolaska.Text; let.vremeletenja = textBoxVremeLetenja.Text; let.osnovnacena = Int32.Parse(textBoxCena.Text); int noviId = Int32.Parse(DataManager.getMaxId()) + 1; let.id = noviId.ToString(); //odakle polazi int id1 = Int32.Parse(listView1.SelectedItems[0].SubItems[0].Text); Aerodrom polazni = DataManager.GetAerodrom(id1); let.polazniaerodrom = polazni; //gde ide int id2 = Int32.Parse(listView2.SelectedItems[0].SubItems[0].Text); Aerodrom destinacija = DataManager.GetAerodrom(id2); let.odredisniaerodrom = destinacija; //kojim avionom putuje int id3 = Int32.Parse(listView3.SelectedItems[0].SubItems[0].Text); Avion avion = DataManager.GetAvion(id3); let.avion = avion; let.brojsedista = avion.brojsedista; if (Tip == 0)//dodaj { DataManager.DodajLet(let); } else if (Tip == 1)//azuriraj { DataManager.AzurirajLet(let); } this.Close(); DialogResult = DialogResult.OK; } }
private void btnUpdate_Click(object sender, RoutedEventArgs e) { while (SelektovaniAerodrom()) { return; } Aerodrom selektovaniAerodrom = DGAerodromi.SelectedItem as Aerodrom; AddNEditWindow few = new AddNEditWindow(selektovaniAerodrom, AddNEditWindow.EOpcija.IZMENA); if (few.ShowDialog() == true) { DGAerodromi.Items.Refresh(); } }
public static void DodajAerodrom(Aerodrom a) { int noviId = Int32.Parse(getMaxId()) + 1; Dictionary <string, object> queryDict = new Dictionary <string, object>(); queryDict.Add("id", noviId.ToString()); queryDict.Add("mesto", a.mesto); queryDict.Add("kapacitet", a.kapacitet); var query = new Neo4jClient.Cypher.CypherQuery("CREATE (n:Aerodrom {id:'" + noviId + "', mesto:'" + a.mesto + "', kapacitet:'" + a.kapacitet + "'}) return n", queryDict, CypherResultMode.Set); ((IRawGraphClient)client).ExecuteGetCypherResults <Aerodrom>(query); }
private void buttonPotragaKratice_Click(object sender, EventArgs e) { string trazi = txtBoxKratica.Text; string url1 = urlAerodromi + "apikey=" + apiKey + "&term=" + trazi; var json1 = new WebClient().DownloadString(url1); Aerodrom a = new Aerodrom(); var aer = JsonConvert.DeserializeObject <List <Aerodrom> >(json1); for (int i = 0; i < aer.Count(); i++) { DataGridViewRow red = new DataGridViewRow(); red.CreateCells(dataGridView2); red.Cells[0].Value = aer[i].value.ToString(); red.Cells[1].Value = aer[i].label.ToString(); dataGridView2.Rows.Add(red); } }
private static void PretragaAerodromaPoSifri() { Console.WriteLine("Uneti sifru aerodroma: "); string sifra = Console.ReadLine(); Aerodrom aerodrom = null; aerodrom = Aplikacija.Instance.Aerodromi.Find(a => a.Sifra.Equals(sifra)); if (aerodrom == null) { throw new AirportNotFoundException($"Nije pronadjen nijedan aerodrom sa zadatom sifrom! : {sifra} \n "); } else { Console.WriteLine($"Aerodrom: {aerodrom} \n"); } }
private void buttonPromeni_Click(object sender, RoutedEventArgs e) { if (dataGridAerodromi.SelectedIndex == -1) { MessageBox.Show("Morate odabarti Aerodrom koji zelite da promenite"); dataGridAerodromi.Focus(); return; } Aerodrom aerodrom = (Aerodrom)dataGridAerodromi.SelectedItem; Aerodrom stari = (Aerodrom)aerodrom.Clone(); int index = VratiIndex(aerodrom); EditAerodromWindow ea = new EditAerodromWindow(aerodrom, Stanje.Izmena); if (ea.ShowDialog() == false) { Aplikacija.Instance.Aerodromi[index] = stari; } }