protected void linkBtnAddFriend_Click(object sender, EventArgs e) { try { using (UserService service = new UserService()) { LinkButton button = ((LinkButton)sender); if (button.CommandName == "Approve") { FriendRequest request = new FriendRequest(); request.FromUserId = button.CommandArgument; request.ToUserId = LoggedUser.ID; service.ApproveFriendRequest(request); } else { } } } catch (Exception ex) { throw ex; } }
public void ApproveFriendRequest(FriendRequest request) { try { userService.ApproveFriendRequest(request); } catch (Exception ex) { throw new SoapException("Error", SoapException.ServerFaultCode, ex); } }
public List<User> GetMyFriends(string userId) { try { List<FriendRequest> requests = new List<FriendRequest>(); List<User> requestedUsers = new List<User>(); connection.Open(); command = new MySqlCommand("select *from friendrequest where Status =" + (int)FriendRequestStatus.Approved + " and FromUserId = '" + userId + "'", connection); reader = command.ExecuteReader(); while (reader.Read()) { FriendRequest request = new FriendRequest(); request.FromUserId = reader.GetString("FromUserId"); request.ToUserId = reader.GetString("ToUserId"); requests.Add(request); requestedUsers.Add(_userList.FirstOrDefault(x => x.ID == request.ToUserId)); } reader.Close(); command = new MySqlCommand("select *from friendrequest where Status =" + (int)FriendRequestStatus.Approved + " and ToUserId = '" + userId + "'", connection); reader = command.ExecuteReader(); while (reader.Read()) { FriendRequest request = new FriendRequest(); request.FromUserId = reader.GetString("FromUserId"); request.ToUserId = reader.GetString("ToUserId"); requests.Add(request); requestedUsers.Add(_userList.FirstOrDefault(x => x.ID == request.FromUserId)); } return requestedUsers; } catch (Exception ex) { throw ex; } finally { if (reader != null && reader.IsClosed == false) { reader.Close(); } if (connection != null && connection.State == System.Data.ConnectionState.Open) { connection.Close(); } } }
public void UpdateFriendRequest(FriendRequest friendRequest) { try { connection.Open(); command = new MySqlCommand("UPDATE friendrequest SET Status = " + (int)friendRequest.Status + " WHERE friendrequest.FromUserId = '" + friendRequest.FromUserId + "' AND friendrequest.ToUserId = '" + friendRequest.ToUserId + "'; ", connection); command.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { if (reader != null && reader.IsClosed == false) { reader.Close(); } if (connection != null && connection.State == System.Data.ConnectionState.Open) { connection.Close(); } } }
public void SendFriendRequest(FriendRequest friendRequest) { try { connection.Open(); command = new MySqlCommand("INSERT INTO friendrequest (FromUserId, ToUserId, Status) VALUES ('" + friendRequest.FromUserId + "', '" + friendRequest.ToUserId + "', " + (int)friendRequest.Status + ");", connection); command.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { if (reader != null && reader.IsClosed == false) { reader.Close(); } if (connection != null && connection.State == System.Data.ConnectionState.Open) { connection.Close(); } } }