// 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 -- insert Employee public bool DSinsertEmployee(Employee employee) { try { // set adapter pta = new canoeDataSetTableAdapters.Canoe_PersonTableAdapter(); // insert // storedProcedure execute pta.CanoeInsertEmployee( 0, employee.Name, employee.Address, employee.Telephone_Number, 0, employee.OfficeAddress, employee.PhoneExtNo, employee.UserName, employee.Password, employee.Role ); return true; } catch (Exception ex) { throw new CanoeException("DSinsertEmployee", 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); } }
// Data Source -- search Employee public DataTable DSsearchEmployee(string id, string name, string role) { try { // set adapter pta = new canoeDataSetTableAdapters.Canoe_PersonTableAdapter(); pdt = new canoeDataSet.Canoe_PersonDataTable(); // select if (id.Length > 0) { pta.FillEmployeeByID(pdt, int.Parse(id)); } else if (name.Length > 0) { pta.FillEmployeeByName(pdt, name); } else if (role.Length > 0) { pta.FillEmployeeByRole(pdt, role); } else { pta.FillEmployeeByNone(pdt); } return pdt; } catch (Exception ex) { throw new CanoeException("DSsearchEmployee", ex.Message); } }