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