public static int AddOrUpdateTopic(Topic t)
{
int ret;
//remove the topics from cache
CacheManager.RemoveItem("topics");
using (db = new topicsEF())
{
var topic = db.Topics.Where(x => x.TopicID == t.TopicID).FirstOrDefault();
if (topic == null)
{
db.Topics.Add(t);
ret = db.SaveChanges();
}
else
{
topic.Title = t.Title;
topic.DateUpdated = DateTime.Now;
ret = db.SaveChanges();
}
return(ret);
}
}
public static Topic GetTopicByID(int id)
{
using (db = new topicsEF())
{
var topic = db.Topics.Where(x => x.TopicID == id).FirstOrDefault();
var comments = topic.Comments;
return(topic);
}
}
public static int AddComment(Comment c)
{
int ret = 0;
using (db = new topicsEF())
{
if (c == null)
{
ret = 0;
}
db.Comments.Add(c);
ret = db.SaveChanges();
}
return(ret);
}
public static List <Topic> GetTopics()
{
if (CacheManager.GetItem("topics") == null)
{
using (db = new topicsEF())
{
var topics = db.Topics.ToList();
//place the list into the cache
CacheManager.AddItem("topics", topics);
return(topics);
}
}
else
{
return(CacheManager.GetItem("topics"));
}
}