public void addEmployee(Employee employee) { using (var context = new TestDataBaseEntities()) { var eList = context.Employees.ToList <Employee>(); context.Employees.Add(employee); context.SaveChanges(); } }
public void deleteEmployee(Employee employee) { using (var context = new TestDataBaseEntities()) { var emp = context.Employees.Find(employee.empNo); if (emp == null) { System.Console.WriteLine("Object not found."); } else { System.Console.WriteLine(emp.empName); context.Employees.Remove(emp); context.SaveChanges(); } } }
public void updateEmployee(Employee employee) { using (var context = new TestDataBaseEntities()) { var emp = context.Employees.Find(employee.empNo); if (emp != null) { emp.empName = employee.empName; emp.salary = employee.salary; emp.mgrEmpNo = employee.mgrEmpNo; emp.dob = employee.dob; emp.doj = employee.doj; emp.dptCode = employee.dptCode; context.SaveChanges(); } else { System.Console.WriteLine("No such employee found."); } } }