Пример #1
0
        private void label3_Click(object sender, EventArgs e)
        {
            var team  = Cache.Get <Team>("team");
            var email = Team_Users.SelectedCells[0].Value as string;

            using (var ctx = new Database.ApplicationContext())
            {
                ctx.UsersInTeams.Remove(ctx.UsersInTeams.First(it => it.TeamId == team.TeamId && it.User.Email == email));
                ctx.SaveChanges();

                Team_Users.Columns.Clear();
                Team_Tasks.Columns.Clear();
                Team_Users.Columns.Add(new DataGridViewTextBoxColumn()
                {
                    DataPropertyName = "Surname",
                    HeaderText       = "Фамилия"
                });
                Team_Users.Columns.Add(new DataGridViewTextBoxColumn()
                {
                    DataPropertyName = "Firstname",
                    HeaderText       = "Имя"
                });
                Team_Users.Columns.Add(new DataGridViewTextBoxColumn()
                {
                    DataPropertyName = "Lastname",
                    HeaderText       = "Отчество"
                });
                Team_Users.Columns.Add(new DataGridViewTextBoxColumn()
                {
                    DataPropertyName = "Email",
                    HeaderText       = "Электронная почта"
                });
                Team_Users.AutoGenerateColumns = false;

                Team_Tasks.Columns.Add(new DataGridViewTextBoxColumn()
                {
                    DataPropertyName = "Summary",
                    HeaderText       = "Название"
                });

                /*  Team_Tasks.Columns.Add(new DataGridViewTextBoxColumn()
                 * {
                 *    DataPropertyName = "Priority",
                 *    HeaderText = "Приоритет"
                 * });
                 * Team_Tasks.Columns.Add(new DataGridViewTextBoxColumn()
                 * {
                 *    DataPropertyName = "Status",
                 *    HeaderText = "Статус"
                 * });
                 */

                Team_Users.DataSource = ctx.UsersInTeams.ToList().Where(it => it.TeamId == team.TeamId).Select(it =>
                {
                    return(ctx.Users.First(t => t.UserId == it.UserId));
                }).ToList();

                Team_Tasks.DataSource = ctx.Tasks.Where(it => it.TeamId == team.TeamId).ToList();
            }
        }