// GET: api/Emp/5 public EmployeeCustomClass Get(int id) { tbEmployee emp = empDb.tbEmployees.FirstOrDefault(e => e.e_id == id); EmployeeCustomClass empCustom = new EmployeeCustomClass(); empCustom.EmpId = emp.e_id; empCustom.EmpName = emp.e_name; empCustom.DeptName = emp.tbDepartment.d_name; return(empCustom); }
// POST: api/Emp public void Post([FromBody] EmployeeCustomClass emp) { Console.WriteLine(emp); tbDepartment dep = empDb.tbDepartments.FirstOrDefault(e => e.d_name.Equals(emp.DeptName)); tbEmployee newEmp = new tbEmployee(); newEmp.e_name = emp.EmpName; newEmp.tbDepartment = dep; //ef empDb.tbEmployees.Add(newEmp); empDb.SaveChanges(); }
// PUT: api/Emp/5 public void Put(int id, [FromBody] EmployeeCustomClass updateEmp) { if (updateEmp != null) { tbEmployee emp = empDb.tbEmployees.FirstOrDefault(e => e.e_id == updateEmp.EmpId); tbDepartment dep = empDb.tbDepartments.FirstOrDefault(e => e.d_name.Equals(updateEmp.DeptName)); emp.e_name = updateEmp.EmpName; emp.tbDepartment = dep; empDb.SaveChanges(); } }
public IEnumerable <EmployeeCustomClass> Get() { //var emp = empDb.tbEmployees.Include(e => e.e_d_id); //return emp.ToList(); List <tbEmployee> list = empDb.tbEmployees.ToList(); List <EmployeeCustomClass> empCustomList = new List <EmployeeCustomClass>(); foreach (tbEmployee e in list) { EmployeeCustomClass emp = new EmployeeCustomClass(); emp.EmpId = e.e_id; emp.EmpName = e.e_name; emp.DeptName = e.tbDepartment.d_name; empCustomList.Add(emp); } return(empCustomList); }