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