public List <DtoResponseModel> Get()
{
//try
//{
using (CrudOperationsEntities dbcontext = new CrudOperationsEntities())
{
var query = from e in dbcontext.UserInfoes
join d in dbcontext.departments on e.dept_id equals d.id
where e.is_delete == "false"
orderby e.name ascending
select new DtoResponseModel()
{
emp_id = e.id,
emp_name = e.name,
emp_email = e.email,
emp_phone = e.phone,
dname = d.dname
};
return(query.ToList());
}
//}
//catch (Exception e)
//{
// return ;
//}
}
public List <UserModel> GetUser(long id)
{
using (CrudOperationsEntities dbcontext = new CrudOperationsEntities())
{
//var result = dbcontext.UserInfoes.FirstOrDefault((p) => p.id == id);
var query = dbcontext.UserInfoes.Where((x) => x.id == id)
.Select(x => new UserModel()
{
id = x.id,
name = x.name,
email = x.email,
phone = x.phone
});
return(query.ToList());
//try
//{
// var query = from e in db.UserInfoes
// where e.dept_id == id
// select e;
// return query;
//}
//catch(Exception e)
//{
// return Enumerable.Empty<UserInfo>();
//}
}
}
public List <DTOGroup> getEmployeeByDept()
{
using (CrudOperationsEntities db = new CrudOperationsEntities())
{
var query1 = db.UserInfoes.GroupBy((p) => p.dept_id).
Select(g => new DTOGroup()
{
noOfEmployees = g.Key, dept_id = g.Count()
});
var query = from p in db.UserInfoes
group p by p.dept_id into g
select new
{
noOfEmployees = g.Key,
count = g.Count()
};
return(query1.ToList());
}
}
