public static IList<Dbo.Tag> ListAllTags()
{
using (CatMyVideoEntities context = new CatMyVideoEntities())
{
return context.T_Tags.ToList().Select(x => new Dbo.Tag() { Name = x.name }).ToList();
}
}
public static IList<Dbo.Tag> ListTagsByVideoId(int videoId)
{
using (CatMyVideoEntities context = new CatMyVideoEntities())
{
return context.T_VideosTags.Where(x => x.video == videoId).ToList().Select(x => new Dbo.Tag() { Name = x.tag }).ToList();
}
}
public static void AddTags(IEnumerable<Dbo.Tag> tags, int video)
{
using (CatMyVideoEntities context = new CatMyVideoEntities())
{
var tmpVideo = context.T_Videos.First(x => x.id == video);
foreach (var tag in tags)
{
T_Tags tmpTag = context.T_Tags.FirstOrDefault(x => x.name == tag.Name);
// If we can't find any tag, create a new one
if (tmpTag == default(T_Tags))
{
tmpTag = new T_Tags();
tmpTag.name = tag.Name;
context.T_Tags.Add(tmpTag);
context.T_VideosTags.Add(new T_VideosTags() { tag = tag.Name, video = video });
}
else
{
context.T_Tags.Attach(tmpTag);
context.Entry(tmpTag).State = System.Data.Entity.EntityState.Modified;
}
}
context.SaveChanges();
}
}
public static IList<Dbo.Role> ListAllRoles()
{
using (CatMyVideoEntities context = new CatMyVideoEntities())
{
IEnumerable<AspNetRoles> query = context.AspNetRoles;
return query.ToList().Select(x => ConvertAspNetRolesToDboRole(x)).ToList();
}
}