public ActionResult Details(int id,string txtComment) { if (!String.IsNullOrEmpty(txtComment)) { DBBL.DAL.Odgovori o = new DBBL.DAL.Odgovori(); o.PitanjeID = id; o.Odgovor = txtComment; o.Datum = DateTime.Now; o.KorisnikID = 1; o.BrojGlasova = 0; Pitanja pitanje = new Pitanja(); using (Pitanja pt = new Pitanja()) { pt.AddAnswer(o); pt.SetAllDetaByPitanjeID(id); pitanje = pt; } return View(pitanje); } Pitanja pitanje2 = new Pitanja(); using (Pitanja pt = new Pitanja()) { pt.SetAllDetaByPitanjeID(id); pitanje2 = pt; } return View(pitanje2); }
// // GET: /Pitanja/ public ActionResult Index() { List<DBBL.DAL.Pitanja> pitanja; using (Pitanja pt= new Pitanja()) { pitanja= pt.GetAllPitanja(); } return View(pitanja); }
public ActionResult Details(int id) { Pitanja pitanje=new Pitanja(); using (Pitanja pt = new Pitanja()) { pt.SetAllDetaByPitanjeID(id); pitanje = pt; } return View(pitanje); }
public ActionResult Details(string name) { using (Wikiped.Models.Pitanja pt = new Wikiped.Models.Pitanja()) { if (!String.IsNullOrEmpty(name)) { ViewBag.Pitanja = pt.GetAllPitanjaByTagName(name); ViewBag.Sadrzaji = pt.GetAllSadrzajiByTagName(name); } ViewBag.Tagovi = pt.GetAllTagsCount().Take(15); } return View(); }
public ActionResult AddCommentForAnswer(int id, string textComm) { if (!String.IsNullOrEmpty(textComm)) { DBBL.DAL.OdgovorNaOdgovor tempOdg = new DBBL.DAL.OdgovorNaOdgovor(); tempOdg.OdgovorID = id; tempOdg.Odgovor = textComm; tempOdg.KorisnikID = 1; tempOdg.Datum = DateTime.Now; using (Pitanja pt = new Pitanja()) { pt.AddCommentOnAnswer(tempOdg); } return Json(new { voteNumber = 1 }); } return View(); }
// // GET: /Users/Details/5 public ActionResult Details(int id) { List<DBBL.DAL.Pitanja> lstPitanja = new List<DBBL.DAL.Pitanja>(); List<DBBL.DAL.Sadrzaji> lstSadrzaji = new List<DBBL.DAL.Sadrzaji>(); using (Pitanja pt = new Pitanja()) { lstPitanja.AddRange(pt.GetAllPitanjaByKorisnikId(id)); lstPitanja.AddRange(pt.GetAllPitanjaOdgovoriByKorisnikId(id)); lstSadrzaji.AddRange(pt.GetAllClanciByKorisnikId(id)); ViewBag.Tagovi = pt.GetAllTagsCount().Take(15); } ViewBag.Sadrzaji = lstSadrzaji; ViewBag.GetTags = new Func<int, IEnumerable<string>>(GetAllTagsForPitanje); ViewBag.GetKorisnikName = new Func<int, string>(GetKorisnikName); ViewBag.GetBrojOdgovora = new Func<int, int>(GetBrojOdgovora); ViewBag.AllPitanja = lstPitanja.Distinct().ToList(); return View(); }
public ActionResult Create(string naslov, int kategorija, string novaKat, int slicnaKat, string tekst, HttpPostedFileBase slika, string tagovi, bool update, int clids) { if (update != true) { #region unos novog clanka using (Spajanje s = new Spajanje()) { Clanci novi = new Clanci(); novi.Popularnost = 0; novi.Ocjenjeno = 0; novi.Guid = Guid.NewGuid(); var fileName = novi.Guid.ToString().Substring(0, 9); string putanja = unosSlike(slika, fileName, 0); if (putanja != string.Empty) { novi.Slika = putanja; } novi.TagVrstaID = unosClanakvrste(kategorija, novaKat, slicnaKat); Korisnici kor = Session["Korisnik"] as Korisnici; novi.KorisnikID = kor.KorisnikID; s.Context.Clanci.AddObject(novi); s.Context.SaveChanges(); Clanci ClanakS = s.Context.Clanci.ToList().Last(); Sadrzaji sadrzajS = new Sadrzaji(); sadrzajS.ClanakID = ClanakS.ClanakID; sadrzajS.Naslov = naslov; sadrzajS.Tekst = tekst; sadrzajS.Datum = DateTime.Now; s.Context.Sadrzaji.AddObject(sadrzajS); s.Context.SaveChanges(); TagoviUnos(tagovi, ClanakS.ClanakID); return Redirect("ClanciPregled?clID=" + ClanakS.ClanakID.ToString()); } #endregion } else { using (Spajanje s = new Spajanje()) { Clanci clanak = (from c in s.Context.Clanci where c.ClanakID == clids select c).FirstOrDefault(); Sadrzaji sadrzaj = (from c in s.Context.Sadrzaji where c.ClanakID == clids select c).FirstOrDefault(); if (clanak != null) { sadrzaj.Naslov = naslov; sadrzaj.Tekst = tekst; TagoviUnos(tagovi, clids); var fileName = clanak.Guid.ToString().Substring(0, 9); string putanja = unosSlike(slika, fileName, clids); if (putanja != string.Empty) { if (putanja != null) { clanak.Slika = putanja; } } if (slicnaKat > 0) { kategorija = 0; } clanak.TagVrstaID = unosClanakvrste(kategorija, novaKat, slicnaKat); s.Context.SaveChanges(); return Redirect("ClanciPregled?clID=" + clids.ToString()); } } } LucenePt.ClearLuceneIndex(); LucenePt.AddUpdateLuceneIndex(LucenePt.GetAllObjectForLuceneIndex()); using (Wikiped.Models.Pitanja pt = new Wikiped.Models.Pitanja()) { ViewBag.Tagovi = pt.GetAllTagsCount().Take(15); } return View(); }
public ActionResult Create() { Korisnici kor = Session["Korisnik"] as Korisnici; if (kor != null) { List<TagVrste> tgs; using (Spajanje s = new Spajanje()) { tgs = (from tg in s.Context.TagVrste orderby tg.Opis ascending select tg).ToList(); ViewBag.clanci = (from cl in s.Context.Clanci join sa in s.Context.Sadrzaji on cl.ClanakID equals sa.ClanakID select sa).ToList(); } using (Wikiped.Models.Pitanja pt = new Wikiped.Models.Pitanja()) { ViewBag.Tagovi = pt.GetAllTagsCount().Take(15); } return View(tgs); } else { return RedirectToAction("Index"); } }
public string GetKorisnikName(int id) { DBBL.DAL.Korisnici korisnik; using (Pitanja pt = new Pitanja()) { korisnik = pt.GetKorisnikByID(id); } if (korisnik != null) { return korisnik.UserName; } return string.Empty; }
public int GetBrojOdgovora(int id) { int count = default(int); using (Pitanja pt = new Pitanja()) { count = pt.GetBrojOdgovoraZaPitanje(id); } return count; }
public IEnumerable<string> GetAllTagsForPitanje(int id) { IEnumerable<string> lstTags; using (Pitanja pt = new Pitanja()) { lstTags = pt.GetAllTagsForPitanjeID(id); } return lstTags; }
public ActionResult VoteDown(int id, bool mainQuestion) { int korisnikId = 1; int voteNumber = default(int); using (Pitanja pt = new Pitanja()) { if (mainQuestion == true) { voteNumber = pt.PitanjeVoteDown(id, korisnikId); } else { voteNumber = pt.OdgovorVoteDown(id, korisnikId); } } return Json(new { voteNumber = voteNumber }); }