/// <summary> /// Gets all the PhotoComment in the database /// </summary> public static List <AjaxComment> GetPhotoCommentsByGalleryID(int PhotoCollectionID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetPhotoCommentsByGalleryID"); db.AddInParameter(dbCommand, "PhotoCollectionID", DbType.Int32, PhotoCollectionID); List <AjaxComment> commentArr = new List <AjaxComment>(); //execute the stored procedure using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { AjaxComment ajaxComment = new AjaxComment(); ajaxComment.WebMemberID = (string)dr["WebMemberID"]; ajaxComment.WebPhotoID = (string)dr["WebPhotoID"]; ajaxComment.NickName = (string)dr["NickName"]; ajaxComment.PhotoUrl = ParallelServer.Get((string)dr["PhotoUrl"]) + "user/" + (string)dr["PhotoUrl"]; ajaxComment.Text = (string)dr["Text"]; ajaxComment.DateTimePosted = TimeDistance.TimeAgo((DateTime)dr["DTCreated"]); commentArr.Add(ajaxComment); } dr.Close(); } // Create the object array from the datareader return(commentArr); }
/// <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()); }
/// <summary> /// /// </summary> /// <param name="dr"></param> /// <returns></returns> public static AjaxComment[] PopulateAjaxComment(IDataReader dr) { List <AjaxComment> commentArr = new List <AjaxComment>(); AjaxComment ajaxComment; ColumnFieldList list = new ColumnFieldList(dr); while (dr.Read()) { ajaxComment = new AjaxComment(); ajaxComment.WebMemberID = (string)dr["WebMemberID"]; ajaxComment.NickName = (string)dr["NickName"]; ajaxComment.PhotoUrl = ParallelServer.Get((string)dr["PhotoUrl"]) + "user/" + (string)dr["PhotoUrl"]; ajaxComment.Text = (string)dr["Text"]; ajaxComment.SentFromMobile = ((int)dr["SentFromMobile"]) == 1 ? true : false; ajaxComment.DateTimePosted = TimeDistance.TimeAgo((DateTime)dr["DTCreated"]); ajaxComment.DTCreated = (DateTime)dr["DTCreated"]; if (list.IsColumnPresent("WebCommentID")) { ajaxComment.WebCommentID = (string)dr["WebCommentID"]; } if (list.IsColumnPresent("Path")) { ajaxComment.Path = (string)dr["Path"]; ajaxComment.Depth = GetDepth(ajaxComment.Path); } if (list.IsColumnPresent("IsDeleted")) { ajaxComment.IsDeleted = (bool)dr["IsDeleted"]; } commentArr.Add(ajaxComment); } return(commentArr.ToArray()); }