public void AddEmployee(Employee emp)
{
var context = new EmployeeDataContext();
context.Employees.InsertOnSubmit(emp); //add to the ORM...
context.SubmitChanges(); //commit
}
public void DeleteEmployee(int id)
{
var context = new EmployeeDataContext();
var rec = context.Employees.FirstOrDefault(e => e.EmpID == id);
if (rec == null)
{
throw new Exception("Employee not found to delete");
}
context.Employees.DeleteOnSubmit(rec);
context.SubmitChanges();
}
public void UpdateEmployee(Employee emp)
{
var context = new EmployeeDataContext();
var rec = context.Employees.FirstOrDefault(e => e.EmpID == emp.EmpID);
if (rec == null)
{
throw new Exception("Employee not found to update");
}
rec.EmpName = emp.EmpName;
rec.EmpAddress = emp.EmpAddress;
rec.EmpSalary = emp.EmpSalary;
context.SubmitChanges();//Commit the modified data...
}
