public async Task <IActionResult> EmployeeList()
{
List <Employee_Project> ilIst = new List <Employee_Project>();
var listData = await(from emp in _context.Employee
join pro in _context.Project on emp.ProjectId equals pro.ProjectId
select new
{
emp.EmployeeId,
emp.EmployeeName,
emp.Designation,
pro.ProjectName
}
).ToListAsync();
listData.ForEach(x =>
{
Employee_Project Obj = new Employee_Project();
Obj.EmployeeId = x.EmployeeId;
Obj.Designation = x.Designation;
Obj.EmployeeName = x.EmployeeName;
Obj.Project = x.ProjectName;
ilIst.Add(Obj);
});
return(Json(ilIst));
}
//-------------------Create Query------------------------------------
public void CreateEmployee_Project(int Project_ID, int Employee_ID, int Role_ID)
{
Employee_Project EP = new Employee_Project();
EP.Estado = 1;
var project = entities.projects.FirstOrDefault(c => c.Project_ID == Project_ID);
var Employe = entities.employees.FirstOrDefault(c => c.Employee_ID == Employee_ID);
var Role = entities.cat_Roles.FirstOrDefault(c => c.Cat_Role_ID == Role_ID);
project.Employee_Projects.Add(EP);
Employe.employee_Projects.Add(EP);
Role.Employee_Projects.Add(EP);
entities.SaveChanges();
}
public async Task <IActionResult> EmployeeList()
{
List <Employee_Project> ilIst = new List <Employee_Project>();
var listData = await(from emp in _context.Employee
select new
{
emp.Id,
emp.Name
}
).ToListAsync();
listData.ForEach(x =>
{
Employee_Project Obj = new Employee_Project();
Obj.EmployeeId = x.Id;
Obj.EmployeeName = x.Name;
ilIst.Add(Obj);
});
return(Json(ilIst));
}
