public void Create(Employee employee)
{
using (StaffContext db = new StaffContext())
{
db.Employees.InsertOnSubmit(employee);
db.SubmitChanges();
}
}
public Employee Get(int id)
{
using (StaffContext db = new StaffContext())
{
return((from c in db.Employees
where c.EmployeeID == id
select c).FirstOrDefault());
}
}
public void Delete(Employee employee)
{
using (StaffContext db = new StaffContext())
{
Employee empl = (from c in db.Employees
where c.EmployeeID == employee.EmployeeID
select c).FirstOrDefault();
db.Employees.DeleteOnSubmit(empl);
db.SubmitChanges();
}
}
public void Update(Employee employee)
{
using (StaffContext db = new StaffContext())
{
Employee emp = (from c in db.Employees
where c.EmployeeID == employee.EmployeeID
select c).FirstOrDefault();
if (emp != null)
{
emp.FirstName = employee.FirstName;
emp.LastName = employee.LastName;
emp.Position = employee.Position;
emp.Salary = employee.Salary;
emp.DateOfBirth = employee.DateOfBirth;
}
db.SubmitChanges();
}
}