/// <summary>
/// User subcribe to tag
/// </summary>
/// <param name="tag"></param>
/// <param name="user"></param>
public static void SubcribeToTag(int tag, int user)
{
using (var db = new QaAContext())
{
//Check the subcribe
var q = (from t in db.UserHasSubscribes where (t.TagId == tag && t.UserId == user) select t).FirstOrDefault();
//if it does not exist yet
if (q == null)
{
var subc = new UserHasSubscribe
{
TagId = tag,
UserId = user
};
db.UserHasSubscribes.Add(subc);
db.SaveChanges();
}
}
}
/// <summary>
/// User subcribes to more tags
/// </summary>
/// <param name="tags"></param>
/// <param name="user"></param>
public static void SubcribeToMoreTags(List<Tag> tags, int user)
{
using (var db = new QaAContext())
{
foreach (var item in tags)
{
//Check the subcribe
var q = (from t in db.UserHasSubscribes where (t.TagId == item.Id && t.UserId == user) select t).FirstOrDefault();
//if it does not exist yet
if (q == null)
{
var subc = new UserHasSubscribe
{
TagId = item.Id,
UserId = user
};
db.UserHasSubscribes.Add(subc);
db.SaveChanges();
}
}
}
}