public static List <CoTopicVM> RetrieveTopic(string topicid)
{
var ret = new List <CoTopicVM>();
var sql = "select topicid,subject,creator,status,createdate,topiccontent from CoTopicVM where topicid = '<topicid>'";
sql = sql.Replace("<topicid>", topicid);
var dbret = DBUtility.ExeLocalSqlWithRes(sql);
foreach (var line in dbret)
{
var imgresize = SeverHtmlDecode.ResizeImageFromHtml(Convert.ToString(line[5]));
var tempvm = new CoTopicVM(Convert.ToString(line[0]), Convert.ToString(line[1]), imgresize, Convert.ToString(line[2])
, Convert.ToString(line[3]), Convert.ToDateTime(line[4]).ToString("yyyy-MM-dd HH:mm:ss"));
tempvm.eventtimelist = RetrieveTopicDueDate(tempvm.topicid);
tempvm.ProjectWorkingList = TopicProject.RetrieveTopicPJ(tempvm.topicid, TopicPJStatus.Working);
tempvm.ProjectDoneList = TopicProject.RetrieveTopicPJ(tempvm.topicid, TopicPJStatus.Done);
tempvm.CommentList = TopicCommentVM.RetrieveComment(tempvm.topicid);
ret.Add(tempvm);
}
return(ret);
}
public static List <TopicCommentVM> RetrieveComment(string tid, string cid)
{
var ret = new List <TopicCommentVM>();
var sql = "select topicid,commentid,commentcontent,creator,commentdate from TopicCommentVM where topicid = '<topicid>' and commentid = '<commentid>'";
sql = sql.Replace("<topicid>", tid).Replace("<commentid>", cid);
var dbret = DBUtility.ExeLocalSqlWithRes(sql);
foreach (var line in dbret)
{
var imgresize = SeverHtmlDecode.ResizeImageFromHtml(Convert.ToString(line[2]));
ret.Add(new TopicCommentVM(Convert.ToString(line[0]), Convert.ToString(line[1])
, imgresize, Convert.ToString(line[3]), Convert.ToDateTime(line[4]).ToString("yyyy-MM-dd HH:mm:ss")));
}
return(ret);
}