/// <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);
}
