// 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); } }