public static void EditEmployeeDepartment(Employees emp, string newDepartment) { using (Lvl2Lesson7DBEntities db = new Lvl2Lesson7DBEntities()) { db.tbl_Employees.Where(x => x.First_Name.Equals(emp.FirstName) && x.Last_Name.Equals(emp.LastName)) .FirstOrDefault().Code_Department = db.tbl_Departments.Where(x => x.Name_Department.Equals(newDepartment)).FirstOrDefault().ID_Departments; db.SaveChanges(); } }
public static void AddDepartment(string nameDepartment) { using (Lvl2Lesson7DBEntities db = new Lvl2Lesson7DBEntities()) { db.tbl_Departments.Add(new tbl_Departments { Name_Department = nameDepartment }); db.SaveChanges(); } }
public static void CreateEmployee(string firstName, string lastName, string nameDepartment) { using (Lvl2Lesson7DBEntities db = new Lvl2Lesson7DBEntities()) { tbl_Employees emp = new tbl_Employees { First_Name = firstName, Last_Name = lastName, Code_Department = db.tbl_Departments.Where(x => x.Name_Department.Equals(nameDepartment)).FirstOrDefault().ID_Departments }; db.tbl_Employees.Add(emp); db.SaveChanges(); } }