/// <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()); }
public DashboardItem PopulateDashboardItem(DashboardItem DashboardItem, IDataReader dr) { // the Datareader will return the results in the following order //-- 1. Favourites this week //-- 2. Latest Photo Galleries //-- 3. New Friend Requests //-- 4. Pending friend reguests //-- 5. new Friends //-- 6. Profile updates //-- 7. inbox //-- 8. Lowdown entry //-- 9. video Comments //-- 10. photo Comments //-- 11. Proximity Tags //-- 12. Live mobile broadcasts //-- 13. New Blog entry //-- 14. Private AAF Question //-- 15. My AAF Questions //-- 2. Latest Photo Galleries if (DashboardItem.DashboardField == DashboardField.NewFriendPhotoGallery) { bool Empty = true; while (dr.Read()) { DashboardItem.HTML += "<li><a href='ViewGallery.aspx?g=" + (string)dr["WebPhotoCollectionID"] + "'>" + (string)dr["Name"] + "-" + TimeDistance.ShortDateTime((DateTime)dr["DTCreated"]) + "<img style='width:51px;height:51px' src='" + ParallelServer.Get() + "user/" + (string)dr["PhotoURL"] + "'></a></li>"; Empty = false; } if (Empty) { DashboardItem.HTML += "<li>No new Galleries</li>"; } } //-- 3. New Friend Requests if (DashboardItem.DashboardField == DashboardField.FriendRequest) { bool Empty = true; while (dr.Read()) { DashboardItem.HTML += "<li><a href='Friendrequest.aspx'>" + (string)dr["FriendMemberNickName"] + " - <img style='width:51px;height:51px' src='" + ParallelServer.Get() + "user/" + (string)dr["photoURL"] + "'></a></li>"; Empty = false; } if (Empty) { DashboardItem.HTML += "<li>No new Friend requests</li>"; } } //-- 4. Pending friend reguests if (DashboardItem.DashboardField == DashboardField.FriendRequestOutstanding) { bool Empty = true; while (dr.Read()) { DashboardItem.HTML += "<li><a href=''>" + (string)dr["FriendMemberNickname"] + "!</a> - View</li>"; Empty = false; } if (Empty) { DashboardItem.HTML += "<li>No pending Friend requests</li>"; } } //-- 6. Profile updates if (DashboardItem.DashboardField == DashboardField.FriendProfileUpdate) { bool Empty = true; while (dr.Read()) { DashboardItem.HTML += "<li><a href='view.aspx?m=" + (string)dr["WebMemberID"] + "'>" + (string)dr["Nickname"] + "</a> </li>"; Empty = false; } if (Empty) { DashboardItem.HTML += "<li>No updated profiles</li>"; } } //-- 7. inbox if (DashboardItem.DashboardField == DashboardField.Inbox) { bool Empty = true; while (dr.Read()) { DashboardItem.HTML += "<li><img src='images/email.gif'> <a href=''>" + (string)dr["Nickname"] + " - " + TimeDistance.ShortDateTime((DateTime)dr["DTCreated"]) + "</a> </li>"; Empty = false; } if (Empty) { DashboardItem.HTML += "<li>No new messages</li>"; } } //-- 9. video Comments if (DashboardItem.DashboardField == DashboardField.VideoComment) { bool Empty = true; int count = 0; while (dr.Read()) { if (count != 10) { DashboardItem.HTML += "<li><a href='view?v=" + (string)dr["WebVideoID"] + "'>" + Trim((string)dr["Title"], 15) + " - " + (string)dr["NickName"] + "</a></li>"; Empty = false; count++; } else { break; } } if (Empty) { DashboardItem.HTML += "<li>No video comments</li>"; } } //-- 10. photo Comments if (DashboardItem.DashboardField == DashboardField.PhotoComment) { bool Empty = true; while (dr.Read()) { DashboardItem.HTML += "<li><a href=''>" + (string)dr["Name"] + "!</a> - <a href=''>" + (string)dr["NickName"] + "!</a></li>"; Empty = false; } if (Empty) { DashboardItem.HTML += "<li>No photo comments</li>"; } } //-- 12. Live mobile broadcasts if (DashboardItem.DashboardField == DashboardField.LiveMobileBroadcasts) { bool Empty = true; while (dr.Read()) { DashboardItem.HTML += "<li><a href='view?v=" + (string)dr["WebVideoID"] + "'>" + Trim((string)dr["Title"], 10) + "</a> - " + (string)dr["NickName"] + " " + TimeDistance.ShortDateTime((DateTime)dr["DTCreated"]) + "</li>"; Empty = false; } if (Empty) { DashboardItem.HTML += "<li>No new Videos</li>"; } } //-- 15. My AAF Questions if (DashboardItem.DashboardField == DashboardField.MyAskAFriendQuestions) { bool Empty = true; while (dr.Read()) { DashboardItem.HTML += "<li><a href='AskAFriend.aspx?q=" + (string)dr["WebAskAFriendID"] + "'>" + Trim((string)dr["Question"], 15) + "</a> - " + TimeDistance.ShortDateTime((DateTime)dr["WentLiveDT"]) + "</li>"; Empty = false; } if (Empty) { DashboardItem.HTML += "<li>No have not posted any Questions</li>"; } else { DashboardItem.HTML = "<a href='AAFUpload.aspx'>Ask A Question Now</a><br/><a href='AskAFriend.aspx'>Answer Questions</a><br/><br/><a href='MyAskAFriend.aspx'><strong>My Questions</strong></a><br/>" + DashboardItem.HTML; DashboardItem.HTML += "<br/><strong>New Questions</strong><br/>"; } } return(DashboardItem); }