private void DeleteUserButton_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(ClientIdBox.Text))
{
MessageBox.Show("Provide all data");
}
else
{
DeleteUserProcedure deleteUser = new DeleteUserProcedure(Connector, ClientIdBox.Text.NullNumber());
try
{
var dt = deleteUser.ExecuteQuery();
DataRow row = dt.Rows[0];
if (int.Parse(row["AffectedRows"].ToString() ?? string.Empty) > 0)
{
MessageBox.Show("Successfully deleted user");
}
else
{
MessageBox.Show("Nothing has been changed!");
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
}
public void DataBaseDeleteUser(DeleteUserProcedure userToDrop)
{
command = new MySqlCommand($"call usun_uzytkownika({userToDrop.UserToDrop}, {userToDrop.CurrentUser});", this.conection);
adapter.InsertCommand = command;
adapter.InsertCommand.ExecuteNonQuery();
command.Dispose();
}
private void DeleteStudent()
{
DeleteUserProcedure user = new DeleteUserProcedure();
user.UserToDrop = choosenUserID;
user.CurrentUser = signInUser.UserID;
DbService.DataBaseDeleteUser(user);
AlertWindow alertWindow2 = new AlertWindow("Student został usunięty.");
alertWindow2.ShowDialog();
}
