private void removeFriendButton_Click(object sender, EventArgs e)
{
string friend = "";
friend = MySQLFunctions.getFriend(email, friendsListBox.Items[friendsListBox.SelectedIndex].ToString());
if (friendsListBox.SelectedIndex == -1)
{
MessageBox.Show("Please select an Item first!");
}
else
{
int totalFriends = int.Parse(MySQLFunctions.getTotalFriends(email));
if (totalFriends == 0) //if user has no friends, just add the friend.
{
MessageBox.Show("User is not your friend!");
}
//Search friends table to see if friend is already added.
else if (friend == "")
{
MessageBox.Show("User is not your friend!");
}
else if (friend == MySQLFunctions.getFriend(email, MySQLFunctions.getName(email)))
{
MessageBox.Show("You cannot remove yourself as a friend!");
}
else
{
MessageBox.Show("Friend removed.");
MySQLFunctions.removeFriend(email, friendsListBox.SelectedIndex, friendsListBox.Items[friendsListBox.SelectedIndex].ToString());
}
}
}
private void HomePage_Load(object sender, EventArgs e)
{
panel4.Hide();
if (MySQLFunctions.getAllTotalPosts() != "0")
{
int totalPosts = int.Parse(MySQLFunctions.getTotalPosts(email));
string post = "";
string name = "";
for (int i = totalPosts; i > 0; i--) //will post all posts for your own email
{
post = MySQLFunctions.getPost(email, i.ToString());
if (post.Length != 0)
{
AddPost a = new AddPost(i, isNewPage);
a.post_lbl.Text = post;
a.post_lbl.Size = new System.Drawing.Size(700, 25);
isNewPage = false;
postCurrentNum = i;
this.Controls.Add(a.post_background);
a.post_background.Controls.Add(a.post_lbl);
a.post_background.Controls.Add(a.date_lbl);
name = MySQLFunctions.getName(email);
a.date_lbl.Text = MySQLFunctions.getDate(email, i.ToString()) + " - " + name;
a.date_lbl.Width = 500;
a.post_lbl.Show();
a.date_lbl.Show();
a.post_background.Show();
PanelLocation += 100; //Adding an amount
}
else
{
i--;
}
}
string[] friendsList = MySQLFunctions.getFriends(email); //Returns string array will all friends emails
for (int i = 0; i < int.Parse(MySQLFunctions.getTotalFriends(email)); i++)
{
int tPosts = friendsList.Length;
string p = "";
string n = "";
for (int j = tPosts; j > 0; j--)
{
p = MySQLFunctions.getPost(friendsList[j - 1], j.ToString());
if (p.Length != 0)
{
AddPost a = new AddPost(j, isNewPage);
a.post_lbl.Text = p;
a.post_lbl.Size = new System.Drawing.Size(700, 25);
isNewPage = false;
postCurrentNum = j;
this.Controls.Add(a.post_background);
a.post_background.Controls.Add(a.post_lbl);
a.post_background.Controls.Add(a.date_lbl);
n = MySQLFunctions.getName(friendsList[j - 1]);
a.date_lbl.Text = MySQLFunctions.getDate(friendsList[j - 1], j.ToString()) + " - " + n;
a.date_lbl.Width = 500;
a.post_lbl.Show();
a.date_lbl.Show();
a.post_background.Show();
PanelLocation += 100; //Adding an amount
}
else
{
j--;
}
}
}
}
}
