private void deleteFriend_Click(object sender, RoutedEventArgs e)
{
customMessageBox deleteFriendBox = new customMessageBox("delete friend");
deleteFriendBox.ShowDialog();
string friendUsername = deleteFriendBox.typedMessage;
yesnoMessageBox areyousure = new yesnoMessageBox("are you sure you want to delete this friend?");
areyousure.ShowDialog();
if (areyousure.yes == true)
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "usp_getIDbyUsername";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@username", friendUsername);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
connection.Close();
if (table.Rows.Count > 0)
{
try
{
connection.Open();
SqlCommand command2 = new SqlCommand();
command2.Connection = connection;
command2.CommandText = "usp_deleteFriend";
command2.CommandType = CommandType.StoredProcedure;
command2.Parameters.AddWithValue("@accountID", accountID);
command2.Parameters.AddWithValue("@friendID", table.Rows[0]["accountId"]);
command2.ExecuteNonQuery();
connection.Close();
}
catch (SqlException ex)
{
errorMessagesBox error = new errorMessagesBox("there was an error deleting this friend");
error.Show();
}
LoadFriends();
}
else
{
errorMessagesBox error = new errorMessagesBox("you are not friends with this user");
error.Show();
}
}
else
{
areyousure.Close();
}
}
private void addFriend_Click(object sender, RoutedEventArgs e)
{
customMessageBox addFriendBox = new customMessageBox("add friend");
addFriendBox.ShowDialog();
string friendUsername = addFriendBox.typedMessage;
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "usp_getIDbyUsername";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@username", friendUsername);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
connection.Close();
if (table.Rows.Count > 0)
{
connection.Open();
try
{
SqlCommand command2 = new SqlCommand();
command2.Connection = connection;
command2.CommandText = "usp_addFriend";
command2.CommandType = CommandType.StoredProcedure;
command2.Parameters.AddWithValue("@accountID", accountID);
command2.Parameters.AddWithValue("@friendID", table.Rows[0]["accountID"].ToString());
command2.ExecuteNonQuery();
}
catch (SqlException ex)
{
errorMessagesBox error = new errorMessagesBox("there was an error adding this friend");
error.Show();
}
connection.Close();
LoadFriends();
}
else
{
customMessageBox command2 = new customMessageBox("username doesn't exist");
command2.ShowDialog();
}
}
void friendButton_Click(object sender, RoutedEventArgs e)
{
yesnoMessageBox messageBox = new yesnoMessageBox("would you like to create a chat with this person?");
messageBox.ShowDialog();
if (messageBox.yes == true)
{
customMessageBox newform = new customMessageBox("what would you like to name this group?");
newform.ShowDialog();
string groupname = newform.typedMessage;
customMessageBox form = new customMessageBox("what would you like the password to be?");
form.ShowDialog();
string password = form.typedMessage;
//creating chat
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "usp_createChatGroup";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@name", groupname);
command.Parameters.AddWithValue("@password", password);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
//adding self to chat
int newGroupID = int.Parse(table.Rows[0]["groupID"].ToString());
command = new SqlCommand();
command.Connection = connection;
command.CommandText = "usp_addGroupAccess";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@accountID", accountID);
command.Parameters.AddWithValue("@groupID", newGroupID);
command.ExecuteNonQuery();
//get id of the other person
DataTable resultTable = new DataTable();
string username = ((Button)sender).Content.ToString();
command = new SqlCommand();
command.Connection = connection;
command.CommandText = "usp_getIDbyUsername";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@username", username);
SqlDataAdapter adapter2 = new SqlDataAdapter(command);
adapter2.Fill(resultTable);
int otherPersonID = Convert.ToInt32(resultTable.Rows[0]["accountID"]);
//add other person to chat
command = new SqlCommand();
command.Connection = connection;
command.CommandText = "usp_addGroupAccess";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@accountID", otherPersonID);
command.Parameters.AddWithValue("@groupID", newGroupID);
command.ExecuteNonQuery();
connection.Close();
LoadChats();
}
}