public FeedComment GetFeedComment(long commentId)
{
var list = dbManager
.ExecuteList(GetFeedCommentQuery(Exp.Eq("Id", commentId)))
.ConvertAll(r => Mappers.ToFeedComment(r));
return(0 < list.Count ? list[0] : null);
}
public List <FeedComment> GetCommentsByDate(DateTime from, DateTime to)
{
var query = new SqlQuery("events_comment")
.SelectAll()
.Where(Exp.Between("Date", from, to) & Exp.Eq("Tenant", tenant))
.OrderBy("Date", true);
return(dbManager.ExecuteList(query).Select(x => Mappers.ToFeedComment(x)).ToList());
}
public List <FeedComment> GetFeedComments(long feedId)
{
return(dbManager
.ExecuteList(GetFeedCommentQuery(Exp.Eq("Feed", feedId)))
.ConvertAll(r => Mappers.ToFeedComment(r)));
}