// Data Source -- delete Employee
public bool DSdeleteEmployee(int id)
{
try
{
// set adapter
pta = new canoeDataSetTableAdapters.Canoe_PersonTableAdapter();
eta = new canoeDataSetTableAdapters.Canoe_EmployeeTableAdapter();
// delete
eta.DeleteEmployeeQuery(id);
pta.DeletePersonQuery(id);
return true;
}
catch (Exception ex)
{
throw new CanoeException("DSdeleteEmployee", ex.Message);
}
}
// Data Source -- update Employee
public bool DSupdateEmployee(Employee employee)
{
try
{
// set adapter
pta = new canoeDataSetTableAdapters.Canoe_PersonTableAdapter();
eta = new canoeDataSetTableAdapters.Canoe_EmployeeTableAdapter();
// update
pta.UpdatePersonQuery(
employee.Name,
employee.Address,
employee.Telephone_Number,
employee.ID
);
eta.UpdateEmployeeQuery(
employee.OfficeAddress,
employee.PhoneExtNo,
employee.UserName,
employee.Password,
employee.Role,
employee.EID
);
return true;
}
catch (Exception ex)
{
throw new CanoeException("DSupdateEmployee", ex.Message);
}
}
