// 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); } }
// DAO -- update Employee public bool DAOupdateEmployee(Employee employee) { try { // connect GetConnection(); // update pserson SqlCommand cmd; cmd = new SqlCommand(updatePsersonQuery, con); cmd.Parameters.AddWithValue("@ID", employee.ID); cmd.Parameters.AddWithValue("@Name", employee.Name); cmd.Parameters.AddWithValue("@Address", employee.Address); cmd.Parameters.AddWithValue("@Telephone_Number", employee.Telephone_Number); // get new id cmd.ExecuteNonQuery(); cmd.Dispose(); // update Employee cmd = new SqlCommand(updateEmployeeQuery, con); cmd.Parameters.AddWithValue("@EID", employee.EID); cmd.Parameters.AddWithValue("@OfficeAddress", employee.OfficeAddress); cmd.Parameters.AddWithValue("@PhoneExtNo", employee.PhoneExtNo); cmd.Parameters.AddWithValue("@UserName", employee.UserName); cmd.Parameters.AddWithValue("@Password", employee.Password); cmd.Parameters.AddWithValue("@Role", employee.Role); cmd.ExecuteNonQuery(); cmd.Dispose(); // close con.Close(); con.Dispose(); return true; } catch (Exception ex) { throw new CanoeException("DAOupdateEmployee", 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); } }
// update Employee public bool updateDSEmploeyDB(Employee employee) { db = new DatabaseAccess(); db.DSupdateEmployee(employee); return true; }
// insert Employee public bool insertDSEmploeyDB(Employee employee) { db = new DatabaseAccess(); db.DSinsertEmployee(employee); return true; }
// update Employee public bool updateDAOEmployee(Employee employee) { db = new DatabaseAccess(); db.DAOupdateEmployee(employee); return true; }
// insert Employee public bool insertDAOEmployee(Employee employee) { db = new DatabaseAccess(); db.DAOinsertEmployee(employee); return true; }
public Employee makeEmployee(String name, String address, int telephone_number, String officeaddress, int phoneextno, String username, String password, String role) { Employee employee = new Employee( name, address, telephone_number, officeaddress, phoneextno, username, password, role ); return employee; }