private void редактироватьToolStripMenuItem_Click(object sender, EventArgs e)
{
restEntities db = new restEntities();
List <employee> query = (from j in db.employee
select j).ToList();
try
{
if (dataGridView1.SelectedCells.Count == 1)
{
employee item = query.First(w => w.id_empl.ToString() == dataGridView1.SelectedCells[0]
.OwningRow.Cells[0].Value.ToString());
EditJob edit = new EditJob(item);
edit.Owner = this;
edit.Show();
}
}
catch {
MessageBox.Show("Обновите список сотрудников");
}
}
}//удалить сотрудника
public void AddJ(string f, string n, string l, DateTime date, int i, string log, string pass)
{
restEntities db = new restEntities();
var query = (from e in db.employee
join p in db.position on e.id_post equals p.id_post
join u in db.users on e.id_user equals u.id_user
select new
{
e.surname_emp,
e.name_emp,
e.lastname_emp,
e.date_emp,
p.name_post,
p.salary,
u.login_user,
u.pass_user
}).ToList();
int user = db.users.Max(us => us.id_user);
employee e1 = new employee
{
surname_emp = f,
name_emp = n,
lastname_emp = l,
date_emp = date,
id_user = user + 1,
id_post = i + 1
};
string role = "";
if (i == 0)
{
role = "manager";
}
else if (i == 1)
{
role = "admin";
}
else if (i == 2)
{
role = "ofic";
}
else if (i == 3)
{
role = "cook";
}
else if (i == 4)
{
role = "bar";
}
users u1 = new users
{
id_user = user + 1,
role_user = role,
login_user = log,
pass_user = pass
};
db.employee.Add(e1);
db.users.Add(u1);
db.SaveChanges();
MessageBox.Show("Сотрудник добавлен");
}//добавить нового сотрудника
