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(); } }
private void label1_Click(object sender, EventArgs e) { // Переход на форму для добавления пользователя Team_Users_Add team_Users_Add = new Team_Users_Add(() => { var team = Cache.Get <Team>("team"); using (var ctx = new Database.ApplicationContext()) { 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_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(); } }); team_Users_Add.Show(); }
public Team_View() { InitializeComponent(); var team = Cache.Get <Team>("team"); var user = Cache.Get <User>("user"); using (var ctx = new Database.ApplicationContext()) { 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_Tasks.AutoGenerateColumns = false; Team_Users.DataSource = ctx.UsersInTeams.ToList().Where(it => it.TeamId == team.TeamId).Select(it => { return(ctx.Users.First(t => t.UserId == it.UserId)); }).ToList(); if (user.isAdmin == true) { Team_Tasks.DataSource = ctx.Tasks.Where(it => it.TeamId == team.TeamId).ToList(); } else { Team_Tasks.DataSource = ctx.Tasks.Where(it => it.TeamId == team.TeamId && it.UserId == user.UserId).ToList(); } } }