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("Сотрудник добавлен"); }//добавить нового сотрудника