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();
}
}
}
