/// <summary> /// render the HTML comments /// </summary> public string GenarateComments(AskAFriend askAFriend) { AjaxAAFComment[] commentList = AjaxAAFComment.GetAAFCommentsByAskAFriendIDWithJoin(askAFriend.AskAFriendID); StringBuilder sbComments = new StringBuilder(); for (int i = 0; i < 10; i++) { if (commentList.Length <= i) { break; } sbComments.Append(commentList[i].ToHTML()); } return(sbComments.ToString()); }
/// <summary> /// gets all the comments for an AskAFriend Question since the last request /// </summary> /// <param name="MemberCommentID"></param> /// <returns></returns> public static AjaxAAFComment[] GetAAFCommentsByWebAskAFriendSinceLastIDWithJoin(string WebAskAFriendID, string LastWebAskAFriendCommentID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetAAFCommentsByWebAskAFriendSinceLastIDWithJoin"); db.AddInParameter(dbCommand, "WebAskAFriendID", DbType.String, WebAskAFriendID); db.AddInParameter(dbCommand, "LastWebAskAFriendCommentID", DbType.String, LastWebAskAFriendCommentID); //execute the stored procedure AjaxAAFComment[] AskAFriendComments = new AjaxAAFComment[0]; using (IDataReader dr = db.ExecuteReader(dbCommand)) { AskAFriendComments = AjaxAAFComment.PopulateAjaxComment(dr); dr.Close(); } return AskAFriendComments; }