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