private void change(object sender, RoutedEventArgs e)
{
editor_employee id_employee = (editor_employee)grid.SelectedItem;
if (id_employee != null)
{
string id_edit = id_employee.LOGIN;
this.Visibility = Visibility.Hidden;
new EditorEmp(connection, this, id_edit);
}
}
public void update_employees()
{
List <editor_employee> editor_list = new List <editor_employee>();
string sqlExpression = "SELECT dbo.EMPLOYEES.id_employee, dbo.EMPLOYEES.last_name_employee, dbo.EMPLOYEES.first_name_employee, dbo.EMPLOYEES.middle_name_employee, dbo.EMPLOYEES.date_birthday_employee, dbo.EMPLOYEES.phone_employee, "
+ " dbo.EMPLOYEES.passport_employee, dbo.EMPLOYEES.email_employee "
+ " FROM dbo.EMPLOYEES INNER JOIN "
+ " dbo.USERS ON dbo.EMPLOYEES.id_employee = dbo.USERS.id_user "
+ " WHERE(dbo.USERS.id_role <> 1) ";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
editor_employee st_rec = new editor_employee();
st_rec.LOGIN = reader.GetString(0);
st_rec.LAST_NAME = reader.GetString(1);
st_rec.FIRST_NAME = reader.GetString(2);
st_rec.MIDDLE_NAME = reader.GetString(3);
st_rec.DOB = (reader.GetDateTime(4)).ToString("dd.MM.yyyy");
st_rec.PHONE = reader.GetString(5);
st_rec.PASSPORT = reader.GetString(6);
st_rec.EMAIL = reader.GetString(7);
editor_list.Add(st_rec);
}
reader.Close();
grid.ItemsSource = editor_list;
grid.Columns[0].Header = "Логин";
grid.Columns[1].Header = "Фамилия";
grid.Columns[2].Header = "Имя";
grid.Columns[3].Header = "Отчество";
grid.Columns[4].Header = "Дата рождения";
grid.Columns[5].Header = "Телефон";
grid.Columns[6].Header = "Паспорт";
grid.Columns[7].Header = "Почта";
}
else
{
reader.Close();
grid.ItemsSource = null;
}
}