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)); }