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