コード例 #1
0
        private void buttonAdd_Click(object sender, EventArgs e)
        {
            PlayerForm playerForm = new PlayerForm();

            List <Team> teams = db.Teams.ToList();

            playerForm.listBoxPastTeams.DataSource    = teams;
            playerForm.listBoxPastTeams.ValueMember   = "Id";
            playerForm.listBoxPastTeams.DisplayMember = "Name";

            DialogResult result = playerForm.ShowDialog(this);

            if (result == DialogResult.Cancel)
            {
                return;
            }

            Player player = new Player();

            player.Age  = (int)playerForm.numericUpDownAge.Value;
            player.Name = playerForm.textBoxName.Text.ToString();

            teams.Clear();
            foreach (var item in playerForm.listBoxPastTeams.SelectedItems)
            {
                teams.Add((Team)item);
            }

            player.Teams = teams;
            db.Players.Add(player);
            db.SaveChanges();

            MessageBox.Show("New player was created");
        }
コード例 #2
0
        private void buttonUpdate_Click(object sender, EventArgs e)
        {
            if (dataGridView1.SelectedRows.Count < 1)
            {
                return;
            }

            int  index     = dataGridView1.SelectedRows[0].Index;
            int  id        = 0;
            bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);

            if (converted == false)
            {
                return;
            }

            Player player = db.Players.Find(id);

            PlayerForm playerForm = new PlayerForm();

            playerForm.textBoxName.Text       = player.Name;
            playerForm.numericUpDownAge.Value = player.Age;

            List <Team> teams = db.Teams.ToList();

            playerForm.listBoxPastTeams.DataSource    = teams;
            playerForm.listBoxPastTeams.ValueMember   = "Id";
            playerForm.listBoxPastTeams.DisplayMember = "Name";
            foreach (Team t in player.Teams)
            {
                playerForm.listBoxPastTeams.SelectedItem = t;
            }

            DialogResult result = playerForm.ShowDialog(this);

            if (result == DialogResult.Cancel)
            {
                return;
            }

            player.Age  = (int)playerForm.numericUpDownAge.Value;
            player.Name = playerForm.textBoxName.Text.ToString();

            foreach (var team in teams)
            {
                if (playerForm.listBoxPastTeams.SelectedItems.Contains(team))
                {
                    if (!player.Teams.Contains(team))
                    {
                        player.Teams.Add(team);
                    }
                }
                else
                {
                    if (!player.Teams.Contains(team))
                    {
                        player.Teams.Remove(team);
                    }
                }
            }

            db.Entry(player).State = EntityState.Modified;
            db.SaveChanges();

            MessageBox.Show("Player was updated");
        }