private void Notification_Click(object sender, RoutedEventArgs e)
{
if (icon.Kind == PackIconKind.PersonPlus) // if person make request freind
{
Message message = new Message(true, id_user, "Request Of Friend " + name);
message.ShowDialog();
}
else if (icon.Kind == PackIconKind.PersonStar) // if person make follow
{
Boolean follow = false;
int friend = -1;
connection.Open();
OracleCommand c = new OracleCommand();
c.Connection = connection;
c.CommandText = "select user_following from user_following where user_id=:id";
c.CommandType = CommandType.Text;
c.Parameters.Add("id", Account.UserID);
OracleDataReader dr = c.ExecuteReader();
while (dr.Read())
{
if (dr[0].ToString() == id_user)
{
follow = true; break;
}
}
dr.Close();
c = new OracleCommand();
c.Connection = connection;
c.CommandText = "select Friend_State from user_friend where user_id=:id and user_friend=:id_user";
c.CommandType = CommandType.Text;
c.Parameters.Add("id", Account.UserID);
c.Parameters.Add("id_user", id_user);
dr = c.ExecuteReader();
if (dr.Read())
{
if (dr["Friend_State"].ToString() == "0")
{
friend = 0;
}
else
{
friend = 1;
}
}
dr.Close();
Home.display_info.Children.Clear();
OtherProfile userx = new OtherProfile(follow, friend);
userx.OtherUserID = Convert.ToInt32(id_user);
Home.display_info.Children.Clear();
Home.display_info.Children.Add(userx);
}
else if (icon.Kind == PackIconKind.Chat) //if person chat with you
{
Chat ch = new Chat();
ch.Show();
}
}
private void List_of_Follower_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
/////////////////////////////// A.2. ///////////////////////////////////////
Close();
Boolean follow = false;
int friend = -1;
int curItem = List_of_Follower.SelectedIndex;
OracleCommand c = new OracleCommand();
c.Connection = connection;
c.CommandText = "select user_following from user_following where user_id=:id";
c.CommandType = CommandType.Text;
c.Parameters.Add("id", Account.UserID);
OracleDataReader dr = c.ExecuteReader();
while (dr.Read())
{
if (dr[0].ToString() == users[curItem].Id_user)
{
follow = true; break;
}
}
dr.Close();
c = new OracleCommand();
c.Connection = connection;
c.CommandText = "select Friend_State from user_friend where user_id=:id and user_friend=:id_user";
c.CommandType = CommandType.Text;
c.Parameters.Add("id", Account.UserID);
c.Parameters.Add("id_user", users[curItem].Id_user);
dr = c.ExecuteReader();
if (dr.Read())
{
if (dr["Friend_State"].ToString() == "0")
{
friend = 0;
}
else
{
friend = 1;
}
}
dr.Close();
Home.display_info.Children.Clear();
UserControls.OtherProfile userx = new UserControls.OtherProfile(follow, friend);
userx.OtherUserID = Convert.ToInt32(users[curItem].Id_user);
Home.display_info.Children.Clear();
Home.display_info.Children.Add(userx);
}