private void PoveziTagove()
{
if (txt_Tagovi.Text != String.Empty)
{
using (TriglavBL temp = new TriglavBL())
{
string[] tags = txt_Tagovi.Text.Split(',');
foreach (var item in tags)
{
Data.EntityFramework.DAL.Tag tag = new Data.EntityFramework.DAL.Tag();
tag.Naziv = item.Trim();
if (temp.getTagByName(tag.Naziv) == null)
{
tag.DatumKreiranja = DateTime.Now;
temp.SaveTag(tag);
}
else
{
tag = temp.getTagByName(tag.Naziv);
}
if (temp.getPosts_TagsByIDS(post.id, tag.id) == null)
{
Data.EntityFramework.DAL.Posts_Tags posts_tags = new Data.EntityFramework.DAL.Posts_Tags();
posts_tags.PostID = post.id;
posts_tags.TagID = tag.id;
temp.SavePosts_Tags(posts_tags);
}
}
}
}
}
public void SaveTag(Tag tag)
{
context.Tag.Add(tag);
context.SaveChanges();
}
private void PoveziTagove()
{
if (txt_Tagovi.Text != String.Empty)
{
using (TriglavBL temp = new TriglavBL())
{
string[] tags = txt_Tagovi.Text.Split(',');
foreach (var item in tags)
{
Data.EntityFramework.DAL.Tag tag = new Data.EntityFramework.DAL.Tag();
tag.Naziv = item.Trim();
if (temp.getTagByName(tag.Naziv) == null)
{
tag.DatumKreiranja = DateTime.Now;
temp.SaveTag(tag);
}
else
{
tag = temp.getTagByName(tag.Naziv);
}
if (temp.getPosts_TagsByIDS(post.id, tag.id) == null)
{
Data.EntityFramework.DAL.Posts_Tags posts_tags = new Data.EntityFramework.DAL.Posts_Tags();
posts_tags.PostID = post.id;
posts_tags.TagID = tag.id;
temp.SavePosts_Tags(posts_tags);
}
}
}
}
}
public List<Korisnik> GetKorisniciRelatedToPitanjeTags(Tag TAG)
{
var query = (
from k in context.Korisnik
join p in context.Post on k.id equals p.VlasnikID
join pt in context.Posts_Tags on p.id equals pt.PostID
join t in context.Tag on pt.TagID equals t.id
where p.PostVrsta == 5 && p.Tagovi.Contains(TAG.Naziv)
select k).OrderByDescending(y => y.Reputacija).OrderBy(x => x.BedzID).Distinct().ToList();
return (List<Korisnik>)query;
}
