public string TagNotifications() { string notification = ""; NewsfeedDAL newsFeedDAL = new NewsfeedDAL(); NotificationDAL notificationDAL = new NotificationDAL(); List <Notification> NotificationsList = new List <Notification>(); NotificationsList = notificationDAL.GetTagNotificationsForAMember(aMember); for (int i = 0; i < NotificationsList.Count; ++i) { #region TagRating //memberlist List <Member> MemberList = new List <Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); string FriendDisplayName = MemberList[0].DisplayName; //memberslist List <Member> PostOwnerMemberList = new List <Member>(); Post aPost = new Post(NotificationsList[i].PostId); PostOwnerMemberList = notificationDAL.GetPostOwner(aPost); List <Post> PostList = new List <Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); string memberLoggedOn = aMember.MemberId; if (memberLoggedOn == PostOwnerMemberList[0].MemberId) { notification += FriendDisplayName + " tagged you on your post which you posted " + FormatDateTime(PostList[0].CreateDate) + " \n\n"; } else if (FriendDisplayName == PostOwnerMemberList[0].DisplayName) { notification += "You were tagged on " + PostOwnerMemberList[0].DisplayName + "'s post by " + FriendDisplayName + " " + FormatDateTime(PostList[0].CreateDate) + "\n\n"; } else { notification += FriendDisplayName + " tagged you on " + PostOwnerMemberList[0].DisplayName + "'s post which was posted " + FormatDateTime(PostList[0].CreateDate) + " \n\n"; } #endregion } return(notification); }
public string CommentRatingNotifications() { string notification = ""; NewsfeedDAL newsFeedDAL = new NewsfeedDAL(); NotificationDAL notificationDAL = new NotificationDAL(); List <Notification> NotificationsList = new List <Notification>(); NotificationsList = notificationDAL.GetCommentRatingNotificationsForAMember(aMember); for (int i = 0; i < NotificationsList.Count; ++i) { #region CommentRating //memberlist List <Member> MemberList = new List <Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); string FriendDisplayName = MemberList[0].DisplayName; List <Comments> CommentList = new List <Comments>(); Comments aComment = new Comments(NotificationsList[i].CommentId); CommentList = notificationDAL.GetCommentTextAndCreateDate(aComment); //memberslist MemberList = new List <Member>(); Post aPost = new Post(CommentList[0].PostId); MemberList = notificationDAL.GetPostOwner(aPost); string postDisplayText = ""; if (CommentList[0].CommentText.Length > 30) { postDisplayText = CommentList[0].CommentText.Substring(0, 30) + "..."; } else { postDisplayText = CommentList[0].CommentText; } notification += FriendDisplayName + " liked your comment '" + postDisplayText + "' which you posted " + FormatDateTime(CommentList[0].CreateDate) + " on " + MemberList[0].DisplayName + " post\n\n"; #endregion } return(notification); }
public void LikeAPost(string sessionMemberID, int postID) { NotificationDAL notificationDAL = new NotificationDAL(); RateAndTagDAL dal = new RateAndTagDAL(); Post aPost = new Post(postID); List <Member> MemberList = new List <Member>(); MemberList = notificationDAL.GetPostOwner(aPost); Member aFriend = new Member(MemberList[0].MemberId); string memberId = sessionMemberID; Member aMember = new Member(memberId); //Check if like exists if (dal.PostRatingExists(aMember, aPost) == 0) { dal.RatePost(aMember, aPost); List <Rating> RatingList = new List <Rating>(); RatingList = notificationDAL.GetPostRatingID(aPost, aMember); Rating aRating = new Rating(RatingList[0].RatingId); if (RatingList.Count > 0) { notificationDAL.InsertPostRatingNotification(aRating, aMember, aFriend, aPost); } } else { //MessageBox.Show("already rated by u"); } aPost.PostId = postID; int numberofPostLikes = newsFeedDAL.CountPostLikes(aPost); //Updating all Clients Clients.updatePostLikeCount(numberofPostLikes, postID); }
public string TagNotifications() { string notification = ""; NewsfeedDAL newsFeedDAL = new NewsfeedDAL(); NotificationDAL notificationDAL = new NotificationDAL(); List<Notification> NotificationsList = new List<Notification>(); NotificationsList = notificationDAL.GetTagNotificationsForAMember(aMember); for (int i = 0; i < NotificationsList.Count; ++i) { #region TagRating //memberlist List<Member> MemberList = new List<Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); string FriendDisplayName = MemberList[0].DisplayName; //memberslist List<Member> PostOwnerMemberList = new List<Member>(); Post aPost = new Post(NotificationsList[i].PostId); PostOwnerMemberList = notificationDAL.GetPostOwner(aPost); List<Post> PostList = new List<Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); string memberLoggedOn = aMember.MemberId; if (memberLoggedOn == PostOwnerMemberList[0].MemberId) { notification += FriendDisplayName + " tagged you on your post which you posted " + FormatDateTime(PostList[0].CreateDate) + " \n\n"; } else if (FriendDisplayName == PostOwnerMemberList[0].DisplayName) { notification += "You were tagged on " + PostOwnerMemberList[0].DisplayName + "'s post by " + FriendDisplayName + " " + FormatDateTime(PostList[0].CreateDate) + "\n\n"; } else { notification += FriendDisplayName + " tagged you on " + PostOwnerMemberList[0].DisplayName + "'s post which was posted " + FormatDateTime(PostList[0].CreateDate) + " \n\n"; } #endregion } return notification; }
public string CommentNotifications() { string notification = ""; NewsfeedDAL newsFeedDAL = new NewsfeedDAL(); NotificationDAL notificationDAL = new NotificationDAL(); List<Notification> NotificationsList = new List<Notification>(); NotificationsList = notificationDAL.GetCommentedOnPostNotification(aMember); for (int i = 0; i < NotificationsList.Count; ++i) { #region Comment notification //memberlist List<Member> MemberList = new List<Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); string FriendDisplayName = MemberList[0].DisplayName; //memberslist MemberList = new List<Member>(); Post aPost = new Post(NotificationsList[i].PostId); MemberList = notificationDAL.GetPostOwner(aPost); List<Post> PostList = new List<Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); List<Post> PostTypeList = new List<Post>(); PostTypeList = notificationDAL.GetPostType(aPost); string postType = ""; if (PostTypeList[0].PostType == "Event") { postType = "event"; } else if (PostTypeList[0].PostType == "Text") { postType = "post"; } else if (PostTypeList[0].PostType == "Photo") { postType = "photo"; } else if (PostTypeList[0].PostType == "Article") { postType = "article"; } else if (PostTypeList[0].PostType == "Video") { postType = "video"; } else if (PostTypeList[0].PostType == "File") { postType = "file post"; } notification += FriendDisplayName + " commented on your " + postType + " which you posted " + FormatDateTime(PostList[0].CreateDate) + " \n\n"; #endregion } return notification; }
public string CommentRatingNotifications() { string notification = ""; NewsfeedDAL newsFeedDAL = new NewsfeedDAL(); NotificationDAL notificationDAL = new NotificationDAL(); List<Notification> NotificationsList = new List<Notification>(); NotificationsList = notificationDAL.GetCommentRatingNotificationsForAMember(aMember); for (int i = 0; i < NotificationsList.Count; ++i) { #region CommentRating //memberlist List<Member> MemberList = new List<Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); string FriendDisplayName = MemberList[0].DisplayName; List<Comments> CommentList = new List<Comments>(); Comments aComment = new Comments(NotificationsList[i].CommentId); CommentList = notificationDAL.GetCommentTextAndCreateDate(aComment); //memberslist MemberList = new List<Member>(); Post aPost = new Post(CommentList[0].PostId); MemberList = notificationDAL.GetPostOwner(aPost); string postDisplayText = ""; if (CommentList[0].CommentText.Length > 30) { postDisplayText = CommentList[0].CommentText.Substring(0, 30) + "..."; } else { postDisplayText = CommentList[0].CommentText; } notification += FriendDisplayName + " liked your comment '" + postDisplayText + "' which you posted " + FormatDateTime(CommentList[0].CreateDate) + " on " + MemberList[0].DisplayName + " post\n\n"; #endregion } return notification; }
public void LikeAPost( string sessionMemberID, int postID) { NotificationDAL notificationDAL = new NotificationDAL(); RateAndTagDAL dal = new RateAndTagDAL(); Post aPost = new Post(postID); List<Member> MemberList = new List<Member>(); MemberList = notificationDAL.GetPostOwner(aPost); Member aFriend = new Member(MemberList[0].MemberId); string memberId = sessionMemberID; Member aMember = new Member(memberId); //Check if like exists if (dal.PostRatingExists(aMember, aPost) == 0) { dal.RatePost(aMember, aPost); List<Rating> RatingList = new List<Rating>(); RatingList = notificationDAL.GetPostRatingID(aPost, aMember); Rating aRating = new Rating(RatingList[0].RatingId); if (RatingList.Count > 0) { notificationDAL.InsertPostRatingNotification(aRating, aMember, aFriend, aPost); } } else { //MessageBox.Show("already rated by u"); } aPost.PostId = postID; int numberofPostLikes = newsFeedDAL.CountPostLikes(aPost); //Updating all Clients Clients.updatePostLikeCount(numberofPostLikes, postID); }
public string CommentNotifications() { string notification = ""; NewsfeedDAL newsFeedDAL = new NewsfeedDAL(); NotificationDAL notificationDAL = new NotificationDAL(); List <Notification> NotificationsList = new List <Notification>(); NotificationsList = notificationDAL.GetCommentedOnPostNotification(aMember); for (int i = 0; i < NotificationsList.Count; ++i) { #region Comment notification //memberlist List <Member> MemberList = new List <Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); string FriendDisplayName = MemberList[0].DisplayName; //memberslist MemberList = new List <Member>(); Post aPost = new Post(NotificationsList[i].PostId); MemberList = notificationDAL.GetPostOwner(aPost); List <Post> PostList = new List <Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); List <Post> PostTypeList = new List <Post>(); PostTypeList = notificationDAL.GetPostType(aPost); string postType = ""; if (PostTypeList[0].PostType == "Event") { postType = "event"; } else if (PostTypeList[0].PostType == "Text") { postType = "post"; } else if (PostTypeList[0].PostType == "Photo") { postType = "photo"; } else if (PostTypeList[0].PostType == "Article") { postType = "article"; } else if (PostTypeList[0].PostType == "Video") { postType = "video"; } else if (PostTypeList[0].PostType == "File") { postType = "file post"; } notification += FriendDisplayName + " commented on your " + postType + " which you posted " + FormatDateTime(PostList[0].CreateDate) + " \n\n"; #endregion } return(notification); }