public bool UnblockAccount(Administrator administrator, Member member, string reasonUnblocked) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspUnblockAccount", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AdministratorID", administrator.AdministratorId); cmd.Parameters.AddWithValue("@MemberID", member.MemberId); cmd.Parameters.AddWithValue("@ReasonUnblocked", reasonUnblocked); try { con.Open(); int x = cmd.ExecuteNonQuery(); return true; } catch (Exception e) { MessageBox.Show(e.Message.ToString()); return false; } } }
public bool AddMessage(Messages message, Member member, Member friend) { using (SqlConnection con = new SqlConnection(ConnectionString)) { int x = 0; SqlCommand cmd = new SqlCommand("AddMessage", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MemberID", member.MemberId); cmd.Parameters.AddWithValue("@FriendID", friend.MemberId); cmd.Parameters.AddWithValue("@MessageText", message.MessageText); try { con.Open(); x = cmd.ExecuteNonQuery(); } catch (Exception e) { e.ToString(); } if (x < 0) { return true; } else { return false; } } }
public Member GetActualDisplayName(Member member) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspGetActualDisplayName", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MemberID", member.MemberId)); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { member.DisplayName = reader["DisplayName"].ToString(); }//End while reader.Close(); } catch (Exception e) { System.Windows.Forms.MessageBox.Show(e.Message.ToString()); } return member; } }
public List<Notification> GetCommentedOnPostNotification(Member member) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspGetCommentedOnPostNotification", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MemberID", member.MemberId); List<Notification> NotificationsList = new List<Notification>(); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Notification aNotification = new Notification(int.Parse(reader["NotificationID"].ToString()), reader["MemberID"].ToString(), int.Parse(reader["PostID"].ToString()), reader["NotificationType"].ToString()); NotificationsList.Add(aNotification); }//End while reader.Close(); } catch (Exception e) { System.Windows.Forms.MessageBox.Show(e.Message.ToString()); } return NotificationsList; } }
public void ProcessRequest(HttpContext Context) { if (Context.Session["profileFriendID"] != null) { string memberId = Context.Request.QueryString["id"]; //get the querystring value that was pass on the ImageURL (see GridView MarkUp in Page1.aspx) memberId = SSTCryptographer.Encrypt(memberId); Member aMember = new Member(memberId); if (memberId != null) { MemberInfoDAL dal = new MemberInfoDAL(); aMember = dal.GetAllMemberInfo(aMember); MemoryStream ms = new MemoryStream(); aMember.ProfilePicture.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] file = ms.ToArray(); ms.Write(file, 0, file.Length); Context.Response.Buffer = true; Context.Response.BinaryWrite(file); ms.Dispose(); } Context.Session["profileFriendID"] = Context.Session["memberID"].ToString(); } else { string memberId = Context.Request.QueryString["id"]; //get the querystring value that was pass on the ImageURL (see GridView MarkUp in Page1.aspx) memberId = SSTCryptographer.Encrypt(memberId); Member aMember = new Member(memberId); if (memberId != null) { MemberInfoDAL dal = new MemberInfoDAL(); aMember = dal.GetAllMemberInfo(aMember); MemoryStream ms = new MemoryStream(); aMember.ProfilePicture.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] file = ms.ToArray(); ms.Write(file, 0, file.Length); Context.Response.Buffer = true; Context.Response.BinaryWrite(file); ms.Dispose(); } } }
public Member GetAllMemberInfo(Member member) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspGetAllMemberInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MemberID", member.MemberId); // List<Member> memberList = new List<Member>(); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { byte[] imageBytes = reader["ProfilePicture"] as byte[]; MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length); // Convert byte[] to Image ms.Write(imageBytes, 0, imageBytes.Length); Image image = Image.FromStream(ms, true); member.FirstName = Convert.ToString(reader["FirstName"]); member.LastName = Convert.ToString(reader["LastName"]); member.DisplayName = Convert.ToString(reader["DisplayName"]); member.Email = Convert.ToString(reader["Email"]); member.RegistrationDate = Convert.ToDateTime(reader["RegistrationDate"]); member.Description = Convert.ToString(reader["Description"]); member.Campus = Convert.ToString(reader["Campus"]); member.MemberType = Convert.ToString(reader["MemberType"]); member.IsOnline = Convert.ToBoolean(reader["isOnline"]); member.ProfilePicture = image; //memberList.Add(memberInfo); }//End while reader.Close(); } catch (Exception e) { MessageBox.Show(e.Message.ToString()); } return member; } }
public bool BlockMember(Member member, Member friend) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspBlockMember", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MemberID", member.MemberId); cmd.Parameters.AddWithValue("@FriendID", friend.MemberId); try { con.Open(); int x = cmd.ExecuteNonQuery(); return true; } catch (Exception e) { MessageBox.Show(e.Message.ToString()); return false; } } }
public int InsertChatText(Group group, string ChatText, Member member) { using (SqlConnection dbcon = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspInsertChatText", dbcon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@GroupID", group.GroupId)); cmd.Parameters.Add(new SqlParameter("@MemberID", member.MemberId)); cmd.Parameters.Add(new SqlParameter("@ChatText", ChatText)); SqlParameter returnValue = new SqlParameter("@Return_Value", DbType.Int32); returnValue.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(returnValue); int postId = 0; try { dbcon.Open(); cmd.ExecuteNonQuery(); postId = Int32.Parse(cmd.Parameters["@Return_Value"].Value.ToString()); } catch (SqlException e) { MessageBox.Show(e.ToString()); } return postId; } }
private void OpenWrapper(int i) { #region OPENING WRAPPER aPost = (Post)ArrayPosts[i]; ArrayMembers = bl.GetMemberDisplayName(aPost.MemberId); countMembers = ArrayMembers.Count; for (int a = 0; a < countMembers; ++a) { aMember = (Member)ArrayMembers[a]; NotificationDAL notificationDAL = new NotificationDAL(); Group group = new Group(aPost.GroupId); string groupDescription = notificationDAL.GetGroupDescription2(group); concatinater.Append("<div class='aPost typeOfText' id='"); concatinater.Append(aPost.PostId); concatinater.Append("'><div class='msgeHeading ui-corner-all' ><h2 class='ui-corner-all'> Posted by: <a href='#' id='"); concatinater.Append(aPost.MemberId); concatinater.Append("' class='btnMemberProfile' style='font-weight:normal; '>"); concatinater.Append(aMember.DisplayName); bool isForMember = false; string date = ""; date = reusable_Methods.FormatDateTime(aPost.CreateDate); if (aPost.MemberId == memberID) { isForMember = true; } if (GroupID == aPost.GroupId) { } else { concatinater.Append("</a> <span class='space'></span> in group: <a id='"); concatinater.Append(aPost.GroupId); concatinater.Append("' class='btnGoToGroupPage groupDesc'>"); concatinater.Append(groupDescription); } concatinater.Append("</a>"); if (isForMember) { concatinater.Append("<span class='ui-icon ui-icon-closethick floatright deletePost pointer ' title ='Delete this post' style='display:none;'></span>"); } concatinater.Append("<span class='DateWithTime ui-corner-all floatright'>"); concatinater.Append(date); //concatinater.Append(Convert.ToDateTime(aPost.CreateDate).ToString("D")); concatinater.Append("</span></h2></div> <div class='postContentArea'> <div> "); } #endregion }
public ArrayList GetMemberDisplayName(string MemberId) { ArrayList custArray; using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspGetMemberDisplayName", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MemberID", MemberId)); con.Open(); SqlDataReader dbReader = cmd.ExecuteReader(); custArray = new ArrayList(); while (dbReader.Read()) { Member aCountry = new Member(dbReader["DisplayName"].ToString(), 0); custArray.Add(aCountry); } con.Close(); } return custArray; }
public string PostRatingNotifications() { string notification = ""; NewsfeedDAL newsFeedDAL = new NewsfeedDAL(); NotificationDAL notificationDAL = new NotificationDAL(); List<Notification> NotificationsList = new List<Notification>(); NotificationsList = notificationDAL.GetPostRatingNotificationsForAMember(aMember); ArrayList ArrayPosts; for (int i = 0; i < NotificationsList.Count; ++i) { #region PostRating List<Member> MemberList = new List<Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); List<Post> PostList = new List<Post>(); Post aPost = new Post(NotificationsList[i].PostId); PostList = notificationDAL.GetPostType(aPost); if (PostList[0].PostType == "Event") { aPost = new Post(NotificationsList[i].PostId, PostList[0].PostType); ArrayPosts = notificationDAL.GetPostCaption(aPost); Event_Post aEvent_Post; aEvent_Post = (Event_Post)ArrayPosts[i]; PostList = new List<Post>(); aPost = new Post(NotificationsList[i].PostId); PostList = new List<Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); string postDisplayText = ""; if (aEvent_Post.EventName.Length > 30) { postDisplayText = aEvent_Post.EventName.Substring(0, 30) + "..."; } else { postDisplayText = aEvent_Post.EventName; } notification += MemberList[0].DisplayName + " liked your event '" + postDisplayText + "' which you posted " + FormatDateTime(PostList[0].CreateDate) + "\n\n"; } else if (PostList[0].PostType == "Text") { aPost = new Post(NotificationsList[i].PostId, PostList[0].PostType); ArrayPosts = notificationDAL.GetPostCaption(aPost); Text_Post aText_Post; aText_Post = (Text_Post)ArrayPosts[0]; PostList = new List<Post>(); aPost = new Post(NotificationsList[i].PostId); PostList = new List<Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); string postDisplayText = ""; if (aText_Post.PostText.Length > 30) { postDisplayText = aText_Post.PostText.Substring(0, 30) + "..."; } else { postDisplayText = aText_Post.PostText; } notification += MemberList[0].DisplayName + " liked your post '" + postDisplayText + "' which you posted " + FormatDateTime(PostList[0].CreateDate) + "\n\n"; } else if (PostList[0].PostType == "Photo") { aPost = new Post(NotificationsList[i].PostId, PostList[0].PostType); ArrayPosts = notificationDAL.GetPostCaption(aPost); Photo_Post aPhoto_Post; aPhoto_Post = (Photo_Post)ArrayPosts[0]; PostList = new List<Post>(); aPost = new Post(NotificationsList[i].PostId); PostList = new List<Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); string postDisplayText = ""; if (aPhoto_Post.PhotoCaption.Length > 30) { postDisplayText = aPhoto_Post.PhotoCaption.Substring(0, 30) + "..."; } else { postDisplayText = aPhoto_Post.PhotoCaption; } notification += MemberList[0].DisplayName + " liked your photo '" + postDisplayText + "' which you posted " + FormatDateTime(PostList[0].CreateDate) + "\n\n"; } else if (PostList[0].PostType == "Article") { aPost = new Post(NotificationsList[i].PostId, PostList[0].PostType); ArrayPosts = notificationDAL.GetPostCaption(aPost); Article_Post aArticle_Post; aArticle_Post = (Article_Post)ArrayPosts[0]; PostList = new List<Post>(); aPost = new Post(NotificationsList[i].PostId); PostList = new List<Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); string postDisplayText = ""; if (aArticle_Post.Title.Length > 30) { postDisplayText = aArticle_Post.Title.Substring(0, 30) + "..."; } else { postDisplayText = aArticle_Post.Title; } notification += MemberList[0].DisplayName + " liked your article '" + postDisplayText + "' which you posted " + FormatDateTime(PostList[0].CreateDate) + "\n\n"; } else if (PostList[0].PostType == "Video") { aPost = new Post(NotificationsList[i].PostId, PostList[0].PostType); ArrayPosts = notificationDAL.GetPostCaption(aPost); Video_Post aVideo_Post; aVideo_Post = (Video_Post)ArrayPosts[0]; PostList = new List<Post>(); aPost = new Post(NotificationsList[i].PostId); PostList = new List<Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); string postDisplayText = ""; if (aVideo_Post.VideoCaption.Length > 30) { postDisplayText = aVideo_Post.VideoCaption.Substring(0, 30) + "..."; } else { postDisplayText = aVideo_Post.VideoCaption; } notification += MemberList[0].DisplayName + " liked your video '" + postDisplayText + "' which you posted " + FormatDateTime(PostList[0].CreateDate) + "\n\n"; } else if (PostList[0].PostType == "File") { aPost = new Post(NotificationsList[i].PostId, PostList[0].PostType); ArrayPosts = notificationDAL.GetPostCaption(aPost); File_Post aFile_Post; aFile_Post = (File_Post)ArrayPosts[0]; PostList = new List<Post>(); aPost = new Post(NotificationsList[i].PostId); PostList = new List<Post>(); PostList = notificationDAL.GetPostCreateDate(aPost); string postDisplayText = ""; if (aFile_Post.FileCaption.Length > 30) { postDisplayText = aFile_Post.FileCaption.Substring(0, 30) + "..."; } else { postDisplayText = aFile_Post.FileCaption; } notification += MemberList[0].DisplayName + " liked your file post '" + postDisplayText + "' which you posted " + FormatDateTime(PostList[0].CreateDate) + "\n\n"; } #endregion } return notification; }
public string FriendRequestSentNotifications() { string notification = ""; NewsfeedDAL newsFeedDAL = new NewsfeedDAL(); NotificationDAL notificationDAL = new NotificationDAL(); List<Notification> NotificationsList = new List<Notification>(); NotificationsList = notificationDAL.GetFriendRequestSentNotificationsForAMember(aMember); for (int i = 0; i < NotificationsList.Count; ++i) { #region FriendRequestSent //memberlist List<Member> MemberList = new List<Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); string FriendDisplayName = MemberList[0].DisplayName; notification += FriendDisplayName + " sent you a friend request\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 AddEventPost(string sessionMemberID, string startDate, string endDate, string name, string host, string venue, int groupID, string details, string type) { memberID = sessionMemberID; StringBuilder htmlText = new StringBuilder(); Member aMember = new Member(memberID); Group aGroup = new Group(groupID); PostDAL postDAL = new PostDAL(); Reusable_Methods reusable_Methods = new Reusable_Methods(); /* * NEEDS ATTENTION !!!!!!!!! * * */ DateTime startDateD = reusable_Methods.CreateDateTime(startDate); DateTime endDateD = reusable_Methods.CreateDateTime(endDate); /* * END NEEDS ATTENTION !!!!!!!!! */ //DateTime startDateD = reusable_Methods.FormatDateFromDateTimePicker(startDate); // DateTime endDateD = reusable_Methods.FormatDateFromDateTimePicker(endDate); Event_Post aEvent_Post = new Event_Post(name, details, venue, startDateD, endDateD, host, type); int postId = postDAL.InsertEvent(aEvent_Post, aGroup, aMember); #region GET POST ArrayPosts = bl.GetASinglePost(postId); int count = ArrayPosts.Count; for (int i = 0; i < count; ++i) { OpenWrapper(i); #region EVENT POST GetEventPosts(); #endregion CloseWrapper(); } #endregion string postToClients = concatinater.ToString(); //Updating all Clients Clients.insertEvent(Context.ConnectionId, postToClients, groupID); }
public int InsertPhoto(Photo_Post photo_Post, Group group, Member member) { using (SqlConnection connection = new SqlConnection(ConnectionString)) { MemoryStream ms = new MemoryStream(); photo_Post.Photo.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); SqlCommand cmd = new SqlCommand("uspInsertPhoto", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@GroupID", group.GroupId)); cmd.Parameters.Add(new SqlParameter("@MemberID", member.MemberId)); cmd.Parameters.Add(new SqlParameter("@Photo", ms.ToArray())); cmd.Parameters.Add(new SqlParameter("@PhotoName", photo_Post.PhotoName)); cmd.Parameters.Add(new SqlParameter("@PhotoCaption", photo_Post.PhotoCaption)); SqlParameter returnValue = new SqlParameter("@Return_Value", DbType.Int32); returnValue.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(returnValue); int postId = 0; try { connection.Open(); cmd.ExecuteNonQuery(); postId = Int32.Parse(cmd.Parameters["@Return_Value"].Value.ToString()); } catch (SqlException e) { MessageBox.Show(e.ToString()); } return postId; } }
public int InsertEvent(Event_Post events, Group group, Member member) { using (SqlConnection dbcon = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspInsertEvent", dbcon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@GroupID", group.GroupId)); cmd.Parameters.Add(new SqlParameter("@MemberID", member.MemberId)); cmd.Parameters.Add(new SqlParameter("@EventName", events.EventName)); cmd.Parameters.Add(new SqlParameter("@EventDetails", events.EventDetails)); cmd.Parameters.Add(new SqlParameter("@EventVenue", events.EventVenue)); cmd.Parameters.Add(new SqlParameter("@StartDate", events.StartDate)); cmd.Parameters.Add(new SqlParameter("@EndDate", events.EndDate)); cmd.Parameters.Add(new SqlParameter("@Host", events.Host)); cmd.Parameters.Add(new SqlParameter("@EventType", events.EventType)); SqlParameter returnValue = new SqlParameter("@Return_Value", DbType.Int32); returnValue.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(returnValue); int postId = 0; try { dbcon.Open(); cmd.ExecuteNonQuery(); postId = Int32.Parse(cmd.Parameters["@Return_Value"].Value.ToString()); } catch (SqlException e) { MessageBox.Show(e.ToString()); } return postId; } }
public bool InsertPostRatingNotification(Rating rating, Member member, Member friend, Post post) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspInsertPostRatingNotification", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RatingID", rating.RatingId); cmd.Parameters.AddWithValue("@MemberID", member.MemberId); cmd.Parameters.AddWithValue("@FriendID", friend.MemberId); cmd.Parameters.AddWithValue("@PostID", post.PostId); try { con.Open(); int x = cmd.ExecuteNonQuery(); return true; } catch (Exception e) { MessageBox.Show(e.Message.ToString()); return false; } } }
protected void LoginButton_Click(object sender, EventArgs e) { Member_Status member_Status; dal = new LoginDAL(); string username = LoginUser.UserName; string password = LoginUser.Password; //Validate the Credentials against the active directory userInformation = new ActiveDirectoryDAL(username, password); username = SSTCryptographer.Encrypt(username); bool isValid = userInformation.ValidateCredentials(); if (!isValid) //Invalid Credentials { failureText = "Incorrect username or password."; ErrorInfo.Visible = true; } else if (dal.GetMemberStatus(member_Status = new Member_Status(username))) { failureText = "Your account has been suspended."; ErrorInfo.Visible = true; } else //Valid Credentials { userInformation.GetUserInformation(); if (IsSchoolOfICTMember()) { //treat the case where we set the remember me check box if (LoginUser.RememberMeSet) { RememberMe(username, password); } dal = new LoginDAL(); //save data into db if first time login Member member; if (!dal.MemberExists(member = new Member(username))) { //add member to database member = new Member(username, userInformation.GetFirstName(), userInformation.GetLastName(), userInformation.GetDisplayName(), userInformation.GetEmail(), userInformation.GetThumbnailPhoto(), userInformation.GetDescription(), userInformation.GetCompany(), ValidateMemberType()); dal.InsertMember(member); //assign member to groups AssignMemberToGroups(username); } Session["memberID"] = username; // Server.Transfer("~/Home.aspx"); Response.Redirect("~/Home.aspx"); //Redirect to home page if the user is a memeber of the faculty of ICT } else { //Display error message if the user is not a memeber of the faculty of ICT failureText = "Sorry. You need to be a registered school of ICT member in order to gain access to this site"; ErrorInfo.Visible = true; } } }
public void InsertChatText(string sessionMemberID, int groupID, string ChatText) { //Article_Post article_Post = new Article_Post(ChatText); Group group = new Group(groupID); Member thisMember = new Member(sessionMemberID); int postID = chatDAL.InsertChatText(group, ChatText, thisMember); Post post = new Post(postID); Article_Post thisArticle = chatDAL.getChatText(ref post); //BulabulaApp.Other_Classes. date new = reusable_Methods.FormatDateTime(aPost.CreateDate); Reusable_Methods reusable_Methods = new Reusable_Methods(); string date = reusable_Methods.FormatDateTimeForChat(post.CreateDate); thisMember = chatDAL.GetMemberDisplayName(thisMember); concatinater.Append(" <div class='chatMemberWrapper'>"); concatinater.Append("<div class='memberNameSection '> <a id="); concatinater.Append(thisMember.MemberId); concatinater.Append(" class='btnMemberProfile pointer' ><em>"); concatinater.Append(thisMember.DisplayName); concatinater.Append("</em></a></div>"); concatinater.Append("</a></div>"); concatinater.Append("<div class='chatContentSection '>"); concatinater.Append(thisArticle.ArticleText); concatinater.Append("</div> <div class='clr'></div>"); concatinater.Append(" </div>"); string chatString = concatinater.ToString(); Clients.updateChat(Context.ConnectionId, chatString, groupID.ToString(), sessionMemberID); }
public string EventNotifications() { string notification = ""; NotificationDAL notificationDAL = new NotificationDAL(); List<Notification> NotificationsList = new List<Notification>(); NotificationsList = notificationDAL.GetEventNotificationsForGroupMembers(); for (int i = 0; i < NotificationsList.Count; ++i) { int postId = NotificationsList[i].PostId; Post aPost = new Post(postId); List<Event_Post> EventNameList = new List<Event_Post>(); EventNameList = notificationDAL.GetEventName(aPost); string eventDisplayText = ""; if (EventNameList[0].EventName.Length > 30) { eventDisplayText = EventNameList[0].EventName.Substring(0, 30) + "..."; } else { eventDisplayText = EventNameList[0].EventName; } List<Member> GroupMembersList = new List<Member>(); Group aGroup = new Group(NotificationsList[i].GroupId); GroupMembersList = notificationDAL.GetGroupMembers(aGroup); for (int j = 0; j < GroupMembersList.Count; ++j) { string friendId = aMember.MemberId; //PERSON WHO IS LOGGED IN //CHECK TO SEE IF PE if (friendId == GroupMembersList[j].MemberId) { List<Member> MemberList = new List<Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); List<Group> GroupList = new List<Group>(); Group Group = new Group(NotificationsList[i].GroupId); GroupList = notificationDAL.GetGroupDescription(Group); notification += MemberList[0].DisplayName + " created the event '" + eventDisplayText + "' in the group '" + GroupList[0].GroupDescription + "'\n\n"; } } } return notification; }
public Reusable_Methods(Member aMember) { this.aMember = aMember; }
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; }
public void MoveShape(string postText, string sessionMemberID, int groupID) { memberID = sessionMemberID; StringBuilder htmlText = new StringBuilder(); Member aMember = new Member(memberID); htmlText.Append(postText); //htmlText.Replace("cat", "dog",); //htmlText.S //string[] parts = postText.Split(''); Text_Post aText_Post = new Text_Post(postText); Group aGroup = new Group(); aGroup.GroupId = groupID; int postId = postDAL.InsertText(aGroup, aText_Post, aMember); #region GET POST ArrayPosts = bl.GetASinglePost(postId); int count = ArrayPosts.Count; for (int i = 0; i < count; ++i) { OpenWrapper(i); #region TEXT POST GetTextPosts(); #endregion CloseWrapper(); } string postToClients = concatinater.ToString(); #endregion //Updating all Clients Clients.shapeMoved(Context.ConnectionId, postToClients, groupID); }
public string MessageNotifications() { string notification = ""; NotificationDAL notificationDAL = new NotificationDAL(); List<Notification> NotificationsList = new List<Notification>(); NotificationsList = notificationDAL.GetMessageNotificationForAMember(aMember); for (int i = 0; i < NotificationsList.Count; ++i) { List<Member> MemberList = new List<Member>(); Member aFriend = new Member(NotificationsList[i].MemberId); MemberList = notificationDAL.GetMemberDisplayName(aFriend); Message aMessage = new Message(NotificationsList[i].MessageId); aMessage = notificationDAL.GetMessageDateTime(aMessage); notification += MemberList[0].DisplayName + " sent you a message at " + FormatDateTime(aMessage.DateTime) + "\n\n"; } return notification; }
public void TagAPost(string sessionMemberID, int postID, string friendID) { NotificationDAL notificationDAL = new NotificationDAL(); //Tag method here Member m; Post p; bool isTagged = tagDAL.TagFriend(p = new Post(postID), m = new Member(friendID)); // INSERT NOTIFICATION string friendId = friendID; Member aFriend = new Member(friendId); string memberId = sessionMemberID; Member aMember = new Member(memberId); aPost.PostId = postID; notificationDAL.InsertTagNotification(aMember, aFriend, aPost); //return number of tags int numberoftags = newsFeedDAL.CountPostTags(aPost); Clients.updateTagCount(numberoftags, 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 void UnlikeAPost(string sessionMemberID, int postID) { RateAndTagDAL dal = new RateAndTagDAL(); string memberId = sessionMemberID; Member aMember = new Member(memberId); aPost.PostId = postID; dal.DeletePostLike(aMember, aPost); int numberofPostLikes = newsFeedDAL.CountPostLikes(aPost); //Updating all Clients Clients.updatePostLikeCount(numberofPostLikes, postID); }
public Member GetMemberDisplayName(Member member) { using (SqlConnection con = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("uspGetMemberDisplayName", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MemberID", member.MemberId)); con.Open(); SqlDataReader dbReader = cmd.ExecuteReader(); while (dbReader.Read()) { member.DisplayName = dbReader["DisplayName"].ToString(); } con.Close(); } return member; }
public void UntagAPost(string sessionMemberID, int postID, string friendID) { Member m; Post p; bool isTagged = tagDAL.DeleteTag(p = new Post(postID), m = new Member(friendID)); aPost.PostId = postID; //returns number of tags int numberoftags = newsFeedDAL.CountPostTags(aPost); //Updating all Clients Clients.updateTagCount(numberoftags, postID); }