private void LoadData()
{
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
var users = (
from s in db.Student
select new
{
s.Surname,
s.Name,
s.Patronymic,
s.Login,
}
).Concat
(
from t in db.Teacher
select new
{
Surname = t.Surname,
Name = t.Name,
Patronymic = t.Patronymic,
Login = t.Login
}
);
var userToList = new
{
Surname = users.First().Surname,
Name = users.First().Name,
Patronymic = users.First().Patronymic,
Login = users.First().Login,
role = db.GetRole(users.First().Login).FirstOrDefault()
};
var UserList = new[] { userToList }.ToList();
UserList.Clear();
users.ToList().ForEach(o =>
{
string currentRole = db.GetRole(o.Login).FirstOrDefault();
UserList.Add(new
{
Surname = o.Surname,
Name = o.Name,
Patronymic = o.Patronymic,
Login = o.Login,
role = currentRole
});
});
dataGridView1.DataSource = UserList;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns["Surname"].HeaderText = "Фамилия";
dataGridView1.Columns["Name"].HeaderText = "Имя";
dataGridView1.Columns["Patronymic"].HeaderText = "Отчество";
dataGridView1.Columns["Login"].HeaderText = "Логин";
dataGridView1.Columns["role"].HeaderText = "Роль";
}
}
private User CreateUser()
{
User user;
using (StudentTestingEntities1 db = new StudentTestingEntities1())
{
string login = db.GetLoginT().FirstOrDefault();
string role = db.GetRole(login).FirstOrDefault();
user = new User(login, role);
}
return(user);
}
