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