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(); } }
//various click events void chatbutton_Click(object sender, RoutedEventArgs e)/////////////make the chat names so when they click it you can get the details of the chat/////////////////// { messages.Text = ""; connection.Open(); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "usp_getMessages"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@lastRecieved", lastRecieved); command.Parameters.AddWithValue("@groupID", groupID); SqlDataAdapter adapter = new SqlDataAdapter(command); DataTable table = new DataTable(); adapter.Fill(table); //MessageBox.Show(table.ToString()); //connection.Close(); Button clickedButton = sender as Button; //connection.Open(); command = new SqlCommand(); command.Connection = connection; command.CommandText = String.Format("SELECT * FROM [chat access] WHERE groupID = {0}", clickedButton.Tag); command.CommandType = CommandType.Text; adapter = new SqlDataAdapter(command); table = new DataTable(); adapter.Fill(table); List <string> peopleInGroup = new List <string>(); foreach (DataRow row in table.Rows) { int accountID = Convert.ToInt32(row["accountID"]); command = new SqlCommand(); command.Connection = connection; command.CommandText = "usp_getUsernameByID"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@accountID", accountID); SqlDataAdapter swagAdapter = new SqlDataAdapter(command); DataTable userTable = new DataTable(); swagAdapter.Fill(userTable); if (userTable.Rows.Count > 0) { peopleInGroup.Add(userTable.Rows[0]["username"].ToString()); } } SqlCommand commandtwo = new SqlCommand(); commandtwo.Connection = connection; commandtwo.CommandText = "usp_getChatGroup"; commandtwo.CommandType = CommandType.StoredProcedure; commandtwo.Parameters.AddWithValue("@name", chatname); adapter = new SqlDataAdapter(commandtwo); DataTable chatgrouptable = new DataTable(); adapter.Fill(chatgrouptable); groupID = (int)clickedButton.Tag; connection.Close(); string message = "DETAILS \n "; foreach (string name in peopleInGroup) { message += String.Format("{0} \n", name); } errorMessagesBox detailsBox = new errorMessagesBox(message); detailsBox.Show(); }