/// <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); }
/// <summary> /// /// </summary> /// <param name="dr"></param> /// <returns></returns> public static AjaxAAFComment[] PopulateAjaxComment(IDataReader dr) { List <AjaxAAFComment> commentArr = new List <AjaxAAFComment>(); AjaxAAFComment ajaxComment; while (dr.Read()) { ajaxComment = new AjaxAAFComment(); ajaxComment.WebCommentID = (string)dr["WebCommentID"]; ajaxComment.WebMemberID = (string)dr["WebMemberID"]; ajaxComment.NickName = (string)dr["NickName"]; ajaxComment.PhotoUrl = "user/" + (string)dr["PhotoUrl"]; ajaxComment.Text = (string)dr["Text"]; ajaxComment.DateTimePosted = TimeDistance.TimeAgo((DateTime)dr["DTCreated"]); ajaxComment.DTCreated = (DateTime)dr["DTCreated"]; commentArr.Add(ajaxComment); } return(commentArr.ToArray()); }