public bool IsFavouriteTopic(string userid, int topicID, MSGorillaEntities _gorillaCtx)
{
FavouriteTopic ftopic = _gorillaCtx.FavouriteTopics.Where(f => f.Userid.Equals(userid) && f.TopicID == topicID).FirstOrDefault();
if (ftopic != null)
{
return(true);
}
return(false);
}
public void clearUnreadMsgCountOfFavouriteTopic(string userid, int topicID)
{
using (var _gorillaCtx = new MSGorillaEntities())
{
FavouriteTopic ftopic = _gorillaCtx.FavouriteTopics.Where(f => f.Userid.Equals(userid) && f.TopicID == topicID).FirstOrDefault();
if (ftopic != null)
{
ftopic.UnreadMsgCount = 0;
_gorillaCtx.SaveChanges();
}
}
}
public int GetFavouriteTopicUnreadCount(string userid, int topicid)
{
using (var _gorillaCtx = new MSGorillaEntities())
{
FavouriteTopic topic = _gorillaCtx.FavouriteTopics.Where(f => f.Userid.Equals(userid) && f.TopicID.Equals(topicid)).FirstOrDefault();
if (topic != null)
{
return(topic.UnreadMsgCount);
}
return(0);
}
}
public void AddFavouriteTopic(string userid, int topicID)
{
using (var _gorillaCtx = new MSGorillaEntities())
{
if (_gorillaCtx.FavouriteTopics.Where(f => f.Userid.Equals(userid) && f.TopicID == topicID).Count() == 0)
{
FavouriteTopic ftopic = new FavouriteTopic();
ftopic.TopicID = topicID;
ftopic.Userid = userid;
ftopic.UnreadMsgCount = 0;
_gorillaCtx.FavouriteTopics.Add(ftopic);
_gorillaCtx.SaveChanges();
}
}
}
public DisplayFavouriteTopic(FavouriteTopic ftopic, MSGorillaEntities _gorillaCtx)
{
Topic topic;
if (ftopic == null || ((topic = _gorillaCtx.Topics.Find(ftopic.TopicID)) == null))
{
topicID = UnreadMsgCount = topicMsgCount = 0;
userid = topicName = topicDescription = null;
}
else
{
userid = ftopic.Userid;
topicID = ftopic.TopicID;
UnreadMsgCount = ftopic.UnreadMsgCount;
topicName = topic.Name;
topicDescription = topic.Description;
topicMsgCount = topic.MsgCount;
GroupID = topic.GroupID;
}
}
