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();
}
}
