//Delete Team private void buttonDeleteTeam_Click(object sender, RoutedEventArgs e) { Object selectedRow = dataGridTeams.SelectedItem; if (selectedRow != null) { string team = (dataGridTeams.SelectedCells[0].Column.GetCellContent(selectedRow) as TextBlock).Text; if (MessageBox.Show("Weet u het zeker?", "", MessageBoxButton.OKCancel, MessageBoxImage.Question) == MessageBoxResult.OK) { var itemSource = dataGridTeams.ItemsSource as DataView; itemSource.Delete(dataGridTeams.SelectedIndex); dataGridTeams.ItemsSource = itemSource; buttonDeleteTeam.IsEnabled = false; buttonEditTeam.IsEnabled = false; } else { return; } var queryString = "SELECT * FROM dbo.Team"; using (var connection = DatabaseConnectionHelper.OpenDefaultConnection()) { var cmd = new SqlCommand(queryString, connection); var dataAdapter = new SqlDataAdapter(cmd); var cmdBuilder = new SqlCommandBuilder(dataAdapter); dataAdapter.Update(_teamData); } } }
private void EditPlayer() { if (TextBoxLastName.Text == string.Empty || TextBoxAdres.Text == string.Empty || TextBoxCity.Text == string.Empty || DatePickerBirthDate.Text == string.Empty) { MessageBox.Show("Veld mag niet leeg zijn!", "Velden moeten gevuld zijn", MessageBoxButton.OK, MessageBoxImage.Information); } else { using (var connection = DatabaseConnectionHelper.OpenDefaultConnection()) using (var sqlCommand = connection.CreateCommand()) { var id = sqlCommand.Parameters.AddWithValue("@id", _id); var lastNameParameter = sqlCommand.Parameters.AddWithValue("@LastName", TextBoxLastName.Text); var addressParameter = sqlCommand.Parameters.AddWithValue("@Adres", TextBoxAdres.Text); var cityParameter = sqlCommand.Parameters.AddWithValue("@City", TextBoxCity.Text); var birthDateParameter = sqlCommand.Parameters.AddWithValue("@BirthDate", DatePickerBirthDate.SelectedDate); sqlCommand.CommandText = $@"INSERT INTO [dbo].[Person] ([PersonId], [LastName], [Adres], [City], [BirthDate]) VALUES ({id}, {lastNameParameter.ParameterName}, {addressParameter.ParameterName}, {cityParameter.ParameterName}, {birthDateParameter.ParameterName})"; sqlCommand.ExecuteNonQuery(); } MessageBox.Show("Success!", "", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } }
private void AddTeam(int _id) { var team = new Coach(); team.Id = _id; team.Name = TextBoxName.Text; team.CoachName = TextBoxCoach.Text; team.Points = Convert.ToInt32(TextBoxPoints.Text); if (TextBoxName.Text != string.Empty && TextBoxCoach.Text != string.Empty) { using (var connection = DatabaseConnectionHelper.OpenDefaultConnection()) using (var sqlCommand = connection.CreateCommand()) { var teamNameParameter = sqlCommand.Parameters.AddWithValue("@Name", team.Name); var teamCoachParameter = sqlCommand.Parameters.AddWithValue("@Coach", team.CoachName); var teamPointsParameter = sqlCommand.Parameters.AddWithValue("@Points", team.Points); sqlCommand.CommandText = $@"INSERT INTO [dbo].[Team] ([Name], [Coach], [Points]) VALUES ({teamNameParameter.ParameterName}, {teamCoachParameter.ParameterName}, {teamPointsParameter.ParameterName})"; sqlCommand.ExecuteNonQuery(); } MessageBox.Show("Success!", "", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); } else { MessageBox.Show("Veld mag niet leeg zijn!", "Velden moeten gevuld zijn", MessageBoxButton.OK, MessageBoxImage.Information); } }
private DataTable GetDataTable() { _teamInformation = new DataTable(); var queryString = "SELECT * FROM Person WHERE Id=@id"; using (var connection = DatabaseConnectionHelper.OpenDefaultConnection()) using (var cmd = new SqlCommand(queryString, connection)) { cmd.Parameters.AddWithValue("@id", _id); var sqlAdapter = new SqlDataAdapter(cmd); sqlAdapter.Fill(_teamInformation); } return(_teamInformation); }
private void LoadData() { dataGridTeams.CanUserAddRows = false; dataGridTeams.SelectionMode = DataGridSelectionMode.Single; dataGridTeams.IsReadOnly = true; string querystring = "SELECT * FROM dbo.Team"; using (var connection = DatabaseConnectionHelper.OpenDefaultConnection()) { var cmd = new SqlCommand(querystring, connection); var dataAdapter = new SqlDataAdapter(cmd); _teamData = new DataTable(); dataAdapter.Fill(_teamData); dataGridTeams.DataContext = _teamData; dataGridTeams.ItemsSource = _teamData.DefaultView; } }