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(); } }