// VRATI LISTU REZERVISANI ARANZMANA ZA KORISNIKA SA // ODGOVARAJUCIM ID public List <Aranzman> RezervisaniAranzmani(string korisnikID) { List <Aranzman> aranzmani = new List <Aranzman>(); komanda.CommandText = $"SELECT * FROM dbo.Aranzmani INNER JOIN dbo.Rezervisao ON dbo.Aranzmani.Id = dbo.Rezervisao.aranzmanID WHERE korisnikID = '{korisnikID}'"; try { konekcija.Open(); citac = komanda.ExecuteReader(); while (citac.Read()) { Aranzman a = new Aranzman { Id = Convert.ToInt32(citac[0]), Destinacija = citac[1].ToString(), Datum = (DateTime)citac[2], Cena = Convert.ToInt32(citac[3]) }; aranzmani.Add(a); } } catch (Exception) { Console.WriteLine("Greska pri povezivanju s bazom."); } finally { konekcija.Close(); } return(aranzmani); }
public async Task <IActionResult> Edit(Guid id, [Bind("BrojDana,Mesto,Popust,PonudaId,Id")] Aranzman aranzman) { if (id != aranzman.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(aranzman); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AranzmanExists(aranzman.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["PonudaId"] = new SelectList(_context.Ponude, "Id", "Sezona", aranzman.PonudaId); return(View(aranzman)); }
//UCITAJ SVE PODATKE O ARANZMANIMA IZ BAZE I PRAVI LISTU OBJEKATA public List <Aranzman> UcitajSveAranzmane() { List <Aranzman> aranzmani = new List <Aranzman>(); komanda.CommandType = System.Data.CommandType.Text; komanda.CommandText = "SELECT * FROM dbo.Aranzmani"; try { konekcija.Open(); citac = komanda.ExecuteReader(); while (citac.Read()) { Aranzman a = new Aranzman { Id = Convert.ToInt32(citac[0]), Destinacija = citac[1].ToString(), Datum = (DateTime)citac[2], Cena = Convert.ToInt32(citac[3]) }; aranzmani.Add(a); } } catch (Exception) { Console.WriteLine("Greska pri citanju iz baze."); } finally { konekcija.Close(); } return(aranzmani); }
public ActionResult DodajAranzman(Aranzman aranzman) { bool upisano = Broker.Instanca.DodajAranzman(aranzman); //Sta ako nije uspelo ? Dodaj. return(RedirectToAction("Index", "Manage")); }
public ActionResult Detalji(Aranzman aranzman) { if (aranzman.Equals(default(Aranzman))) { return(HttpNotFound()); } return(View(aranzman)); }
public ActionResult AranzmanIzmeni(FormCollection aranzman) { Aranzman nov = new Aranzman(); nov.AranzmanID = Convert.ToInt32(aranzman["SifraAranzmana"]); nov.Cena = Convert.ToInt32(aranzman["Cena"]); nov.Raspolozivost = Convert.ToInt32(aranzman["Raspolozivost"]); //nov.Aktivan = Convert.ToInt32(aranzman["Aktivan"]); Admin.IzmeniAranzman(nov); TempData["Izmena"] = "Aranžman je uspešno izmenjen."; return(RedirectToAction("AranzmaniDodajView")); }
public async Task <IActionResult> Create([Bind("BrojDana,Mesto,Popust,PonudaId,Id")] Aranzman aranzman) { if (ModelState.IsValid) { aranzman.Id = Guid.NewGuid(); _context.Add(aranzman); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["PonudaId"] = new SelectList(_context.Ponude, "Id", "Sezona", aranzman.PonudaId); return(View(aranzman)); }
private void RezervisiAranzman(string korisnikID, Aranzman aranzman) { komanda.CommandText = $"INSERT INTO dbo.Rezervisao VALUES('{korisnikID}', {aranzman.Id})"; try { konekcija.Open(); komanda.ExecuteNonQuery(); } catch (Exception) { Console.WriteLine("Greska pri konekciji sa bazom."); } finally { konekcija.Close(); } }
public ActionResult Rezervisi(Aranzman aranzman) { if (aranzman.Equals(default(Aranzman))) { return(HttpNotFound()); } string korisnikID = User.Identity.GetUserId(); bool rezervisao = Broker.Instanca.ProveriIRezervisi(korisnikID, aranzman); if (rezervisao) { return(View("~/Views/Aranzmani/UspesnoRezervisano.cshtml")); } return(View("~/Views/Aranzmani/NeuspesnoRezervisano.cshtml")); }
public bool ProveriIRezervisi(string korisnikID, Aranzman aranzman) { var aranzmani = RezervisaniAranzmani(korisnikID); bool vecRezervisao = aranzmani.Contains(aranzman) ? true : false; if (vecRezervisao) { return(false); } else { RezervisiAranzman(korisnikID, aranzman); } return(true); }
public async Task <IActionResult> OnPost() { if (pocetak.CompareTo(kraj) > 0 || cena < 1) { return(Page()); } Aranzman noviAranzman = new Aranzman(); noviAranzman.cena = cena; noviAranzman.pocetak = new DateTime(pocetak.Ticks, DateTimeKind.Utc); noviAranzman.kraj = new DateTime(kraj.Ticks, DateTimeKind.Utc); noviAranzman.hotel = new MongoDBRef("hoteli", new ObjectId(hotelID)); await _dbAranzmani.InsertOneAsync(noviAranzman); var update = Builders <Hotel> .Update.Push(Hotel => Hotel.Aranzmani, new MongoDBRef("aranzmani", noviAranzman.Id)); await _dbHoteli.UpdateOneAsync(Hotel => Hotel.Id == new ObjectId(hotelID), update); return(RedirectToPage("/Hotel-Single", new{ id = hotelID })); }
public bool DodajAranzman(Aranzman aranzman) { bool uspelo = false; komanda.CommandText = $"INSERT INTO dbo.Aranzmani(Destinacija,Datum,Cena) VALUES('{aranzman.Destinacija}', '{aranzman.Datum.ToString("yyyy.M.d")}', {aranzman.Cena})"; try { konekcija.Open(); komanda.ExecuteNonQuery(); uspelo = true; } catch (Exception) { Console.WriteLine("Neuspesno upisivanje."); } finally { konekcija.Close(); } return(uspelo); }