/*done*/ private void friendButton_Click(object sender, EventArgs e) { yesnoMessageBox messageBox = new yesnoMessageBox("would you like to create a chat with this person?"); messageBox.ShowDialog(); if (messageBox.yes == true) { InputForm newform = new InputForm("what would you like to name this group", "group name", "okay"); newform.ShowDialog(); string groupname = newform.SubmittedText; InputForm form = new InputForm("what would you like the password to be", "password", "all good"); form.ShowDialog(); string password = form.SubmittedText; 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); 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(); string username = ((Button)sender).Text; command = new SqlCommand(); command.Connection = connection; command.CommandText = "usp_getIDbyUsername"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@username", username); command.ExecuteNonQuery(); connection.Close(); LoadChats(); } }
/*done*/ private void deleteFriendButton_Click(object sender, EventArgs e) { InputForm form = new InputForm("delete friends", "delete friend", "delete"); form.ShowDialog(); string friendUsername = form.SubmittedText; 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) { CustomMessageBox error = new CustomMessageBox("there was an error deleting this friend"); error.Show(); } LoadFriends(); } else { CustomMessageBox error = new CustomMessageBox("you are not friends with this user"); error.Show(); } }