private void buttonAdd_Click_1(object sender, EventArgs e) { FormPlayer playerForm = new FormPlayer(); List <Team> teams = db.Teams.ToList(); playerForm.comboBoxTeam.DataSource = teams; playerForm.comboBoxTeam.ValueMember = "Id"; playerForm.comboBoxTeam.DisplayMember = "Name"; DialogResult result = playerForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Player player = new Player(); player.Name = playerForm.textBoxName.Text; player.Position = playerForm.comboBoxPosition.SelectedItem.ToString(); player.Age = (int)playerForm.numericUpDownAge.Value; player.Team = (Team)playerForm.comboBoxTeam.SelectedItem; db.Players.Add(player); db.SaveChanges(); MessageBox.Show("New soccer player was created"); }
private void buttonUpdate_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { int index = dataGridView1.SelectedRows[0].Index; int id = 0; bool convert = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (convert == false) { return; } Player player = db.Players.Find(id); FormPlayer playerForm = new FormPlayer(); playerForm.textBoxName.Text = player.Name; playerForm.numericUpDownAge.Value = player.Age; playerForm.comboBoxPosition.SelectedItem = player.Position; List <Team> teams = db.Teams.ToList(); playerForm.comboBoxTeam.DataSource = teams; playerForm.comboBoxTeam.ValueMember = "Id"; playerForm.comboBoxTeam.DisplayMember = "Name"; if (player.Team != null) { playerForm.comboBoxTeam.SelectedValue = player.Team.Id; } DialogResult result = playerForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } player.Name = playerForm.textBoxName.Text; player.Position = playerForm.comboBoxPosition.SelectedItem.ToString(); player.Age = (int)playerForm.numericUpDownAge.Value; player.Team = (Team)playerForm.comboBoxTeam.SelectedItem; db.Entry(player).State = EntityState.Modified; db.SaveChanges(); MessageBox.Show("Soccer player was updated"); } }