public EmployeeVM GetEmployee(int id) { Employee emp = null; EmployeeVM evm = null; try { emp = db.GetById(id); if (emp != null) { evm = new EmployeeVM(); evm.EmployeeNo = emp.EmployeeNo; evm.EmployeeName = emp.EmployeeName; evm.DeptNo = (int)emp.DeptNo; evm.Job = emp.Job; evm.HireDate = emp.HireDate; evm.Salary = emp.Salary; evm.Commision = emp.Commision; } } catch { } return evm; }
public void TestUpdateEmployee() { EmployeeVM evm = new EmployeeVM(); evm.EmployeeName = "Aston K"; evm.EmployeeNo = 4; evm.Commision = 100; evm.DeptNo = 2; evm.HireDate = DateTime.Today; evm.Job = "TECH"; evm.Manager = 3; evm.Salary = 22900; Assert.IsTrue(empMngr.UpdateEmployee(evm)); }
public List<EmployeeVM> GetEmployees() { List<EmployeeVM> employees = new List<EmployeeVM>(); foreach (Employee e in db.GetAll()) { EmployeeVM evm = new EmployeeVM(); evm.EmployeeNo = e.EmployeeNo; evm.EmployeeName = e.EmployeeName; evm.Job = e.Job; evm.HireDate = e.HireDate; evm.Salary = e.Salary; evm.Commision = e.Commision; employees.Add(evm); } return employees; }
public bool UpdateEmployee(EmployeeVM evm) { Employee emp = db.GetById(evm.EmployeeNo); emp.EmployeeName = evm.EmployeeName; emp.Commision = evm.Commision; emp.HireDate = evm.HireDate; emp.Job = evm.Job; emp.Manager = evm.Manager; emp.Salary = evm.Salary; try { db.Update(emp); db.Save(); return true; } catch(Exception e) { return false; } }
public IHttpActionResult PostEmployee(EmployeeVM evm) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (empManager.EmployeeExists(evm.EmployeeNo)) { return Conflict(); } try { evm.EmployeeNo=empManager.InsertEmployee(evm); } catch { return BadRequest(); } return CreatedAtRoute("DefaultApi", new { id = evm.EmployeeNo }, evm); }
public IHttpActionResult PutEmployee(EmployeeVM employee) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (empManager.GetEmployee(employee.EmployeeNo) == null) { return NotFound(); } try { empManager.UpdateEmployee(employee); return StatusCode(HttpStatusCode.NoContent); } catch { return BadRequest(ModelState); } }
public int InsertEmployee(EmployeeVM evm) { Employee emp = new Employee(); emp.EmployeeNo= evm.EmployeeNo; emp.EmployeeName = evm.EmployeeName; emp.Commision = evm.Commision; emp.DeptNo= evm.DeptNo; emp.HireDate = evm.HireDate; emp.Job = evm.Job; emp.Manager = evm.Manager; emp.Salary = evm.Salary; try { db.Insert(emp); db.Save(); } catch (Exception e) { } return emp.EmployeeNo; }