public HttpResponseMessage GetAllCounts()
{
using (DBEntities dBEntities = new DBEntities())
{
var joinTEst = dBEntities.employees.Join(dBEntities.Emp_Detail,
emp => emp.employee_id,
emp_dtl => emp_dtl.Fk_employee_id,
(emp, emp_dtl) => new {
Emp_Name = emp.First_name,
emp.Age,
emp_dtl.Fk_employee_id
});
var data = dBEntities.DashBoardCounts();
return(new HttpResponseMessage()
{
Content = new StringContent(JArray.FromObject(data).ToString(), Encoding.UTF8, "application/json")
});
}
}
