private Let DohvatiSelektiraniLet()
{
Let selektiraniLet = null;
if (popisLetovaDataGridView.CurrentRow != null)
{
selektiraniLet = popisLetovaDataGridView.CurrentRow.DataBoundItem as Let;
}
return(selektiraniLet);
}
//jos putanje!
public static List <Let> VratiPutanjeLeta(String odakle, String dokle)
{
//var veza = new Neo4jClient.Cypher.CypherQuery("MATCH path = (n:Aerodrom)-[*]-(l:Aerodrom) with nodes(path) as p " +
// " where exists(n.mesto) and n.mesto = 'Nis'" +
// " and exists(l.mesto)and l.mesto = 'New York' " +
// "return [node in p where not node: Let and not node: Avion]",
// new Dictionary<string, object>(), CypherResultMode.Set);
//IEnumerable<Node<Aerodrom>> tmp = ((IRawGraphClient)client).ExecuteGetCypherResults<IEnumerable<Node<Aerodrom>>>(veza).ToList();
var query = client.Cypher
.Match("p=(pol:Aerodrom {mesto:{odakle}})-[*]-(dest:Aerodrom {mesto:{dokle}})")
.WithParam("odakle", odakle)
.WithParam("dokle", dokle)
.Return((p, order) => new
{
aerodromi = Return.As <IEnumerable <Node <Aerodrom> > >("nodes(p)"),
letovi = Return.As <IEnumerable <Node <Let> > >("nodes(p)")
})
.Limit(1);
var result = query.Results;
List <Let> letovi = new List <Let>();
foreach (var res in result)
{
//foreach (var city in res.aerodromi.ToList())
//{
// if (city.Data.mesto != null)
// {
// MessageBox.Show(city.Data.mesto);
// }
//};
foreach (var let in res.letovi.ToList())
{
if (let.Data.datumpolaska != null && let.Data.datumpolaska == "18.12.2018")
{
Let l = new Let();
l = let.Data;
letovi.Add(l);
}
}
;
}
return(letovi);
}
public ActionResult Edit([Bind(Include = "LetId,DatumiVrijeme,StatusId,LinijaId")] Let let)
{
if (ModelState.IsValid)
{
db.Entry(let).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LinijaId = new SelectList(db.Linija, "LinijaId", "LinijaId", let.LinijaId);
ViewBag.StatusId = new SelectList(db.Status, "StatusId", "Naziv", let.StatusId);
return(View(let));
}
public IActionResult Snimi(LetDodajVM model)
{
MyContext db = new MyContext();
Let l = model.Let;
l.GradID = model.Let.GradID;
l.KlasaID = model.Let.KlasaID;
db.Let.Add(l);
db.SaveChanges();
db.Dispose();
return(RedirectToAction("Prikazi"));
}
public async Task <IHttpActionResult> PostLet(Let let)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Let.Add(let);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = let.LetId }, let));
}
public static Let PronadjiLet(int id)
{
Dictionary <string, object> queryDict = new Dictionary <string, object>();
queryDict.Add("id", id.ToString());
var query = new Neo4jClient.Cypher.CypherQuery("start n=node(*) where (n:Let) and exists(n.id) and n.id = {id} return n",
queryDict, CypherResultMode.Set);
Let letovi = ((IRawGraphClient)client).ExecuteGetCypherResults <Let>(query).Single();
return(letovi);
}
public static void AzurirajLet(Let l)
{
var query = new Neo4jClient.Cypher.CypherQuery("start n=node(*) where (n:Let) and exists(n.id) and n.id = '" + l.id + "'" +
" set n.datumpolaska = '" + l.datumpolaska + "'," +
" n.vremepolaska = '" + l.vremepolaska + "'," +
" n.vremeletenja = '" + l.vremeletenja + "'," +
" n.osnovnacena = '" + l.osnovnacena + "'" +
" return n",
new Dictionary <string, object>(), CypherResultMode.Set);
List <Let> letovi = ((IRawGraphClient)client).ExecuteGetCypherResults <Let>(query).ToList();
}
public static void KreirajLet(Let let)
{
IMongoDatabase db = Session.MongoDatabase;
var letovi = db.GetCollection <Let>("let");
letovi.InsertOne(let);
if (let.AvioKompanija != ObjectId.Empty)
{
DodajAvioKompanijiLet(let.Id, let.AvioKompanija);
}
}
void Specify_expand_processes_arguments_with_linq()
{
var expr1 = Let <Tuple <bool, bool> > .Predicate(x => x.Item1 && x.Item2);
var expr2 = Let <bool> .Expr(y => new Tuple <bool, bool>(y, y));
var nestedExpression = Let <bool> .Expr(z => expr1.Invoke(expr2.Invoke(z)));
var expandAgain = nestedExpression.Expand().Expand().ToString();
expandAgain.Should().Be(nestedExpression.Expand().ToString());
}
public object VisitLetStatement(Let statement)
{
Declare(statement.Name);
if (statement.Initializer != null)
{
statement.Initializer.Accept(this);
}
Define(statement.Name);
return(null);
}
public void TestCijenaEx2()
{
UneseniLet ul = new UneseniLet();
Posiljaoc p = new Posiljaoc("Amela", "Spica", "2901994175003", "+38762-282-330", "bla");
Let l = new Let(9363, 4, 0.125, 2);
ul.posiljaoc = p;
ul.let = l;
ul.cijena = 1220;
double cijena = 1280.15;
Assert.AreEqual(ul.cijena, cijena);
}
private void buttonPromeni_Click(object sender, RoutedEventArgs e)
{
if (dataGridLetovi.SelectedIndex == -1)
{
MessageBox.Show("Morate selektovati let");
return;
}
Let let = (Let)dataGridLetovi.SelectedItem;
EditLetWindow el = new EditLetWindow(let, Stanje.Izmena);
el.ShowDialog();
}
public KupiKartu(Let let, Stanje stanje)
{
mainLet = let;
InitializeComponent();
this.stanjeG = stanje;
ZauszetaMesta();
List <Sediste> listSedista = new List <Sediste>();
listSedista = let.Avion.SedistaBiznisKlase;
foreach (Sediste s in let.Avion.SedistaEkonomskeKlase)
{
listSedista.Add(s);
}
view = CollectionViewSource.GetDefaultView(listSedista);
view.Filter = CustomFilter;
dataGridSedista.ItemsSource = view;
textBoxSifra.Text = let.Sifra;
textBoxPilot.Text = let.Pilot;
textBoxVremePolaska.Text = let.vremePolaska.ToString();
textBoxVremeDolaska.Text = let.vremeDolaska.ToString();
textBoxPolazniAerodrom.Text = let.PolazniAerodrom.ToString();
textBoxDolazniAerodrom.Text = let.DolazniAerodrom.ToString();
textBoxNazivAviona.Text = let.Avion.ToString();
if (stanjeG == Stanje.Povratna)
{
decimal cenaPovratna = let.Cena - (let.Cena * 0.5M);
textBoxCenaLeta.Text = cenaPovratna.ToString();
}
else
{
textBoxCenaLeta.Text = let.Cena.ToString();
}
dataGridSedista.ColumnWidth = new DataGridLength(1, DataGridLengthUnitType.Star);
if (Aplikacija.Instance.LoggedUser != null)
{
textBoxIme.IsReadOnly = true;
textBoxPrezime.IsReadOnly = true;
textBoxIme.Text = Aplikacija.Instance.LoggedUser.Ime;
textBoxPrezime.Text = Aplikacija.Instance.LoggedUser.Prezime;
}
}
private void detaljiLetaButton_Click(object sender, EventArgs e)
{
Let selektiraniLet = DohvatiSelektiraniLet();
if (selektiraniLet == null)
{
MessageBox.Show("Niste odabrali let za koji želite pogledati detalje.");
return;
}
FormDetaljiLeta form = new FormDetaljiLeta(selektiraniLet);
form.ShowDialog();
}
public async Task <IHttpActionResult> DeleteLet(int id)
{
Let let = await db.Let.FindAsync(id);
if (let == null)
{
return(NotFound());
}
db.Let.Remove(let);
await db.SaveChangesAsync();
return(Ok(let));
}
public AddNEditLet(Let let, EOpcija opcija = EOpcija.DODAVANJE)
{
InitializeComponent();
this.let = let;
this.opcija = opcija;
this.DataContext = let;
//TxtSifra.Text = let.Sifra;
//TxtDestinacija.Text = let.Destinacija;
//TxtOdrediste.Text = let.Odrediste;
//TxtVremePolaska.Text = let.VremePolaska.ToString();
//TxtVremeDolaska.Text = let.VremeDolaska.ToString();
//TxtCena.Text = let.Cena.ToString();
}
// GET: Lets/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Let let = db.Let.Find(id);
if (let == null)
{
return(HttpNotFound());
}
return(View(let));
}
public void IzmeniLet(DataGridView dataGridView2)
{
if (dataGridView2.SelectedRows.Count > 0)
{
Let l = new Let();
l = (Let)dataGridView2.SelectedRows[0].DataBoundItem;
FrmLet let = new FrmLet(l);
let.ShowDialog();
}
else
{
MessageBox.Show("Nije selektovan let!");
}
}
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
while (SelektovaniLet())
{
return;
}
Let selektovaniLet = DGLetovi.SelectedItem as Let;
AddNEditLet few = new AddNEditLet(selektovaniLet, AddNEditLet.EOpcija.IZMENA);
if (few.ShowDialog() == true)
{
DGLetovi.Items.Refresh();
}
}
public static List<Karta> VratiKarteULetu(Let let)
{
SqlConnection cnn = Konekcija.KreirajKoekciju();
SqlCommand komanda = new SqlCommand("SELECT * FROM Karta WHERE LetId = @LetID AND Deleted = 0", cnn);
komanda.Parameters.AddWithValue("@LetID", let.Id);
List<Karta> karte = new List<Karta>();
try
{
cnn.Open();
SqlDataReader dr = komanda.ExecuteReader();
while (dr.Read())
{
Karta k = new Karta();
k.KartaId = (int)dr["KartaId"];
k.Let = LetDAO.vratiLet((int)dr["LetId"]);
Sediste s = new Sediste();
s.Id = 1;
s.Red = (int)dr["BrojReda"];
s.SedisteURedu = (int)dr["BrojSedista"];
EtipSedista tip;
Enum.TryParse(dr["Klasa"].ToString(), out tip);
s.tipSedista = tip;
s.Deleted = false;
k.Sediste = s;
k.Korisnik = KorisnikDAO.vratiKorisnika((int)dr["KorisnikId"]);
k.Kapija = dr["Kapija"].ToString();
k.Cena = (decimal)dr["Cena"];
k.Deleted = Convert.ToBoolean(dr["Deleted"]);
karte.Add(k);
}
}
catch (Exception xcp)
{
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
MessageBox.Show(xcp.Message);
return null;
}
return karte;
}
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Let let = await db.Let.FindAsync(id);
if (let == null)
{
return(HttpNotFound());
}
return(View(let));
}
void Describe_anonymous_type_local_delegate()
{
// Expression<Func<int, int, ?>>
var expr1 = Linq.Expr((int a, int b) => new { a, b });
var expr2 = Linq.Expr((int c) => expr1.Invoke(c, 0));
var expr3 = Let <int> .Getter(a => expr2.Invoke(a).a);
context[$"{expr2.Expand()}"] = () =>
{
it[$"expr(4).getter(a) should be 4"] = () =>
{
expr3.Expand().Invoke(4).Should().Be(4);
};
};
}
public async Task <IActionResult> Create([Bind("Id,PocetnaDestinacijaId,KrajnjaDestinacijaId,TerminalId,KompanijaId,DatumPolaska,BrojMjesta,BrojLeta")] Let let)
{
if (ModelState.IsValid)
{
_context.Add(let);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["KompanijaId"] = new SelectList(_context.Kompanija, "Id", "Naziv", let.KompanijaId);
ViewData["KrajnjaDestinacijaId"] = new SelectList(_context.Destinacija, "Id", "Grad", let.KrajnjaDestinacijaId);
ViewData["PocetnaDestinacijaId"] = new SelectList(_context.Destinacija, "Id", "Grad", let.PocetnaDestinacijaId);
ViewData["TerminalId"] = new SelectList(_context.Terminal, "Id", "Naziv", let.TerminalId);
return(View(let));
}
private void button1_Click(object sender, EventArgs e)
{
MLetovi f = new MLetovi();
f.Tip = 0;
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.let = f.let;
DataManager.VezaLetAerodromPolazni(f.let, f.let.polazniaerodrom);
DataManager.VezaLetAerodromOdredisni(f.let, f.let.odredisniaerodrom);
DataManager.VezaLetAerodromAvion(f.let, f.let.avion);
PopuniListView();
}
}
private void dgvLetovi_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int id = Convert.ToInt32(dgvLetovi.SelectedRows[0].Cells[0].Value);
HttpResponseMessage response = letServis.GetResponse(id.ToString());
if (response.IsSuccessStatusCode)
{
odabraniLet = response.Content.ReadAsAsync <Let>().Result;
DialogResult = DialogResult.OK;
Close();
}
else
{
MessageBox.Show(response.ReasonPhrase, Poruke.error, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static ITerm TmMap(Func <int, Var, ITerm> onVar, int c, ITerm t)
{
ITerm Walk(int c, ITerm t)
{
return(t switch
{
Let let => new Let(let.Info, let.Variable, Walk(c, let.LetTerm), Walk(c + 1, let.InTerm)),
Var var => onVar(c, var),
Abs abs => new Abs(abs.Info, Walk(c + 1, abs.Body), abs.BoundedVariable, abs.Type),
App app => new App(app.Info, Walk(c, app.Left), Walk(c, app.Right)),
True e => e,
False f => f,
If ift => new If(ift.Info, Walk(c, ift.Condition), Walk(c, ift.Then), Walk(c, ift.Else)),
_ => throw new InvalidOperationException()
});
}
public void DajDistancuTestIstoPolazisteIOdrediste()
{
Let l = new Let();
l.polaziste = "Sarajevo";
l.odrediste = "Sarajevo";
Assert.IsTrue(l.DajDistancu() == 0);
l.polaziste = "Pariz";
l.odrediste = "Pariz";
Assert.IsTrue(l.DajDistancu() == 0);
l.polaziste = "Istanbul";
l.odrediste = "Istanbul";
Assert.IsTrue(l.DajDistancu() == 0);
}
private void btnPregledajLet_Click(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
int id = Int32.Parse(listView1.SelectedItems[0].SubItems[0].Text);
Let l = DataManager.GetLet(id);
PregledajPutnike pregledaj = new PregledajPutnike();
pregledaj.let = l;
pregledaj.ShowDialog();
}
else
{
MessageBox.Show("Morate odabrati let!");
}
}
private void kupiKartuButton_Click(object sender, EventArgs e)
{
Let selektiraniLet = DohvatiSelektiraniLet();
if (selektiraniLet == null)
{
MessageBox.Show("Niste odabrali let za koji želite kupiti kartu.");
return;
}
FormRezervacijaKarte form = new FormRezervacijaKarte(selektiraniLet);
form.ShowDialog();
OsvjeziDGV(RepozitorijSkyFlyReservation.DohvatiLetove());
}
void Specify_linq_builder()
{
int value = 0;
var checker = Let <int> .Predicate(x => x == 0);
checker.Invoke(value).Should().BeTrue();
checker.Expand().Invoke(value).Should().BeTrue();
var inc = Linq.Expr <int, int>(x => x + 1);
value = inc.Invoke(value);
value.Should().Be(1);
checker.Invoke(value).Should().BeFalse();
}
private static List<Let> GetElementLets(XElement xEle, List<XElement> garbage)
{
XName letName = XName.Get("let", Constants.ISONamespace);
List<Let> listLets = new List<Let>();
foreach (XElement x in xEle.Descendants())
{
if (x.Name == letName)
{
Let let = new Let();
let.Name = String.Concat("$", x.Attribute(XName.Get("name")).Value);
let.Value = x.Attribute(XName.Get("value")).Value;
garbage.Add(x);
listLets.Add(let);
}
}
return listLets;
}
