public List<EmployeeNumber> GetEmployeeNumberList()
{
OleDbCommand odCom = BuildSelectCmd("Employee", "EmployeeNumber", "Active=TRUE");
OleDbDataReader odRdr = odCom.ExecuteReader();
List<EmployeeNumber> employeeNumberList = new List<EmployeeNumber>();
EmployeeNumber employeeNumber = null;
while (odRdr.Read())
{
employeeNumber = new EmployeeNumber();
employeeNumber.ID = Convert.ToInt32(odRdr["EmployeeNumber"]);
employeeNumberList.Add(employeeNumber);
}
odRdr.Close();
return employeeNumberList;
}
public EmployeeNumber GetEmployeeNumber(int id)
{
OleDbCommand odCom = BuildSelectCmd("EmployeeNumber", "*", "ID=@ID", new object[] { "@ID", id });
OleDbDataReader odRdr = odCom.ExecuteReader();
EmployeeNumber employeeNumber = null;
if (odRdr.Read())
{
employeeNumber = new EmployeeNumber();
employeeNumber.ID = Convert.ToInt32(odRdr["ID"]);
}
odRdr.Close();
return employeeNumber;
}
