public static string addFriend(string email, int ID, string listBoxText)
{
string idNum = getID(email);
string connectionString = null;
MySqlConnection cnn;
connectionString = $"server=localhost;database=SNHUBook;uid=root;pwd={MYSQLPassword};";
cnn = new MySqlConnection(connectionString);
int newID = ID + 1;
string userEmail = MySQLFunctions.getEmail(newID.ToString());
string query = $"INSERT INTO friends (AccountID, ID, value, email) values ({idNum}, {ID}, '{listBoxText}', '{userEmail}');";
MySqlCommand cmd = new MySqlCommand(query, cnn);
MySqlDataReader dr;
cnn.Open();
dr = cmd.ExecuteReader();
string home = string.Empty;
while (dr.Read())
{
home = dr.GetString(0);
Console.WriteLine(home);
}
dr.Close();
cnn.Close();
return(home);
}
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 BackgroundImage4_Click(object sender, EventArgs e)
{
MySQLFunctions.SQLCommand($"UPDATE accounts set backgroundImage_path='Background4.jpg' where Email='{email}';");
this.Hide();
AccountPage d = new AccountPage(email);
d.ShowDialog();
this.Close();
}
private void Add_bn_Click(object sender, EventArgs e)
{
Bio_lbl.Text = add_bio;
AddBio_Text.Hide();
Add_bn.Hide();
Cancel_bn.Hide();
hometown_text.Hide();
cancel_home_bn.Hide();
add_home_bn.Hide();
MySQLFunctions.SQLCommand($"UPDATE accounts SET Bio='{add_bio}' where Email = '{email}'");
}
public HomePage(string email) //Please use this one to transfer data.
{
InitializeComponent();
this.email = email;
//Below is checking which profile photo to load
Image myimage = new Bitmap(MySQLFunctions.getProfileImage(email));
pictureBox1.BackgroundImage = myimage;
user_button.Text = MySQLFunctions.getName(email);
}
public AccountPage(String email)
{
InitializeComponent();
this.email = email;
Image myimage = new Bitmap(MySQLFunctions.getProfileImage(email));
ProfilePicture.BackgroundImage = myimage;
user_button.Text = MySQLFunctions.getName(email);
username_lbl.Text = MySQLFunctions.getName(email);
Bio_lbl.Text = MySQLFunctions.getBio(email);
home_lbl.Text = MySQLFunctions.getHome(email);
Image backImage = new Bitmap(MySQLFunctions.getBackgroundImage(email));
CoverPicture.BackgroundImage = backImage;
panel4.Hide();
if (MySQLFunctions.getTotalPosts(email) != "0")
{
int totalPosts = int.Parse(MySQLFunctions.getTotalPosts(email));
string post = "";
for (int i = totalPosts; i > 0; i--)
{
post = MySQLFunctions.getPost(email, i.ToString());
if (post.Length != 0)
{
postsTooDelete.Items.Add(post);
AccountAddPost a = new AccountAddPost(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);
a.date_lbl.Text = MySQLFunctions.getDate(email, i.ToString());
a.post_lbl.Show();
a.date_lbl.Show();
a.post_background.Show();
PanelLocation += 100; //Adding an amount
}
else
{
i--;
}
}
}
}
public static string[] getFriends(string email) //returns string array that contains emails of all friends
{
//CheckifUserhasfriends
if (friendExists(MySQLFunctions.getAccountIDNext(email)) != "") //Returns 1 for 1 friend
{
string[] returnString = new string[int.Parse(getTotalFriends(email))]; //Array of size 1
string connectionString;
MySqlConnection cnn;
string query;
MySqlCommand cmd;
MySqlDataReader dr;
string home;
int ID;
int j = 0;
for (int i = 0; i < int.Parse(getTotalAccounts()); i++)
{
ID = i + 1;
if (MySQLFunctions.innerFriendExists(ID.ToString()) != "")
{
connectionString = $"server=localhost;database=SNHUBook;uid=root;pwd={MYSQLPassword};";
cnn = new MySqlConnection(connectionString);
query = $"SELECT email FROM friends WHERE ID like {ID.ToString()};";
cmd = new MySqlCommand(query, cnn);
cnn.Open();
dr = cmd.ExecuteReader();
home = string.Empty;
while (dr.Read())
{
home = dr.GetString(0);
Console.WriteLine(home);
}
dr.Close();
cnn.Close();
returnString[j] = home;
j++;
}
}
return(returnString);
}
else
{
return(new string[0]);
}
}
public SettingsPage(int recievedform, string email)
{
InitializeComponent();
returnform = recievedform;
this.email = email;
Image myimage = new Bitmap(MySQLFunctions.getProfileImage(email));
pictureBox1.BackgroundImage = myimage;
user_button.Text = MySQLFunctions.getName(email);
ChangePasswordPanel.Visible = false;
ChangePasswordPanel.SendToBack();
LogoutPanel.Visible = false;
LogoutPanel.BringToFront();
}
private void deletePostSubmitButton_Click(object sender, EventArgs e)
{
if (postsTooDelete.SelectedIndex == -1)
{
MessageBox.Show("Please select an Item first!");
}
else
{
MessageBox.Show("Post removed.");
MySQLFunctions.deletePost(email, postsTooDelete.Text);
this.Hide();
AddProfileImage a = new AddProfileImage(2, email);
this.Close();
}
}
private void login_bn_Click(object sender, EventArgs e)
{
if (password != "" && username != "")
{
if (password == MySQLFunctions.getPass(username))
{
this.Hide();
HomePage d = new HomePage(username);
d.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Account does not exist / Password is not correct");
}
}
}
public FriendRequest(string email, int recievedNum)
{
InitializeComponent();
this.email = email;
recievedform = recievedNum;
string totalString = MySQLFunctions.getTotalAccounts();
int totalAccounts = int.Parse(totalString);
//Adds in all accounts
for (int i = 1; i <= totalAccounts; i++)
{
friendsListBox.Items.Add(MySQLFunctions.getName(i));
}
}
private void profileImageFour_Click(object sender, EventArgs e)
{
if (isPersonalPage == false)
{
MySQLFunctions.SQLCommand($"UPDATE accounts set profImage_path='FemaleAvatar2.png' where Email='{email}';");
this.Hide();
HomePage d = new HomePage(email);
d.ShowDialog();
this.Close();
}
else
{
MySQLFunctions.SQLCommand($"UPDATE accounts set profImage_path='FemaleAvatar2.png' where Email='{email}';");
this.Hide();
AccountPage d = new AccountPage(email);
d.ShowDialog();
this.Close();
}
}
private void ChangePasswordButton_Click(object sender, EventArgs e)
{
if (passwordTextBox.Text.Length == 0)
{
invalid.Visible = true;
}
else if (!passwordTextBox.Text.Equals(retypeTextBox.Text))
{
pwDoesNotMatch.Visible = true;
}
else
{
//Change password
MySQLFunctions.changePassword(email, passwordTextBox.Text);
MessageBox.Show("Password has been changed!");
passwordTextBox.Text = "";
retypeTextBox.Text = "";
ChangePasswordPanel.Visible = false;
}
}
private void Submit_post_button_Click(object sender, EventArgs e)
{
AccountAddPost ah = new AccountAddPost(postCurrentNum, isNewPage);
ah.post_lbl.Text = textBox1.Text;
ah.post_lbl.Size = new System.Drawing.Size(700, 25);
this.Controls.Add(ah.post_background);
ah.post_background.Controls.Add(ah.post_lbl);
ah.post_background.Controls.Add(ah.date_lbl);
ah.post_lbl.Show();
ah.date_lbl.Show();
ah.post_background.Show();
PanelLocation += 100;
MySQLFunctions.savePost(email, textBox1.Text, ah.date_lbl.Text);
this.Hide();
AddProfileImage a = new AddProfileImage(2, email);
this.Close();
}
private void save_button_Click(object sender, EventArgs e)
{
signup a = new signup(email_textbox.Text, firstname_textbox.Text, lastname_textbox.Text, password_textbox.Text);
a.firstname_check();
a.lastname_check();
a.Email();
a.password_check();
if (a.firstname_check() == true)
{
firstname_textbox.BackColor = Color.Green;
}
else if (a.firstname_check() == false)
{
firstname_textbox.BackColor = Color.Red;
}
if (a.lastname_check() == true)
{
lastname_textbox.BackColor = Color.Green;
}
else if (a.lastname_check() == false)
{
lastname_textbox.BackColor = Color.Red;
}
if (a.Email() == true)
{
email_textbox.BackColor = Color.Green;
}
else if (a.Email() == false)
{
email_textbox.BackColor = Color.Red;
}
if (a.password_check() == true)
{
password_textbox.BackColor = Color.Green;
}
else
{
password_textbox.BackColor = Color.Red;
}
if (email_textbox.BackColor != Color.Red && firstname_textbox.BackColor != Color.Red &&
lastname_textbox.BackColor != Color.Red && password_textbox.BackColor != Color.Red)
{
string username = email_textbox.Text;
if (password == MySQLFunctions.getPass(username))
{
MessageBox.Show("Account Already exists");
}
else
{
string tempString = "INSERT INTO accounts (FirstName, LastName, Email, Password, profImage_path, backgroundImage_path, Bio, Home) Values('";
tempString = tempString + firstName + "', '";
tempString = tempString + lastName + "', '";
tempString = tempString + email + "', '";
tempString = tempString + password + "','nyc.jpg','10759301728_IMG_9920.jpg', 'NULL', 'NULL')";
MySQLFunctions.SQLCommand(tempString);
MessageBox.Show("You Successfully Signed Up! You May Now LogIn");
this.Hide();
WelcomePage o = new WelcomePage();
o.ShowDialog();
}
}
else
{
MessageBox.Show("Make Sure Everythings Valid and Submit again");
}
}
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--;
}
}
}
}
}
