public void TestUpdateEmpItemDAO()
{
EmpDAO empDao = new EmpDAO();
OleDbConnection con = empDao.Begin();
Emp emp = empDao.FindEmpByIdDAO(con, 1);
empDao.UpdateEmpItemDAO(con, emp);
empDao.Commit();
empDao.Close();
}
public void TestFindEmpByIDDAO()
{
EmpDAO empDao = new EmpDAO();
OleDbConnection con = empDao.Begin();
Emp emp = empDao.FindEmpByIdDAO(con, 5);
Assert.AreEqual(emp.M_leaderName, "gray.piao");
empDao.Commit();
empDao.Close();
}
private List <Emp> FindAllEmpsForAllocate()
{
List <Emp> emps = null;
try
{
OleDbConnection con = empDao.Begin();
emps = empDao.FindAllEmpDAO(con);
empDao.Commit();
return(emps);
}
catch (Exception)
{
empDao.RollBack();
throw;
}
finally
{
empDao.Close();
}
}
public void TestAddEmpItemDAO()
{
Emp emp = new Emp();
emp.M_name = "emp\" )'01";
emp.M_statue = "0";
emp.M_title = "TM";
EmpDAO empDao = new EmpDAO();
OleDbConnection con = empDao.Begin();
empDao.AddEmpItemDAO(con, emp);
empDao.Commit();
empDao.Close();
}
public void AddEmp(Emp emp)
{
try
{
OleDbConnection con = empDao.Begin();
empDao.AddEmpItemDAO(con, emp);
empDao.Commit();
}
catch (Exception)
{
empDao.RollBack();
throw;
}
finally {
empDao.Close();
}
}
private void BathUpdateEmpsToDB(List <Emp> emps)
{
try
{
OleDbConnection con = empDao.Begin();
foreach (Emp emp in emps)
{
empDao.UpdateEmpItemDAO(con, emp);
}
empDao.Commit();
}
catch (Exception)
{
empDao.RollBack();
throw;
}
finally
{
empDao.Close();
}
}