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.");
}
}
}
