public string Delete(int TopicId)
{
using (FORUMEntities3 context = new FORUMEntities3())
{
// var _topic = context.Topics.Single(t => t.TopicId == topic.TopicId);
// _topic.Title = topic.TitleName;
// _topic.Description = topic.Description;
// context.
var _topics = from t in context.Topics
where t.TopicId == TopicId
select t;
foreach (var topic in _topics)
{
context.Topics.Remove(topic);
}
try
{
context.SaveChanges();
}
catch (Exception e)
{
return("An error occured while deleting the topic");
}
}
return("Title deleted successfully");
}
// GET api/Title/5
public List <Models.Topic> Get(int CategoryId)
{
var topics = new List <Models.Topic>();
using (var context = new FORUMEntities3())
{
if (context.Topics.Count() > 0)
{
var xx = (from em in context.Topics
where em.CategoryId == CategoryId
select new { em.TopicId, em.Title, em.Description, em.Comments, em.Created }).ToList();
foreach (var Topic in xx)
{
var topic = new Models.Topic();
topic.CategoryId = CategoryId;
topic.TopicId = Topic.TopicId;
topic.TitleName = Topic.Title;
topic.Description = Topic.Description;
topic.CommentCount = Topic.Comments.Count();
topic.CreatedDate = Topic.Created;
topics.Add(topic);
}
}
}
return(topics);
}
public string Put(Models.Topic topic)
{
using (FORUMEntities3 context = new FORUMEntities3())
{
var _topic = context.Topics.Single(t => t.TopicId == topic.TopicId);
_topic.Title = topic.TitleName;
_topic.Description = topic.Description;
_topic.CategoryId = topic.CategoryId;
context.SaveChanges();
}
return("Title updated successfully");
}
// POST api/values
public string Post(Models.Category category)
{
using (FORUMEntities3 context = new FORUMEntities3())
{
var cat = new AngularWebApi.Category();
cat.CategoryId = category.CategoryId;
cat.CategoryName = category.CategoryName;
cat.Description = category.Description;
context.Categories.Add(cat);
context.SaveChanges();
}
return("Category added successfully");
}
public string Post(Models.Topic topic)
{
using (FORUMEntities3 context = new FORUMEntities3())
{
var _topic = new AngularWebApi.Topic();
_topic.CategoryId = topic.CategoryId;
_topic.Title = topic.TitleName;
_topic.Description = topic.Description;
_topic.Created = DateTime.Now;
context.Topics.Add(_topic);
context.SaveChanges();
}
return("Title added successfully");
}
public Models.Topic GetTopic(int TitleId)
{
var topics = new Models.Topic();
using (var context = new FORUMEntities3())
{
if (context.Topics.Count() > 0)
{
var xx = (from em in context.Topics
where em.TopicId == TitleId
select new { em.TopicId, em.Title, em.Description, em.Comments, em.CategoryId }).ToList();
foreach (var Topic in xx)
{
topics.CategoryId = Topic.CategoryId;
topics.TopicId = Topic.TopicId;
topics.TitleName = Topic.Title;
topics.Description = Topic.Description;
}
}
}
return(topics);
}
// GET api/values
public List <Models.Category> Get()
{
var categories = new List <Models.Category>();
using (var context = new FORUMEntities3())
{
if (context.Categories.Count() > 0)
{
var xx = (from em in context.Categories
select new { em.CategoryId, em.CategoryName, em.Description, em.Topics }).ToList();
foreach (var category in xx)
{
var cat = new Models.Category();
cat.CategoryId = category.CategoryId;
cat.CategoryName = category.CategoryName;
cat.Description = category.Description;
cat.TopicsCount = category.Topics.Count();
categories.Add(cat);
}
}
}
return(categories);
}
