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