void Initialise()
{
using (var db = new PlayerMarketEntities())
{
players = db.Players.ToList();
playstyles = db.PlayStyles.ToList();
}
ListBoxPlayers.ItemsSource = players;
ListBoxPlayers.DisplayMemberPath = "PlayerName";
ComboBoxPlayStyle.ItemsSource = playstyles;
ComboBoxPlayStyle.DisplayMemberPath = "PlayStyleName";
}
private void ButtonEdit_Click(object sender, RoutedEventArgs e)
{
if (ButtonEdit.Content.ToString() == "Edit")
{
TextBoxName.IsReadOnly = false;
TextBoxPosition.IsReadOnly = false;
TextBoxPlayStyle.IsReadOnly = false;
TextBoxGamesPlayed.IsReadOnly = false;
TextBoxGoals.IsReadOnly = false;
TextBoxAssists.IsReadOnly = false;
TextBoxCleanSheets.IsReadOnly = false;
ButtonEdit.Content = "Save";
TextBoxName.Background = Brushes.White;
TextBoxPosition.Background = Brushes.White;
TextBoxPlayStyle.Background = Brushes.White;
TextBoxGamesPlayed.Background = Brushes.White;
TextBoxGoals.Background = Brushes.White;
TextBoxAssists.Background = Brushes.White;
TextBoxCleanSheets.Background = Brushes.White;
}
else
{
using (var db = new PlayerMarketEntities())
{
var playerToEdit = db.Players.Find(player.PlayerId);
playerToEdit.PlayerName = TextBoxName.Text; // add all fields
playerToEdit.Goals = Convert.ToInt32(TextBoxGoals.Text);
playerToEdit.Games = Convert.ToInt32(TextBoxGamesPlayed.Text);
playerToEdit.Assists = Convert.ToInt32(TextBoxAssists.Text);
playerToEdit.CleanSheets = Convert.ToInt32(TextBoxCleanSheets.Text);
playerToEdit.PlayStyleId = Convert.ToInt32(TextBoxPlayStyle.Text);
//converting categoryid to integer from text box (string)
// tryparse is a safe way to do conversion: null if fails
int.TryParse(TextBoxPlayStyle.Text, out int playestyleId);
playerToEdit.PlayStyleId = playestyleId;
if (player.PlayStyleId != null)
{
ComboBoxPlayStyle.SelectedIndex = (int)player.PlayStyleId - 1;
}
else
{
ComboBoxPlayStyle.SelectedItem = null;
}
// save to database
db.SaveChanges();
ListBoxPlayers.ItemsSource = null; // reset list box
players = db.Players.ToList(); // get fresh link
ListBoxPlayers.ItemsSource = players; // re-link
}
ButtonEdit.Content = "Edit";
ButtonEdit.IsEnabled = false;
TextBoxName.IsReadOnly = true;
TextBoxPosition.IsReadOnly = true;
TextBoxPlayStyle.IsReadOnly = true;
TextBoxGamesPlayed.IsReadOnly = true;
TextBoxGoals.IsReadOnly = true;
TextBoxAssists.IsReadOnly = true;
var brush = new BrushConverter();
TextBoxName.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxPosition.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxPlayStyle.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxGamesPlayed.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxGoals.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxAssists.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxCleanSheets.Background = (Brush)brush.ConvertFrom("#E8FBFF");
}
}
private void ButtonDelete_Click(object sender, RoutedEventArgs e)
{
if (ButtonDelete.Content.ToString() == "Delete")
{
ButtonDelete.Content = "Are You Sure?";
TextBoxName.Background = Brushes.White;
TextBoxPosition.Background = Brushes.White;
TextBoxPlayStyle.Background = Brushes.White;
TextBoxGamesPlayed.Background = Brushes.White;
TextBoxGoals.Background = Brushes.White;
TextBoxAssists.Background = Brushes.White;
TextBoxCleanSheets.Background = Brushes.White;
TextBoxName.IsReadOnly = false;
TextBoxPosition.IsReadOnly = false;
TextBoxPlayStyle.IsReadOnly = false;
TextBoxGamesPlayed.IsReadOnly = false;
TextBoxGoals.IsReadOnly = false;
TextBoxAssists.IsReadOnly = false;
TextBoxCleanSheets.IsReadOnly = false;
TextBoxName.Background = Brushes.Red;
TextBoxPosition.Background = Brushes.Red;
TextBoxPlayStyle.Background = Brushes.Red;
TextBoxGamesPlayed.Background = Brushes.Red;
TextBoxGoals.Background = Brushes.Red;
TextBoxAssists.Background = Brushes.Red;
TextBoxCleanSheets.Background = Brushes.Red;
}
else
{
using (var db = new PlayerMarketEntities())
{
var playerToDelete = db.Players.Find(player.PlayerId);
db.Players.Remove(playerToDelete);
db.SaveChanges();
ListBoxPlayers.ItemsSource = null; // reset list box
players = db.Players.ToList(); // get fresh link
ListBoxPlayers.ItemsSource = players; // re-link
}
ButtonDelete.Content = "Delete";
ButtonDelete.IsEnabled = false;
//clear out boxes
TextBoxName.Text = " ";
TextBoxPosition.Text = " ";
TextBoxPlayStyle.Text = " ";
TextBoxGamesPlayed.Text = " ";
TextBoxGoals.Text = " ";
TextBoxAssists.Text = " ";
TextBoxCleanSheets.Text = " ";
var brush = new BrushConverter();
TextBoxName.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxPosition.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxPlayStyle.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxGamesPlayed.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxGoals.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxAssists.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxCleanSheets.Background = (Brush)brush.ConvertFrom("#E8FBFF");
}
}
private void ButtonAdd_Click(object sender, RoutedEventArgs e)
{
if (ButtonAdd.Content.ToString() == "Add")
{
//set boxes to editable
ButtonAdd.Content = "Confirm";
TextBoxName.Background = Brushes.White;
TextBoxPosition.Background = Brushes.White;
TextBoxPlayStyle.Background = Brushes.White;
TextBoxGamesPlayed.Background = Brushes.White;
TextBoxGoals.Background = Brushes.White;
TextBoxAssists.Background = Brushes.White;
TextBoxCleanSheets.Background = Brushes.White;
TextBoxName.IsReadOnly = false;
TextBoxPosition.IsReadOnly = false;
TextBoxPlayStyle.IsReadOnly = false;
TextBoxGamesPlayed.IsReadOnly = false;
TextBoxGoals.IsReadOnly = false;
TextBoxAssists.IsReadOnly = false;
TextBoxCleanSheets.IsReadOnly = false;
//clear out boxes
TextBoxName.Text = " ";
TextBoxPosition.Text = " ";
TextBoxPlayStyle.Text = " ";
TextBoxGamesPlayed.Text = " ";
TextBoxGoals.Text = " ";
TextBoxAssists.Text = " ";
TextBoxCleanSheets.Text = " ";
}
else
{
ButtonAdd.Content = "Add";
TextBoxName.IsReadOnly = true;
TextBoxPosition.IsReadOnly = true;
TextBoxPlayStyle.IsReadOnly = true;
TextBoxGamesPlayed.IsReadOnly = true;
TextBoxGoals.IsReadOnly = true;
TextBoxAssists.IsReadOnly = true;
var brush = new BrushConverter();
TextBoxName.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxPosition.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxPlayStyle.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxGamesPlayed.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxGoals.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxAssists.Background = (Brush)brush.ConvertFrom("#E8FBFF");
using (var db = new PlayerMarketEntities())
{
Player newPlayer = new Player
{
PlayerName = TextBoxName.Text,
Goals = Convert.ToInt32(TextBoxGoals.Text),
Games = Convert.ToInt32(TextBoxGamesPlayed.Text),
Assists = Convert.ToInt32(TextBoxAssists.Text),
CleanSheets = Convert.ToInt32(TextBoxCleanSheets.Text),
PlayStyleId = Convert.ToInt32(TextBoxPlayStyle.Text)
};
db.Players.Add(newPlayer);
// save to database
db.SaveChanges();
ListBoxPlayers.ItemsSource = null; // reset list box
players = db.Players.ToList(); // get fresh link
ListBoxPlayers.ItemsSource = players; // re-link
}
ButtonAdd.Content = "Add";
TextBoxName.IsReadOnly = true;
TextBoxPosition.IsReadOnly = true;
TextBoxPlayStyle.IsReadOnly = true;
TextBoxGamesPlayed.IsReadOnly = true;
TextBoxGoals.IsReadOnly = true;
TextBoxAssists.IsReadOnly = true;
TextBoxCleanSheets.IsReadOnly = true;
brush = new BrushConverter();
TextBoxName.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxPosition.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxPlayStyle.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxGamesPlayed.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxGoals.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxAssists.Background = (Brush)brush.ConvertFrom("#E8FBFF");
TextBoxCleanSheets.Background = (Brush)brush.ConvertFrom("#E8FBFF");
}
}
