public List<Associate.Discussion> GetTopics(int CategoryID, int groupID)
{
try
{
using (AssociateConnDataContext asso = new AssociateConnDataContext())
{
var discussions = (from d in asso.Get_Topics(CategoryID, groupID)
orderby d.PostDateTime descending
where d.IsParent == true
select new Associate.Discussion
{
TopicDesc = d.TopicDesc,
TopicHeader = d.topicheader,
TopicID = d.TopicID,
PostDateTime = d.PostDateTime,
IsParent = d.IsParent,
CreatedBy = d.CreatedBy,
CreatedByname=d.FirstName + " " + d.LastName ,
CommentCount = d.CommentCount,
Category = new Category { CategoryID = d.CategoryID, IsActive = d.IsActive, CategoryDesc = d.CategoryDesc },
Group = new Group { GroupID = d.GroupID, GroupDesc = d.GroupDesc },
});
List<Associate.Discussion> diss = new List<Associate.Discussion>(discussions);
return diss;
}
}
catch (Exception ex)
{
throw ex;
}
}
