public IHttpActionResult Get()
{
using (HumanResourceManagementEntities dbContext = new HumanResourceManagementEntities()) {
var query = from employee in dbContext.Employees
select new EmployeeModel {
EmployeeId = employee.EmpID,
EmployeeName = employee.EmpName,
Address = employee.Address,
Email = employee.Email,
DateOfJoin = employee.DOJ,
Gender = employee.Gender == true ? 1 : 0,
YearOfBirth = employee.YearOfBirth
};
var listOfEmployees = query.ToList();
return(Ok(listOfEmployees));
}
}
public IHttpActionResult Post([FromBody] EmployeeModel newEmployee)
{
using (HumanResourceManagementEntities dbContext = new HumanResourceManagementEntities())
{
var insertedEmployee = dbContext.Employees.Add(new Employee()
{
EmpName = newEmployee.EmployeeName,
DeptID = newEmployee.DepartmentId,
Email = newEmployee.Email,
Address = newEmployee.Address,
DOJ = newEmployee.DateOfJoin,
Gender = newEmployee.Gender > 0,
YearOfBirth = newEmployee.YearOfBirth,
});
dbContext.SaveChanges();
return(Ok(insertedEmployee));
}
}
public IHttpActionResult Get(int id)
{
using (HumanResourceManagementEntities dbContext = new HumanResourceManagementEntities())
{
var query = from employee in dbContext.Employees
where employee.EmpID == id
select new EmployeeModel
{
EmployeeId = employee.EmpID,
EmployeeName = employee.EmpName,
Address = employee.Address,
Email = employee.Email,
DateOfJoin = employee.DOJ,
Gender = employee.Gender == true ? 1 : 0,
YearOfBirth = employee.YearOfBirth
};
var foundEmployee = query.FirstOrDefault();
return(Ok(foundEmployee));
}
}
