//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;
}
}
