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