//
// GET: /Clanci/
public ActionResult Index()
{
ClanciServisObrada c = new ClanciServisObrada();
ViewBag.Search = false;
return View(c.getAllClanci());
}
//
// GET: /Clanci/
public ActionResult Index()
{
ClanciServisObrada c = new ClanciServisObrada();
return View(c.getAllClanci());
}
public ActionResult Edit(int id)
{
ClanciServisObrada c = new ClanciServisObrada();
return View(ClanciServisObrada.getClanakById(id));
}
public List<ClanciServisObrada> getAllClanci()
{
using (Spajanje s = new Spajanje())
{
List<ClanciServis> tst = (from c in s.Context.Clanci
join sa in s.Context.Sadrzaji
on c.ClanakID equals sa.ClanakID
join ts in s.Context.TagVrste
on c.TagVrstaID equals ts.TagVrstaID
select new ClanciServis
{
ClanakId = c.ClanakID,
slika = c.Slika,
popularnost = (double)c.Popularnost,
ocjena = (int)c.Ocjenjeno,
naslov = sa.Naslov,
opis = sa.Opis,
tekst = sa.Tekst,
klasa = ts.Opis,
vrsta = (int)ts.Vrsta,
komentari=(from k in s.Context.Komentari where k.ClanakID==c.ClanakID select k).Count()
}).ToList();
List<ClanciServisObrada> finals = new List<ClanciServisObrada>();
ClanciServisObrada tempF;
List<TagVrste> SveVrste = GetAllVrste();
foreach (TagVrste it in SveVrste)
{
try
{
tempF = null;
tempF = new ClanciServisObrada();
tempF.ClanciOrig = (from lis in tst where lis.vrsta == it.Vrsta select lis).ToList();
tempF.klasa = (from lis in tempF.ClanciOrig select lis.klasa).FirstOrDefault().ToString();
finals.Add(tempF);
}
catch (Exception)
{
}
}
List<Tags> tagovi;
//tagovi=(from tc in s.Context.TagClanci join clan in s.Context.Clanci on tc.ClanakID equals clan.ClanakID
//join t in s.Context.Tags on tc.TagID equals t.TagID select t).ToList()
foreach (ClanciServisObrada repl in finals)
{
foreach (ClanciServis cl in repl.ClanciOrig)
{
cl.tekst=cl.tekst.Substring(0, (cl.tekst.Length*20)/100);
cl.tekst = cl.tekst.Substring(0,cl.tekst.LastIndexOf(' '));
cl.tekst += "...";
tagovi = null;
tagovi = (from tc in s.Context.TagClanci join clan in s.Context.Clanci on tc.ClanakID equals clan.ClanakID
join t in s.Context.Tags on tc.TagID equals t.TagID where tc.ClanakID==cl.ClanakId select t).ToList();
foreach (Tags tg in tagovi)
{
cl.tekst = MvcHtmlString.Create(cl.tekst.Replace(tg.Ime, "<div class='Clanci-Tag'>" + tg.Ime + "</div>")).ToString();
}
}
}
return finals;
}
}