public IActionResult prikaziPreporukeKncerata()
{
List <Koncert> l = new List <Koncert>();
var rr = session.Execute("SELECT * FROM \"preporuka\" ;");
foreach (var result in rr)
{
var zanr = result.GetValue <string>("zanr");//zanr ili tip koncerta
var r = session.Execute("SELECT * FROM \"Koncert\" WHERE tip =\'" + zanr + "\' ALLOW FILTERING;");
foreach (var rs in r)
{
Koncert k = new Koncert();
k.KoncertID = rs.GetValue <string>("koncertID");
k.Ime = rs.GetValue <string>("ime");
k.Organizator = rs.GetValue <string>("organizator");
k.Sponzor = rs.GetValue <string>("sponzor");
k.Opis = rs.GetValue <string>("opis");
k.Tip = rs.GetValue <string>("tip");
l.Add(k);
}
}
return(View(l));
}
public async Task <ActionResult> GetByParams(string sensorId, DateTimeOffset from, DateTimeOffset to)
{
var listOfPollution = _session.Execute("SELECT * FROM pollution_data WHERE sensorid='" + sensorId + "' AND collecttime>" + from.ToUnixTimeMilliseconds() + " AND collecttime<" + to.ToUnixTimeMilliseconds() + "");
IList <PollutionDTO> pollutions = new List <PollutionDTO>();
foreach (var res in listOfPollution)
{
PollutionDTO p = new PollutionDTO();
p.SensorId = res.GetValue <string>("sensorid");
p.CollectTime = res.GetValue <DateTimeOffset>("collecttime");
p.SensorData = res.GetValue <float>("sensordata");
pollutions.Add(p);
}
return(Ok(pollutions));
}
public async Task <ActionResult> Get()
{
var listOfPollution = _session.Execute("select * from alertPollution where about='Need to be solved' ALLOW FILTERING");
IList <AlertPollution> pollutions = new List <AlertPollution>();
foreach (var res in listOfPollution)
{
AlertPollution p = new AlertPollution();
p.SensorId = res.GetValue <string>("sensorid");
p.CollectTime = res.GetValue <DateTimeOffset>("collecttime");
p.SensorData = res.GetValue <float>("sensordata");
p.About = res.GetValue <string>("about");
pollutions.Add(p);
}
return(Ok(pollutions));
}
public IActionResult OnPostRec()
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String email = HttpContext.Session.GetString("email");
if (!String.IsNullOrEmpty(email))
{
Korisnik korisnik = mapper.FirstOrDefault <Korisnik>("select * from korisnik where email = '" + email + "'");
if (korisnik.tip == 1)
{
return(Redirect(("/Book?id=" + idKnjiga + "&zanr=" + zanr + "&success=admin").ToString()));
}
Recenzija recenzija = mapper.FirstOrDefault <Recenzija>("select * from \"Recenzija\" where \"knjigaID\"= ? and \"korisnikID\"= ?", idKnjiga, korisnik.korisnikID.ToString());
if (recenzija == null)
{
String query = $"insert into \"EBook\".\"Recenzija\" (\"recenzijaID\",\"korisnikID\", \"knjigaID\", komentar, ocena,nazivknjige,zanrknjige,opisknjige,email) values ('" + Cassandra.TimeUuid.NewId() + $"','{korisnik.korisnikID.ToString()}','{idKnjiga}','{komentar}',{ocena}, '{naziv}', '{zanr}', '{opis}', '{email}')";
session.Execute(query);
return(Redirect(("/Book?id=" + idKnjiga + "&zanr=" + zanr).ToString()));
}
else
{
return(Redirect(("/Book?id=" + idKnjiga + "&zanr=" + zanr + "&success=already").ToString()));
}
}
else
{
return(RedirectToPage("/Login"));
}
}
public IActionResult OnPostObrisiRez(string id, string kId)
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String query = $"delete from \"EBook\".\"Rezervacija\" where \"rezervacijaID\"= '{id}' and \"korisnikID\"='{kId}'";
session.Execute(query);
return(RedirectToPage());
}
public IActionResult OnPostObrisiKnjigu(string id, string zanr)
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String query = $"delete from \"EBook\".\"Knjiga\" where \"knjigaID\"= '{id}' and \"zanr\"='{zanr}'";
session.Execute(query);
return(Redirect("/Admin?success=dBook"));
}
public IActionResult OnPostStatusRealizovano(string id, string kId)
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String query = $"update \"EBook\".\"Rezervacija\" set status='Realizovano' where \"rezervacijaID\"= '{id}' and \"korisnikID\"='{kId}'";
session.Execute(query);
return(Redirect("/Admin?success=sRealizovano"));
}
public IActionResult OnPostObrisiRec(string id, string kId)
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String query = $"delete from \"EBook\".\"Recenzija\" where \"knjigaID\"= '{id}' and \"korisnikID\"='{kId}'";
session.Execute(query);
return(Redirect("/Admin?success=dRec"));
}
public Tuple <string, string> GetHtml(long id)
{
try
{
RowSet r = _session.Execute(string.Format("select html, url from html where id = {0}", id));
var row = r.GetRows().ElementAt(0);
return(new Tuple <string, string>(row.GetValue(typeof(string), "url").ToString(),
row.GetValue(typeof(string), "html").ToString()));
}
catch (ArgumentOutOfRangeException ex01)
{
return(null);
}
catch (Exception ex)
{
Log.Error(ex);
return(null);
}
}
public IActionResult OnPostSmanji(string id, string zanr)
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
Knjiga k = mapper.First <Knjiga>("select * from \"Knjiga\" where \"knjigaID\"= ? and zanr= ?", id, zanr);
String query = $"update \"EBook\".\"Knjiga\" set kolicina = {k.kolicina-1} where \"knjigaID\"='{id}' and zanr='{zanr}'";
session.Execute(query);
return(Redirect("/Admin?success=minus"));
}
public IActionResult OnPostSacuvaj()
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String email = HttpContext.Session.GetString("email");
korisnik = mapper.FirstOrDefault <Korisnik>("select * from korisnik where email = '" + email + "'");
if (newPassword != null && !newPassword.Equals(""))
{
String query = $"update \"EBook\".korisnik set sifra = '{newPassword}' where email= '" + email + $"' and korisnikid='{korisnik.korisnikID}'";
session.Execute(query);
}
return(Redirect("./Login"));
}
public void OnGet()
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String email = HttpContext.Session.GetString("email");
if (!String.IsNullOrEmpty(email))
{
Korisnik korisnik = mapper.FirstOrDefault <Korisnik>("select * from korisnik where email = '" + email + "'");
if (korisnik.tip == 1)
{
Message = "Admin";
}
else
{
Message = "User";
}
//Message = "Welcome " + korisnik.ime;
}
kategorije = mapper.Fetch <string>("SELECT DISTINCT zanr FROM \"Knjiga\"");
//SELECT "knjigaID", AVG(ocena) FROM "Recenzija" GROUP BY "knjigaID" LIMIT 5;
najpopularnijeKnjige = new List <Knjiga>();
RowSet knjigaOcena = session.Execute("SELECT \"knjigaID\", AVG(ocena) as avgocena, COUNT(*) as brojocena, nazivknjige, zanrknjige, opisknjige FROM \"Recenzija\" GROUP BY \"knjigaID\"");
foreach (var item in knjigaOcena)
{
Knjiga k = new Knjiga();
k.knjigaID = item["knjigaID"] != null ? item["knjigaID"].ToString() : string.Empty;
k.ocena = item["avgocena"] != null ? (float)item["avgocena"] : 0;
k.brojocena = item["brojocena"] != null ? (long)item["brojocena"] : 0;
k.naziv = item["nazivknjige"] != null ? item["nazivknjige"].ToString() : string.Empty;
k.zanr = item["zanrknjige"] != null ? item["zanrknjige"].ToString() : string.Empty;
k.opis = item["opisknjige"] != null ? item["opisknjige"].ToString() : string.Empty;
najpopularnijeKnjige.Add(k);
}
najpopularnijeKnjige.Sort((a, b) => b.CompareTo(a));
brojKnjiga = mapper.Single <int>("SELECT COUNT(*) FROM \"Knjiga\"");
brojKorisnika = mapper.Single <int>("SELECT COUNT(*) FROM korisnik");
brojRezervacija = mapper.Single <int>("SELECT COUNT(*) FROM \"Rezervacija\"");
brojRecenzija = mapper.Single <int>("SELECT COUNT(*) FROM \"Recenzija\"");
bibliotekar1 = mapper.FirstOrDefault <Korisnik>("SELECT * FROM korisnik where korisnikid = '7' and email = '*****@*****.**'");
bibliotekar2 = mapper.FirstOrDefault <Korisnik>("SELECT * FROM korisnik where korisnikid = '8' and email = '*****@*****.**'");
}
public IActionResult OnPost()
{
Cassandra.ISession session = SessionManager.GetSession();
if (session == null)
{
return(RedirectToPage("/Error"));
}
string fileName = saveBase64AsImage(novaKnjiga.slika);
novaKnjiga.slika = "images/" + "Library" + "/" + fileName;
String noviId = Cassandra.TimeUuid.NewId().ToString();
String query = $"insert into \"Knjiga\" (zanr, \"knjigaID\", autor, brstrana, godina, kolicina, naziv, opis, pismo, slika, jezik) values ('{novaKnjiga.zanr}', '" + noviId + $"', '{novaKnjiga.autor}', '{novaKnjiga.brstrana}', '{novaKnjiga.godina}', {novaKnjiga.kolicina}, '{novaKnjiga.naziv}', '{novaKnjiga.opis}', '{novaKnjiga.pismo}','{novaKnjiga.slika}','{novaKnjiga.jezik}')";
session.Execute(query);
return(RedirectToPage("/Book", new { id = noviId, zanr = novaKnjiga.zanr }));
}
public IActionResult OnPostRez()
{
int brojac = 0;
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String email = HttpContext.Session.GetString("email");
if (!String.IsNullOrEmpty(email))
{
Korisnik korisnik = mapper.FirstOrDefault <Korisnik>("select * from korisnik where email = '" + email + "'");
Knjiga k = mapper.First <Knjiga>("select * from \"Knjiga\" where \"knjigaID\"= ? and zanr= ?", idKnjiga, zanr);
//mogucnost da admin moze da rezervise neku knjigu za nekog korisnika ukoliko unese korisnikovu mail adresu
if (korisnik.tip == 1)
{
Korisnik kor = mapper.FirstOrDefault <Korisnik>("select * from korisnik where email = '" + emailKorisnika + "'");
if (kor != null)
{
String queryUpdate = $"update \"EBook\".\"Knjiga\" set kolicina = {k.kolicina-1} where \"knjigaID\"='{idKnjiga}' and zanr='{zanr}'";
session.Execute(queryUpdate);
String query = $"insert into \"EBook\".\"Rezervacija\" (\"rezervacijaID\",\"korisnikID\", \"knjigaID\", datum, status, nazivknjige,zanrknjige,email) values ('" + Cassandra.TimeUuid.NewId() + $"','{kor.korisnikID.ToString()}','{idKnjiga}','{(DateTime.Now).ToString("yyyy-MM-dd'T'HH:mm:ssZ")}','Aktivno', '{k.naziv}', '{k.zanr}', '{emailKorisnika}')";
session.Execute(query);
return(Redirect(("/Book?id=" + idKnjiga + "&zanr=" + zanr + "&success=AdminTrue").ToString()));
}
return(Redirect(("/Book?id=" + idKnjiga + "&zanr=" + zanr + "&success=AdminFalse").ToString()));
}
//da izbroji korisnikove rezervacije
IList <Rezervacija> rezervacije = new List <Rezervacija>();
rezervacije = mapper.Fetch <Rezervacija>("select * from \"Rezervacija\" where \"korisnikID\"=?", korisnik.korisnikID).ToList <Rezervacija>();
for (int i = 0; i < rezervacije.Count; i++)
{
if (rezervacije.ElementAt(i).status.Equals("Na cekanju"))
{
brojac++;
}
}
//ako postoji bar jedna knjiga u bazi sa tim imenom i zanrom
if (k.kolicina > 0)
{
//ako korisnik ima vise od 5 aktivnih rezervacija da mu onemoguci dok ne preuzme odredjene rezervacije
if (brojac >= 5)
{
return(Redirect(("/Book?id=" + idKnjiga + "&zanr=" + zanr + "&success=false").ToString()));
}
else
{
String queryUpdate = $"update \"EBook\".\"Knjiga\" set kolicina = {k.kolicina-1} where \"knjigaID\"='{idKnjiga}' and zanr='{zanr}'";
session.Execute(queryUpdate);
String query = $"insert into \"EBook\".\"Rezervacija\" (\"rezervacijaID\",\"korisnikID\", \"knjigaID\", datum, status, nazivknjige,zanrknjige,email) values ('" + Cassandra.TimeUuid.NewId() + $"','{korisnik.korisnikID.ToString()}','{idKnjiga}','{(DateTime.Now).ToString("yyyy-MM-dd'T'HH:mm:ssZ")}','Na cekanju', '{k.naziv}', '{k.zanr}', '{email}')";
session.Execute(query);
return(Redirect(("/Book?id=" + idKnjiga + "&zanr=" + zanr + "&success=true").ToString()));
}
}
else
{
return(Redirect(("/Book?id=" + idKnjiga + "&zanr=" + zanr + "&success=out").ToString()));
}
}
else
{
return(RedirectToPage("/Login"));
}
}
public IActionResult Edit([FromQuery(Name = "id")] string id)
{
GetUserAutoList();
Auto = UserAutoList.Where(x => x.Id.ToString() == id).FirstOrDefault();
string query = $"SELECT * FROM auto_by_id WHERE id={Guid.Parse(id)};";
var rs = _session.Execute(query);
var temp = rs.First();
Auto.Brand = temp.GetValue <string>("brand");
Auto.Model = temp.GetValue <string>("model");
Auto.Year = temp.GetValue <int>("year");
Auto.Price = temp.GetValue <int>("price");
Auto.Power = temp.GetValue <int>("power");
Auto.Volume = temp.GetValue <int>("volume");
Auto.Contact = temp.GetValue <string>("contact");
Auto.Color = temp.GetValue <string>("color");
Auto.Description = temp.GetValue <string>("description");
Auto.EquipmentList = string.Join(", ", temp.GetValue <string[]>("equipmentlist") == null ? new string[0] : temp.GetValue <string[]>("equipmentlist"));
if (Auto == null)
{
return(NotFound("Car do not exist"));
}
return(View(this));
}
public RowSet ExecuteNonAsync(string statement)
{
return(_session.Execute(new SimpleStatement(statement)));
}
public IActionResult AdProfile(Guid idAd, string typeofJob, string email)
{
bool indicator = false;
bool indicatora = false;
Ad ad = mapper.Fetch <Ad>("SELECT * from opportunity.ad where typeofjob='" + typeofJob + "' AND idad = " + idAd + "").FirstOrDefault();
if (ad.EmailFirm != email)
{
session.Execute("insert into opportunity.user_ads_history (email,idad,time,typeofjob) values ('" + GetLoggedUser(null) + "'," + idAd + ", toTimestamp(now()), '" + typeofJob + "' )");
}
User u = mapper.Fetch <User>("SELECT * FROM opportunity.user WHERE email='" + GetLoggedUser(null) + "'").FirstOrDefault();
foreach (var item in u.AdSaved)
{
if (item.Key == idAd)
{
indicator = true;
}
}
List <Ads_user_applied> applied = mapper.Fetch <Ads_user_applied>("SELECT * FROM ads_user_applied where email='" + LoggedUser + "'").ToList();
foreach (var item in applied)
{
if (item.IdAd == idAd)
{
indicatora = true;
}
}
ViewBag.Indicator = indicator;
ViewBag.Indicatora = indicatora;
return(View(ad));
}
public void OnGet(string zanr, string SearchBook)
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String email = HttpContext.Session.GetString("email");
if (!String.IsNullOrEmpty(email))
{
Korisnik korisnik = mapper.FirstOrDefault <Korisnik>("select * from korisnik where email = '" + email + "'");
if (korisnik.tip == 1)
{
Message = "Admin";
}
else
{
Message = "User";
}
//Message = "Welcome " + korisnik.ime;
}
if (!String.IsNullOrEmpty(SearchBook))
{
knjigaSearch = mapper.FirstOrDefault <Knjiga>("select * from \"Knjiga\" where naziv like '" + SearchBook + "%'");
}
if (String.IsNullOrEmpty(SearchBook) || knjigaSearch == null)
{
zanrFilter = zanr;
HttpContext.Session.Remove("pagingState");
foreach (var zanrRaw in session.Execute("SELECT DISTINCT zanr FROM \"Knjiga\";"))
{
zanrovi.Add(zanrRaw["zanr"].ToString());
}
RowSet knjigeRaw;
if (String.IsNullOrEmpty(zanr) | !zanrovi.Contains(zanr))
{//all
var ps = session.Prepare("SELECT * from \"Knjiga\" ;");
var statement = ps.Bind().SetAutoPage(false).SetPageSize(10);
knjigeRaw = session.Execute(statement);
var pagingState = knjigeRaw.PagingState;
if (pagingState != null)
{
HttpContext.Session.Set("pagingState", pagingState);
}
}
else
{
var ps = session.Prepare("SELECT * from \"Knjiga\" where zanr='" + zanr + "';");
var statement = ps.Bind().SetAutoPage(false).SetPageSize(5);
knjigeRaw = session.Execute(statement);
var pagingState = knjigeRaw.PagingState;
if (pagingState != null)
{
HttpContext.Session.Set("pagingState", pagingState);
}
}
foreach (var knjigaRaw in knjigeRaw)
{
Knjiga knjiga = new Knjiga();
knjiga.autor = knjigaRaw["autor"] != null ? knjigaRaw["autor"].ToString() : string.Empty;
knjiga.brstrana = knjigaRaw["brstrana"] != null ? knjigaRaw["brstrana"].ToString() : string.Empty;
knjiga.godina = knjigaRaw["godina"] != null ? knjigaRaw["godina"].ToString() : string.Empty;
knjiga.knjigaID = knjigaRaw["knjigaID"].ToString();
knjiga.kolicina = knjigaRaw["kolicina"] != null?Int32.Parse(knjigaRaw["kolicina"].ToString()) : 0;
knjiga.naziv = knjigaRaw["naziv"] != null ? knjigaRaw["naziv"].ToString() : string.Empty;
knjiga.opis = knjigaRaw["opis"] != null ? knjigaRaw["opis"].ToString() : string.Empty;
knjiga.pismo = knjigaRaw["pismo"] != null ? knjigaRaw["pismo"].ToString() : string.Empty;
knjiga.slika = knjigaRaw["slika"] != null ? knjigaRaw["slika"].ToString() : string.Empty;
knjiga.zanr = knjigaRaw["zanr"] != null ? knjigaRaw["zanr"].ToString() : string.Empty;
knjiga.jezik = knjigaRaw["jezik"] != null ? knjigaRaw["jezik"].ToString() : string.Empty;
sveKnjige.Add(knjiga);
}
}
else
{
sveKnjige.Add(knjigaSearch);
}
}
/*public void OnGet(string SearchBook)
* {
* Cassandra.ISession session = SessionManager.GetSession();
* IMapper mapper = new Mapper(session);
*
* String email = HttpContext.Session.GetString("email");
* if(!String.IsNullOrEmpty(email))
* {
* Korisnik korisnik = mapper.FirstOrDefault<Korisnik>("select * from korisnik where email = '" + email + "'");
* if(korisnik.tip==1)
* Message="Admin";
* else
* Message="User";
* //Message = "Welcome " + korisnik.ime;
* }
*
* Knjiga k = mapper.FirstOrDefault<Knjiga>("select * from \"Knjiga\" where naziv = '" + SearchBook + "'");
*
* }*/
public JsonResult OnGetLoadMore(string selektovaniZanr)
{
byte[] pagingState;
bool gotPagingState = HttpContext.Session.TryGetValue("pagingState", out pagingState);
if (!gotPagingState)
{
return(new JsonResult("nemaVise"));
}
Cassandra.ISession session = SessionManager.GetSession();
RowSet knjigeRaw;
if (selektovaniZanr.CompareTo("All") == 0)
{
var ps = session.Prepare("SELECT * from \"Knjiga\" ;");
var statement = ps.Bind().SetAutoPage(false).SetPageSize(7).SetPagingState(pagingState);
knjigeRaw = session.Execute(statement);
pagingState = knjigeRaw.PagingState;
if (pagingState != null)
{
HttpContext.Session.Set("pagingState", pagingState);
}
else
{
HttpContext.Session.Remove("pagingState");
}
}
else
{
var ps = session.Prepare("SELECT * from \"Knjiga\" where zanr='" + selektovaniZanr + "';");
var statement = ps.Bind().SetAutoPage(false).SetPageSize(5).SetPagingState(pagingState);
knjigeRaw = session.Execute(statement);
pagingState = knjigeRaw.PagingState;
if (pagingState != null)
{
HttpContext.Session.Set("pagingState", pagingState);
}
else
{
HttpContext.Session.Remove("pagingState");
}
}
List <Knjiga> josKnjiga = new List <Knjiga>();
foreach (var knjigaRaw in knjigeRaw)
{
Knjiga knjiga = new Knjiga();
knjiga.autor = knjigaRaw["autor"] != null ? knjigaRaw["autor"].ToString() : string.Empty;
knjiga.brstrana = knjigaRaw["brstrana"] != null ? knjigaRaw["brstrana"].ToString() : string.Empty;
knjiga.godina = knjigaRaw["godina"] != null ? knjigaRaw["godina"].ToString() : string.Empty;
knjiga.knjigaID = knjigaRaw["knjigaID"].ToString();
knjiga.kolicina = knjigaRaw["kolicina"] != null?Int32.Parse(knjigaRaw["kolicina"].ToString()) : 0;
knjiga.naziv = knjigaRaw["naziv"] != null ? knjigaRaw["naziv"].ToString() : string.Empty;
knjiga.opis = knjigaRaw["opis"] != null ? knjigaRaw["opis"].ToString() : string.Empty;
knjiga.pismo = knjigaRaw["pismo"] != null ? knjigaRaw["pismo"].ToString() : string.Empty;
knjiga.slika = knjigaRaw["slika"] != null?LoadImage(knjigaRaw["slika"].ToString()) : string.Empty;
knjiga.zanr = knjigaRaw["zanr"] != null ? knjigaRaw["zanr"].ToString() : string.Empty;
knjiga.jezik = knjigaRaw["jezik"] != null ? knjigaRaw["jezik"].ToString() : string.Empty;
josKnjiga.Add(knjiga);
}
return(new JsonResult(josKnjiga));
}
